Re: Centralized names resolution

  • From: Maxim Demenko <mdemenko@xxxxxxxxx>
  • Date: Thu, 09 Feb 2006 15:27:55 +0100

With according quoting it works  in my setup:
>sqlplus scott@\"//col-fc3-02:1521/\"

SQL*Plus: Release - Production on Thu Feb 9 15:27:27 2006

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

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

Or, when connect from within sqlplus, double quotes must not be escaped:

oracle@col-fc3-02:~ >sqlplus /nolog

SQL*Plus: Release - Production on Thu Feb 9 15:29:54 2006

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

idle> conn scott@"//col-fc3-02:1521/"
Enter password:

Best regards


Bobak, Mark schrieb:

It's interesting (read as "annoying") that w/ EZCONNECT, you have to
supply the password on the command line.
This works fine:
$ sqlplus mbobak/mypassword@//devora2:1521/dvl1

SQL*Plus: Release - Production on Thu Feb 9 09:05:37 2006

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

Connected to: Oracle9i Enterprise Edition Release - 64bit Production With the Partitioning and OLAP options JServer Release - Production


But this fails:
$ sqlplus mbobak@//devora2:1521/dvl1

SQL*Plus: Release - Production on Thu Feb 9 09:05:14 2006

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

SQL*Plus: Release - Production

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

Usage 1: sqlplus -H | -V

   -H             Displays the SQL*Plus version and the
                  usage help.
   -V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [<logon>] [<start>] ]

 <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

   -C <version>   Sets the compatibility of affected commands to the
                  version specified by <version>.  The version has
                  the form "x.y[.z]".  For example, -C 10.2.0
   -L             Attempts to log on just once, instead of
                  reprompting on error.
   -M "<options>" Sets automatic HTML markup of output.  The options
                  have the form:
                  HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
                  [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT]
   -R <level>     Sets restricted mode to disable SQL*Plus commands
                  that interact with the file system.  The level can
                  be 1, 2 or 3.  The most restrictive is -R 3 which
                  disables all user commands interacting with the
                  file system.
   -S             Sets silent mode which suppresses the display of
                  the SQL*Plus banner, prompts, and echoing of

 <logon> is: (<username>[/<password>][@<connect_identifier>] | /)
             [AS SYSDBA | AS SYSOPER] | /NOLOG

   Specifies the database account username, password and connect
   identifier for the database connection.  Without a connect
   identifier, SQL*Plus connects to the default database.

   The AS SYSDBA and AS SYSOPER options are database administration

   The /NOLOG option starts SQL*Plus without connecting to a

 <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]

   Runs the specified SQL*Plus script from a web server (URL) or the
   local file system (filename.ext) with specified parameters that
   will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run.  The files may
contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

-- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning

"There are 10 types of people in the world:  Those who understand
binary, and those who don't."

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Radoulov, Dimitre
Sent: Thursday, February 09, 2006 8:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Centralized names resolution

With 10g you get easy connect.

e.g. sqlplus scott/tiger@//someserver:1529/orcl

And in 8i/9i you can connect with:





Other related posts: