- 论坛徽章:
- 0
|
本帖最后由 大红机器 于 2010-04-13 11:37 编辑
listener.ora配了,listener正常启动了,相应的service也配了
但是修改密码过程如下
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 13-APR-2010 10:45:23
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener ecip
Current Listener is ecip
LSNRCTL> change password
Old password:
New password:
Reenter new password:
TNS-01101: Could not find service name password
LSNRCTL>
--------------------------------------------------------------------------------------------------------------------------------
解决了
最后还是listener.ora配的问题
原来的listener.ora内容:
ECIP =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = 1523)))
SID_LIST_ECIP =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/ora10g/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = ecip)
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = 1523)))
)
)
修改为:
ECIP =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = 1523)))
SID_LIST_ECIP =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/ora10g/product/10.2.0)
(PROGRAM = extproc)
)
)
就好了,不过不知道为什么,恳请大虾解释一下 |
|