topic shutting down an instance in Operating System - HP-UX

shutting down an instance

HPADM — Mon, 25 Nov 2002 15:58:28 GMT

Hi!
I have two instance running on my oracle server.
How can I shutdown one without shutting down the other?
To start up I use this sqlplu statement:
startup database_name Pfile=myinit.ora
Is it correct?
thank you

Re: shutting down an instance

Christian Gebhardt — Mon, 25 Nov 2002 16:12:05 GMT

Hi

ensure that you have set the right ORACLE_SID

echo $ORACLE_SID

svrmgrl
> connect internal
> select * from v$instance; (correct database?)
> shutdown immediate;

With oracle9i you have to be installation-User and connect with
sqlplus "/ as sysdba"
> select * from v$instance;
> shutdown immediate;

Chris

Re: shutting down an instance

MANOJ SRIVASTAVA — Mon, 25 Nov 2002 16:14:46 GMT

HPADM

basically you need to

1.login to oracle su - oracle
2. svrmgrl to start the server manager

3. connect internal ( to conenct to teh database )

4. shutdown or start up depending on waht you want to do

after login in u need to do a grep on env for SID to know the instance.

Manoj Srivastava

Re: shutting down an instance

Yvonne Butler — Tue, 26 Nov 2002 15:00:10 GMT

You can use the command "oraenv" to change to the you want to connect ot.