Home » RDBMS Server » Server Administration » multiple sid's
multiple sid's [message #57599] Wed, 25 June 2003 03:41 Go to next message
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

Report message to a moderator

Re: multiple sid's [message #57602 is a reply to message #57599] Wed, 25 June 2003 04:16 Go to previous messageGo to next message
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

Report message to a moderator

Re: multiple sid's [message #57605 is a reply to message #57602] Wed, 25 June 2003 06:37 Go to previous message
santh
Messages: 4
Registered: June 2003
Junior Member
But how i should i define multiple sid's pls hlp more detailed.can i run at sametime
bye

Report message to a moderator

Previous Topic: Practical document about Oracle on Solaris?
Next Topic: Scripts to determine parent/child relationship
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:53:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.