启动数据库报🕴错【cuò】，ORA-18008: cannot find OUTLN schema

问题现象：
数据库版本【bǎn běn】👑 Oracle 11g r2
hrdb1>startup
Oracle 例程已【lì chéng yǐ】经启动🐎。

Total System Global Area 4392697856 bytes-
 

Fixed Size                  2233616 bytes
Variable Size            1090521840 bytes
Database Buffers         3288334336 bytes
Redo Buffers               11608064 bytes
数据库装载完毕🚝。
ORA-01092: Oracle instance terminated. Disconnection forced
ORA-18008: cannot find OUTLN schema
进程【jìn chéng】🔰 ID: 5294
会话 ID: 683 序列号【xù liè hào】: 3

hrdb1>!oerr ora 18008
18008, 00000, "cannot find OUTLN schema"
// *Cause:  The database creation script that creates this schema must not
//          have been executed.
// *Action: Review the log files to see what happened when the database
//          was created.

问题原因：
outlin用户被误删除

解决方法：

按照♑metalink上的解决办法【jué bàn fǎ】，先修改replication_dependency_tracking参数，重建数♎据库outln用户及【yòng hù jí】相关对【xiàng guān duì】象即可🅱。

1，启动到【qǐ dòng dào】mount状态【zhuàng tài】，修改🏃replication_dependency_tracking参数🍒
alter system set replication_dependency_tracking =false scope=spfile;

2，启动数【qǐ dòng shù】据库至open状态🍘
hrdb1>shutdown immediate
hrdb1>startup

3，执行脚【zhí háng jiǎo】🌌本doptim.bsq，Oracle 10g版本可【bǎn běn kě】参考执🆑行附录脚本
@$Oracle_HOME/rdbms/admin/doptim.bsq

此时，用户已创建

hrdb1>select username from dba_users;

USERNAME
------------------------------
OUTLN

4，修改回🍏replication_dependency_tracking参数为【cān shù wéi】true

alter system set replication_dependency_tracking =true scope=spfile;

5，重新启动数据【dòng shù jù】库【kù】，系统恢【xì tǒng huī】复正常
hrdb1>shutdown abort
Oracle 例程已🌩经关闭🗜。
hrdb1>startup
Oracle 例程已🌩经启动。

Total System Global Area 4392697856 bytes
Fixed Size                  2233616 bytes
Variable Size            1090521840 bytes
Database Buffers         3288334336 bytes
Redo Buffers               11608064 bytes
数据库装载完【zhuāng zǎi wán】🤱毕【bì】。
数据库已经打开🎏。
hrdb1>select username from dba_users;

USERNAME
------------------------------
WJ
OUTLN
SYS
SYSTEM
HR
STRMADMIN

已选择6行。

由于版本是【běn shì】Oracle 11g，直接执【zhí jiē zhí】🗞行相关🥉脚本即【jiǎo běn jí】可，oracle 10g版本可以参考🎥《Script to Create User OUTLN in 10.2 [ID 422983.1]》

备注：用于复【yòng yú fù】🥐制的一【zhì de yī】个参数🍈，第一次🤪碰到，做个记【zuò gè jì】录
REPLICATION_DEPENDENCY_TRACKING enables or disables dependency tracking for read/write operations to the database. Dependency tracking is essential for propagating changes in a replicated environment in parallel.

参考资【cān kǎo zī】🆎料：
Unable To Start The Database With OUTLN Schema Dropped ORA-01092& ORA-18008 [ID 855104.1]
Script to Create User OUTLN in 10.2 [ID 422983.1]