The process of oraclerac adding service (11gr2 version)

The process of adding service to oracle rac (version 11gr2)
the
1. Manually add service
su-oracle
the
[oracle@dtydb3 ~]$ srvctl add service -d epmdb -s srv_epm1 -r epmdb1 -a epmdb2 -P basic -e select -m basic -z 180 -w 5
the
2. View service status and properties
the
sys@EPMDB1(10.4.124.233)> select name, failover_method, failover_type, goal, clb_goal from dba_services; www.2cto.com
the
NAME                                                                                                                                                                 |
——————– ———- ——————– —————————————————– —— —–
SYS$BACKGROUND . . . . . . . . . . . . . . . . . . . . . . . . .
SYS$USERS . . . . . . . . . . . . . . . . . . . . . . . . . .
epmdb . . . . . . . . . . . . . . . . . . . .
srv_epm1                                                                                                                  
the
[grid@dtydb3 ~]$ crsctl status resource ora.epmdb.srv_epm1.svc -t
————————————————– ——————————
NAME TARGET STATE SERVER STATE_DETAILS
————————————————– ——————————
Cluster Resources
————————————————– ——————————
ora.epmdb.srv_epm1.svc
                                                                   
[grid@dtydb3 ~]$ srvctl status service -d epmdb
Service srv_epm1 is running on instance(s) epmdb1
[grid@dtydb3 ~]$ srvctl config service -d epmdb -s srv_epm1
Service name: srv_epm1 www.2cto.com
Service is enabled
Server pool: epmdb_srv_epm1
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 5
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: epmdb1
Available instances: epmdb2
the
[grid@dtydb3 ~]$ lsnrctl status
the
LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 13-JUN-2012 15:22:46
the
Copyright (c) 1991, 2010, Oracle. All rights reserved.
the
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
————————
Alias ​​LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 – Production
Start Date         04-MAY-2012 14:36:04
Uptime 40 days 0 hr. 46 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP           OFF   www.2cto.com  
Listener Parameter File /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/dtydb3/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.243)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.233)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for this service…  
Service “epmdb” has 1 instance(s).
Instance “epmdb1”, status READY, has 1 handler(s) for this service…
Service “srv_epm1” has 1 instance(s).
Instance “epmdb1”, status READY, has 1 handler(s) for this service…
[grid@dtydb3 ~]$
the
3. Modify the service, if the creation is not normal
modify service
the
—srvctl modify service -d epmdb -s srv_epm1 -r epmdb2 -a epmdb1 -P basic -e select -m basic -z 100 -w 2
the
— delete service
the
srvctl remove service -d epmdb -s srv_epm1 -f
the
4. TAF test
the
tnsname.ora configuration
tydb_srv_epm1 =
(DESCRIPTION =
(LOAD_BALANCE = NO)
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = srv_epm1)
)
)
the
close instance 1
shutdown immediate
the
sqlplus system/oracle@tydb_srv_epm1
the
SQL> select instance_name from v$instance;
the
INSTANCE_NAME
—————-
epmdb2
www.2cto.com
Successfully switched to the second node
the
restore restore
the
Restart instance 1 startup
Switch service to instance 1
su-oracle
the
srvctl relocate service -d epmdb -s srv_epm1 -i epmdb2 -t epmdb1

the
the
Author hijk139