-
Set Default Database
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
-
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.
Thanks/Gopu
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
for the bash shell
export ORACLE_SID=neeraj
for tsch
set ORACLE_SID neeraj
for windows
set ORACLE_SID=neeraj
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|