啟動資料庫報錯，ORA-18008: cannot find OUTLN schema

啟動資料庫報錯，ORA-18008: cannot find OUTLN schema

問題現象：

資料庫版本 oracle 11g r2

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

資料庫裝載完畢。

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-18008: cannot find OUTLN schema

程序 ID: 5294

會話 ID: 683 序列号: 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上的解決辦法，先修改replication_dependency_tracking參數，重建資料庫outln使用者及相關對象即可。

1，啟動到mount狀态，修改replication_dependency_tracking參數

alter system set replication_dependency_tracking =false scope=spfile;

2，啟動資料庫至open狀态

hrdb1>shutdown immediate

hrdb1>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 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

資料庫裝載完畢。

資料庫已經打開。

hrdb1>select username from dba_users;

USERNAME

------------------------------

WJ

OUTLN

SYS

SYSTEM

HR

STRMADMIN

已選擇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]

http://space.itpub.net/519536/viewspace-615000