| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: svrmgrl, sqlplus question ???
do you have an account ops$oracle identified externally? Because THAT is what the / alone is meant to log you into. So Oracle is doing exactly what it should.
You aren't..... / as sysdba gets you in so that you can do startup/shutdown/recovery etc
/ gets you in to use SQL
>From: Charlie Mengler <charliem_at_mwh.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: svrmgrl, sqlplus question ???
>Date: Mon, 27 Aug 2001 18:10:27 -0800
>
><RANT>
>When I'm logged onto the Unix system as user "oracle"
>using 9i, Oracle refuses to allow me to log into it by
>just using "/". It insists that always include the two
>words " / as sysdba"! Since it precludes me from
>logging into Oracle just using "/", what is gained by
>forcing me to always specify "as sysdba", too????
></RANT>
>
>Rachel Carmichael wrote:
>
> > you cannot format in svrmgrl and you should start learning to use
>sqlplus
> > for this stuff, as svrmgrl goes away in 9i
> >
> > in sqlplus what I do is:
> >
> > sqlplus
> >
> > then at the username prompt I type
> >
> > / as sysdba
> >
> > once you do that you can do startup and shutdown
> >
> > >From: Janet Linsy <janetlinsy_at_yahoo.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: svrmgrl, sqlplus question ???
> > >Date: Mon, 27 Aug 2001 13:21:20 -0800
> > >
> > >Hi all,
> > >
> > >In sqlplus, you can use "col ... format ..." to make
> > >the output pretty. Can we format columns, make title
> > >in svrmgrl?
> > >
> > >Also I read that sqlplus can be used to mount, open
> > >database in 8i, but I don't see how.
> > >
> > >The db is 815 on Sun 5.6.
> > >
> > >Thank you!
> > >
> > >Janet
> > >
> > >__________________________________________________
> > >Do You Yahoo!?
> > >Make international calls for as low as $.04/minute with Yahoo!
>Messenger
> > >http://phonecard.yahoo.com/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Janet Linsy
> > > INET: janetlinsy_at_yahoo.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Aug 28 2001 - 11:17:36 CDT
 |
 |