FINDINGS

login as: oracle
oracle@192.168.1.101’s password:
Last login: Fri Sep 10 03:22:27 2021
[oracle@lovetech ~]$
[oracle@lovetech ~]$
[oracle@lovetech ~]$ . oraenv
ORACLE_SID = [dbatest] ? dbaprod
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@lovetech ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 10 03:24:34 2021

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

Connected to an idle instance.

SQL> startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
SQL>
SQL> select name,open_mode from v$database;

NAME OPEN_MODE

DBAPROD READ WRITE

SQL> show parameter audit;

NAME TYPE VALUE

audit_file_dest string /u01/app/oracle/admin/dbaprod/
adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB

SQL>
SQL> select value from v$parameter where name = ‘audit_file_dest’;

VALUE

/u01/app/oracle/admin/dbaprod/adump

SQL> alter system set audit_file_dest=’/oradata/app/oracle/admin/dbaprod/adump’ scope=spfile;

System altered.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925

CAUSE

Audit_file_dest was changed to /oradata/app/oracle/admin/dbaprod/adump directory own by root and oracle couldn’t write to it.This caused permissionn issues.

[oracle@lovetech oradata]$ ls -ldh /oradata/app/oracle/admin/dbaprod/adump
drwxr-xr-x. 2 root root 6 Sep 10 13:00 /oradata/app/oracle/admin/dbaprod/adump

SOLUTION
As user root, change directory owner and group on /oradata file system to oracle and oinstall respectively

[oracle@lovetech oradata]$ su – root
Password:
Last login: Fri Sep 10 12:55:08 EDT 2021 on pts/0
[root@lovetech ~]# chown -R oracle:oinstall /oradata
[root@lovetech ~]# chmod -R 775 /oradata

Validate that directory and group has been change successfully,then switch to oracle and start the database

[root@lovetech ~]# ls -ldh /oradata/app/oracle/admin/dbaprod/adump
drwxrwxr-x. 2 oracle oinstall 6 Sep 10 13:00 /oradata/app/oracle/admin/dbaprod/adump
[root@lovetech ~]# su – oracle
Last login: Fri Sep 10 10:34:57 EDT 2021 from 192.168.1.11 on pts/0

[oracle@lovetech ~]$ . oraenv
ORACLE_SID = [dbatest] ? dbaprod
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@lovetech ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 10 13:39:16 2021

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 367439872 bytes
Fixed Size 2213456 bytes
Variable Size 297798064 bytes
Database Buffers 62914560 bytes
Redo Buffers 4513792 bytes
Database mounted.
Database opened.
SQL>
SQL> select name,open_mode from v$database;

NAME OPEN_MODE

DBAPROD READ WRITE

Changing directory owner and group on /oradata file system to oracle and oinstall resolved the issue.

Note: The use of any materials on this website is at your own risk. It is provided for educational purposes only. It has been tested internally,
but we do not guarantee that it will work for you. We recommend you test in your test environment before using.