Solution : https://service.sap.com/sap/support/notes/609332 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the ORA-12541 and ORA-12224 errors indicating the absence of a database listener. The errors occur when work processes attempt to connect to the database but cannot find a listener to handle the request. Possible causes include incorrect configuration files, misalignment between tnsnames.ora and listener.ora, excessive simultaneous queries, non-operational listeners, inappropriate environment settings, and incorrect listener naming. Resolutions involve verifying correct configuration file usage, ensuring matching settings in tnsnames.ora and listener.ora, managing query volumes, confirming listener status with 'lsnrctl' commands, and checking environment variables and listener naming conventions.
Key words :
error => oci-call 'olog' failed, rc = 12541 error => connect failed, listenerwork processes report, terms tns-12541 12541 reason, tcp/ip link, error occurs sporadically, wrong configuration files, correct configuration files, local environment variable, lsnrctl start my_listener
Related Notes :
| 445038 | Problems when accessing Net8 configuration files |
| 396873 | UNIX: Error due to socket authorizations |
| 131561 | Work processes sometimes abend during database connect |