Re: How do i change defualt database when we have mor than 1 database on a server.
Quote:
Originally posted by abhaysk
Hi,
i have say N databases on the server.The 1st database while creation is taken defualt as this is registered first in REGISTRY.
How do i change this to the new database name in registry so that i can use this as my defualt database.
All i know is i have to change ORACLE_SID parameter in Registy.....but dunno the path....
Can any 1 help ??????
Regards
Abhay.
Quote:
I agree......as long as we know wat we are doing....we can go ahead and make chages in registry
And from another post of yours:
Quote:
DaPi :
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Enum\Root\LEGACY_ORACLEORAHOME81TNSLISTENERABHAY
Is this the entry that i have to delete if i want to get rid of the Service OracleOraHome81TNSListenerAbhay ???????
Abhay.
Does this sound like you know what you are doing? Doesn't sound like it to me.
Re: Re: How do i change defualt database when we have mor than 1 database on a server.
Quote:
Originally posted by stecal
And from another post of yours:
Does this sound like you know what you are doing? Doesn't sound like it to me.
Quote:
Path is Go to registry....
My Comp>HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE>HOME
well actually i have 2 versions of oracle running on my machine....
so i have hom0 and hom1.versions are 8.x and 9.x
In 9.x , in the path specified u dont have entry Oracle_SID, u have to create a string with name ORACLE_SID and enter the data(database name), in 8.x u have defualty the string, all u have to do is edit the data to change defualt database.
i dunno y 9.x dosent hav an entry as such....
I did make the changes said above.....
and yes i was able to switch the defualt databases...
Abhay.