Solution : https://service.sap.com/sap/support/notes/562863 (SAP Service marketplace login required)
Summary :
SAP Note addresses common queries regarding SAP database users, logging processes, and password management, primarily within Oracle environments. Key points include the identification of default database users (SAPR3, SYSTEM, SYS, etc.), storage locations for user information in the Oracle dictionary, and methods for logging onto the database especially when the database is stopped, utilizing SYSDBA or SYSOPER privileges. It provides detailed steps for changing Oracle passwords using SQLPLUS and emphasizes the importance of aligning password changes in the Oracle system with the SAPUSER table to avoid disruption. Additionally, the note outlines special considerations for logging in without a password using the "CONNECT INTERNAL" mechanism and addresses issues related to OPS$ user connections.
Key words :
sap<sid>db / sap<xyz>db / sapsr3db sap<sid>db, sapr3shd / sap<sid>shd / sap<xyz>shd / sapsr3shd, dbsnmp sap<sid>db / sap<xyz>db / sapsr3db, sap<sid>db / sap<xyz>db / sapsr3db, sapr3 / sap<sid> / sap<xyz>db / sapsr3db, sapr3 / sap<sid> / sap<xyz> / sapsr3 user, sapr3 / sap<sid> / sap<xyz> / sapsr3, system-specific sap<sid> user, sap<sid>db tsmsys, sap<xyz> db
Related Notes :
| 700548 | FAQ: Oracle authorizations |
| 617444 | Separate SCHEMA ID for database schema and tablespace name |
| 480266 | Problems with the SYSDBA/SYSOPER/INTERNAL connect |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 361641 | Creating OPS$ users on UNIX |
| 186119 | Restricting DB access to specific hosts |
| 168243 | Assigning sysdba and sysoper authorizations |