cancel
Showing results for 
Search instead for 
Did you mean: 

How to replace sapdba with brtools after upgrade database to 10.2

Former Member
0 Kudos
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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Note 134592 says about it. Hope this helps

former_member204746
Active Contributor
0 Kudos

you must adapt table SDBAC to use brconnect instead of sapdba.

check SAP Note 403704 - BRCONNECT - Enhanced functions for Oracle DBA

it contains an SQL script to change that easily.

lbreddemann
Active Contributor
0 Kudos

> 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.

Yes, it does so, because somebody forgot to upgrade the BASIS SP as well...

What BASIS SP are you using?

regards

Lars