Friday, 16 March 2018

ORA-09925: Unable to create audit trail file tips


ORA-09925: Unable to create audit trail file tips

Question:  I get the ORA-09925 error when trying to log on to SQLPlus:


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

Cause: ORACLE was not able to create the file being used to hold audit trail records.

 

Action:

 SQL> exit

]$ cd app

app]$ cd admin

admin]$ mkdir standby

]$ cd standby

standby]$ mkdir adump

]$ cd

]$ export ORACLE_SID=standby

]$ sqlplus / as sysdba

sql> startup nomount

ORACLE instance started.

Total System Global Area  836976640 bytes
Fixed Size                  1348160 bytes
Variable Size             473959872 bytes
Database Buffers          356515840 bytes
Redo Buffers                5152768 bytes

SQL>

relink a single executable (binary file) using ADADMIN utility

In this post, I would like to write something useful for patching and fine-tuning. When times, we have to relink a particular binary file ...