Need Help regarding TNS listener

[Former Member]

ORA-12514: TNS: No listener .

in Dev_W0 i got this error also

OCI-call 'OCIServerAttach' failed: rc = 12541

Please Advice

[Former Member]

Hi Jafer,

Please check in services whether TNSListener is running or not.

If it is not running Start listener.

If it is running and still you are getting No listener may be you have logged on with other than <SID>adm. Try to login with <SID>adm and check.

Refer Note 563574 - Composite SAP note ORA-12514

If your problem is not solved send us DEV_W0 logfile.

Regards,

Suraj