Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- srvctl config service -d test -s testsrv
- Service name: test
- Server pool:
- Cardinality: 2
- Disconnect: false
- Service role: PRIMARY
- Management policy: AUTOMATIC
- DTP transaction: false
- AQ HA notifications: true
- Global: false
- Commit Outcome: false
- Failover type: SESSION
- Failover method:
- TAF failover retries: 180
- TAF failover delay: 5
- Connection Load Balancing Goal: LONG
- Runtime Load Balancing Goal: NONE
- TAF policy specification: BASIC
- Edition:
- Pluggable database name:
- Maximum lag time: ANY
- SQL Translation Profile:
- Retention: 86400 seconds
- Replay Initiation Time: 300 seconds
- Session State Consistency:
- GSM Flags: 0
- Service is enabled
- Preferred instances: test1,test2
- Available instances:
- TEST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = testsrv-scan.idfcbank.com)(PORT = 1653))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = TEST)
- )
- )
- testsrv =
- (DESCRIPTION =
- (LOAD_BALANCE = ON)
- (FAILOVER = ON)
- (ADDRESS = (PROTOCOL = TCP)(HOST = testsrv-scan.idfcbank.com)(PORT = 1653))
- (CONNECT_DATA =
- (SERVICE_NAME = testsrv)
- (FAILOVER_MODE =
- (TYPE = SELECT)
- (METHOD = BASIC)
- (RETRIES = 180)
- (DELAY = 5)
- )
- )
- )
- 1* select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SYS'
- 1 SYS SYS$USERS NONE NONE NO
- 1 SYS SYS$USERS NONE NONE NO
- 1 SYS SYS$USERS NONE NONE NO
- 1 SYS SYS$USERS NONE NONE NO
- 1 SYS testsrv NONE NONE NO
- 2 SYS SYS$USERS NONE NONE NO
- 2 SYS SYS$USERS NONE NONE NO
- 2 SYS SYS$USERS NONE NONE NO
- NAME TYPE VALUE
- db_unique_name string test
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement