problem starting listener service

[Former Member]

hai,

while installing oracle patch 9.2.0.3 i manually stoped the listener service.

now when i'am trying to start it , its giving me an error

can anyone help me on this

bye

nandana

[Former Member]

hai,

this is the listner.ora file

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = XID.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = XID)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 192.168.0.114)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = XID)

(ORACLE_HOME = D:\oracle\ora92)

)

)

tnsnames.ora

1. TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora

2. Generated by Oracle configuration tools.

ZENITH =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = zenith1)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = zenith.domain)

)

)

INST1_HTTP =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = zenith1)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

#DID.WORLD =

1. (DESCRIPTION =

1. (SDU = 32768)

2. (ADDRESS_LIST =

3. (ADDRESS =

4. (COMMUNITY = SAP.WORLD)

5. (PROTOCOL = TCP)

6. (HOST = 192.168.0.114)

1. (PORT = 1527)

1. )

2. )

3. (CONNECT_DATA =

4. (SID = DID)

5. (GLOBAL_NAME = DID.WORLD)

6. )

7. )

XID.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 192.168.0.114)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = XID)

(GLOBAL_NAME = XID.WORLD)

)

)

[Former Member]

Hi,

To startup listener listener.ora file is Imp.

Simple listener file looks like

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL=tcp)

(HOST=hostname) #<-- Use YOUR machines HOST NAME

(PORT=1521)

)

)

1. This tells the listener of DEDICATED services it can connect you to

#

SID_LIST_LISTENER= #<-- Used for DEDICATED connect

(SID_LIST= #<-- requests

(SID_DESC=

(SID_NAME=VIN) #<-- Put YOUR $ORACLE_SID value

(ORACLE_HOME=/oracle/v9206) #<-- Put YOUR $ORACLE_HOME value

)

(SID_DESC= #<-- Other databases may be added

(SID_NAME=TESTDB) #<-- here

(ORACLE_HOME=/oracle/v9206)

)

)

startup sequence to have the listener started before the database.

I guess ur on WIN platform?Check for Env variables and Port availability.

Paste error from command lsnrctl status and lsnrctl stop and lsnrctl start

Vinod

[Former Member]

hai everyone,

i have checked the listener.ora and tnsnames.ora files. all the entries are correct.

i checked the services and then found the oracle service itself is not starting.

any suggestions?

nandana

[former_member204746]

please supply both files.

[Former Member]

hai everyone,

when i check in the listener.log file it lists the following error -

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

[Former Member]

Hi,

Check for a file tns.ora. See what sid name it contains. Most prob somehow the tns settings have been changed. Check if the SID mentioned here and the SID name of the sap database are same or not.

[Former Member]

hi

The SID being supplied by the client in unknown to the listener you are trying

to connect to. To begin troubleshooting, start at the server and issue a

‘lsnrctl stat [listener_name]’ command. This will display a list of

available SIDs. Make sure the instance you want to connect to is shown. If

it is not, edit the listener.ora file to include your instance, restart the

listener, and retry the operation.

On the client, open the TNSNAMES.ORA file and verify the SID in the

CONNECT_DATA section of your Net Service Name is correct and matches the SID

name on the listener side.

If the SID is correct, make sure the HOST in the address section is pointing

to the correct server or IP address. If the HOST is pointing to an old

address and the listener on the old server is not listening for the sid

specified then the connection will fail with an ORA-12505.

Regards

Vinod

[former_member204746]

adapt file LISTENER.ORA and make sure it has an entry for your SID. Right now, it cannot find your SID in this file.