Re: Oracle 9i SQLDBA

Thanks. I tried the command below and it worked.

Is there any tutorial for Oracle 9i DBA to perform day-to-day function? Thanks

"Mark Townsend" <markbtownsend_at_attbi.com> wrote in message news:BA6A8187.A1BC%markbtownsend_at_attbi.com...
> in article b229hi$186pps$1_at_ID-159205.news.dfncis.de, Useko Netsumi at
> usenets_at_nyc.rr.com wrote on 2/7/03 10:53 PM:
>
> >
> > Does the 'dba' function has changed a lot since Oracle 7? Thanks.
>
> Sure has :-)
>
> sqldba and svrmgr where deprecated a release back
>
> Use sqlplus from the oracle accountd, as follows
>
> sqlplus "/ as sysdba"
> startup
>
> (or)
>
> shutdown
>
> On my Mac
>
> > su-2.05a$ sqlplus "/ as sysdba"
> > SQL*Plus: Release 9.2.0.1.0 - Developer's Release on Sat Feb 8 09:37:57
2003>
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.>
> > Connected to an idle instance.>
> > SQL> startup
> > ORACLE instance started.>
> > Total System Global Area 113873180 bytes
> > Fixed Size 450844 bytes
> > Variable Size 92274688 bytes
> > Database Buffers 20480000 bytes
> > Redo Buffers 667648 bytes
> > Database mounted.
> > Database opened.
> > SQL> shutdown
> > Database closed.
> > Database dismounted.
> > ORACLE instance shut down.
> > SQL>
>
> dbshut and dbstart should still be there, however, in $ORACLE_HOME/bin
>
Received on Sun Feb 09 2003 - 09:43:43 CST