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!