Tuesday, May 15, 2012

Establish a direct connection to Oracle from sqlplus (without an alias)

People like us who change environments all the time with various customers, not to waste time configuring a connection alias in the tnsnames.ora file you can directly connect to an ORACLE database from sqlplus using


sqlplus user/pass@server_ip:port/sid

ex: sqlplus guy/fomi@10.10.10.10:1521/test

No comments:

Post a Comment