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.
Recent Comments