Set Default Database

[neeraj.mca1982]

Hi Dear,
I had Oracle10G database (Database Name "ORCL") by DBCA and again another ones I create a Database by manually (Database Name "Neeraj")
When I Open the database then by default ORCL database has been opened.
and for open the Neeraj Database every time we set
SET ORACLE_SID=Neeraj
Please support to me What i do, When I open the database by default Neeraj database has been open.

Regards,
Neeraj Singh

[gopu_g]

Which plat form you are using?
if you are using windows you have to change the Home PATH and set "Neeraj" database home ,you can find it in the properties of mycomputer, Advanced tab, environment variables.

If you are using Linux you have to set the profile(. bash_profile) same like that.

[vnktummala]

adding to Gopu, you need to set ORACLE_SID parameter to 'Neeraj' in windows system variables section. For UNIX you can set the same in .profile or .bash_profile.

Thanks,

[gandolf989]

for the bash shell
export ORACLE_SID=neeraj
for tsch
set ORACLE_SID neeraj
for windows
set ORACLE_SID=neeraj