Re: listener problem

The password that has been set in listener.ora. If you don't want it, just delete the line password_listener = <some string> Hth,

Sybrand Bakker, Oracle DBA

Fei Sha wrote:

> Hi,
>
> I'm trying oracle 8 enterprise 8.0.3.0.2 on NT 4.0 SP3.
>
> I can connect to the database from Oracle Navigater and
> Oracle JDBC. When I connect with PLUS80W.exe, it works but with
> a warning msg :
>
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
>
> I don't really understand this but np.
>
> When I use PLUS80.exe to connect then:
>
> ERROR:
> ORA-12203: TNS:unable to connect to destination
>
> LSNRCTL -status
>
> LSNRCTL> status
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR80 for 32-bit Windows: Version
> 8.0.3.0.0 - Prod
> uction
> Start Date 28-OCT-98 23:27:14
> Uptime 0 days 12 hr. 14 min. 8 sec
> Trace Level off
> Security ON
> SNMP OFF
> Listener Parameter File C:\O8SERVER\NET80\admin\listener.ora
> Listener Log File C:\O8SERVER\NET80\log\listener.log
> Services Summary...
> OEM has 1 service handler(s)
> extproc has 1 service handler(s)
> The command completed successfully
>
> LSNRCTL> start
> Starting tnslsnr80: please wait...
>
> TNS-01106: Listener using listener name LISTENER has already been
> started
>
> LSNRCTL> stop
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
> TNS-01169: The listener has not recognized the password
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=OEM))
> TNS-01169: The listener has not recognized the password
> Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=nora)(Port=1521))
> TNS-01169: The listener has not recognized the password
> Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=nora)(Port=1526))
> TNS-01169: The listener has not recognized the password
> Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
> TNS-01169: The listener has not recognized the password
>
> What password it talks about?
>
> Thanks!
>
> Fei
Received on Thu Oct 29 1998 - 12:07:36 CST