Can not start the listener after patched oracle to 9.2.0.6.

[MA Qiang]

The error is as follows:
> lsnrctl start

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 28-JUN-2005 08:35:11

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /opt/oracle/ora92/product/9.2.0/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek

> cat listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/ora92/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = saturn)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = saturn)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/ora92/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = catalog)
(ORACLE_HOME = /opt/oracle/ora92/product/9.2.0)
(SID_NAME = catalog)
)
)

When I comment the following lines:

# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCPS)(HOST = saturn)(PORT = 2484))
# )

I can start the listener.
But I can start the listener with the origin listener.ora before patched.

Are there anything wrong with my patching?


Thanks.

[Warren_9]

Hi,

is the /etc/hosts file to include
"127.0.0.1 localhost.[localdomain] localhost"??

[Eric Antunes]

Hi,

As said in Note 1010529.6 (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1010529.6&p_database_id=NOT), the last close parenthesis shouldn't be in column 1.

Try it with listener.ora like this:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = saturn)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = saturn)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/ora92/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = catalog)
(ORACLE_HOME = /opt/oracle/ora92/product/9.2.0)
(SID_NAME = catalog)
)
)


Best Regards,

Eric Antunes

[Eric Antunes]

Hi again,

The forum erases TABS... Let's see like this:

LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= )(Port= 1521))
)

Also, don't forget to set:

CONNECT_TIMEOUT_ = 10


Best Regards,

Eric Antunes

[MA Qiang]

/etc/hosts is not changed after patching.
# ping localhost
PING localhost: 64 byte packets
64 bytes from 127.0.0.1: icmp_seq=0. time=0. ms
64 bytes from 127.0.0.1: icmp_seq=1. time=0. ms

----localhost PING Statistics----
2 packets transmitted, 2 packets received, 0% packet loss
round-trip (ms) min/avg/max = 0/0/0

I want to learn someting about TCPS. I wonder whether TCPS module is upgrade correctly.

[Indira Aramandla · Accepted solution]

Hi Qiang,

If after applying the latest patch set for Oracle Database9i Release there is a problem with the listener as
Error: TNS-12537:
TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
According to metalink note this It is a problem with protocol adaptors. Oracle Net transport protocols linked with tnslsnr are:
IPC
BEQ
TCP/IP
SSL
RAW
Listener.ora:
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)....)
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)...)

After disabling TCPS entry the problem has gone.
Now how to enable to use TCPS
Here is how.
If the listener is failing to start and it is due to the underlying tcps not setup correctly, Make sure you have ASO installed on the server.

To check if ASO is installed â ¦On a UNIX platform run the 'adapters' command at the shell. If you have ASO installed you will see something like, Installed Oracle Advanced Security option/Security products are:
RC4 40-bit encryption algorithm
RC4 56-bit encryption algorithm
DES40 40-bit encryption algorithm
DES 56-bit encryption algorithm
MD5 crypto-checksumming algorithm
But Oracle also says that there are several bugs listed refering to listeners and the tcps. As a workaround,
Shutdown all the process for the database and listener and do a relink all.

I hope this helps.

Indira A

[MA Qiang]

I reinstall the patch:
Secure Socket Layer Patch 9.2.0.6.0
SSL Required Support Files Patch 9.2.0.6.0
and TCPS can work.

Thanks.