Post-installation step for PSU fails with Error ‘ORA-00980: synonym translation is no longer valid…’ (Doc ID 2207209.1)

Last updated on NOVEMBER 24, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Post-installation step for SPU/PSU fails with error

SELECT extract(column_value, ‘/bundle/@id’).getNumberVal() bundleID
*
ERROR at line 37:
ORA-06550: line 37, column 12:
PL/SQL: ORA-00980: synonym translation is no longer valid
ORA-06550: line 37, column 5:
PL/SQL: SQL Statement ignored

..
..

SQL> DROP DIRECTORY admin_dir;
DROP DIRECTORY admin_dir
*
ERROR at line 1:
ORA-04043: object ADMIN_DIR does not exist

 

Changes

Database is upgraded from 10gR1 or lower version, in recent.

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