Oracle中修改ORACLE_SID

1.首先我们来查看下当前数据库的一些信息，如下

点击(此处)折叠或打开

1. [root@rac1 ~]# su - oracle
   
2. [oracle@rac1 ~]$ env | grep ORACLE
   
3. ORACLE_SID=rac1
   
4. ORACLE_HOSTNAME=rac1
   
5. ORACLE_BASE=/u01/app/oracle
   
6. ORACLE_TERM=xterm
   
7. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
   
8. [oracle@rac1 ~]$

上面显示的ORACLE_SID为rac1，将更改为oradg



2.更改环境变量

点击(此处)折叠或打开

1. [oracle@rac1 ~]$ export ORACLE_SID=oradg 
   
2. [oracle@rac1 ~]$ export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

注意export后的ORACLE_SID前没有"$"符号。



3.查看并更改配置文件    /etc/oratab中最后一行的sid（如我的就是rac1 -> oradg）

修改后的如下：

点击(此处)折叠或打开

1. [oracle@rac1 ~]$ more /etc/oratab
   
2. #Backup file is /u01/app/grid/product/11.2.0/grid/srvm/admin/oratab.bak.rac1 line added by Agent
   
3. #
   
4. 
   
5. 
   
6. 
   
7. # This file is used by ORACLE utilities. It is created by root.sh
   
8. # and updated by either Database Configuration Assistant while creating
   
9. # a database or ASM Configuration Assistant while creating ASM instance.
   
10. 
    
11. # A colon, ':', is used as the field terminator. A new line terminates
    
12. # the entry. Lines beginning with a pound sign, '#', are comments.
    
13. #
    
14. # Entries are of the form:
    
15. # $ORACLE_SID:$ORACLE_HOME::
    
16. #
    
17. # The first and second fields are the system identifier and home
    
18. # directory of the database respectively. The third filed indicates
    
19. # to the dbstart utility that the database should , "Y", or should not,
    
20. # "N", be brought up at system boot time.
    
21. #
    
22. # Multiple entries with the same $ORACLE_SID are not allowed.
    
23. #
    
24. #
    
25. +ASM:/u01/app/grid/product/11.2.0/grid:N
    
26. oradg:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent

4.更改数据库系统文件，进入$ORACLE_HOEM/dbs目录下，更改所有文件名中含有老的SID，不过在修改之前，先对将要改的文件进行备
份，后面出现问题号修改

点击(此处)折叠或打开

1. [oracle@rac1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
   
2. [oracle@rac1 dbs]$ ll
   
3. total 10284
   
4. -rw-r----- 1 oracle asmadmin 10493952 Mar 11 07:10 datadg
   
5. -rw-rw---- 1 oracle asmadmin 1544 Mar 11 07:10 hc_rac1.dat
   
6. -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
   
7. -rw-r----- 1 oracle oinstall 37 Mar 10 21:54 initrac1.ora
   
8. -rw-r----- 1 oracle asmadmin 24 Mar 10 21:43 lkRAC1
   
9. -rw-r----- 1 oracle oinstall     1536 Mar 10 21:54 orapwrac1

备哈份。。。

点击(此处)折叠或打开

1. [oracle@rac1 dbs]$ cp hc_rac1.dat hc_rac1.dat.bak
   
2. [oracle@rac1 dbs]$ cp initrac1.ora initrac1.ora.bak
   
3. [oracle@rac1 dbs]$ cp lkRAC lkRAC.bak
   
4. [oracle@rac1 dbs]$ cp orapwrac1 orapwrac1.bak

上面六个文件名中所有含rac1的都要将其改为oradg,如下所示

点击(此处)折叠或打开

1. hc_rac1.ora ------> hc_oradg.ora
2. initrac1.ora ------> initoradg.ora
3. lkRAC1 ------> lkORADG
4. orapwrac1 ------> orapworadg

修改后目录下的所有文件如下：

点击(此处)折叠或打开

1. [oracle@rac1 dbs]$ ll
   
2. total 10300
   
3. -rw-r----- 1 oracle asmadmin 10493952 Mar 11 07:10 datadg
   
4. -rw-rw---- 1 oracle asmadmin 1544 Mar 11 07:10 hc_oradg.dat
   
5. -rw-r----- 1 oracle oinstall 1544 Mar 11 07:17 hc_rac1.dat.bak
   
6. -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
   
7. -rw-r----- 1 oracle oinstall 37 Mar 10 21:54 initoradg.ora
   
8. -rw-r----- 1 oracle oinstall 37 Mar 11 07:17 initrac1.ora.bak
   
9. -rw-r----- 1 oracle oinstall 24 Mar 11 07:22 lkORADG
   
10. -rw-r----- 1 oracle oinstall 24 Mar 11 07:22 lkRAC1.bak
    
11. -rw-r----- 1 oracle oinstall 1536 Mar 10 21:54 orapworadg
    
12. -rw-r----- 1 oracle oinstall     1536 Mar 11 07:17 orapwrac1.bak

5.最后进入SQLPLUS 打开数据库

点击(此处)折叠或打开

1. [oracle@rac1 dbs]$ sqlplus / as sysdba
   
2. 
   
3. SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 11 07:24:46 2016
   
4. 
   
5. Copyright (c) 1982, 2013, Oracle. All rights reserved.
   
6. 
   
7. Connected to an idle instance.
   
8. 
   
9. SQL> startup
   
10. ORACLE instance started.
    
11. 
    
12. Total System Global Area 626327552 bytes
    
13. Fixed Size 2255832 bytes
    
14. Variable Size 180356136 bytes
    
15. Database Buffers 436207616 bytes
    
16. Redo Buffers 7507968 bytes
    
17. Database mounted.
    
18. Database opened.
19. SQL> select instance from v$thread;
    
    
    INSTANCE
    -----------------------------------------
    oradg

看下上面的实例名，已经完成更改了。

退出sqlplus，去看下系统环境变量

点击(此处)折叠或打开

1. [oracle@rac1 dbs]$ env | grep ORACLE
   
2. ORACLE_SID=oradg
   
3. ORACLE_HOSTNAME=rac1
   
4. ORACLE_BASE=/u01/app/oracle
   
5. ORACLE_TERM=xterm
   
6. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
   
7. [oracle@rac1 dbs]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30258496/viewspace-2059865/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30258496/viewspace-2059865/