Re: Connect /nolog...

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 11 Jun 2003 23:50:14 GMT
Message-ID: <3EE7BECD.2BF246A6@telusplanet.net>

Jane O wrote:

> When starting up the instance...
> What does
>
> Connect /nolog...

First of all, you likely mean sqlplus /nolog, not connect /nolog.

sqlplus is a command interpreter. Years ago it was designed under the assumption that you want to invoke SQL stantements and SQLPlus commands (yes - they are different) against a specific data set under a specific userid. If you did not pass the userid/password and connection information, you were prompted for this. Yuo needed the connection info to enter the environment!

Until recently Oracle had a separate 'administrative command interpreter' environment - most recently called "server manager". There was a lot of overlap between the server manager and the SQL*Plus capabilities (and probably code lines.) The one significant access difference between the two was 'server manager' might be used before any connection COULD be established. You enter the environment before providing connection information.

So Oracle collapsed server manager into SQL*Plus and gave SQL*Plus the extra ability to enter the environment before providing connection information. Thus you can now say

sqlplus /nolog                  <<< to enter environment

connect user/password_at_service < AS environment_role > << to connect

and "AS SYSDBA" puts you into an environment very similar to the old Server Manager.

HTH
/Hans Received on Wed Jun 11 2003 - 18:50:14 CDT