Oracle 12 Startup upgrade throws error 443

oracleoracle-12cupgrade

Please follow the logic of my attempts at upgrade before suggesting a fix. The error 443 is not the main problem here.

  • we are upgrading from oracle 11.2.0.4 to 12.2.0.1 on a Solaris 11.3 server 'test'.
  • all upgrades are successful except the one database called VIT which throws the error on startup upgrade (after logging in as oracle12): terminating the instance due to error 443
  • we cloned VIT and mounted it on another server. It upgrades successfully. We then mounted the same clone on 'test' and it does not startup, throwing the same error 443.
  • we then renamed VIT to VITNEW on 'test' and the upgrade works! We then renamed it back to VIT and it throws the same error 443 on startup.

So after all these attempts it's obvious to me that there is either something with the name or the server, but bear in mind other databases work on that same server, and it's ONLY that name of VIT that does not work on 'test'.

Weird problem. We have opened a SR for it, but Oracle have no answers yet. Hoping someone might have an idea.

Best Answer

We got to the bottom of this eventually!

It was an oracle group write (g+w) permission missing in the parent folder of the diagnostic_dest structure. Why it gives an error 443 and not a simple write permission error, only the oracle engineers who created this enigmatic diagnostic_dest structure will know!