Solution : https://service.sap.com/sap/support/notes/125588 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP regroupe les problèmes connus et leurs solutions pour la version 4.0B de SAPDBA. Elle fournit une liste de correctifs et de notes associées traitant des problèmes tels que les réponses erronées d’Oracle, les problèmes avec différentes opérations de BR*Tools et les erreurs dans les processus d'administration de base de données. Chaque patch est accompagné d'une date et d'un numéro de note qui renvoie à des détails supplémentaires. La suite d'outils comprend BRARCHIVE, BRBACKUP, BRRESTORE, BRCONNECT et BRTOOLS, utilisée largement dans l’environnement SAP pour la gestion des problèmes de base de données.
Mots Clés :
/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
Notes associées :
| 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 |