SQL> @?/ctx/admin/catctx.sql oracle SYSAUX TEMP NOLOCK
sql> connect CTXSYS/oracle
SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
SQL> connect /as sysdba
SQL> alter user ctxsys account lock password expire;
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------------------------------------ ------------------------------ -----------
Oracle Text 10.2.0.5.0 VALID
Oracle XML Database 10.2.0.5.0 VALID
Oracle Enterprise Manager 10.2.0.5.0 VALID
Oracle Database Catalog Views 10.2.0.5.0 VALID
Oracle Database Packages and Types 10.2.0.5.0 VALID
SQL> select * from ctxsys.ctx_version;
VER_DICT VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0
SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
VER_CODE
----------
10.2.0.5.0
SQL> select count(*) from dba_objects where owner='CTXSYS';
COUNT(*)
----------
339
SQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;
no rows selected
No comments:
Post a Comment