Solution : https://service.sap.com/sap/support/notes/34479 (SAP Service marketplace login required)
Summary :
This SAP Note addresses multiple ORA- error codes arising from connectivity issues between SAP applications and Oracle databases starting from SAP Release 3.0D with SQL-Net V2. The errors, such as ORA-12154, ORA-12203, and others, involve incorrect configurations in TNSNAMES.ORA, listener issues, or environmental variable misconfigurations. Solutions include verifying file presence, correctness of service names and syntax in TNSNAMES.ORA, ensuring the Oracle listener is operational, and correct environmental settings. Recommendations for handling other specific ORA- errors related to timeout and authentication services are also provided, involving adjustments in listener.ora and sqlnet.ora files respectively.
Key words :
ora-12545ora-12203ora-12154ora-12633ora-12535ora-12541for, additional key words sql-net v1, sql-net v1 connectionsthese db links, file /usr/sap/put/bin/dbenv, \usr\sap\put\bin\dbenv, directory <drive>\orant\network\admin, '/usr/sap/trans/bin/tpparam', profile parameter dbs/ora/tnsname, v1 db links function, operating system specific manual
Related Notes :
| 443867 | ORA-12154 Collective SAP note |
| 403004 | Database connect using R3trans fails |
| 324714 | DB connect error in TMS after Oracle upgrade/change |
| 131561 | Work processes sometimes abend during database connect |
| 61041 | Change to SQL*Net V2 (ORACLE) |
| 53446 | Configuration of SQL*NET V2 for 3.0E ORACLE |
| 51933 | No Connect to database (ORA-1004) |