Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connect /nolog...

Connect /nolog...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 11 Jun 2003 15:42:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703C66EF4@lnewton.leeds.lfs.co.uk>


Connect to sqlplus but do not logon to any schema as in :

dev817> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 11 15:38:38 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> show user
USER is ""
SQL> select * from user_tables;
SP2-0640: Not connected

It allows you to get in in a similar manner to the old svrmgrl utility where youinvariably followed this up with a 'conect internal' prior to starting the instance up.

In 9i, svrmgrl is no more, so you need sqlplus to start things off.

HTH Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: Jane O [mailto:janeohin_at_aol.com]
Posted At: Wednesday, June 11, 2003 2:57 PM Posted To: server
Conversation: Connect /nolog...
Subject: Connect /nolog...

When starting up the instance...
What does

Connect /nolog...

mean/do ?

Thanks
Jane Received on Wed Jun 11 2003 - 09:42:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US