啟動(dòng)數(shù)據(jù)庫(kù)報(bào)錯(cuò)，ORA-18008: cannot find OUTLN schema

問(wèn)題現(xiàn)象：
數(shù)據(jù)庫(kù)版本 Oracle 11g r2
hrdb1>startup
Oracle 例程已經(jīng)啟動(dòng)。

Total System Global Area 4392697856 bytes-
 

Fixed Size                  2233616 bytes
Variable Size            1090521840 bytes
Database Buffers         3288334336 bytes
Redo Buffers               11608064 bytes
數(shù)據(jù)庫(kù)裝載完畢。
ORA-01092: Oracle instance terminated. Disconnection forced
ORA-18008: cannot find OUTLN schema
進(jìn)程 ID: 5294
會(huì)話 ID: 683 序列號(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.

問(wèn)題原因：
outlin用戶被誤刪除

解決方法：

按照metalink上的解決辦法，先修改replication_dependency_tracking參數(shù)，重建數(shù)據(jù)庫(kù)outln用戶及相關(guān)對(duì)象即可。

1，啟動(dòng)到mount狀態(tài)，修改replication_dependency_tracking參數(shù)
alter system set replication_dependency_tracking =false scope=spfile;

2，啟動(dòng)數(shù)據(jù)庫(kù)至open狀態(tài)
hrdb1>shutdown immediate
hrdb1>startup

3，執(zhí)行腳本doptim.bsq，Oracle 10g版本可參考執(zhí)行附錄腳本
@$Oracle_HOME/rdbms/admin/doptim.bsq

此時(shí)，用戶已創(chuàng)建

hrdb1>select username from dba_users;

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

4，修改回replication_dependency_tracking參數(shù)為true

alter system set replication_dependency_tracking =true scope=spfile;

5，重新啟動(dòng)數(shù)據(jù)庫(kù)，系統(tǒng)恢復(fù)正常
hrdb1>shutdown abort
Oracle 例程已經(jīng)關(guān)閉。
hrdb1>startup
Oracle 例程已經(jīng)啟動(dòng)。

Total System Global Area 4392697856 bytes
Fixed Size                  2233616 bytes
Variable Size            1090521840 bytes
Database Buffers         3288334336 bytes
Redo Buffers               11608064 bytes
數(shù)據(jù)庫(kù)裝載完畢。
數(shù)據(jù)庫(kù)已經(jīng)打開(kāi)。
hrdb1>select username from dba_users;

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

已選擇6行。

由于版本是Oracle 11g，直接執(zhí)行相關(guān)腳本即可，oracle 10g版本可以參考《Script to Create User OUTLN in 10.2 [ID 422983.1]》

備注：用于復(fù)制的一個(gè)參數(shù)，第一次碰到，做個(gè)記錄
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]