Oracle error: & quot; ORA-18008: unable to find the OUTLN solution & quot; Solution

Source: Internet
Author: User

Oracle error: "ORA-18008: unable to find the OUTLN solution" connected to Oracle today error: ORA-18008: unable to find the OUTLN solution, the day before yesterday also used well, the error message is displayed no matter whether you query any SQL statement or click to view the list. After a while, the solution is finally solved. Now, record the solution. Problem: ORA-18008: The OUTLN solution cannot be found. Cause: the outln user is deleted by mistake. Database Version: Oracle 10g (10.2.0.3.0) solution steps: 1, the oracle boot to the mount status (SQL command: startup mount;) SQL> startup mount; ORA-01031: insufficient permissions Note: haha, a message indicating insufficient permissions is displayed. you can log on with the system account .. SQL> connect/as sysdba; connected. SQL> startup mount; ORA-01081: unable to start ORACLE that is already running-Close it first Note: cannot eat hot tofu ah... SQL> shutdown immediate; the database has been closed. The database has been detached. The ORACLE routine has been disabled. SQL> startup mount; the ORACLE routine has been started. Total System Global Area 591396864 bytesFixed Size 1291916 bytesVariable Size 314575220 bytesDatabase Buffers 268435456 bytesRedo Buffers 7094272 bytes database loaded. Note: Good luck. Go to the mount status... 2. Modify the replication_dependency_tracking parameter SQL> alter system set replication_dependency_tracking = false scope = spfile; the system has changed. 3. Start the database to the open state SQL> shutdown immediate; ORA-01109: the database has not opened the unmounted database. The ORACLE routine has been disabled. SQL> startup; the ORACLE routine has been started. Total System Global Area 591396864 bytesFixed Size 1291916 bytesVariable Size 318769524 bytesDatabase Buffers 264241152 bytesRedo Buffers 7094272 bytes database loaded. The database has been opened. 4. create outln user SQL> create user outln identified by outln; the user has been created. SQL> select username from dba_users; USERNAME ------------------------------ OUTLNSYSSYSTEMSCOTTNote: The outln user is successfully created... 5. Modify the replication_dependency_tracking parameter to trueSQL> alter system set replication_dependency_tracking = true scope = spfile; the system has changed. 6. Restart the database and restore the system to normal SQL> shutdown abort; the ORACLE routine has been disabled. SQL> startup; the ORACLE routine has been started. Total System Global Area 591396864 bytesFixed Size 1291916 bytesVariable Size 322963828 bytesDatabase Buffers 260046848 bytesRedo Buffers 7094272 bytes database loaded. The database has been opened. OK!

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.