Solution : https://service.sap.com/sap/support/notes/361641 (SAP Service marketplace login required)
Summary :
To implement OPS$ users for Oracle databases in SAP environments on UNIX, SAP Notes detail distinct procedures based on Basis release versions. For release <= 4.6D, the CHDBPASS tool is utilized to initialize the OPS$ user and modify SAPR-SIDADM passwords. This involves the creation of the SAPUSER table and granting the sapdba role to the new user via Oracle's sysdba privileges. For releases >= 6.10, the oradbusr.sql script is recommended. Password changes for database users should be handled via brconnect with the appropriate commands detailed in the Note. Download links and command syntax are provided to ensure proper implementation.
Key words :
newly created ops$<sapsid>adm database user, ops$<sapsid>adm user, terms ops$ops$ reason, sap <sapsid>adm user, user ora<sapsid> > connect/, os ora<sid> user, solution sap basis <= release 4, syntax sqlplus /nolog @oradbusr, ops$<sapsid>adm, sql schemaowner unix sap_sid
Related Notes :
| 776505 | BR*Tools fail with ORA-01017 / ORA-01031 on Linux |
| 562863 | FAQ: Logon mechanisms |
| 437648 | DB13: External program terminated with exit code 1/2 |
| 403004 | Database connect using R3trans fails |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 319211 | Problems with CHDPASS under Oracle >= 8.0.6 |
| 134592 | Importing the SAPDBA role (sapdba_role.sql) |
| 50088 | Creating OPS$ users on Windows NT/Oracle |