Solution : https://service.sap.com/sap/support/notes/8523 (SAP Service marketplace login required)
Summary :
The customer is unable to execute scheduled database backups using the Computing Center Management System (CCMS). The issue is related to the "Volumes needed" functionality in the CCMS/DBA planning calendar, which fails to operate as intended. This is rectified in SAP Release 4.0 and detailed in note 135772. The underlying causes include missing critical documentation for backup scheduling tools, absence of the SUID bit for specific Oracle executable files on UNIX, missing OPS$ user, and issues with interfacing external programs. The solution involves a series of configurations for external program calls, user environment setup, file permissions, and necessary Oracle database user definitions.
Key words :
su rootcd /usr/sap/<sid>/sys/exe/runchown ora<sid> brbackup brarchive brconnect brtools sapdbachmod 4775 brbackup brarchive brconnect brtools sapdbacaution, > connect internal> create user ops$<sid>adm #, identified externallydefault tablespace psapuser1dtemporary tablespace psaptemp, su - ora<sid>sqldba lmode=, additional registry entrydba_<sid>_authorization, tools=>administration=>jobs=>job definition, > create user ops$sapservice<sid> #, sql error message ora-01920, brrestore remains <sid>adm, user ops$<sid>adm
Related Notes :
| 135772 | Confign of SAPDBA/BR programs in the ORACLE environment |
| 51933 | No Connect to database (ORA-1004) |
| 29725 | Table analysis/extent adjustment cancels in DB13 |
| 15626 | SAPDBA: Invisible password for SAPDBA |