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 Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools

7 Steps to configure BDR replication in postgresql