Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15

Error:

We are getting below error while installing UPK Server and Client on windows server 2012 R2.

UPK client / server Installation fails with a Library Loader log:

@ System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
@ ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored (Fault Detail is equal to An ExceptionDetail,
@ likely created by IncludeExceptionDetailInFaults=true, whose value is:
@ Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored

Fix:

Stop the installer before running Library Loader and manually add grant permissions.

Steps:

• Drop the tablespace and users.  Start a fresh installation.
• Create a setupdiag.ini

Locate the ..\setup\Branding\UPK\Installer folder

Create a new notepad file called setupdiag.ini

Open the file and enter the following:

[SetupDebug]

Stopbeforelibraryloader=1

Save and close the file.

• Create a setupdiag.ini
• Start installer and enter credentials desired to be created
• Installer pauses 
• Grant the execute privileges

• Log in as SYSDBA, run the the following queries:

grant execute on sys.dbms_lob to ODSERVER;

grant execute on sys.dbms_lob to ODSERVER_APP;

•  Log into Oracle with the credentials of the schema created (i.e.,ODSERVER)

• Run the following query:

select object_name, object_type from obj where status !='VALID';

returned two FUNCTIONS:

ADD_PART

PART_EXISTS

•  Recompile the invalid objects

alter compile;

example: alter FUNCTION ADD_PART compile;

example: alter FUNCTION PART_EXISTS compile;

• Let installer continue

• Click Finish