Oracle中修改ORACLE_SID

关注

转载最新推荐文章于 2025-07-06 19:53:04 发布 1k 阅读 AI 写同款· GEO 优化 ›

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

点击(此处)折叠或打开

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

2.更改环境变量

点击(此处)折叠或打开

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

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

修改后的如下：

点击(此处)折叠或打开

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

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

点击(此处)折叠或打开

备哈份。。。

点击(此处)折叠或打开

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

点击(此处)折叠或打开

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

点击(此处)折叠或打开

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

点击(此处)折叠或打开

[oracle@rac1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 11 07:24:46 2016
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2255832 bytes
Variable Size 180356136 bytes
Database Buffers 436207616 bytes
Redo Buffers 7507968 bytes
Database mounted.
Database opened.
SQL> select instance from v$thread;

INSTANCE
-----------------------------------------
oradg