In Oracle 12c Database you can’t manually install or de-install Oracle Text component (anymore), if your database was upgraded from 11g to 12c with Oracle Text component already installed then you are OK.
To install in 12c , you will be using DBCA (Database Configuration Assistance):
*** Command Line silent approach (syntax):
dbca -silent -configureDatabase -sourceDB <db unique name for RAC or SID for Single Instance db> -sysDBAUserName <user name with SYSDBA privileges> -sysDBAPassword <password for sysDBAUserName user name>] -addDBOption ORACLE_TEXT
ora47> dbca -silent -configureDatabase -SourceDB ora47 -sysDBAUsername sys -addDBOption ORACLE_TEXT
Preparing to Configure Database
Adding Oracle Text
Completing Database Configuration
Look at the log file “/ora47/ora47/cfgtoollogs/dbca/ora47/ora47.log” for further details.
*** GUI interface:
//add your database SID:ORACLE_HOME
If you face the above the problem, then you need grant execute the following system packages to “PUBLIC” :
SQL> grant execute on sys.dbms_sql to public;
SQL> grant execute on sys.dbms_job to public;
SQL> grant execute on sys.dbms_lob to public;
and that is it….you have successfully installed Oracle Text.
select * from dba_registry where COMP_ID=’CONTEXT’ ;
if you want to de-install the Oracle TEXT component you can use DBCA again and “uncheck” the component.
if whaever reason you couldn’t do that then use the traditional 11g way:
SQL>drop procedure sys.validate_context;
select comp_id, comp_name, version, status from dba_registry where COMP_ID=’CONTEXT’;
SELECT object_name FROM dba_objects WHERE status = ‘INVALID’;
One thought on “installation/deinstallation of Oracle Text in Oracle 12c”
Thank you very much; exactly what I was looking for.