srvctl add service -db rac -service acsrv -preferred rac1 -available rac2 failovertype TRANSACTION -commit_outcome TRUE -failoverretry 30 -failoverdelay 10 -retention 86400 -replay_init_time 1800 -notification TRUE
srvctl start service -db rac -service acsrv
url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv-scan)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=acsrv)))
[oracle@srv1 ac_demo]$ srvctl config service -db rac -s acsrv
Service name: acsrv
Server pool:
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Global: false
Commit Outcome: true
Failover type: TRANSACTION
Failover method:
TAF failover retries: 30
TAF failover delay: 10
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 1800 seconds
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: rac1
Available instances: rac2
[oracle@srv1 ac_demo]$
# test: conn scott/tiger@//srv1:1531/acsrv
No comments:
Post a Comment