HOME > > ORA-18008: cannot find OUTLN schema

ORA-18008: cannot find OUTLN schema

Anup - Monday, May 6, 2013

The following action can be done to workaround the situation, but please note that the following solution is not supported as dropping the outln schema is not a supported action in the first place:

1-startup mount:
startup mount

2-run:

alter system set replication_dependency_tracking =false scope=spfile;

3-Shutdown the database
shutdown immediate

4-Startup the database in the upgrade mode.
startup upgrade

5-Create the outln schema:
the creation information can be extracted from :
$OH/rdbms/admin/doptim.bsq

6-Run:
alter system set replication_dependency_tracking =true scope=spfile;

7-shutdown the database
shutdown immediate

8-startup the database
startup

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me