解决Oracle监听器失效:
(1)在listener.ora文件的最后(括号之外),加入参数:
DIRECT_HANDOFF_TTC_LISTENER=OFF
(2)用System账户进入,执行:
SQL> alter system shutdown immediate 'D001';
SQL> alter system set DISPATCHERS = '(protocol=tcp) (dispatchers=3)';
(1)在listener.ora文件的最后(括号之外),加入参数:
DIRECT_HANDOFF_TTC_LISTENER=OFF
(2)用System账户进入,执行:
SQL> alter system shutdown immediate 'D001';
SQL> alter system set DISPATCHERS = '(protocol=tcp) (dispatchers=3)';