查询oracle rac实例名,oracle 10g RAC 实例名称修改？

方法

如果node1节点已经有实例1了，现在改成实例a，如下

先做实例的配置，

登录实例1.

ORACLE_SID=inthrac1

sqlplus / as sysdba

create pfile='init_.ora‘ from spfile;

host vi init_.ora

:%s/inthrac1/inthraca

:%s/inthrac2/inthracb

:x

create spfile='+DG01/inthrac/spfileinthrac_.ora' from pfile='init_.ora';

host cp $ORACLE_HOME/dbs/initthrac1.ora $ORACLE_HOME/dbs/initthraca.ora

host vi $ORACLE_HOME/dbs/initthraca.ora

host orapwd file=$ORACLE_HOME/dbs/orapwinthraca password=**********

:%s/spfileinthrac/spfileinthrac_

:x

shutdown immedaite;

host ORACLE_SID=inthraca

startup

host lsnrctl status

shutdown immediate

srvctl add instance -d inthrac -i inthraca -n inthrac01

crs_stat -t

至此inthraca已经成功加入。

如法可以添加inthracb，

记得最后要用inthrac1.inthrac两个用 srvctl remove instance 删除掉。

host crs_stat ora.inthrac.inthraca.inst

NAME=ora.inthrac.inthraca.inst

TYPE=application

ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/db_1/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for Instance

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=inthrac01

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=ora.inthrac01.vip

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=600

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=

的确，这里对于客户端，实例名都是透明的，客户端是用service_name而非SID，所以没有太多意义，

以上仅是学习研究之用而已。

[本帖最后由 inthirties2 于 2010-7-31 01:32 编辑]