https://mailnest.com/dbawiki/index.php?action=history&feed=atom&title=SQL%2APlus_connection_without_using_tnsnames.oraSQL*Plus connection without using tnsnames.ora - Revision history2026-04-05T23:03:47ZRevision history for this page on the wikiMediaWiki 1.29.3https://mailnest.com/dbawiki/index.php?title=SQL*Plus_connection_without_using_tnsnames.ora&diff=45&oldid=prev127.0.0.1: 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..."2011-11-30T14:44:41Z<p>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..."</p>
<p><b>New page</b></p><div>No access to tnsnames.ora or just a temporary database and don't want to add the connection to the tnsnames.ora file?<br />
<br />
Connect direct using this syntax (equivalent to the "Direct" tab in Toad):<br />
sqlplus /@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sdiora03.ont.local)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=VENDORDEV))) as sysdba'</div>127.0.0.1