SLTechnology News&Howtos › Database ›

ORA-09925: Unable to create au

Shulou Source: shulou.com Published: 2022-06-01 18:51:44 11月06日 Update

ORA-09925: the sqlplus / as sysdba brought by Unable to create audit trail file cannot be connected

ERROR:

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9925

ORA-01075: you are currently logged on

[oracle@yang dbs] $vi inithukou.ora

* .audit_file_dest='$ORACLE_BASE/admin/hukou/adump'

[oracle@yang dbs] $mv spfilehukou.ora spfilehukou.ora.bak

SQL > show parameter audit_file_dest

/ picclife/app/oracle/admin/hukou/adump

[root@yang adump] # rm-f *

[oracle@yang ~] $sqlplus / as sysdba

[root@yang adump] # ls

Hukou_ora_8423_20171102051747052914143795.aud