Oracle rac service addition Process (11gr2)

Oracle rac service addition Process (11gr2) 1. manually add servicesu-oracle [oracle @ dtydb3 ~] $ Srvctl add service-d epmdb-s srv_epm1-r epmdb1-a epmdb2-P basic-e select-m basic-z 180-w 5 2, view service status and Properties
Sys @ EPMDB1 (10.4.124.233)> select name, failover_method, failover_type, goal, clb_goal from dba_services; www.2cto.com NAME FAILOVER_M FAILOVER_TYPE GOAL CLB_G certificate ---------- certificate ------------ SYS $ background none certificate SYS $ users none SHORTepmdb LONGsrv_epm1 basic select none long [grid @ dtydb3 ~] $ Crsctl status resource ora. epmdb. srv_epm1.svc-t specify name target state server STATE_DETAILS specify Cluster Resources using ora. epmdb. srv_epm1.svc 1 ONLINE dtydb3 [grid @ dty Db3 ~] $ Srvctl status service-d epmdbService srv_epm1 is running on instance (s) epmdb1 [grid @ dtydb3 ~] $ Srvctl config service-d epmdb-s srv_epm1Service name: srv_epm1 internal Service is enabledServer pool: Protocol: 1 Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA specification: specification type: SELECTFailover method: BASICTAF failover retries: 180TAF failover delay: 5 Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Preferred instances: epmdb1Available instances: epmdb2 [grid @ dtydb3 ~] $ Lsnrctl status LSNRCTL for Linux: Version 11.2.0.2.0-Production on 13-JUN-2012 15:22:46 Copyright (c) 1991,201 0, Oracle. all rights reserved. connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER) STATUS of the LISTENER ------------------------ Alias LISTENERVersion TNSLSNR for Linux: version 11.2.0.2.0-ProductionStart Date 04-MAY-2012 14: 36: 04 Uptime 40 days 0 hr. 46 min. 42 secTrac E Level offSecurity ON: Local OS AuthenticationSNMP OFF www.2cto.com Listener Parameter File/oracle/11.2.0/grid/network/admin/listener. oraListener Log File/oracle/app/oracle/diag/tnslsnr/dtydb3/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = LISTENER) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 10.4.124.243) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOC OL = 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 ~] $3, modify the service, if the creation is abnormal, modify the service --- srvctl modify service-d epmdb-s srv_epm1-r epmdb2-a epmdb1-P basic-e select-m basic-z 100-w 2 -- delete service srvctl remove service-d epmdb-s srv_epm1-f 4, TAF test tnsname. ora configure 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 ))) shut down instance 1 shutdown immediate sqlplus system/oracle @ tydb_srv_epm1 SQL> select instance_name from v $ instance; INSTANCE_NAME ---------------- epmdb2 www.2cto.com is successfully switched to the second node recovery restart instance 1 startup switch service to instance 1su-oracle srvctl relocate service-d epmdb-s srv_epm1-I epmdb2-t epmdb1
Author hijk139