SQL> conn / as sysdba;
ERROR:
ORA-09925: Unable to create audit trail file
HP-UX Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
Warning: You are no longer connected to ORACLE.
ERROR:
ORA-09925: Unable to create audit trail file
HP-UX Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
Warning: You are no longer connected to ORACLE.
如果系统表空间SYSTEM已经被审计信息填满,可用以下命令清空审计表。SQL> truncate table sys.aud$;
SQL> alter system set audit_trail=none scope=spfile;重新启动数据库。 SQL> shutdown immediate
SQL> startup检查审计功能是否已经关闭。
SQL> show parameter audit_trail屏幕显示如下信息:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string NONE其中NONE表示审计功能已经关闭。
这个没有经过测试,只是给LZ一个方法,试试可不可以的。
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted