Solution : https://service.sap.com/sap/support/notes/400241 (SAP Service marketplace login required)
Summary :
SAP Note addresses connection issues to Oracle database, specifically for R/3 work processes requiring use of 'sapr3' user. Errors noted include ORA-01017 and ORA-01031, indicating invalid credentials and insufficient privileges, respectively. Resolution involves using OPS$ users, configured with OS_AUTHENT_PREFIX and operational system user name matches. Proper setups for OPS$ users include ensuring domain names are included in Oracle 8.1.5 on NT systems. Alternatives include direct 'sapr3' login with default 'sap' password, essential for connection success providing correct password setting or OPS$ setup. Additionally, BR*TOOLS use OPS$ for database connections. Note emphasizes correct password retrieval and user setup to avoid connectivity failures.
Key words :
default tablespace <user_tsp> temporary tablespace psaptemp identified externally, accessing table sapuserthe system issues message ora-00942, connection 0 error => oci-call 'olog' failed, connection 0 error => oci-call 'olog' failed, accessing table sapuserthe system issues ora-00980, error => oci-call 'olog' failed, ops$c11adm ops$c11adm ops$prdadmyou, ops$<local_host>\sapservice<sid> 1b, service sap<sid>_<instance_number>, database instance <sid> failed reason
Related Notes :
| 969519 | 6.20/6.40 Patch Collection Installation : Oracle/UNIX |
| 951167 | ORA-28000: the account is locked |
| 849141 | SAP NetWeaver 2004s Installation on Windows: Oracle |
| 700548 | FAQ: Oracle authorizations |
| 675940 | SAP Web AS 6.40 Installation on Windows: Oracle |
| 662644 | Composite SAP Note: ORA-00942 |
| 650796 | Composite Note: ORA-00980 |
| 569302 | Loading data in BW fails with ORA-01017 |
| 562863 | FAQ: Logon mechanisms |
| 437648 | DB13: External program terminated with exit code 1/2 |
| 403004 | Database connect using R3trans fails |
| 361641 | Creating OPS$ users on UNIX |
| 134592 | Importing the SAPDBA role (sapdba_role.sql) |