centos7.2 oracle10g 如何修改sid实例名

主机名改变后需要更改改下面的文件

1.  监听里的host需要更改如下：

/u01/app/oracle/product/10.2.0/db_1/network/admin

修改如下文件主机名

 sed –i 's/ora10/oracle10/g'/u01/app/oracle/product/10.2.0/db_1/network/admin/ listener.ora

 

[oracle@host-192-168-246-161 admin]$ cat listener.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME =PLSExtProc)

      (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS =(PROTOCOL = TCP)(HOST = oracle10)(PORT= 1521))

      (ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

2.  修改主机名

hostnamectl set-hostnameoracle

vi /etc/hosts

192.168.246.161oracle10

修改实例名sid

1.  检查原来数据库名

[oracle@oracle admin]$ echo $ORACLE_SID

ora10

[oracle@oracle admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 8 11:04:152017

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

SQL> select instance from v$thread;

INSTANCE

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

ora10

2.  修改Oracle用户的ORACLE_SID环境变量，如由orc10修改为oracle10

[oracle@oracle admin]$ cat ~/.bash_profile | grep -i sid

export ORACLE_SID=ora10

[oracle@oracle admin]$ sed -i 's/ora10/oracle10/g' ~/.bash_profile

[oracle@oracle admin]$ cat ~/.bash_profile | grep -i sid

export ORACLE_SID=oracle10

3.  使新修改的ORACLE_SID环境变量生效

[oracle@oracle dbs]$ source ~/.bash_profile

[oracle@oracle dbs]$ echo $ORACLE_SID

oracle10

4.  修改/etc/oratab文件，将sid名由旧的修改为新的，如从orc10修改为oracle10

[oracle@oracle admin]$ vi /etc/oratab

oracle10:/u01/app/oracle/product/10.2.0/db_1:Y

 [oracle@oracle admin]$cd $ORACLE_HOME/dbs

[oracle@oracle dbs]$ pwd

/u01/app/oracle/product/10.2.0/db_1/db