ORA-09925 Solution On Oracle Linux 6

Error :

[oracle@ErmanTestSTDBY ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 15 15:42:42 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

 

[oracle@ErmanTestSTDBY ~]$ rman target / 

Recovery Manager: Release 12.1.0.2.0 – Production on Sun Oct 15 15:42:11 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

Solutions :

$ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable.

oracle@ErmanTestSTDBY ~]$ ls -lad /u01/app/oracle/admin/cdb1/adump/ —cdb1=Oracle<SID>
drwxr-xr-x. 2 root root 4096 Oct 15 13:14 /u01/app/oracle/admin/cdb1/adump/

[root@ErmanTestSTDBY ~]# chown oracle /u01/app/oracle/admin/cdb1/adump

—————————————————————————————————————————————–

[oracle@ErmanTestSTDBY ~]$ $ORACLE_HOME/bin/sqlplus -L “/ as sysdba”

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 15 16:00:26 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit

Disconnected

[oracle@ErmanTestSTDBY ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 – Production on Sun Oct 15 16:00:35 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN>

 

 

Hits: 3

Leave a Reply

Your email address will not be published. Required fields are marked *