TNS listener error

[xiandao]

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

[Hein van den Heuvel]

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

[Victor Fridyev]

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

[T G Manikandan]

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.

[xiandao]

Thanks.
it work correctly now.