Tuesday, 12 November 2013

SQL Access Manager: SQL error. Stmt #: 2 Error Position: 0 Return: 12541 - ORA-12541: TNS:no listener

PSAPPSRV LOG:                                                                                                             
GenMessageBox(200, 0, M): SQL Access Manager: SQL error. Stmt #: 2 Error Position: 0
Return: 12541 - ORA-12541: TNS:no listener
GenMessageBox(0, 0, M): Database Signon: Could not sign on to database FSYS with user PSAPPS.

Trying to boot application server domain or process scheduler receive errors like the following:
PSAPPSRV LOG
GenMessageBox(200, 0, M): SQL Access Manager: SQL error. Stmt #: 2 Error Position: 0
Return: 12541 - ORA-12541: TNS:no listener
GenMessageBox(0, 0, M): Database Signon: Could not sign on to database FSYS with user PSAPPS.

Solution :

ORA-12541: TNS:no listener means the Oracle database listener is not started.
Check to ensure this is started with the Oracle DBA.
(you can check listner service using lsnrctl on solaris)
Also make sure tnsnames.ora has correct entries.

No comments:

Post a Comment