Search This Blog

Sunday, July 24, 2011

Don't Delete OUTLN Schema

Oracle 11g or later.

Installation of Oracle 11g database created few schemas based on the PRODUCT INSTALLED.
like
1. sysman
2. dbsnmp
3. outln

Schemas depands on PRODUCT INSTALLED but beside that there are few SCHEMAS is required by SYS user and MUST NOT BE DELETED
LIKE:
OUTLN Schema

Suppose if you deleted by MISTAKE OUTLN schema then database will not start and startup process ended with following error.

Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-18008: cannot find OUTLN schema
Process ID: 5046
Session ID: 218 Serial number: 5

Solution:
restore last valid backup ( which included OUTLN schema)
Or
Oracle Support

No comments: