Solution : https://service.sap.com/sap/support/notes/1025707 (SAP Service marketplace login required)
Summary :
The SAP Note addresses configuration requirements and methods for integrating external Oracle databases into the DBA Cockpit's planning calendar, applicable from Basis Release 7.00 onwards. Key setup steps include system registration, active connection establishment via a working secondary database, and ensuring correct software versions - Oracle database version minimum 9.2 and specific patch levels for BR*Tools. Additionally, setup requires synchronizing system time across platforms. Connection methods detailed include RFC (for ABAP systems), Remote/Secure Shell, and SAP gateway, each with specific prerequisites and detailed configurations steps to ensure secure and effective integration of the DBA Cockpit with external Oracle databases.
Key words :
setenv ex1_oracle_home /oracle/ex1/<db_vers>setenv ex1_sapdata_home /oracle/ex1setenv ex2_oracle_home /oracle/ex2/<db_vers>setenv ex2_sapdata_home /oracle/ex2setenv ex3_oracle_home /oracle/ex3/<db_vers>setenv ex3_sapdata_home /oracle/ex3for windows, setenv oracle_home /oracle/ex1/<db_vers>setenv sapdata_home /oracle/ex1setenv sapexe /usr/sap/cen/sys/exe/runin, setenv oracle_sid ex1setenv oracle_home /oracle/ex1/<db_vers>setenv sapdata_home /oracle/ex1setenv sapexe <cenadm_home_dir>make, cd /oracle/ex1chmod 775 saparch sapbackup sapcheck sapreorg saptrace saptrace/background saptrace/usertrace oraarchchmod 664 saparch/archex1, logcd /oracle/ex1/<db_vers>chmod 775 dbs rdbms/auditchmod 664 dbs/initex1, basis release 620 support package 61basis release 640 support package 19alternatively, chmod 775 <diagnostic_dest>/diag/rdbms/<sid>/<sid>/ note, sql> connect /sql> desc sap_sdbahsql> desc sap_sdbadnote 5, tcp/ip connections -> sapxpg_dbdest_<dbhost_name> -> gateway options, sysdbasql> create user ops$cenadm identified externally
Related Notes :
| 1383843 | DBACOCKPIT: Remote system 620/640 with BR*Tools > 7.00 |
| 1028624 | Overview of DBA Cockpit for Oracle |
| 968820 | DBA Cockpit planning calendar: External ABAP systems 620/640 |