recreating ctxsys in 10g

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

The above is my oracle version.I need to drop my CTXSYS user and then re-create it with all relevant objects.Can anyone guide me with a step by step approach
suhinrasheedAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
<ORACLE_HOME>/ctx/admin

ctxsys.sql   -  to recreate the user

ctxrelod.sql - to recreate the objects
0
 
suhinrasheedAuthor Commented:

SQL> connect /as sysdba
Connected.
SQL> @ctxrelod.sql
BEGIN dbms_registry.check_server_instance; END;

*
ERROR at line 1:
ORA-39702: database not open for UPGRADE or DOWNGRADE
ORA-06512: at "SYS.DBMS_REGISTRY", line 944
ORA-06512: at line 1


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64
bit Production
With the Partitioning and Data Mining options
$

got the above
0
 
schwertnerConnect With a Mentor Commented:
SQL>connect sys/pasw@alias as sysdba
SQL>shutdown immediate
SQL>startup migrate
or
SQL>startup upgrade
SQL>@ctxrelod.sql
....
SQL>shutdown immediate
0
All Courses

From novice to tech pro — start learning today.