Home » Server Options » Data Guard » ora 09925 -unable to create audit trail file (10.2.0.4.0,linux version)
ora 09925 -unable to create audit trail file [message #563981] Sun, 19 August 2012 12:23 Go to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
[oracle@RSASPGERP02 ~]$ cd /
[oracle@RSASPGERP02 ~]$ . .bash_profile
[oracle@RSASPGERP02 ~]$ sqlplus / as sysdba

sql*plus:Release 10.2.0.4.0 - production
Error:
ORA-09925:Unable to create audit trail file
Linux-x86_64 Error:28: No space left on device
Additional information :9925
ORA-09925:Unable to create audit trail file
Linux-x86_64 Error:28: No space left on device
Additional information :9925

Enter user-name:_

i need your help guys.....
can you please tell me how to overcome with this issue....its standby archieving problem ,the problem appears when try to connect directly or through telenet
and we try to login directly using oracle user we receving following message and login fail,
"GDM could not write to your authorization file,this could mean that you are out of disk space or that your home directory could not be opened for writting" ,
I DELETED OLD ARCHIVE FILES AND NOW ITS LOGGING IN and everything OK BUT NOW NO NEW ARCHIVEING FILES ARE CREATED
may be iam missing some thing ...
thanks in advance...
Re: ora 09925 -unable to create audit trail file [message #563984 is a reply to message #563981] Sun, 19 August 2012 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 23192
Registered: January 2009
Senior Member
>may be iam missing some thing ...
missing a clue or two

post results from following OS commands

df -k
env | sort
Re: ora 09925 -unable to create audit trail file [message #563985 is a reply to message #563981] Sun, 19 August 2012 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-09925:Unable to create audit trail file
Linux-x86_64 Error:28: No space left on device

The error message is clear, the file system where the audit files are is full, enlarge it or remove old files.

Regards
Michel
Re: ora 09925 -unable to create audit trail file [message #563986 is a reply to message #563981] Sun, 19 August 2012 12:50 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
Can you please tell me step by step command on linux to follow on...
Re: ora 09925 -unable to create audit trail file [message #563988 is a reply to message #563986] Sun, 19 August 2012 12:52 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
hi michel,

yes removed the old archive files but its not creating new archive files in standby

Regards&thanks,
sam
Re: ora 09925 -unable to create audit trail file [message #563989 is a reply to message #563988] Sun, 19 August 2012 12:53 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
yes removed the old archive files but its not creating new archive files in standby


The problem is NOT in the archived log destination, it is in the audit trail destination.
The command BlackSwan gave you will help you to know which file system it is.

Regards
Michel
Re: ora 09925 -unable to create audit trail file [message #563990 is a reply to message #563988] Sun, 19 August 2012 12:54 Go to previous messageGo to next message
BlackSwan
Messages: 23192
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: ora 09925 -unable to create audit trail file [message #563991 is a reply to message #563990] Sun, 19 August 2012 13:03 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
Thank you verymuch michel,blackswan
Really appriciate your help...
Reach you with the post
thanks again....
Regards,
sam
Re: ora 09925 -unable to create audit trail file [message #564223 is a reply to message #563991] Wed, 22 August 2012 03:56 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 9920592 5771832 3636692 62% /
/dev/sda5 4582896 140448 4205896 4% /u01
/dev/sda2 11904620 6774284 4515852 61% /opt
tmpfs 517360 0 517360 0% /dev/shm
[oracle@localhost ~]$ env|sort
_=/bin/env
CVS_RSH=ssh
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/opt/oracle
HOSTNAME=localhost.localdomain
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_IS_PRELINKED=1
KDE_NO_IPV6=1
LANG=en_US.UTF-8
LD_ASSUME_KERNEL=2.6.18
LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/opt/oracle/product
ORACLE_HOME=/opt/oracle/product/11.2.0/db_1
ORACLE_SID=sam
PATH=/opt/oracle/product/11.2.0/db_1/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/opt/oracle/bin
PWD=/opt/oracle
QTDIR=/usr/lib/qt-3.3
QTINC=/usr/lib/qt-3.3/include
QTLIB=/usr/lib/qt-3.3/lib
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=oracle
Re: ora 09925 -unable to create audit trail file [message #564224 is a reply to message #564223] Wed, 22 August 2012 03:58 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
hi blackswan,

can you please help me out what what should i do changes in order to generate my new archive file,

thanks in advance.....
Re: ora 09925 -unable to create audit trail file [message #564225 is a reply to message #564224] Wed, 22 August 2012 04:02 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
I DELETED OLD ARCHIVE FILES AND NOW ITS LOGGING IN and everything OK BUT NOW NO NEW ARCHIVEING FILES ARE CREATED
may be iam missing some thing ...
thanks in advance
Re: ora 09925 -unable to create audit trail file [message #564226 is a reply to message #564223] Wed, 22 August 2012 04:04 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
I DELETED OLD ARCHIVE FILES AND NOW ITS LOGGING IN and everything OK BUT NOW NO NEW ARCHIVEING FILES ARE CREATED
may be iam missing some thing ...
thanks in advance
Re: ora 09925 -unable to create audit trail file [message #564227 is a reply to message #564226] Wed, 22 August 2012 04:11 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
The above file is off different version can you please let me know what changes should be made to overcome from this issue....
Re: ora 09925 -unable to create audit trail file [message #564235 is a reply to message #564227] Wed, 22 August 2012 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Due your current behaviour, I leave this topic.

Regards
Michel
Re: ora 09925 -unable to create audit trail file [message #564542 is a reply to message #563981] Sat, 25 August 2012 03:45 Go to previous message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
hi,
can you please let me know what are the changes have to be done
Previous Topic: Configuring rman for dataguard environment.
Next Topic: STANDBY RESOURCE DEMOND
Goto Forum:
  


Current Time: Mon Dec 29 00:08:22 CST 2014

Total time taken to generate the page: 0.20566 seconds