shutdown en startup with 2 instances [message #73162] |
Mon, 23 February 2004 04:38 |
patrick
Messages: 83 Registered: December 2000
|
Member |
|
|
Hello everybody,
We have an oracle server with version 8.1.7. We want to make a cold backup. So we bring oracle down and a few hours later we bring it up. Now the problem is with getting oracle up again. It doesn't. We solve this by restarting the server. After that oracle comes up without a problem.
We use the following scripts with the shutdown and startup
with the following commands on svrmgrl.exe prompt
connect internal/*****@orcl
shutdown immediate
exit
connect internal/****@orcl
startup
exit
We have two different instances on the server and two different scripts like the one we use above. I heard there are some problems with two instances and then using scripts like this. Is there anyone that can explain this to me or help me with the problem.
thank you for helping
PAtrick
|
|
|
Re: shutdown en startup with 2 instances [message #73163 is a reply to message #73162] |
Mon, 23 February 2004 06:11 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
oracle transports a built-in script to do startup and shutdown.
assuming u have multiple database in the same machine,
1. edit oratab file.
add correspoing entries of ORACLE_HOME and ORACLE_SID to controlled.
2. $ORACLE_HOME/bin/dbstart and dbshut reads this oratab file to start and shutdown.
add ur lnsrclt start /stop commands inside dbstart and dbshut
IN WINDOWS:
use controlpanel services to startup/shutdown the databases
or
set ur ORACLE_SID
run the scritps to start /shut
|
|
|