Monday, March 24, 2014

12c: Datapatch failure with ORA-01017 error

As we are going to be upgrading a database to 12c, I'm keeping my eyes open for issues that might crop up when we install it and MOS note 1635007.1 is one worth reading up on!  Titled "Datapatch fails with ORA-01017, as it only connects to the database with OS Authentication" it appears that datapatch only is using OS authentication and it reports back the rejection error of ORA-01017 if you are trying to install it under an account which fails the OS authentication.  Even though this note indicates that the issue may be resolved with bug 18151716, if you read that bug information it doesn't really match the description of this note!

Regardless, I learned a bit as I usually track against ad_bugs to see if patches were applied but there is another table DBA_REGISTRY_SQLPATCH which Oracle suggests to modify if the datapatch needs to be applied manually in one of the two workarounds suggested.

1 comment:

  1. Can you please share the workaround to resolve the issue