Monday, 31 May 2010

SQL*Plus Direct Connection URL

Note for myself, avoiding the use of a tnsnames.ora file to connect with.

sqlplus {username}/{password}@{hostname}:{port}/{service-name}

d:\temp>sqlplus scott/

SQL*Plus: Release Production on Mon May 31 08:04:56 2010

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options>


Anonymous said...

This is the "Easy Connect" syntax. It was extended in 11g to allow the DB server process type to be specified.
See for the syntax

Anonymous said...

And it's not specific in anyway to SQL*Plus.