Oracle nid utility
1. Shut down the database
2. Startup mount database
3. Run the nid utility as below and also as below recommended please change the parameter file for the dbname parameter and you cna open up the database
nid target=sys/oracle dbname=NIJAM setname=YES
DBNEWID: Release 11.2.0.3.0 – Production on Wed Dec 24 09:09:19 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database BENZ (DBID=790652138)
Connected to server version 11.2.0
Control Files in database:
/u02/app/benz/control/control1.ctl
/u02/app/benz/control/control2.ctl
/u02/app/benz/control/control3.ctl
Change database name of database BENZ to NIJAM? (Y/ [N]) => Y
Proceeding with operation
Changing database name from BENZ to NIJAM
Control File /u02/app/benz/control/control1.ctl – modified
Control File /u02/app/benz/control/control2.ctl – modified
Control File /u02/app/benz/control/control3.ctl – modified
Datafile /u02/app/oracle/benz/system01.db – wrote new name
Datafile /u02/app/oracle/benz/sysaux01.db – wrote new name
Datafile /u02/app/oracle/benz/undotbs01.db – wrote new name
Datafile /u02/app/oracle/benz/user01.db – wrote new name
Datafile /u02/app/oracle/benz/apex01.db – wrote new name
Datafile /u02/app/oracle/benz/ggs_data01.db – wrote new name
Datafile /u02/app/benz/temp01.db – wrote new name
Control File /u02/app/benz/control/control1.ctl – wrote new name
Control File /u02/app/benz/control/control2.ctl – wrote new name
Control File /u02/app/benz/control/control3.ctl – wrote new name
Instance shut down
Database name changed to NIJAM.
Modify parameter file and generate a new password file before restarting.
Successfully changed database name.
DBNEWID – Completed successfully.
SQL> select name, open_mode, database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————- —————-
NIJAM READ WRITE PRIMARY
4. Change db_name in spfile (or in pfile editing the file):
Alter system set db_name=newname scope=spfile;
5. Recreate password file:
orapwd file=orapwNIJAM password=oracle
6. Startup the database
Startup
7. Post rename steps:
- Change SID in listener.ora
- Correct tnsnames.ora
- Remove old trace directories
Change /etc/oratab(UNIX) or rename windows service using oradim
Comments
Post a Comment