Operating System - HP-UX
1748145 Members
3483 Online
108758 Solutions
New Discussion юеВ

Re: Can not start the listener after patched oracle to 9.2.0.6.

 
SOLVED
Go to solution
MA Qiang
Regular Advisor

Can not start the listener after patched oracle to 9.2.0.6.

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.

6 REPLIES 6
Warren_9
Honored Contributor

Re: Can not start the listener after patched oracle to 9.2.0.6.

Hi,

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

Eric Antunes
Honored Contributor

Re: Can not start the listener after patched oracle to 9.2.0.6.

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
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Can not start the listener after patched oracle to 9.2.0.6.

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
Each and every day is a good day to learn.
MA Qiang
Regular Advisor

Re: Can not start the listener after patched oracle to 9.2.0.6.

/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
Honored Contributor
Solution

Re: Can not start the listener after patched oracle to 9.2.0.6.

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

Never give up, Keep Trying
MA Qiang
Regular Advisor

Re: Can not start the listener after patched oracle to 9.2.0.6.

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.