Accessing oracle with sqlplus and no tnsnames

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.

del.icio.us:Accessing oracle with sqlplus and no tnsnames digg:Accessing oracle with sqlplus and no tnsnames spurl:Accessing oracle with sqlplus and no tnsnames wists:Accessing oracle with sqlplus and no tnsnames simpy:Accessing oracle with sqlplus and no tnsnames newsvine:Accessing oracle with sqlplus and no tnsnames blinklist:Accessing oracle with sqlplus and no tnsnames furl:Accessing oracle with sqlplus and no tnsnames reddit:Accessing oracle with sqlplus and no tnsnames fark:Accessing oracle with sqlplus and no tnsnames blogmarks:Accessing oracle with sqlplus and no tnsnames Y!:Accessing oracle with sqlplus and no tnsnames smarking:Accessing oracle with sqlplus and no tnsnames magnolia:Accessing oracle with sqlplus and no tnsnames segnalo:Accessing oracle with sqlplus and no tnsnames gifttagging:Accessing oracle with sqlplus and no tnsnames

This entry was posted on Friday, July 28th, 2006 at 2:07 pm by steveny and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Accessing oracle with sqlplus and no tnsnames”

  1. Me Says:
    August 23rd, 2006 at 4:00 pm

    Uh, wrong!
    That only works in 10g and the syntax is:
    sqlplus login/pwd@//hostname:1521/servicename
    Get on the ball bud!

Leave a Reply