multiple sid's [message #57599] |
Wed, 25 June 2003 03:41 |
santh
Messages: 4 Registered: June 2003
|
Junior Member |
|
|
hello sir
i ahve one problems in configuring multiple
db's
i created some db's with services and
changed in listener.ora and tnsnmaes entries
my question is
whehter i can run multiple db's same time or not whther
i have to set the sid's each time
pls hlp
jels
|
|
|
Re: multiple sid's [message #57602 is a reply to message #57599] |
Wed, 25 June 2003 04:16 |
Chandru
Messages: 12 Registered: July 2000
|
Junior Member |
|
|
Hi,
You can have multiple SIDs on the same server and all of them running on the same listener/port. I have managed to have at least 3 SIDs simultaneously running on the same server using the same port/listener. But BEWARE! you might run into memory and performance problems as each one grabs a definite space depending on the init.ora configuration. Also when you administer a SID you will have to set it as the Default Oracle SID.
HTH
Chandru
|
|
|
|