Andre Broers’ personal blog

July 17, 2008

Oracle rename db_domain and GlobalName of a database

Filed under: oracle — Tags: , , — broersa @ 9:30 am

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/

No Comments Yet »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.