Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017Connect needed Oracle server

0

Posted

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

1 Answer

0

Posted

• 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. What Is a Connect Identifier? A “connect identifier” is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/network/admin/ directory.