Change Oracle DB Name ,DBID and Both
Change Oracle DB Name ,DBID and Both Oracle DBA changing database name ,DBID or both are common activity which are needed to be performed regularly. With the introduction on the NID utility this has become easy to make such changes.In this blog , We will show you how to change : 1. DB Name and ID 2. DB Name 3. DBID using NID utility. Change DB Name and DBID: 1) Take Full backup of the database and mount database. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 251658240 bytes Fixed Size 2236368 bytes Variable Size 161210416 bytes Database Buffers 83886080 bytes Redo Buffers ...