Monday, September 21, 2015

How to change DBID of Oracle Database



use Note: 224266.1 From Metalink


-Check DBID for both target and source instance ( they will be same)
select dbid, name, open_mode, activation#, created from v$database;

Command to change: 
-nid target=sys/manager@TEST_DB

Command to change Password file:
--Backup password file
[orafvnd@db1001]$ mv orapwTEST orapwTEST_old
 -rwSr-----   1 oratest  fvndba      1536 Sep  3 17:05 orapwFVND_old

[oratest@db1001]$ orapwd file=orapwTEST password=manager entries=2

No comments:

Post a Comment