how to check the this in Listener

[Former Member]

Dear All,

I am face problem in Listener.

At present Listener is up and sap is working fine.

While going through log I find this error.

Please suggest how to resolved the problem .

we are using oracle 9i and Ecc 5

LISTENER2Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\oracle\ora92\network\admin\listener.ora

Log messages written to E:\oracle\ora92\network\log\listener2.log

Trace information written to E:\oracle\ora92\network\trace\listener2.trc

Trace level is currently 0

Started with pid=1268

TNS-01151: Missing listener name, LISTENER2, in LISTENER.ORA

LISTENER.ORA

LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora

Generated by Oracle configuration tools.

STARTUP_WAIT_TIME_FS****-SAP-ORAV = 0

LISTENER1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = ***-SAP***)(PORT = 1528))

)

)

)

ADMIN_RESTRICTIONS_FS****-SAP-ORAV = on

FSL****--SAP-ORAV =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = PRD))

(ADDRESS = (PROTOCOL = IPC)(KEY = PRD.WORLD))

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(Host = *********)(Port = 1527))

)

#

This file is written by Oracle Services For MSCS

on Tue May 16 21:20:04 2006

#

TRACE_LEVEL_FS****--SAP-ORAV = OFF

CONNECT_TIMEOUT_LISTENER = 10

STARTUP_WAIT_TIME_LISTENER = 0

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = ********)(PORT = 1527))

)

)

)

SID_LIST_F****--SAP-ORAV =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = E:\oracle\ora92)

)

)

TRACE_LEVEL_LISTENER = OFF

CONNECT_TIMEOUT_FS****--SAP-ORAV = 10

NMICONF.LOG

DBSNMP for 32-bit Windows: release 9.2.0.7.0 - Production on *

Discovering services on ***configured on host addresses {***-01. ********.5 ****}

Warning : Skipping OracleOraHome92TNSListenerFsl****: Could not find corresponding listener definition in

Warning : Skipping OracleOraHome92TNSListenerLISTENER2 : Could not find corresponding listener definition in

Warning : Skipping OracleOraHome92TNSListenerprd : Could not find corresponding listener definition in

Warning : Skipping OracleOraHome92TNSListenerprd.world

: Could not find corresponding listener definition in

Warning : LISTENER1 defined in E:\oracle\ora92\network\admin\listener.ora will be skipped, because it does not monitor any of the valid SIDs Warning : LISTENER defined in E:\oracle\ora92\network\admin\listener.ora will be skipped, because it does not monitor any of the valid SIDs

Warning : No Listener found for SID PRD. PRD will be skipped

Could not determine location of emtab.

Please guide steps how to solve the problem

Regards,

Kumar

[Former Member]

hi

SIMPLY WRITE DOWN THE HOST NAME OR SYSTEM ID IN LISTENER.ORA FILE AND CHECK VIA CMD >TNSPING SID

AND TNSPING SYSTEM NAME ALSO CHECK OUT TNSNAME.ORA FILE ALSO

I SEND U AN LISTENERE .ORA FILE

check out the listener.ora file entry where you can write down your system name and system ip and also system id

XX = IP ADDRESS

<SID> UR SYSTEM ID

<SYS NAME> UR SYSTEM NAME

ALSO CHECK OUT THAT WHEN U INSTALL ORACLE IT ASK SET PATH IN TWO FIELDS

1. SID920

2.DRIVE\ORACLE\SID\920

eg:-

1. LISTENER.ORA Network Configuration File: g:\oracle\t11\920\network\admin\listener.ora

2. Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.100.xx)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.100.xx)(PORT = 1527))

)

)

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = <SID>.WORLD)

)

)

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = <SID>)

)

)

(DESCRIPTION =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <SYSTEM IP>)

(PORT = 1527)

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = E:\oracle\ora92)

(PROGRAM = extproc)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = SID)

(ORACLE_HOME = E:\oracle\ora92)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = SID)

(ORACLE_HOME = E:\oracle\ora92)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

REGARDS,

VIKAS NAGAR