Solution : https://service.sap.com/sap/support/notes/443867 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the ORA-12154 error which typically occurs when SAP systems using Oracle databases fail to resolve the service name due to misconfigured or erroneous entries in tnsnames.ora or sqlnet.ora files. Key solutions include verifying these files as per SAP Note 445038, ensuring the NAMES.DIRECTory_PATH in sqlnet.ora includes "TNSNAMES", and correctly setting the dbs_ora_tnsname and ORACLE_SID parameters. The note strongly advises checking environmental settings, using Net8 assistant for syntax validation in tnsnames.ora, and maintaining correct entries in the tp configuration. Additionally, adjustments in the DBCon table, password guidelines, and TP_DOMAIN settings may be required to resolve the issue.
Key words :
location brdbconnect-1a tnsping call fails, /oracle/<sid>/920_64/network/admin, error => oci-call 'olog' failed, /3 profile parameter dbs/ora/tnsname, whilst connect system/<password>@<sid>, abap parameter abap/locale_ctype, connect system/manager@c11, connect system/<password>@<sid>, error => connect failed, incorrect oci-dlls 6
Related Notes :
| 520233 | NT: Error due to incorrect oci.dll/ociw32.dll versions |
| 445038 | Problems when accessing Net8 configuration files |
| 339092 | DB MultiConnect with Oracle as secondary database |
| 324714 | DB connect error in TMS after Oracle upgrade/change |
| 34479 | Collective note for problems with SQL-Net V2 ORACLE |