How to change DBID?
STEP 1 Shutdown the database
STEP 2 Start database but not open.
STEP 3 execute following command on command prompt.
CMD>nid target=sys/password
STEP 4 Startup database with resetlogs option.
Important:
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
How to change DBNAME?
STEP 1 SQL> select dbid, name from v$database; (Note Down Output)
STEP 2 SQL> shutdown imemdiate;
SQL> startup mount;
STEP 3 SQL> host nid target=sys/Passworda DBNAME=INDIAN (New DB Name) setname=Y
STEP 4 SQL> !export ORACLE_SID=INDIAN
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount
SQL> show parameter db_name
SQL> alter system set db_name=INDIAN scope=spfile;
SQL> shutdown immediate;
SQL> startup
SQL> select name,dbid from v$database;
Modify parameter file and generate a new password file before restarting
