oracle 改实例名,oracle更改实例名

oracle更改实例名

------------------

--环境情况

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

PL/SQL Release 9.2.0.6.0 - Production

CORE    9.2.0.6.0       Production

TNS for Solaris: Version 9.2.0.6.0 - Production

NLSRTL Version 9.2.0.6.0 - Production

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

MED

SQL> select name from v$database;

NAME

---------

MED

--关闭数据块

SQL> SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

--修改环境变量ORACLE_SID

vi .bash_profile

将ORACLE_SID=MED改为ORACLE_SID=KONG

--修改口令文件和参数文件

/opt/oracle/product/9.2.0$cd dbs/

/opt/oracle/product/9.2.0/dbs$ls

init.ora       initMED.ora    initdw.ora     lkMED          orapwMED       snapcf_MED.f   spfileMED.ora

/opt/oracle/product/9.2.0/dbs$mv orapwMED orapwKONG

/opt/oracle/product/9.2.0/dbs$mv spfileMED.ora spfileKONG.ora

/opt/oracle/product/9.2.0/dbs$mv initMED.ora initKONG.ora

/opt/oracle/product/9.2.0/dbs$ls

init.ora        initKONG.ora    initdw.ora      lkMED           orapwKONG       snapcf_MED.f    spfileKONG.ora

--重新登录oracle用户使环境变量生效

/opt/oracle/product/9.2.0/dbs$exit

logout

~#su - oracle

--启动数据块

SQL> startup

ORACLE instance started.

Total System Global Area 2585237200 bytes

Fixed Size                   734928 bytes

Variable Size             436207616 bytes

Database Buffers         2147483648 bytes

Redo Buffers                 811008 bytes

Database mounted.

Database opened.

--验证

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

KONG

SQL> select name from v$database;

NAME

---------

MED

----------------------

--结论

通过修改环境变量中ORACLE_SID以及对应的参数文件名和口令文件名就可以重新命名实例

dump文件对应的目录如果也要改的话需要先更改参数文件中dump的路径

即使修改了实例名数据块名也不会发生变化