Archive for July, 2006

Accessing oracle with sqlplus and no tnsnames

Friday, July 28th, 2006

If you want to access a database without it being in your tnsnames.ora file, you can use a ‘URL’ at the command line:

sqlplus login/pwd@//hostname:1521/sidname

This should work with versions 9 and above. Let me know if other versions work.

Posted in Oracle | 1 Comment »