Set Default Database
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
Please support to me What i do, When I open the database by default Neeraj database has been open.
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.
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.
Try hard to get what you like OR you will be forced to like what you get.
for the bash shell
set ORACLE_SID neeraj
this space intentionally left blank
Click Here to Expand Forum to Full Width