General
cancel
Showing results for 
Search instead for 
Did you mean: 

HPUX Error: 239: Connection refused

Jon H
Advisor

HPUX Error: 239: Connection refused

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.

18 REPLIES
Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

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.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
TTr
Honored Contributor

Re: HPUX Error: 239: Connection refused

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
Advisor

Re: HPUX Error: 239: Connection refused

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

Re: HPUX Error: 239: Connection refused

So you have HOST=xxx.xxx.com in your listener.ora?
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

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.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

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
Advisor

Re: HPUX Error: 239: Connection refused

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

Re: HPUX Error: 239: Connection refused

tnsnames.ora. change (HOST = localhost) to (HOST = xxx.xxx.com).
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

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

Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

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))
)
)
)
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

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.
Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

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))))
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

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))))
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

Still have the same error.
Court Campbell
Honored Contributor

Re: HPUX Error: 239: Connection refused

Ok, moving on. Is TNS_ADMIN set correctly?
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

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
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

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

Thanks for all the help.
Jon H
Advisor

Re: HPUX Error: 239: Connection refused

new oracle files...
not HPUX security.