oracle 导入时监听密码,学习笔记:Oracle监听管理 生产Oracle数据库设置监听密码

天萃荷净

Oracle监听设置密码，记录分享一个关于Oracle数据库监听程序的密码设置的方法

1.更改Oracle数据库监听密码

LSNRCTL> change_password

Old password:

New password:

Reenter new password:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521)))

Password changed for LISTENER

The command completed successfully

2.设置Oracle监听密码

LSNRCTL> set password

Password:

The command completed successfully

LSNRCTL> save_config

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521)))

Saved LISTENER configuration parameters.

Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora

Old Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.bak

The command completed successfully

[oracle@ecp-uc-db1 admin]$ cat listener.ora

#—-ADDED BY TNSLSNR 10-JUN-2011 18:13:24—

PASSWORDS_LISTENER = 6D7AA003392C436A

#——————————————–

note：10g数据库上需要上添加(重启监听)

LOCAL_OS_AUTHENTICATION_LISTENER = OFF

1、添加LOCAL_OS_AUTHENTICATION_LISTENER = OFF之前

Security ON: Password or Local OS Authentication

2、添加LOCAL_OS_AUTHENTICATION_LISTENER = OFF之后

Security ON: Password

3.查询Oralce监听状态

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521)))

TNS-01169: The listener has not recognized the password

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521)))

TNS-01169: The listener has not recognized the password

LSNRCTL>set password 123456

The command completed successfully

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.4.0 – Production

Start Date 10-JUN-2011 18:15:49

Uptime 0 days 0 hr. 1 min. 16 sec

Trace Level off

Security ON: Password

SNMP OFF

Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ECP-UC-DB1)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary…

Service “PLSExtProc” has 1 instance(s).

Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…

Service “ecp” has 1 instance(s).

Instance “ecp”, status READY, has 1 handler(s) for this service…

Service “ecpXDB” has 1 instance(s).

Instance “ecp”, status READY, has 1 handler(s) for this service…

Service “ecp_XPT” has 1 instance(s).

Instance “ecp”, status READY, has 1 handler(s) for this service…

The command completed successfully

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之学习笔记:Oracle监听管理 生产Oracle数据库设置监听密码