Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.44 KB | None | 0 0
  1. srvctl config service -d test -s testsrv
  2. Service name: test
  3. Server pool:
  4. Cardinality: 2
  5. Disconnect: false
  6. Service role: PRIMARY
  7. Management policy: AUTOMATIC
  8. DTP transaction: false
  9. AQ HA notifications: true
  10. Global: false
  11. Commit Outcome: false
  12. Failover type: SESSION
  13. Failover method:
  14. TAF failover retries: 180
  15. TAF failover delay: 5
  16. Connection Load Balancing Goal: LONG
  17. Runtime Load Balancing Goal: NONE
  18. TAF policy specification: BASIC
  19. Edition:
  20. Pluggable database name:
  21. Maximum lag time: ANY
  22. SQL Translation Profile:
  23. Retention: 86400 seconds
  24. Replay Initiation Time: 300 seconds
  25. Session State Consistency:
  26. GSM Flags: 0
  27. Service is enabled
  28. Preferred instances: test1,test2
  29. Available instances:
  30.  
  31. TEST =
  32. (DESCRIPTION =
  33. (ADDRESS = (PROTOCOL = TCP)(HOST = testsrv-scan.idfcbank.com)(PORT = 1653))
  34. (CONNECT_DATA =
  35. (SERVER = DEDICATED)
  36. (SERVICE_NAME = TEST)
  37. )
  38. )
  39.  
  40.  
  41. testsrv =
  42. (DESCRIPTION =
  43. (LOAD_BALANCE = ON)
  44. (FAILOVER = ON)
  45. (ADDRESS = (PROTOCOL = TCP)(HOST = testsrv-scan.idfcbank.com)(PORT = 1653))
  46. (CONNECT_DATA =
  47. (SERVICE_NAME = testsrv)
  48. (FAILOVER_MODE =
  49. (TYPE = SELECT)
  50. (METHOD = BASIC)
  51. (RETRIES = 180)
  52. (DELAY = 5)
  53. )
  54. )
  55. )
  56.  
  57. 1* select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SYS'
  58.  
  59. 1 SYS SYS$USERS NONE NONE NO
  60. 1 SYS SYS$USERS NONE NONE NO
  61. 1 SYS SYS$USERS NONE NONE NO
  62. 1 SYS SYS$USERS NONE NONE NO
  63. 1 SYS testsrv NONE NONE NO
  64. 2 SYS SYS$USERS NONE NONE NO
  65. 2 SYS SYS$USERS NONE NONE NO
  66. 2 SYS SYS$USERS NONE NONE NO
  67.  
  68. NAME TYPE VALUE
  69. db_unique_name string test
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement