ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 配置solaris10 oracle10g的监听器密码

配置solaris10 oracle10g的监听器密码

原创 Linux操作系统 作者:wisdomone1 时间:2009-11-20 11:35:41 0 删除 编辑
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 1.       su – oracle

2.       vi $ORACLE_HOME/network/admin/listener.ora

添加如下内容

LOCAL_OS_AUTHENTICATION_LISTENER=OFF  ---涂绿为监听器的名字

3.       bash-3.00$ lsnrctl     ---输入lsnrctl进入监听器

 

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:30:46

 

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

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> set current_listener LISTENER    --- LISTENER为配置的监听器的名字

Current Listener is LISTENER

LSNRCTL> change_password               ---为监听器配置密码

Old password:                            ---如以前没配置过密码,回车就可

New password:                           ---配置新密码

Reenter new password:                     --重新确认新密码

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

Password changed for LISTENER

The command completed successfully

LSNRCTL> set password                   ---再次输入以上配置的新密码

Password:

The command completed successfully

LSNRCTL> save_config                    ---保存生效以上配置

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

Saved LISTENER configuration parameters.

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

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

The command completed successfully

LSNRCTL> status                       ----查看配置后监听器状态

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Solaris: Version 10.2.0.1.0 - Production

Start Date                20-NOV-2009 10:30:37

Uptime                    0 days 0 hr. 1 min. 36 sec

Trace Level               off

Security                  ON: Password             ---请注意,此时密码开启

SNMP                      OFF

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

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

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=240a)(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 "source" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

Service "sourceXDB" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

Service "source_XPT" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

The command completed successfully

4.       下次再对监听器进行任何操作

bash-3.00$ lsnrctl

 

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:33:58

 

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

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> status  

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

TNS-01169: The listener has not recognized the password   ---表明需要输入密码

LSNRCTL> set password                             ---输入密码就可,进行相关操作

Password:

The command completed successfully

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-620124/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689906