sqlplus userid/password@dbserverIP:1521/dbSID
or
sqlplus /nolog
SQL> connect
This has been tested on 10g and 11g, not too sure if previous versions can connect like this or not :)
Friday, October 16, 2009
Connecting to sqlplus without TNSNAMES
In case you want to connect to oracle through sqlplus without using TNSNAMES.ORA definition the following connection string can be used
sqlplus userid/password@dbserverIP:1521/dbSID
or
sqlplus /nolog
SQL> connectuserid/password@dbserverIP:1521/dbSID
This has been tested on 10g and 11g, not too sure if previous versions can connect like this or not :)
sqlplus userid/password@dbserverIP:1521/dbSID
or
sqlplus /nolog
SQL> connect
This has been tested on 10g and 11g, not too sure if previous versions can connect like this or not :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment