"Quick Check" Sqlplus Connect Oracle

There are two ways to connect Oracle using Sqlplus.

First, the Simple way

Sqlplus username/password @ip or hostname: Port/Database service Name

Second, the way of pre-configuration TNSNames

Under the "%oracle_home%\network\admin" path, there is a Tnsnames.ora file that is used to register the Tnsname.

The registration form is as follows and the Chinese part should be replaced appropriately:

=  =    =      ==== Port)))      = = database service name)   ))        

View Code

Once configured, you can connect using the following command:

Sqlplus username/password @ registered Tnsname

For detailed configuration see:

http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch3.htm#i1142625

"Quick Check" Sqlplus Connect Oracle