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

Q

What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool

✍: 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.

2007-04-28, 9438👍, 0💬