Home » RDBMS Server » Server Utilities » shutdown en startup with 2 instances
shutdown en startup with 2 instances [message #73162] Mon, 23 February 2004 04:38 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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
Previous Topic: sqlldr & sequence
Next Topic: e-mail from one software to another software which have same database
Goto Forum:
  


Current Time: Sat Jun 29 05:24:06 CDT 2024