Requirements for SQL*Plus Connection in Oracle

Q

What Information Is Needed to Connect SQL*Plus an Oracle Server in Oracle?

✍: FYIcenter.com

A

If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server:

  • The network hostname, or IP address, of the Oracle server.
  • The network port number where the Oracle server is listening for incoming connections.
  • The name of the target database instance managed by the Oracle server.
  • The name of your user account predefined on in the target database instance.
  • The password of your user account predefined on in the target database instance.

 

Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-17, 130👍, 0💬