No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48581 | Total active users | 1393 | Act. users last 24h | 5 | Act. users last hour | 0 | Registered user hits last week | 165 | Registered user hits last month | 388 |
|
Go up
Health Check script from Oracle : I got the solution for some errors and warnings
Subject: |
Health Check script from Oracle : I got the solution for some errors and warnings |
Author: |
Joël Péran, France |
Date: |
Feb 22, 2021, 13:52, 7 days ago |
Os info: |
Windows Server 2K16 |
Oracle info: |
19c |
Error info: |
HCKE-0003, HCKE-0023, HCKE-0016 |
Message: |
Hi everybody,
I took the habit to run the hcheck.sql script provided by the Oracle Support, after migrating databases from 12c to 19c. On some of them, I had issues : orphan links mostly (HCKE-0023, HCKE-0016 (warnings), HCKE-0003). I raised a SR for that kind of problems and the SR Team gave me clues and solutions for all the problems encountered. So I can share these solutions with you in case you have the same problems :) as the MOS notes mentioned linked to these errors are not public ...
Regards,
Joel |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
Subject: |
Re: Health Check script from Oracle : I got the solution for some errors and warnings |
Author: |
Michel Cadot, France |
Date: |
Feb 22, 2021, 14:50, 7 days ago |
Score: |
       |
Message: |
You can describe the problems involved without mentioning Oracle Health Check script or MOS notes content but you can point us to relevant MOS notes giving their ids.
Regards
Michel
|
Your rating?: |
This reply is Good Excellent |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
Subject: |
Re: Health Check script from Oracle : I got the solution for some errors and warnings |
Author: |
Joël Péran, France |
Date: |
Feb 23, 2021, 07:32, 6 days ago |
Message: |
Hi Michel,
The notes provided can't be read by people like you and me as they are not public. But I can help fixing the errors without mentionning the content of the notes :) Just by trying some tricks and running some queries.
Health Check Script can be freely downloaded and used (it's also an advice from Mike Dietrich).
Regards,
Joel |
Your rating?: |
This reply is Good Excellent |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|