修改oracle实例的名称

修改oracle实例的名称相对比较简单，只需要修改环境变量ORACLE_ID，口令文件及参数文件的名称即可，步骤如下：

step 1：停止实例

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

step 2：修改环境变量ORACLE_SID

[oracle@wgx ~]$ vim .bash_profile


export ORACLE_BASE=/usr/local/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
##############################################################
#####   修改环境变量ORACLE_SID的取值为book
export ORACLE_SID=book
##############################################################
export ORACLE_OWNER=oracle
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'


[oracle@wgx ~]$ source .bash_profile 

step 3：修改口令文件和参数文件的名称

[oracle@wgx dbs]$ ls
hc_DBUA0.dat  hc_orcl.dat  init.ora  lkBOOK  lkBOOKS  lkMYDB  lkORCL  orapworcl  spfileorcl.ora
[oracle@wgx dbs]$ pwd
/usr/local/oracle/product/11.2.0/db_1/dbs
[oracle@wgx dbs]$ mv orapworcl orapwbook
[oracle@wgx dbs]$ mv spfileorcl.ora spfilebook.ora
[oracle@wgx dbs]$ ls
hc_DBUA0.dat  hc_orcl.dat  init.ora  lkBOOK  lkBOOKS  lkMYDB  lkORCL  orapwbook  spfilebook.ora

step 4：启动实例

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size		    2220200 bytes
Variable Size		  281022296 bytes
Database Buffers	  780140544 bytes
Redo Buffers		    5554176 bytes
Database mounted.
Database opened.

step 5：查看实例名称

SQL> show parameter name;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert		 string
db_name 			         string	 BOOK
db_unique_name			     string	 BOOK
global_names			     boolean FALSE
instance_name			     string	 book
lock_name_space 		     string
log_file_name_convert		 string
service_names			     string	 BOOK