on 11-12-2007 11:03 PM
Hi,
We are running Solution Manager 4.0 SP13 on Oracle 10.2.0.2 patch 16.
When we run transaction dbacockpit.
We highlight the SPACE Overview for the Local ( default ) database - size=0, free space = 0...
ALL the stats for tablespaces, size, etc are all zero !!!!
In transaction DB17 all the Database check conditions are marked.
The job SAP_COLLECTOR_FOR_PERFMONITOR runs every hour - RSCOLL00
The table TCOLL has the entry rsoracol.
The table ORA_MON_DBCON has CON_NAME = default database
Due to applying patch 16 we have ran - brconnect -u / -c -f stats -t oradict_stats
We decided to increase a tablespace and the ran - brconnect -u / -c -f stats -t system_stats
However if we run the old transaction DB02OLD, all the database performance, tables and indexes stats are available.
We can run - DB02OLD - Current Sizes - DB Analysis - refresh - perform DB checks - that Tablespace Stats are updated !
Please Help !
to make your search even easier, simply follow SAP note 1002840 (and the notes it links to) and db02 (previous d02n) will work correctly then
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Baran.
Here is the fix:
Database = Oralce 10.2.0.2 Patch 16 ( patch 15 should be OK aswell)
SAP Netweaver 2004s SP12 or SP13
Run DbaCockpit - System configuration - Active System = 1( for Local database) -click On Default System - ( the Bottom Message Wiindow Will "pop" telling you what system is default )
Run Transaction DB17 and ensure all Conditions are active.
Run Transaction SM36 and Schedule Job SAP_COLLECTOR_FOR_PERFMONITOR to run every hour - (RSCOLL00)
Run se16 - table = TCOLL - Table of Contents ( F7 ) - ensure it has the entry rsoracol.
Run SE38 - RSORACUP - execute - CON_NAME = DEFAULT - OPERATIO = CREATE - execute
Run SE16 - table = ORA_MON_DBCON - table of Contents - ( leave all options blank ) - execute - the result will be similar to below:
CON NAME DEFAULT
STATUS A
MAX RUNTIME 1.800
MAX UPLOAD 1.000.000
LOG LIFE 100
DESCRIPTION Local R/3 Database
Run SE16 - Table= DB02_COLL_PLAN - Table of Contents (F7) - Leave all entries blank- Execute - Results will have found around 60 to 65 modules (the exact number depend on your R/3 release/patch) per DB connection - example of one of the entries below:
CON NAME DEFAULT
SMON ID 100
SMON NAME DB-GE-MD
FUNCNAME ORA_COLL_DB_GENERAL_MAIN_DATA
MONIFILL DEF100
RANK 2
STATUS A
SCH DATE XXXXXXX
SCH TIME X X
PROCESS TYPE S
Run transaction dbacockpit - Jobs - dba planning calender - action pad - check database - run immediately - Let job complete - highlight and check log
Run se16 - table = DB02_COLL_LOG = table of contents ( F7 ) - Leave all fields blank - Execute - page down and you will see a number of entries similar to the following:
COLL DATE 15.11.2007
COLL TIME 07:57:19
CON NAME DEFAULT
SMON ID 901
SMON NAME AD-GE-CM
MONIFILL DEF901
RCODE 0
UPLOAD 10
DURATION 1
Run transaction - dbacockpit - space - bouble click sapce overview - in the right hand pane you will see size - freespace - etc etc.
For further inforamtion note number: 1002840 ( Specifically steps 4 and 5 ) If stats not updated .. run the SAP_COLLECTOR_FOR_PERFMONITOR job - repeat steps 4 and 5 in the note and run the dba planning job check Database.
Run DBACockpit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Clive,
I am facing the same problem in dbacockpit.
I have followed the steps you have given in DB02_COLL_PLAN i found the entry , and i executed the job check database and i checked the logs .
I found no entry in DB02_COLL_LOG and space overview is not showing anything.
Please suggest...
Thanks,
Subhash.G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.