topic Re: TNS listener error in Operating System - HP-UX

TNS listener error

xiandao — Sun, 25 Apr 2004 04:30:12 GMT

I install oracle7.3.2.2 in hpux 11.00
I installed:
Oracle Names
Oracle Server Manager(Motif)
Oracle Server(RDBMS)
Oracle XA Library
PL/SQL V2
Pro*C
SQL*Net(V2)
SQL*Plus
TCP/IP Protocal Adepter(V2)

when I finished, I run root.sh with root
I want use SID:ysy and PORT 15216,
then add "listener 15216/tcp #for oracle"
in etc/services

cteate listener.ora in /etc:
LISTENER=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(Host=scoy)(Port=15216))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/oracle/app/oracle/product/7.3.2.2)
(SID_NAME=ysy)
)
)

STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER=10
TRACE_LEVEL_LISTENER=OFF

add tnsnames.ora in /etc:
Ysy=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(Host=scoy)(Port=15216))
(CONNECT_DATA=(SID=sej2))
)

then I run ../lsnrctl in fileã »manager

LSNRCTL for HPUX â ¦â ¦
Copyrightâ ¦â ¦

Message 850 not found;No message file for product=NETWORK, facility=NL
LSNRCTL>start
Message 1070 not found;No messge file for product=NETWORK, facility=TNSTNS-12545:Message 12545 not found;No Message file for product=NETWORK, facility=TNS
TNS-00515:Message 515 not found;No message file for product=NETWORK, facility=TNS
HPUX Error:2:No such file or directory.
LSNRCTL>

Why!? What I do is incorrect!
Pls help!

P.S. or hope you to tell me the correct steps
after install com

Re: TNS listener error

Hein van den Heuvel — Sun, 25 Apr 2004 12:31:44 GMT

>> Message 850 not found;No message file for product=NETWORK, facility=NL

Looks like the path ORACLE_HOME, and specifically the NLS directories below there, is not correct

>> then I run ../lsnrctl in fileÃ£Â Â»manager

What exactly do you mean by that?
Are you a root/system user, drilled down froma gui filemanager to teh Oracle executables and then try to start the listener? That's not goign to work.

You shoudl log in as the selected Oracle user (or for example su - oracle ). Now do 'env' and see a lot of ORA... and NLS... environment variables set up. With hose in place do 'lsnrctl start'

hth,

Re: TNS listener error

Victor Fridyev — Sun, 25 Apr 2004 13:40:57 GMT

Hi,

Why do you create listener.ora and tnsnames.ora in /etc ?
As far as I know, the right place is $ORACLE_HOME/network/admin directory.
It seems to me, the message says that you use pattern files in this directory.

HTH

Re: TNS listener error

T G Manikandan — Sun, 25 Apr 2004 23:18:02 GMT

By default Oracle uses port number 1521.There is no need to make entries in /etc/services file.

Also,

set the env. variables for Oracle like

ORACLE_HOME=
PATH=$PATH=$ORACLE_HOME/bin

Make sure that the files listener.ora and tnsnames.ora file are moved to $ORACLE_HOME/network/admin directory.

The best way to create LISTENER and service naming is to use the GUI tool,NET configuration Assistant or NET assistant whih will automatically create files for you.

Re: TNS listener error

xiandao — Mon, 26 Apr 2004 01:51:37 GMT

Thanks.
it work correctly now.