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, 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:You can't eat hot tofu...
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:Good luck, entering the mount status...