Problem with DDIC length calculation in CL_SQL_METADATA_ORA

July 30, 2009 at 11:49 am

[] [] [] [] [] [] [] [] [] []

Symptom
You are using DB connect to connect an external Oracle database with a UTF-8 character set to an SAP system. When the method GET_COLUMNS of the class CL_SQL_METADATA_ORA is called for a table of the external database, an unusable ABAP Dictionary (DDIC) length is returned for some or all of the VARCHAR2 [...]

RZ20 DB KPIs Oracle: “Database Size” without PSAPTEMP

July 22, 2009 at 2:37 am

[] [] [] [] [] [] [] [] []

Symptom
In RZ20, the value for “Database Size” in the “DB KPIs Oracle” tree is displayed without specifying the size of PSAPTEMP.
Other terms
RZ20, DB, database, KPI, key performance indicator, DB KPIs Oracle
Reason and Prerequisites
This problem is caused by a program error.
Solution
This error is corrected in Basis Release 7.00 Support Package 20 and Basis Release 7.01 [...]

DBACOCKPIT: Display error if system change DBA/backup logs

July 20, 2009 at 6:46 am

[] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
When you use the “Backup Logs” or “DBA Logs” function in the DBA Cockpit and change the selected remote system, the detail display of the log may not work and the system may issue message BR0252E.
Other terms
DBA, database administration, DBA Cockpit, Oracle, DBACOCKPIT, backup, logs, DBA logs, DB12, DB14
Reason and Prerequisites
This problem is caused [...]

Corrections in RZ20 for Oracle monitoring (9)

July 13, 2009 at 3:35 am

[] [] [] [] [] [] [] [] [] [] []

Symptom
The following corrections and enhancements for the Oracle database monitoring are released in transaction RZ20 with the Support Packages listed below:
1. ABAP dump DBIF_RSQL_INVALID_CURSOR in SBOM_BUILD_SYSCHECK_TREE
—————————————————————–
After you start the SAP system, the following ABAP dump is written:
Runtime Error DBIF_RSQL_INVALID_CURSOR
Exception [...]

Wrong Oracle Table History Data in Service Download

July 7, 2009 at 10:49 am

[] [] [] [] [] [] []

Symptom
When comparing segment history information of Oracle database based systems between ST14 and DB02N (SAP_BASIS 620-700) or DBACOCKPIT/DB02 (700 SP12+) you notice differences in size and further measures.
Other terms
DBACockpit Oracle, DB02 Oracle
Reason and Prerequisites
With SAP_BASIS 620 a new history collector for Oracle was introduced. Please Refer to SAP Note 868063 for details. [...]

ORA: Schema name is ignored in DBA Cockpit Setup Wizard

July 3, 2009 at 2:20 am

[] [] [] [] [] [] [] []

Symptom
On the first screen of the DBA Cockpit setup wizard in the SAP Solution Manager, the user provides the database schema. On the next screen, this information is lost (user name).
Other terms
ORACLE DBA COCKPIT SETUP WIZARD
Reason and Prerequisites
A program error causes this behavior.
Solution
The problem is solved with SAP Basis 7.01 SP5 that is part [...]

Error in method IS_ADMIN for Oracle remote databases

June 30, 2009 at 10:32 am

[] [] [] [] [] [] []

Symptom
The creation of a connection to an Oracle remote database
during a setup via the Solution Manager fails.
Other terms
ORACLE, IS_ADMIN, CL_ORA_DBCON
Reason and Prerequisites
There are several SAP schemas (for example, ABAP and Java stack) in the Oracle remote database.
Solution
Implement the attached corrections.