مشكلة عند الدخول Ora-09817

[نبيل عوض]

 

SQL> conn / as sysdba

ERROR:

ORA-09817: Write to audit file failed.

Linux-x86_64 Error: 28: No space left on device

Additional information: 12

ORA-01075: you are currently logged on

 

[نبيل عوض]

يعطيكم العافية تم حل المشكلة 

[oracle@zeus ~]$ sqlplus / as sysdba
...
...
Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

 

SQL> alter database mount;

Database altered.

SQL> alter database clear unarchived logfile group 1;
Database altered.

SQL> alter database clear unarchived logfile group 2;
Database altered.

SQL> alter database clear unarchived logfile group 3;
Database altered.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup

 وتم حل المشكلة