You can get the “DB Statistics on ORACLE Databases” error while executing RTCCTOOL on your SAP system with the DVM subject and the following details.
You can get the below report output via executing the RTCCTOOL on your SAP system
SE38 –> RTCCTOOL
In this case, you need to check “Collector Logs” for INACTIVE status values ;
DB02 –> Space –> Additional Functions –> Collector Logs –> open the “Modules” tab –> Search for “I” for the “Status” Column
Also you can make this check via controlling the table “DB02_CALL_PLAN”
DB16 –> DB02_CALL_PLAN
Search the “I” values for the area “Status” like below and execute
You can get the same list which we already got from DB02, important information is the DB Connection name
In our example DB Connection name is DEFAULT
To solve the issue, execute the following steps ;
SE38 –> RSORACUP
COM_NAME : DEFAULT
OPERATIO : DELETE
F8 – Execute
Continue with –> “NO” for the below question screen
Execute the program again with the below values ;
COM_NAME : DEFAULT
OPERATIO : CREATE
Now you can check the result again with executing the report RTCCTOOL
Hello and thank you. This was very helpful. I’ve done it before but your notes were more succinct then chasing down notes. Just a couple things:
Where you write DB16 –> DB02_CALL_PLAN it should be SE16 (Not DB16) and DB02_COLL_PLAN (Not DB02_CALL_PLAN).
I also do a refresh on the DBACOCKPIT >> Space Overview screen (Starts job REFRESH SPACE STATISTIC:DEFAULT) and recheck the collector logs to see that they ran before doing RTCCTOOL again.
Well, thanks again!
David