HPUX Error: 239: Connection refused

[Court Campbell]

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

[Jon H]

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]

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

[Court Campbell]

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

[Jon H]

Still have the same error.

[Court Campbell]

Ok, moving on. Is TNS_ADMIN set correctly?

[Jon H]

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]

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

Thanks for all the help.

[Jon H]

new oracle files...
not HPUX security.