cancel
Showing results for 
Search instead for 
Did you mean: 

shutting down an instance

SOLVED
Go to solution
HPADM
Advisor

shutting down an instance

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
3 REPLIES
Christian Gebhardt
Honored Contributor
Solution

Re: shutting down an instance

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
MANOJ SRIVASTAVA
Honored Contributor

Re: shutting down an instance

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
Yvonne Butler
Regular Advisor

Re: shutting down an instance

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