This article can guide you to alter the DBID for Oracle databases whenever we are in need of it. Here we will use DBNEWID utility to change the same. Below are the steps to follow.
Index
Steps to Change the DBID for Oracle Database
Before starting the process of changing the DBID please ensure you have a full database backup.
Step 1 –
SHUTDOWN IMMEDIATE STARTUP MOUNT
Step 2 –
$ nid TARGET=SYS/
Step 3 –
STARTUP MOUNT
Step 4 –
ALTER DATABASE OPEN RESETLOGS;
Steps to Change DBNAME along with DBID
In case you need to change the database name also along with DBID then the process is the same as above, the only difference is the command, stated below
nid TARGET=SYS/<Password> DBNAME=<NEW DATABASE NAME>
Conclusion
The above article has provided you with enough information about how to change the DBID along with DBNAME for a oracle database.
FAQ
How to Find DBID in Oracle ?
SQL Query to find DBID –
SELECT DBID FROM V$DATABASE;
Another way to get the DBID is through connecting the RMAN utility
RMAN TARGET /
connected to target database: TESTDB (DBID=1756755399)