Re: Oracle 9i SQLDBA

From: Erik Domstad <d2domer_at_dtek.chalmers.se>
Date: 10 Feb 2003 05:39:21 -0800
Message-ID: <781128fe.0302100539.757a910d@posting.google.com>

"Useko Netsumi" <usenets_at_nyc.rr.com> wrote in message news:<b229hi$186pps$1_at_ID-159205.news.dfncis.de>...
> I installed oracle 9i Enterprise sucessfully. Then I ran 'dbca' and create a
> 'multipurpose' database. It went fine.
>
> I log in as scott/tiger and system/manager and they log me in fine.
>
> But then, I'm having problem running the following:
>
> dbshut
> sqldba
> svrmgrl
> etc...
>
> What other things do I have to do to be able to start and stop the database
> manually?
>
> Since I can't shutdown the db, I rebooted the server but unfortunately I
> can't bring up the database by running 'dbstart'.
>
> Does the 'dba' function has changed a lot since Oracle 7? Thanks.

dbstart and dbshut looks in your oratab file, your instance must be listed there to be affected.

Also, note the comment at the beginning of the script:

###################################
# 
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.

#####################################

/Erik Received on Mon Feb 10 2003 - 07:39:21 CST