Installation of Oracle Text failing with error then database disconnect (Doc ID 1627721.1)

Last updated on FEBRUARY 28, 2014

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Installing Oracle Text, using the steps from Note: Manual installation, deinstallation and verification of Oracle Text 11gR2 (Doc ID 970473.1), on a cloned 11.2.0.3 database. The install fails with ORA-04043: object DR$SESSION_STATE_T does not exist. Then, when trying to uninstall, it fails with ORA-01432: public synonym to be dropped does not exist.

 

Screen shot from Install --

No errors.
... loading driparx.pkh
drop type dr$session_state_t force
*
ERROR at line 1:
ORA-04043: object DR$SESSION_STATE_T does not exist


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

banner@NEXT [/not/ORACLE_HOME/path]
$

 

Oracle Text component is left with status 'LOADING':

SQL> select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';

COMP_NAME     STATUS     VERSION
--------------------------------------------------------------------------------
Oracle Text      LOADING

 

Screen shot from Uninstall  --

SQL> @?/ctx/admin/catnoctx.sql

Session altered.


PL/SQL procedure successfully completed.

dropping all ctxsys objects...
drop public synonym ctx_doc
                  *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

banner@NEXT [/not/ORACLE_HOME/path]
$


Oracle Text component is left with status 'REMOVING':

SQL> select comp_id, comp_name, version, status,schema from dba_registry;

COMP_ID      COMP_NAME   VERSION     STATUS          SCHEMA
---------------------------------------------------------------------
CONTEXT     Oracle Text                     REMOVING       CTXSYS



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