on 11-18-2007 4:10 PM
Hi guys,
I have already gone through the several other threads on sdn which repeat the same issue here but I am not able to find a solution via them. Can any one give me some leads into this...
-- CHANGES DONE --
We applied all relevant support packs which were part of Support stack 13. This involved also patching SAP BASIS from 10 to 13. Also NW04S 700 kernel was upgraded to patch 114 (SAPEXE and SAPEXEDB SAR packages)
STATEMENT OF PROBLEM(S)
Tcode dbacockpit does not refresh data in the overview pane.
note: db02old still works and we are able to refresh stats from there but dbacockpit overiew pane does not get populated.
Also post support packs: sap_collector_for_performance runs successfully but reports in job log database system is not supported
When we do a refresh via dbacockpit, the job refresh space statistics ends with a compute bcd overflow dump.
CHECKS ALREADY MADE
--Note 1066044 for the BCD overflow dump does not help. We are already at BASIS pack 13 and the correction contained in the note is already in place. As
per the note since are already at BASIS SP13 we should not be facing this. Why are we facing this then ?
--Note 868063
Call report rsoracup; put in con_name=DEFAULT; operatio=CREATE;F8 did this.
--Note 1002840.(checks done as per note)
a) Check if SAP_Collector_for_perfmonitor is scheduled hourly
It completes successfully but gives job log below
1/16/2007 12:06:14 Job started
1/16/2007 12:06:14 Step 001 started (program RSCOLL00, variant , user ID DDIC)
1/16/2007 12:06:14 Clean_Plan:Cleanup of DB13 Plannings
1/16/2007 12:06:14 Clean_Plan:started by RSDBPREV on server
1/16/2007 12:06:14 Clean_Plan:Cleaning up jobs of system xxx
1/16/2007 12:06:14 Clean_Plan:finished
1/16/2007 12:06:15 Database system not supported
1/16/2007 12:06:17 Job finished
Why ?? (we got oracle 10.2.0.2)
b) se16 -> table TCOLL. Check if entery RSORACOL exists.
It does exist as below
RNAME RSORACOL
RENUM 1
SYTYP S
ALTSY
DAYOW XXXXXXX
TIMOD XXXXXXXXXXXXXXXXXXXXXXXX
c)SE16 -> table ORA_MON_DBCON. Check for enrry con name: DEFAULT.
It does exist as below
CON NAME DEFAULT
STATUS A
MAX RUNTIME 1,800
MAX UPLOAD 1,000,000
LOG LIFE 100
DESCRIPTION Local database. R/3 system available.
d)se16 -> table db02_coll_plan. Check if all the entries have status A and there are 64 entries. This is ok
--Note 1042725
SE16-> PROGDIR for Name= 'LSDBORA3F03'; Set field EDTX to blank
All entries have EDTX blank but there is no entry 'LSDBORA3F03
Despite all the above checks I am unable to get the dbacockpit to refresh. Does anyone have any ideas. Will putting in the latest DBSL shared library patch for oracle solve this... I did SAPEXE and EXEDB.SAR latest. Any ideas...?
Cheers, Vikram
vikramr2k@gmail.com
I have the same problem. Did you ever reslove this?
Thanks!
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
can you validate these notes and also check below transactions to get soem information on the error entry;
SM21,DB14,alert logs.
Note 1002840 - No data or obsolete data in DB Space Statistic monitor
Note 1284011 - DBA Cockpit: Problems when reading DB alert log
Note 1027146 - Database administration and monitoring in the DBA Cockpit
Note 1028624 - Overview of DBA Cockpit for Oracle
regards
nag
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.