ORA-3136错误解决(二)
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XXXXXXXX" has 2 instance(s).
Instance "XXXXXX", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:16 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXXXX)(PORT=1521))
Instance "XXXXXX", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXX)(PORT=1521))
"DEDICATED" established:31 refused:0 state:ready
LOCAL SERVER
Service "XXXXXXXXX" has 2 instance(s).
Instance "XXXXXX", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXX)(PORT=6661))
Instance "XXXXXX", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXX)(PORT=51924))
Service "XXXXXXXX" has 2 instance(s).
Instance "XXXXXXX", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:16 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXX)(PORT=1521))
Instance "XXXXXXX", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXXX)(PORT=1521))
"DEDICATED" established:31 refused:0 state:ready
LOCAL SERVER
The command completed successfully
LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 60
The command completed successfully
4、修改之后观察一段时间
系统恢复正常。