Re: Oracle listener problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 27 Jun 2001 19:45:23 +0200
Message-ID: <tjk6pk7g2ruta7@beta-news.demon.nl>

"Reinhard Pagitsch" <reinhard.pagitsch_at_isis-papyrus.com> wrote in message news:9hcb4l$d9a2b$1_at_ID-86832.news.dfncis.de...
> Hello,
>
> does anybody know what the problem is and how I can solve it?
>
> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.201)(PORT=1521)
> TNS-12224: TNS:no listener
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> 32-bit Windows Error: 61: Unknown system error
> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=1.1.6.23)(PORT=1521))
> TNS-01169: The listener has not recognized the password
> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=1.1.6.23)(PORT=1522))
> TNS-01169: The listener has not recognized the password
>
> Thank you,
> Reinhard
>
>
>
>

The listener has a password and you didn't use the set password command before attempting the operations you are getting errors for. The listeners password is in listener.ora in the line password_listener=()
both encrypted and unencrypted is allowed In the former case you need to issue
set password<RET>
<your password>

In the latter case
set password <password>

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Jun 27 2001 - 12:45:23 CDT