topic Re: HPUX Error: 239: Connection refused in Operating System - HP-UX

HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 13:52:48 GMT

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.

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 14:02:17 GMT

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.

Re: HPUX Error: 239: Connection refused

TTr — Wed, 03 Sep 2008 14:09:44 GMT

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.

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 14:44:48 GMT

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

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 14:55:26 GMT

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

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 15:00:00 GMT

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.

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 15:26:03 GMT

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)
)
)

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 15:30:08 GMT

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...

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 15:40:35 GMT

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

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 15:46:56 GMT

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

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 16:02:37 GMT

It also looks like there is and extra parenthesis in this line:

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

try this:

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

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 16:16:52 GMT

TNS-01150: The address of the specified listener name is incorrect

Listener failed to start. See the error message(s) above...

I believe that ( was needed after all... at least according to the way I counted.

thanks for the help so far... let me know if there is anything else. I may end up reinstalling oracle shortly here.

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 16:26:34 GMT

I will use your info and lay out the line as I have it in my listener.ora files:

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

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 16:33:47 GMT

Man, my eyes are bugging out looking at this. sorry, try this:

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

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 16:46:20 GMT

Still have the same error.

Re: HPUX Error: 239: Connection refused

Court Campbell — Wed, 03 Sep 2008 16:52:42 GMT

Ok, moving on. Is TNS_ADMIN set correctly?

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 16:55:17 GMT

Yes
SHLIB_PATH=/oracle/product/10.1.0/lib:/usr/lib
PATH=/oracle/product/10.1.0/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/usr
/local/bin:.
ORACLE_BASE=/oracle
LOGNAME=oracle
ORACLE_SID=tempia11
SHLIB=/oracle/product/10.1.0/lib:/usr/lib
TNS_ADMIN=/oracle/product/10.1.0/network/admin
ORACLE_ADMIN=/oracle/product/admin
HOME=/home/oracle
ORACLE_HOME=/oracle/product/10.1.0

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 18:18:30 GMT

seemed to be sqlnet.ora or listener.ora file.

Thanks for all the help.

Re: HPUX Error: 239: Connection refused

Jon H — Wed, 03 Sep 2008 18:19:11 GMT

new oracle files...
not HPUX security.