An error occurred while starting the database: ORA-18008: cannot find OUTLN schema

Source: Internet
Author: User


Start Database Error ORA-18008: cannot find OUTLN schema problem symptom: database version oracle 11g r2hrdb1> startupORACLE routine has started. Www.2cto.com Total System Global Area 4392697856 bytesFixed Size 2233616 bytesVariable Size 1090521840 bytesDatabase Buffers 3288334336 bytesRedo Buffers 11608064 bytes the database has been loaded.
ORA-01092: ORACLE instance terminated. Disconnection forcedORA-18008: cannot find OUTLN schema process ID: 5294 session ID: 683 serial number: 3 hrdb1>! Oerr ora 1800818008,000 00, "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. cause: the outlin user is accidentally deleted from www.2cto.com. Solution: Follow the solution on metalink to modify the replication_dependency_tracking parameter and recreate the outln user and related objects of the database. 1. Start the database to the mount state. Modify the replication_dependency_tracking parameter alter system set replication_dependency_tracking = false scope = spfile; 2. Start the database to the open state hrdb1> shutdown immediatehrdb1> startup 3, and Exec. for version bsq and oracle 10 Gb, see run the appendix script @ $ ORACLE_HOME/rdbms/admin/doptim. bsq at this time, the user has created hrdb1> select username from dba_users; USERNAME------------------------------OUTLN www.2cto.com 4, modify back replication_dependency_tracking parameter to true alter s Ystem set replication_dependency_tracking = true scope = spfile; 5. Restart the database and restore the system to normal. hrdb1> the shutdown abortORACLE routine has been disabled. Hrdb1> the startupORACLE routine has been started. Total System Global Area 4392697856 bytesFixed Size 2233616 bytesVariable Size 1090521840 bytesDatabase Buffers 3288334336 bytesRedo Buffers 11608064 bytes database loaded. The database www.2cto.com has been opened. Hrdb1> select username from dba_users; The USERNAME------------------------------WJOUTLNSYSSYSTEMHRSTRMADMIN has selected 6 rows. Since the version is oracle 11g, you can directly execute the relevant Script. For the 10g version of oracle, see Script to Create User OUTLN in 10.2 [ID 422983.1] www.2cto.com remarks: a parameter used for copying, for the first time, make a record 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. reference: 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
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.