HPUX Error: 239: Connection refused

[Jon H]

New Itanium 11.23 HPUX, with Oracle 10.1.0.4.0 installed.

Trying to start the listener and getting the following errors.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.com)(PO
RT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused

Host is XXX.XXX on purpose...

Anyone offer suggestions. I know the listener.ora and tnsnames.ora are correct. I know the IP and hostname resolve forwards and back.

I believe there is some sort of blocking on the 1521 port that possible the OS is not allowing to work.

> telnet xxx 1521
Trying...
telnet: Unable to connect to remote host: Connection refused

> telnet xxx 22
Trying...
Connected to xxx.xxx.com.
Escape character is '^]'.

sendmail port works ftp etc. but not the 1521 for Oracle.

I am told the firewall is the same for all systems, and other systems(HPUX 11.11 and 11.00) the listener works and the telnet to 1521 works. I don't have access to other 11.23 systems and this is first I have setup with oracle, so I am hoping it is something in the OS like ipfilters or HIDS... but not sure..


Any suggestions would be greatly appreciated.

[Court Campbell]

If the listener isn't started it would make sense that you wold get a connection refused using telnet. You might try a metalink search (if you have an account). Or look at netca.

[TTr]

Check your listener.ora file for syntax errors and incorrect parameter settings. Also check the listener.log for any additional errors other than the ones printed at the listener start up.

[Jon H]

So I am guessing from the replies so far, that you all believe this to be a Oracle issue rather than something on HPUX.

Thanks - let me know if someone thinks of something different.

So far netca and metalink are not helping but were good suggestions.

I had looked at the log already but I will hand out points for trying to help.
Thanks all

[Court Campbell]

So you have HOST=xxx.xxx.com in your listener.ora?

[Court Campbell]

can you post your listener.ora and tnsnames file? It's hard to trouble shoot with the limited info. There are quite a few things that could cause this issue. It could be as simple as access rights for the oracle user to read the /etc/hosts file. I am not saying that's it, just making a point.

[Jon H]

listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = aaa.yyy.com)
(ORACLE_HOME = /oracle/product/10.1.0)
(SID_NAME = aaa)
)
)

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



tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

aaa.yyy.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aaa.yyy.com)
)
)

[Jon H]

this might be an issue but I dont know.... no protocols listed.
/oracle/product/10.1.0/bin> adapters tnslsnr

Oracle Net transport protocols linked with tnslsnr are:


Oracle Net naming methods linked with tnslsnr are:


Oracle Advanced Security options linked with tnslsnr are:

RC4 40-bit encryption
RC4 56-bit encryption
RC4 128-bit encryption
RC4 256-bit encryption
DES40 40-bit encryption
DES 56-bit encryption
3DES 112-bit encryption
3DES 168-bit encryption
AES 128-bit encryption
AES 192-bit encryption
AES 256-bit encryption
MD5 crypto-checksumming
SHA-1 crypto-checksumming
Kerberos v5 authentication
RADIUS authentication


further info.
/oracle/product/10.1.0/bin> adapters oracle

Oracle Net transport protocols linked with oracle are:

IPC
BEQ
TCP/IP
SSL
RAW

Oracle Net naming methods linked with oracle are:

Local Naming (tnsnames.ora)
Oracle Directory Naming
Oracle Host Naming

Oracle Advanced Security options linked with oracle are:

RC4 40-bit encryption
RC4 56-bit encryption
RC4 128-bit encryption
RC4 256-bit encryption
DES40 40-bit encryption
DES 56-bit encryption
3DES 112-bit encryption
3DES 168-bit encryption
AES 128-bit encryption
AES 192-bit encryption
AES 256-bit encryption
MD5 crypto-checksumming
SHA-1 crypto-checksumming
Kerberos v5 authentication
RADIUS authentication



listener.ora and tnsnames.ora have 755 perms with oracle oinstall as ownership...
/etc/hosts has 666 perms...

[Court Campbell]

tnsnames.ora. change (HOST = localhost) to (HOST = xxx.xxx.com).

[Jon H]

changed to xxx.xxx.com from localhost
Still getting the same error.