Connect to Oracle today error: ORA-18008: unable to find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up this error
Connect to Oracle today error: ORA-18008: unable to find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up this error
Connect to Oracle today error: ORA-18008: can not find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up the error prompt, busy for a while, finally, the solution is recorded.
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:
1. Start oracle to the mount status (SQL command: startup mount ;)
SQL> startup mount;
ORA-01031: insufficient Permissions
Note: Haha, I am prompted that the permission is insufficient. It doesn't matter. 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: I cannot eat hot tofu in my heart...
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 bytes
Fixed Size 1291916 bytes
Variable Size 314575220 bytes
Database Buffers 268435456 bytes
Redo Buffers 7094272 bytes
The database has been loaded.
Note: It's lucky to go to the mount status...