DB Systems - Databases with Failed state aren't exported to report

Question

DB Systems - Databases with Failed state aren't exported to report

eps-oci opened this issue a year ago · 9 comments

eps-oci commented a year ago

Hi,

We have realized that DB Systems databases in failed state aren't exported to report.

Regards,
Ernani

Answer 1 · 2023-10-24T20:19:21.000Z

Can you please elaborate a bit more, which report ?

Answer 2 · 2023-10-24T20:33:29.000Z

When we run showoci.py -d, we have receiving a list of Oracle databases created, except databases with failed state. For example dba tried to do a reshape and failed, the database came up again but the state still in Failed, this database isn't exported to report.

Answer 3 · 2023-10-24T20:35:56.000Z

Currently showoci does not extract databases with status failed, I will add it for next version for next week Tuesday.

Answer 4 · 2023-10-24T20:36:36.000Z

Thank you!

Answer 5 · 2023-10-25T00:49:49.000Z

Hi, In order to have it fix quickly, you can edit the file showoci_service.py
Go to line 899 and change FAILED to FAILEDXXX (it is in procedure check_lifecycle_state_active)
Run again and let me know

Answer 6 · 2023-10-25T21:29:17.000Z

I forwarded your suggestion, but I didn't receive a feedback yet.

Answer 7 · 2023-10-26T14:57:47.000Z

Hello!! It's been working fine!!! Thank you!

Answer 8 · 2023-10-26T15:01:12.000Z

Great, it will be implemented next Tue, if you are happy, can you kindly close the ticket

Answer 9 · 2023-10-26T16:41:15.000Z

Thanks for the quick correction and attention!