Home   Notes   Contact Me

sqlplus

Local

External


Starting

# connect_identifier - look in tnsnames.ora and find the 'name' that equals the structure to find it sqlplus username/password@connect_identifier

If command line login fails

Connecting as shown above on the sqlplus command line was failing for me, 
but the following worked, so sometimes you may need to try it.  I do NOT yet have any idea why the same information
presented slightly differently works.
sqlplus # At usename prompt: username@connect_identifer # At password prompt: password