change database id of database

2010-12-16  张林 

change database id of database

SQL script to change database id of database.
. oraenv
sqlplus / as sysdba
shutdown immediate (shutdown abort if need)
startup mount
host nid target=/ (tesed, why it hold here?)
--OR
--exit
--nid TARGET=system/password
--sqlplus / as sysdba
startup mount (shutdown abort if need)
alter database open resetlogs;
select dbid from v$database;
 
http://remidian.com/oracle/change-database-id-of-database.html
fyi,1) login as "oracle"

. oraenv

 input sid

 2) sqlplus '/as sysdba'

   SQL> alter user system identified by "yourpassword";

 alter user sys identified by "yourpassword";

alter user system identified by "yourpassword";

alter user dbsnmp identified by "yourpassword";

alter user sysman identified by "yourpassword";

grant sysdba to system;
325°/3256 人阅读/0 条评论 发表评论

登录 后发表评论