TNS Listener problem on Oracle 10.2g

[Former Member]

Dear All,

I am facing a problem of TNS Listener as I am trying to install IDES ECC 6.0 on Windows Server 2003 Ent Edition.I have set all the Env variables like ORACLE_HOME,ORACLE_SID but still I am getting the problem & Oracle listener & isql plus isn't getting started.

The lsnrctl.log file is attached below.

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-JUL-2007 19:04:24

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=OR4.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=OR4))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=IDE)(PORT=1527))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 61: Unknown error

Can anyone please help me on this?

Thanks

[andreas_herzog]

-> is the listener started (as a process)? have a look under the services...

-> could you post the contents of listener.ora...

GreetZ, AH

[Former Member]

The TNSNAME.ORA & LISTENER,ORA file is as given below:

TNSNAME.ORA :

-

---

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

1. Filename......: tnsnames.ora

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

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

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

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

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

BD2.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = portal)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = BD2)

(GLOBAL_NAME = BD2.WORLD)

)

)

LISTENER.ORA :

-

---

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

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

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

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

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

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

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = BD2.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = BD2)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = portal)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = BD2)

(ORACLE_HOME = C:\oracle\BD2\102)

)

)

Please look into this & if any other file is required just let me know.

Thanks

[andreas_herzog]

^^ files seem to look OK...

-> listener process is not running and you are not able to start it?

-> tcp port 1527 is not occupied by any other application?

-> what about

> tnsping BD2 ?

-> your hosts file is accurate?

GreetZ, AH

[Former Member]

Hi Andreas,

Thanks for your effort .

When I run the command tnsping BD2 ,it showed the following message .

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-JUL-2

007 20:08:55

Copyright (c) 1997, 2005, Oracle. All rights reserved.

TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility

=TNS

Please take a look into this.

Thanks

[andreas_herzog]

on one hand you have SID = BD2

> (CONNECT_DATA =

> (SID = BD2)

> (GLOBAL_NAME = <b>BD2</b>.WORLD)

> (KEY = BD2.WORLD)

> )

> (ADDRESS=

> (PROTOCOL = IPC)

> (KEY = <b>BD2</b>)

> )

> (ADDRESS =

> (COMMUNITY = SAP.WORLD)

> (PROTOCOL = TCP)

> (HOST = portal)

> (PORT = 1527)

> (SID_NAME = BD2)

> (ORACLE_HOME = C:\oracle\<b>BD2</b>\102)

but...on the other hand you have SID = OR4...

> Connecting to

> (ADDRESS=(PROTOCOL=IPC)(KEY=<b>OR4</b>.WORLD))

> TNS-12541: TNS:no listener

> TNS-12560: TNS:protocol adapter error

> TNS-00511: No listener

> 32-bit Windows Error: 2: No such file or directory

> nnecting to (ADDRESS=(PROTOCOL=IPC)(KEY=<b>OR4</b>))

==> <b>which sid is the right one? you cannot connect to the "wrong" system id...</b>

i think something really got mixed up...

GreetZ, AH

[Former Member]

the message:

<i>TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility=TNS</i> indicates that you have installed more than one Oracle Home on this box.

If this is the case and you are not currently upgrading from Oracle9 to Oracle10 please refere to the Multiple Oracle Home section in the installation or upgrade guide.

regards

Peter