nid 修改oracle数据库名

由于前期规划问题，需要修改实例名，除了重装外，还可以使用nid修改
官方文档：http://docs.oracle.com/cd/E11882_01/server.112/e22490/dbnewid.htm#SUTIL1544
下面是将实例名PWDB87改为PWDB88过程：

1、创建pfile，并shutdown库重启库到mount状态：

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2.6657E+10 bytes
Fixed Size 2234080 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 1.3757E+10 bytes
Redo Buffers 12431360 bytes
Database mounted.

[csyz_oracle:/home/oracle$ps -ef|grep smon
oracle 286966 209758 0 15:40:27 pts/2 0:00 grep smon
oracle 270998 1 0 15:39:08 - 0:00 ora_smon_PWDB87
grid 86884 1 0 Mar 05 - 0:08 asm_smon_+ASM
复制

2、使用nid命令修改dbname

[csyz_oracle:/home/oracle$nid TARGET=SYS DBNAME=PWDB88 SETNAME=YES

DBNEWID: Release 11.2.0.3.0 - Production on Tue Mar 11 15:40:45 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Password:
Connected to database PWDB87 (DBID=4183327063)

Connected to server version 11.2.0

Control Files in database:
+DG_DATA1/pwdb87/controlfile/current.256.840725021

Change database name of database PWDB87 to PWDB88? (Y/[N]) => Y

Proceeding with operation
Changing database name from PWDB87 to PWDB88
Control File +DG_DATA1/pwdb87/controlfile/current.256.840725021 - modified
Datafile +DG_DATA1/pwdb87/datafile/system.260.84072505 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/sysaux.261.84072506 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/undotbs1.262.84072506 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/users.264.84072508 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_large.266.84183114 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_large.267.84183121 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/sts_precise_i3_pw.268.84183128 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_medium.269.84183144 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_medium.270.84183163 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_medium.271.84183176 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_medium.272.84183190 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_small.273.84183208 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_small.274.84183228 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_small.275.84183249 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_tab_small.276.84183270 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_small.277.84183277 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_small.278.84183297 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_small.279.84183317 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_small.280.84183336 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_85_ind_small.281.84183356 - wrote new name
Datafile +DG_DATA1/pwdb87/datafile/precise_i3_pw_tab_infra.282.84183370 - wrote new name
Datafile +DG_DATA1/pwdb87/tempfile/temp.263.84072506 - wrote new name
Control File +DG_DATA1/pwdb87/controlfile/current.256.840725021 - wrote new name
Instance shut down

Database name changed to PWDB88.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.
复制

3、修改pfile里面的db_name参数

[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$cp initPWDB87.ora initPWDB88.ora
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$vi initPWDB88.ora

*.db_name='PWDB88'
复制

4、生成新密码文件：

[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$pwd
/i3data1/oracle/app/oracle/product/11.2.0/db/dbs
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$ls
hc_PWDB87.dat init.ora initPWDB87.ora initPWDB88.ora lkPWDB87 orapwPWDB87
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$orapwd file=orapwPWDB88 password=oracle entries=10
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$ls -l
total 56
-rw-rw---- 1 oracle dba 1544 Mar 11 15:41 hc_PWDB87.dat
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 1008 Mar 11 15:37 initPWDB87.ora
-rw-r----- 1 oracle dba 1008 Mar 11 15:42 initPWDB88.ora
-rw-r----- 1 oracle dba 24 Feb 28 14:43 lkPWDB87
-rw-r----- 1 oracle dba 1536 Mar 11 15:38 orapwPWDB87
-rw-r----- 1 oracle dba 2560 Mar 11 15:44 orapwPWDB88
复制

5、修改环境变量，直接起库即可：

[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$. ~/.profile_11g
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$echo $ORACLE_SID
PWDB88

[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 11 15:45:45 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2.6657E+10 bytes
Fixed Size 2234080 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 1.3757E+10 bytes
Redo Buffers 12431360 bytes
Database mounted.
Database opened.

SQL> show parameter name

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_file_name_convert string

db_name string
PWDB88
db_unique_name string
PWDB88
global_names boolean
FALSE
instance_name string

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
PWDB88
lock_name_space string

log_file_name_convert string

processor_group_name string

service_names string
PWDB88
复制