Patch 10117518 Fails With "AutoPatch error: Your database is missing important grants on SYS objects"
Last updated on JULY 28, 2017
Applies to:Oracle Applications DBA - Version 12.2 to 12.2.3 [Release 12.2Cloud]
Information in this document applies to any platform.
The GEPW: AD Upgrade Driver for 12.2 (patch 10117518) fails in spite of running adgrants.sql with:
Your database is missing important grants on SYS objects.
To fix this:
1) Log on as the database server owner, and set your environment for
maintaining your database server. Create a directory called
$ORACLE_HOME/appsutil/admin and copy $APPL_TOP/admin/adgrants.sql
to that directory.
2) Connect to the database as the SYS user and run adgrants.sql passing
the name of the schema containing FND tables.
For example, if the schema that contains FND tables in your database
is called APPLSYS, you would run adgrants.sql as follows:
$ cd $ORACLE_HOME/appsutil/admin
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @adgrants.sql APPLSYS
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms