How do i change defualt database when we have mor than 1 database on a server.

[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.

[stecal]

What is it with people wanting to directly edit the registry? Does any Oracle manual tell you to explicitly edit registry values? How about setting the ORACLE_SID via system or user environment variables?

XP: My computer>properties>advanced>environment variables

[abhaysk]

HI,

Can u please explain in detail of using envi variables?????

Abhay.

[abhaysk]

I gotta answer....
S i did change the paramter Oracale_Sid in Registry...
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....

Please if any body else who knows how to change default other than REGISTRY please let me know.....

AS stecal was telling a method to do so.....am not aware of it...please can any 1 explain it to me....


Regards
Abhay.

[alenz]

if you are connecting with SQL*Net you login like this:

sqlnet /nolog
set instance MYDB
connect scott/tiger


now you will be connected to MYDB no matter what the default database was set to.

to change the ORACLE_SID env variable in windows do:
set ORACLE_SID=MYDB
to see the current ORACLE_SID setting do:
echo %ORACLE_SID%

The only way I have been able to change the default ORACLE_SID in the past is to change it in the registry.

[alenz]

Opps, I ment SQLPlus not SQL*Net.

maybe you should use SQL*Net anyway and always use @MYDB in the connect string.

[agasimani]

To make the long notes short, the safest way is:

c:\set ORACLE_SID=sid

[prasadvd]

ABHAY !

How did u change the ORACLE_SID in registry ?

[abhaysk]

Originally posted by agasimani
To make the long notes short, the safest way is:

c:\set ORACLE_SID=sid

agasimani :

This will not work..... i Did try...
It will not chage the defualt database to new 1.....

Abhay.

[abhaysk]

Originally posted by prasadvd
ABHAY !

How did u change the ORACLE_SID in registry ?

Run REGEDIT

Gp to the path

My Comp>HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE>HOME

Change the ORACLE_SID.....

Abhay.