on 10-20-2008 3:02 PM
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
Note 134592 says about it. Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.