SQL*Plus connection without using tnsnames.ora

From dbawiki

Revision as of 14:44, 30 November 2011 by 127.0.0.1 (talk) (Created page with "No access to tnsnames.ora or just a temporary database and don't want to add the connection to the tnsnames.ora file? Connect direct using this syntax (equivalent to the "Direc...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

No access to tnsnames.ora or just a temporary database and don't want to add the connection to the tnsnames.ora file?

Connect direct using this syntax (equivalent to the "Direct" tab in Toad):

sqlplus /@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sdiora03.ont.local)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=VENDORDEV))) as sysdba'

Retrieved from "https://mailnest.com/dbawiki/index.php?title=SQL*Plus_connection_without_using_tnsnames.ora&oldid=45"