Re: Oracle 9i SQLDBA

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 08 Feb 2003 17:42:34 GMT
Message-ID: <BA6A8187.A1BC%markbtownsend@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 Sat Feb 08 2003 - 11:42:34 CST