Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to replace sapdba with brtools after upgrade database to 10.2

All,

    I have update our database to oracle 10.2,my brtools version is 7.0 now ,
but can't run analyze table and dbcheck in db13,
seems to still use SQLDBA when run analyze table and dbcheck.
please refer to the below informations.

Detail log:                    0810080300.aly
------------------------------------------------------------------------------------------------------------
*******************************************************************************
*****                 SAPDBA - SAP Database Administration for ORACLE     *****
*******************************************************************************
SAPDBA V6.10    Analyze tables
                --------------
SAPDBA release: 6.10
Patch level   : 1
Patch date    : 2001-05-25
ORACLE_SID    : PRD
ORACLE_HOME   : /oracle/PRD/102_64
ORACLE VERSION: 10.2.0.2.0
Database state: 'open'
SAPPRD       : 46C
SAPDBA DB USER:  (-u option)
OS login user : prdadm
OS eff.  user : prdadm
SYSDBA   priv.: not checked
SYSOPER  priv.: not checked
Command line  : sapdba -u / -analyze DBSTATCO
HOST NAME     : sapprd1
OS SYSTEM     : HP-UX
OS RELEASE    : B.11.31
OS VERSION    : U
MACHINE       : ia64
Log file      : '/oracle/PRD/sapcheck/0810080300.aly'
Log start date: '2008-10-08'
Log start time: '03.00.09'
*******************************************************************************
----- Start of deferred log ---
SAPDBA: Can't find the executable for SQLDBA/SVRMGR. Please, install one of
        them or enter one of them in the SAPDBA profile (parameter
        sqldba_path).
        (2008-10-08 03.00.06)
SAPDBA: Error - running temporary sql script
        '/oracle/PRD/sapreorg/dbacmd.sql' with contents:
CONNECT /******** AS SYSDBA
SAPDBA: Couldn't check SYSDBA privilege.
SAPDBA: Can't find the executable for SQLDBA/SVRMGR. Please, install one of
        them or enter one of them in the SAPDBA profile (parameter
        sqldba_path).
        (2008-10-08 03.00.06)
SAPDBA: Error - running temporary sql script
        '/oracle/PRD/sapreorg/dbacmd.sql' with contents:
CONNECT /******** AS SYSOPER
SAPDBA: Couldn't check SYSOPER privilege.
----- End of deferred log ---
Analyze parameters:
Object: All tables in table DBSTATC ( for DB optimization run )
Method: E ( Default )
Option: P10 ( Default )
Time frame: 100 hours
Refresh   : All objects
*******************************************************************************
Option: DBSTATCO ( for the DB optimizer: Tables with Flag DBSTATC-TOBDO = 'X' )

** Refresh Statistics according control table DBSTATC **
Total Number of Tables in DBSTATC to be analyzed:                           170
Number of Tables with forced statistics update (ACTIV = 'U'):                 0
SAPDBA: SELECT USER# FROM SYS.USER$ WHERE NAME='SAPPRD'
ORA-00942: table or view does not exist
           (2008-10-08 03.00.09)
SAPDBA: Error - getting size of segment 'SAPPRD.D010INC'
SAPDBA: Error - during table analysis - table name: ->D010INC
SAPDBA: No tables analyzed ( No entries in DBSTATC with TOBDO = X or errors ).
SAPDBA: 0 table(s) out of 170 was (were) analyzed
        Difference may be due to:
           - Statistics not allowed ( see DBSTATC in CCMS )
           - Tables do not exist on database and were skipped

Detailed summary of Step 1:
Number of Tables that needed new statistics according to DBSTATC:             1
Number of Tables marked in DBSTATC, but non-existent on the Database:         0
Number of Tables where the statistics flag was resetted:                      0

******* Creating statistics for all tables without optimizer statistics *******
SAPDBA: Using control table DBSTATC
        for taking optimizer settings into account
SAPDBA: 0 table(s) without statistics were found.
SAPDBA: 0 table(s) ( out of 0 ) was (were) analyzed/refreshed.
        0 table(s) was (were) explicitely excluded or pool/cluster table(s).
SAPDBA: 0 index(es) without statistics was (were) found.
SAPDBA: 0 index(es) ( out of 0 ) was (were) analyzed/refreshed.
        0 index(es) was (were) explicitely excluded or pool/cluster indexe(s).
SAPDBA: 157 table statistics from 157 tables were dropped.
        They are either explicitely excluded in DBSTATC,
        or R/3 Pool- or Cluster- tables
        that must not have CBO Statistics

SAPDBA: The whole operation took 10 sec
SAPDBA: Step 1 was finished unsuccessfully
SAPDBA: Step 2 was finished successfully
Date:   2008-10-08
Time:   03.00.19
*********************** End of SAPDBA statistics report ****************
How to replace sapdba by brtools?please give me support,thanks.


Best Regards,
Mr.chen
Former Member
Not what you were looking for? View more on this topic or Ask a question