Thursday, July 17, 2008

Oracle rename db_domain and GlobalName of a database

Thursday, July 17, 2008 Posted by Andre Broers , , 8 comments
The steps I took where:

connect / as sysdba

alter database rename global_name to <sid><db_domain>;

alter system set db_domain=<db_domain> scope=spfile;

bounce the database

recreate the dbconsole repository as explained in this blogentry:

http://broersa.wordpress.com/2008/01/10/regenerate-database-console-repository/

8 comments:

  1. Quester is a Pakistan-based questioning answering website where people can ask questions and we try our best to provide them with the best answers. Anyone can ask any legit question in English or Roman Urdu and we provide answers in the same language format. www.quester.pk

    ReplyDelete