tns: no listener

[Former Member]

Hello.

When i'm starting instance disp-works are died. In dev_w* seeing entries:

<b> C Thu Jul 12 09:15:38 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 3514]

C *** ERROR => CONNECT failed with sql error '12541'

[dbsloci.c 9750]

B ***LOG BY2=> sql error 12541 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 12541 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]

</b>

i checked logon into oracle as sysdba - it's ok. But when i'm trying logon as @<sid>:

<b>SQL> conn /@<sid>

ERROR:

ORA-12541: TNS:no listener</b>

is anybody who give explanation of this errors?

we are using Windows 64-bit, oracle 10.2, ERP 2004.

regards,

Denis

Message was edited by:

Denis Yugay

[Former Member]

Hi,

It seems that Listener is not running in your os.

Restart the listener and then try starting SAP.

You can check the entries in the below files if there are problems with listener.

and make sure that hostnames etc.. are given correctly.

/oracle/SID/920_64/network/admin

sqlnet.ora,

listener.ora,

tnsnames.ora,

"Points for helpful answer".

Regards,

Sandy.

[Former Member]

Hello Denis ,

1 ) Check status of TNSservice - > As per message your TNS Service is not active -> Start TNS Listner .

2 ) Try to ping TNS using command TNSPING SID

Plesae check the SAP Note :

Note 609332 - Composite note: ORA-12541/ORA-12224

Get back to me if you need further assistance .

Regards ,

Santosh