方法
如果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 编辑]