Error Applying Patch 19278976 With SP2-0310 And ORA-00942 Unable To Open Files ../10.2.0/db_1/rdbms/admin/dbmshptab.sql and dbmshpro.sql (Doc ID 1992898.1)

Last updated on APRIL 10, 2015

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, when attempting to apply patch 19278976,
the following errors occur:

The following files are reported as missing:
dbmshptab.sql and dbmshpro.sql

Filename = adgrants_19278946.log.txt

SP2-0310: unable to open file "/u400/oracle/finproddb/10.2.0/db_1/rdbms/admin/dbmshpro.sql"
grant select on dbmshp_runs to apps
*
ERROR at line 1:
ORA-00942: table or view does not exist

AND

File name = adgrants_19278976.log.txt

SP2-0310: unable to open file "/u400/oracle/finproddb/10.2.0/db_1/rdbms/admin/dbmshptab.sql"
SP2-0310: unable to open file "/u400/oracle/finproddb/10.2.0/db_1/rdbms/admin/dbmshpro.sql"
grant select on dbmshp_runs to apps
*
ERROR at line 1:
ORA-00942: table or view does not exist

grant select on dbmshp_function_info to apps
*
ERROR at line 1:
ORA-00942: table or view does not exist

grant select on dbmshp_parent_child_info to apps
*
ERROR at line 1:
ORA-00942: table or view does not exist

 

Cause

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