RE: Centralized names resolution

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 9 Feb 2006 09:06:21 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF2706C020EB@AABO-EXCHANGE02.bos.il.pqe>

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

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

SQL*Plus: Release 10.2.0.1.0 - Production

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

Received on Thu Feb 09 2006 - 08:06:21 CST