ORA-18008: cannot find OUTLN schema

if you dropped OUTLN schema, normal user cannot login with below error:

ERROR:
ORA-18008: cannot find OUTLN schema


Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
ERROR:
ORA-18008: cannot find OUTLN schema


Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.


There are two notes on metalink for this issue:

855104.1 - Unable To Start The Database With OUTLN Schema Dropped ORA-01092& ORA-18008
790116.1 - Recreating Dropped Outln Schema Errors With Ora-00604 And Ora-18008


there are two options:
1. restore to time before dropping
2. work around by recreate OUTLN
2.1 shutdown immediate
2.2 alter system set replication_dependency_tracking=fales scope=pfile;
2.3 shutdown immediate
2.4 startup upgrade
2.5 run $ORACLE_HOME/rdbms/admin/doptim.bsq
2.6 alter system set replication_dependency_tracking=true scope=pfile;
2.7 shutdown immediate
2.8 startup


you might get error when run recreation script

create index i_obj#_intcol# on cluster c_obj#_intcol#
*
ERROR at line 1:
ORA-02033: a cluster index for this cluster already exists

sname varchar2("M_IDEN") not null, /* Name of set */
*
ERROR at line 2:
ORA-00910: specified length too long for its datatype

statistics raw("M_CSIZ"), /* uninterpreted statistics */
*
ERROR at line 7:
ORA-00910: specified length too long for its datatype

ol_name varchar2("M_IDEN"), /* named is potentially generated */
*
ERROR at line 3:
ORA-00910: specified length too long for its datatype


create unique index outln.ol$name on outln.ol$(ol_name)
*
ERROR at line 1:
ORA-00942: table or view does not exist


create unique index outln.ol$signature on outln.ol$(signature,category)
*
ERROR at line 1:
ORA-00942: table or view does not exist


ol_name varchar2("M_IDEN"), /* outline name */
*
ERROR at line 3:
ORA-00910: specified length too long for its datatype


create unique index outln.ol$hnt_num on outln.ol$hints(ol_name, hint#)
*
ERROR at line 1:
ORA-00942: table or view does not exist


ol_name varchar2("M_IDEN"), /* outline name */
*
ERROR at line 3:
ORA-00910: specified length too long for its datatype


create index outln.ol$node_ol_name on outln.ol$nodes(ol_name)
*
ERROR at line 1:
ORA-00942: table or view does not exist

sname varchar2("M_IDEN"),
*
ERROR at line 3:
ORA-00910: specified length too long for its datatype


pname varchar2("M_IDEN"),
*
ERROR at line 4:
ORA-00910: specified length too long for its datatype


reference:
https://forums.oracle.com/forums/thread.jspa?threadID=2257491