Re: Centralized names resolution

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

SQL*Plus: Release 10.2.0.1.0 - 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 10.2.0.1.0 - 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_at_col-fc3-02:~ >sqlplus /nolog

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

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

idle> conn scott@"//col-fc3-02:1521/ORA102.world" Enter password:
Connected.
scott_at_ORA102>

Best regards

Maxim

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 10.2.0.1.0 - Production on Thu Feb 9 09:05:37 2006
>
>Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
>Connected to:
>Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
>With the Partitioning and OLAP options
>JServer Release 9.2.0.7.0 - Production
>
>SQL>
>
>But this fails:
>$ sqlplus mbobak@//devora2:1521/dvl1
>
>SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 9 09:05:14 2006
>
>Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
>SQL*Plus: Release 10.2.0.1.0 - 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]
>{ON|OFF}]
> -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
> commands.
>
> <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
> privileges.
>
> The /NOLOG option starts SQL*Plus without connecting to a
> database.
>
> <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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre
>Sent: Thursday, February 09, 2006 8:56 AM
>To: oracle-l_at_freelists.org
>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:
>
>sqlplus
>username/password@'(description=(address=(protocol=<protocol>)(host=<hos
>tname>)(port=<port>))(connect_data=(sid=<sid>)))'
>
>
>
>Regards,
>Dimitre
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l