Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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.