No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48613 | | Total active users | 1400 | | Act. users last 24h | 3 | | Act. users last hour | 0 | | Registered user hits last week | 107 | | Registered user hits last month | 432 |
|
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, 122 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, 122 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, 121 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
|