Solution : https://service.sap.com/sap/support/notes/125588 (SAP Service marketplace login required)
Summary :
This SAP Note is a compilation of known issues and their resolutions for SAPDBA version 4.0B. It lists detailed patches and associated notes tackling problems such as Oracle error responses, issues with different BR*Tools operations, and errors in database administration processes. Each patch is provided with a date and a note number which references further details. The toolset includes BRARCHIVE, BRBACKUP, BRRESTORE, BRCONNECT, and BRTOOLS, collectively helping manage database issues extensively used in the SAP landscape.
Key words :
/general/r3server/patches/rel40b/nt//ora/ora73the precise procedure, reorganization 6 1998-04-07 100626 freespace check returns ora-00001 7 1998-04-07 100683 restart 'single index reorg', /general/r3server/patches/rel40b/<platform>/<os>/oraif, recognized 35 1998-10-23 122860 access table sapdbapriv 36 1998-10-27 123370 sapdba -check reports redolog_not_mirrored 37 1998-11-10 125383, return codes 63 1999-02-25 140695 processing oracle defunct processes 64 1999-02-26 140879 sapdba, long process lists 27 1998-08-26 115127 check parameter archive_stuck 28 1998-09-11 116986 check, brbackup profile 57 1999-01-11 133543 -check reports redolog_not_mirrored 58 1999-01-21 135305 corrupt file, sapdba analysis 2 1998-01-07 91934 -analyze dbstatco delivers returncode>0 3 1998-01-13 92562 sapdba, incorrect 81 1999-05-11 152041 year 2000 conditional adjustments 82 1999-05-18 153027 error message, area restore/recovery 80 1999-05-07 151613 returncode sapdba -analysis
Related Notes :
| 359981 | SAPDBA: Wrong exp param. for NLS char. JA16SJIS |
| 302935 | SAPDBA: ORA-00955 while restoring constraints |
| 300078 | SAPDBA: Error in tablespace space check |
| 202385 | Core dump in SAPDBA/BR tools 4.0B with Oracle 7.3.4 |
| 201365 | SAPDBA: Error in determining RawDevices size |
| 197872 | SAPDBA warning in function BrrTimestampExtern2Intern |
| 193686 | SAPDBA: <sidadm> does not have DBA authorization |
| 188495 | CBO:Alert - missg statistics for POOL/CLUSTER indxs |
| 186759 | SAPDBA: Error altering storage of ... |
| 184256 | SAPDBA, BRBACKUP, BR*: Raw device file> 2G |
| 173813 | SAPDBA: VIEW text with incorrect line break |
| 169925 | CBO: double entries in DBSTATC |
| 169921 | CBO: ACTIV='U' has no effect |
| 169552 | SAPDBA: ORA-25102 (invalid PARALLEL option) |
| 164680 | SAPDBA: Loading LONG RAW columns with SQL*Loader |
| 160300 | CBO: (checkopt) - obsolete stats not recognized |
| 160032 | CBO: Incorrect DISTINCT_KEYS values in DBA_INDEXES |
| 158819 | SAPDBA: Option -next does not find all objects |
| 158597 | CBO: Tables without statistics |
| 156564 | SAPDBA: Loss of column defaults in reorganization |
| 155037 | SAPDBA: UNLOAD of LONG-RAW columns incorrect |
| 154193 | SAPDBA: Reorganizations and ABAP-DDIC |
| 154146 | CBO: -checkopt (unique constraint violated) |
| 152041 | SAPDBA: Year 2000 conditional adjustments |
| 151613 | SAPDBA: Return code sapdba -analyze |
| 148296 | SAPDBA: Error selecting categorie from DD09L |
| 147787 | SAPDBA: analyze: unauthorized exit with RC = 1 |
| 147297 | SAPDBA: CB:-fld VWTYP not prop.filled in DBSTATTORA |
| 147268 | SAPDBA: -checkopt PSAP% generates poor statistics |
| 146897 | SAPDBA: Reorg. Scripts for locked tables |
| 143288 | SAPDBA: Super collective note |
| 141158 | SAPDBA: ORA-01219 after mounting the database |
| 140714 | SAPDBA: Return codes |
| 135305 | SAPDBA: corrupted/wrong file name |
| 132358 | SAPDBA: Error in Exp. tablespace on Tape |
| 131522 | SAPDBA: No.of blcks for FILE#, BLOCK# is unknown II |
| 131372 | CBO: Tuning of expensive SQL statements |
| 129965 | SAPDBA: Consideration of BACKINT backups |
| 128238 | SAPDBA: Termination script creation export on tape |
| 127777 | SAPDBA: Message 'Missing indexes' is written to the CBO log |
| 127582 | CBO: UPGRADE 4.0/4.5 (reduction of runtime) |
| 126834 | SAPDBA: Core dump because of more than 16 Redo logs |
| 126769 | Corrections in SAPDBA and in BR programs |
| 126023 | SAPDBA: No. of blocks for FILE#, BLOCK# is unknown |
| 125827 | SAPDBA: Error when moving a data file |
| 125596 | SAPDBA: Core dump after restart with unload/load |
| 125554 | SAPDBA: Support for Oracle 7.3.4 |
| 125383 | SAPDBA: New option -V for patch information |
| 123370 | SAPDBA: sapdba -check reports REDOLOG_NOT_MIRRORED |
| 122860 | SAPDBA: Access SAPDBAPRIV |
| 122858 | SAPDBA: Link on raw device is not recognized |
| 119678 | SAPDBA: core dump when you change the password |
| 118242 | SAPDBA: Termination during reorg. of indexes w. |
| 113786 | SAPDBA: Problems for very long process lists |
| 113739 | DB14: No LOG-INFO available for various DBA ops. |
| 112498 | SAPDBA: -checkopt PSAP% does not store new tables in DBSTATC |
| 110308 | SAPDBA: Error in recovery (reorg.run of index Tsp.) |
| 109521 | SAPDBA: Termination of check run on WinNT |
| 108008 | SAPDBA: Object list -> "object name.0 not found". |
| 107750 | SAPDBA: exp error for several dump directories |
| 105959 | SAPDBA: Message "Opt. Statistics for Views" |
| 105356 | SAPDBA: -check (use in R/3 Releases < 4.0) |
| 104280 | SAPDBA:Error getting type or size of exp<TSPN>.dmp |
| 104215 | DB13-DB24: CPIC communication error |
| 102657 | SAPDBA: invalid profile parameter exireo_dumpdir |
| 101665 | SAPDBA: Term. for "CREATE TABLE. .. AS SELECT..." |
| 101464 | SAPDBA: Statistic flag(s) ... not reset |
| 100974 | SAPDBA: Prg. ex. after func. 'Create missing stats' |
| 100683 | SAPDBA: Restart "single index reorg" not possible |
| 96272 | SAPDBA: Error with -analyze during reorganization |
| 95513 | SAPDBA: Cannot evaluate Oracle version |
| 91934 | SAPDBA: -analyze DBSTATCO delivers Returncode>0 |
| 90961 | SAPDBA: ORA-01403 for SAPDBA analysis |
| 24552 | BRRESTORE/SAPDBA: not enough space in file system |
| 19466 | Downloading SAP kernel patches |
| 12741 | Current versions of BR*Tools and SAPDBA |