Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change the instance name

915529Feb 6 2012 — edited Sep 11 2012

I installed Oracle 11g database on linux redhat 32-bit OS and created a database with SID orcl and deleted it. now when i recreated a database with SID orcldg and after exporting the environmental variable ORACLE_SID as orcldg when the database is again started. querying the instance name as
SELECT INSTANCE_NAME FROM V$INSTANCE;
still returns the instance_name orcl. how can i change the instance name ?

Thanks in advance...

Edited by: k.bhanja on Feb 6, 2012 3:53 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2012

Added on Feb 6 2012

#general-database-discussions

24 comments

27,998 views