I have a problem in the job execution in our routine application. This job fill data from a Database.
The job name is #P1CPC02, it contains the next code:
AGENT BCPORA17
USER root
SCRIPTNAME -
/xcom_rep/CREP/carga/bin/cargaNormal.sh
But show this error:
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 26 11:15:09 2017
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected
SP2-0670: Internal number conversion failed
Usage: { EXIT | QUIT }@[ SUCCESS | FAILURE | WARNING | n |
<variable> | :<bindvariable> ] [ COMMIT | ROLLBACK ]
Please need your help how fix this error.
When you connect, we write an audit record. The error
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 28: No space left on device
means we did not have enough space to write the record, so we could not successfully connect to the database
If you can connect as sysdba, you can see where the audit files are written:
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string C:\ORACLE\ADMIN\NP12\ADUMP
If you cannot connect, they will likely be under your $ORACLE_HOME, or the $ORACLE_BASE/admin directory.
find $ORACLE_HOME -name "*.aud" -ls
will give you an idea.
You need to clear some space down in that filesystem