Home » RDBMS Server » Server Administration » Multiple Database
Multiple Database [message #52856] Sat, 17 August 2002 08:12 Go to next message
Sun
Messages: 92
Registered: August 2002
Member
Anybody pls tell me how to start two databases
at a time. i am using oracle 8.1.5 in windows NT

Report message to a moderator

Re: Multiple Database [message #52861 is a reply to message #52856] Sun, 18 August 2002 11:07 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Just to mention two such ways:

1. Create batch script as:

net start OracleService"SID_1"
net start OracleService"SID_2"

2. Create batch script as:

set oracle_sid="SID_1"
svrmgrl @c:tempstart_sid_1.sql

set oracle_sid="SID_2"
svrmgrl @c:tempstart_sid_2.sql

and

start_sid_2.sql should be:

connect internal
startup
exit

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: end-of-file on communication channel for remote database
Next Topic: Re: VB-Oracle Connectivity
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 10:47:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.