启动数据库报错，ORA-18008: cannot find OUTLN schema
问题现象：数据库版本 Oracle 11g r2hrdb1>startupOracle 例程已经启动。
Total System Global Area 4392697856 bytes-
Fixed Size 2233616 bytesVariable Size 1090521840 bytesDatabase Buffers 3288334336 bytesRedo Buffers 11608064 bytes数据库装载完毕。ORA-01092: Oracle instance terminated. Disconnection forcedORA-18008: cannot find OUTLN schema进程 ID: 5294会话 ID: 683 序列号: 3
hrdb1>!oerr ora 1800818008, 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上的解决办法，先修改replication_dependency_tracking参数，重建数据库outln用户及相关对象即可。
1，启动到mount状态，修改replication_dependency_tracking参数alter system set replication_dependency_tracking =false scope=spfile;
2，启动数据库至open状态hrdb1>shutdown immediatehrdb1>startup
3，执行脚本doptim.bsq，Oracle 10g版本可参考执行附录脚本@$Oracle_HOME/rdbms/admin/doptim.bsq
此时，用户已创建
hrdb1>select username from dba_users;
USERNAME------------------------------OUTLN
4，修改回replication_dependency_tracking参数为true
alter system set replication_dependency_tracking =true scope=spfile;
5，重新启动数据库，系统恢复正常hrdb1>shutdown abortOracle 例程已经关闭。hrdb1>startupOracle 例程已经启动。
Total System Global Area 4392697856 bytesFixed Size 2233616 bytesVariable Size 1090521840 bytesDatabase Buffers 3288334336 bytesRedo Buffers 11608064 bytes数据库装载完毕。数据库已经打开。hrdb1>select username from dba_users;
USERNAME------------------------------WJOUTLNSYSSYSTEMHRSTRMADMIN
已选择6行。
由于版本是Oracle 11g，直接执行相关脚本即可，oracle 10g版本可以参考《Script to Create User OUTLN in 10.2 [ID 422983.1]》
备注：用于复制的一个参数，第一次碰到，做个记录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.
参考资料：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]
