Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have Oracle 11g(windows) database in which i had two database "orcl" and "abc"
When i open oracle database control it show Database Instance: orcl
Now i delete database "orcl" and when i open oracle database control it still shows Database Instance: orcl but with status down.
I want new Database Instance: abc
How to do this. Plz help
Posted

1 solution

I take it that you mean that you have two separate instances and databases? Typically two different instances are bound to separate databases.

If yo already have the instances, in order to operate with another one, you need to change the SID definition. Depending on how you connect the database the SID may be changed differently. Very often the SID is specified using an environment variable so if this is a Windows machine, using command prompt, check if ORACLE_SID is defined and change the value of that environment variable to proper SID name.

Remember that if you change the variable in a command prompt, the change is effective only until you close the prompt.
 
Share this answer
 
Comments
Raj Negi 29-Aug-14 2:26am    
How to check ORACLE_SID and how to change SID. I am totally new to oracle DB, I dont know how to do it.
Wendelius 29-Aug-14 3:04am    
If you're using Windows and you use command prompt based toos, then type SET in command prompt to see the current ORACLE_SID.

Another way is to open computer properties and open environment variables. There you should see ORACLE_SID and be able tio change it.

Have a look at following document. Hopefully it would help you: Administering Oracle Database / Environment Variables[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900