ORACLE 11G 设置监听密码取消本地认证后无法动态注册

zengmuansha

设置监听文件listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))          # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))             # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON             # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON             # line added by Agent

#----ADDED BY TNSLSNR 29-APR-2014 18:35:23---
PASSWORDS_LISTENER = 25DF9EAFEE8A7DC3
LOCAL_OS_AUTHENTICATION_LISTENER = OFF
#--------------------------------------------

[grid@posdb03 admin]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-APR-2014 18:51:46

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             29-APR-2014 18:45:21
Uptime                   0 days 0 hr. 6 min. 31 sec
Trace Level             off
Security                ON: Password or Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File       /u01/app/grid/base/diag/tnslsnr/posdb03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.137)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.133)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "posc" has 1 instance(s).
  Instance "posdb1", status READY, has 1 handler(s) for this service...
Service "posdb" has 1 instance(s).
  Instance "posdb1", status READY, has 1 handler(s) for this service...
Service "posdbXDB" has 1 instance(s).
  Instance "posdb1", status READY, has 1 handler(s) for this service...
The command completed successfully

服务都在重启后无法动态注册 5分钟呢
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
LSNRCTL> start
Starting /u01/app/grid/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/grid/11.2.0/network/admin/listener.ora
Log messages written to /u01/app/grid/base/diag/tnslsnr/posdb03/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             29-APR-2014 18:52:00
Uptime                   0 days 0 hr. 0 min. 0 sec
Trace Level             off
Security                ON: Password
SNMP                   OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File       /u01/app/grid/base/diag/tnslsnr/posdb03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-01169: The listener has not recognized the password
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             29-APR-2014 18:52:00
Uptime                   0 days 0 hr. 0 min. 20 sec
Trace Level             off
Security                ON: Password
SNMP                   OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File       /u01/app/grid/base/diag/tnslsnr/posdb03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully

十分钟后依旧是那样的

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             29-APR-2014 18:52:00
Uptime                   0 days 0 hr. 10 min. 39 sec
Trace Level             off
Security                ON: Password
SNMP                   OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File       /u01/app/grid/base/diag/tnslsnr/posdb03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully

图文精华

ORACLE 11G 设置监听密码取消本地认证后 无法动态注册

ORACLE 11G 设置监听密码取消本地认证后无法动态注册