OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » mixed databases

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

mixed databases [message #63333]

Mon, 27 September 2004 22:10

Sanjeev Suri
Messages: 11
Registered: September 2004

Junior Member

sir, if i am having more then one databases on one machine, how can i specify a particular database to start on starting the instance.

i have tried it by giving the particular init.ora file with the start command.

i want to know whether the parameter is to be set at the o/s level.

please help me,

thanks

sanjeev suri

Report message to a moderator

Re: mixed databases [message #63334 is a reply to message #63333]

Mon, 27 September 2004 22:36

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi

tell me on which O/S your databases are running

if it is on Windows then you have make that entry in registry in oracle folder

and if it is on Unix then you have make the entry in required file

send me info about O/S

regards

D.Dilip

Report message to a moderator

Re: mixed databases [message #63336 is a reply to message #63334]

Tue, 28 September 2004 01:48

Sanjeev Suri
Messages: 11
Registered: September 2004

Junior Member

hello sir, thanks a lot my o/s is windows 2000. pl. guide me which parameter of the registry is to be changed

Report message to a moderator

Re: mixed databases [message #63337 is a reply to message #63336]

Tue, 28 September 2004 02:00

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

hi sanjeev

go to registry by typing REGEDIT at run option in a start button when registry window is open then click on HKEY_LOCAL_MACHINE option then it will open a tree structured file system under that select software option then you will find oracle folder select that
u will find oracle_home option then on right side pane
u will find multiple entries as oracle_sid(this entries equal to num of databases existing ou your system )then select the database u want to start at boot time then u will find entry as oracle_sid = false convert this to true.

false value indcicates that particular database will not start when systen starts and true indicates reverse
save the changes and for testing purpose restart the system(if possible) then you can check out whether database is open or not

this will work let me know if it fails
D.Dilip

Report message to a moderator

Re: mixed databases [message #63338 is a reply to message #63337]

Tue, 28 September 2004 02:17

Sanjeev Suri
Messages: 11
Registered: September 2004

Junior Member

Thanks a lot, finally it worked. i'm really thankful to u. can u give me ur mail id so that i can contact u if there is some other problem .

i'm undergoing training in Fundamentals 1 of oracle DBA.

thanks once again
Sanjeev Suri

Report message to a moderator

Re: mixed databases [message #63339 is a reply to message #63338]

Tue, 28 September 2004 02:30

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi

finally your problem was solved!!!!

u can catch me to following mail-id
dilipkumard@mascon.co.in

and all the best for your training program

Regards

D.Dilip

Report message to a moderator

Previous Topic:	Copying a database to a new instance
Next Topic:	ora_snp running.why?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 14:47:46 CST 2025