OraFAQ Forum: Server Administration » multiple db's ,sid's services

Home » RDBMS Server » Server Administration » multiple db's ,sid's services

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multiple db's ,sid's services [message #57574]

Tue, 24 June 2003 06:05

santhu
Messages: 4
Registered: June 2003

Junior Member

can i create multiple sid's and services and use at parrallely.How to do it. i made entries in address list in listener and sid_list in tnsnames and what step
i do next.How to run multiple db's
pls hlp

Report message to a moderator

Re: multiple db's ,sid's services [message #57576 is a reply to message #57574]

Tue, 24 June 2003 06:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can.
create different sercives using orapwd
have one service or database (sid) as primary.
use tnsentries to connect to others.
else
set ur ORACLE_SID everytime to login to a particular database

Report message to a moderator

Re: multiple db's ,sid's services [message #57585 is a reply to message #57576]

Tue, 24 June 2003 12:28

santhu
Messages: 4
Registered: June 2003

Junior Member

But How can i work multiple database at same time.Is
it possible with multiple address list and sid list with listener and tnsnames
work multiple db's at same time that's my problem

Report message to a moderator