Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

Popular posts from this blog

PostgreSQL pgBadger

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

Migrating From Oracle to PostgreSQL using ora2pg open source tools

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to configure Replication Manager (repmgr) ?