I have a 8.1.7 repository database for Designer 9i (client) running on SUN Solaris 8. I can start the database up but when I access the data via Designer it crashes. I try to start it back up and I get the following message
ORA-09925: Unable to create audit trail file
SVR4 Error: 6: No such device or address
Additional information: 9925
This happens even after I have removed all of the .aud files from $ORACLE_HOME/rdbms/audit.
Can anyone give me some clues as to what the problem might be? How do you determine whether it's a hardware problem or a database problem. I have checked everything I know to check as far as the database is concerned. Nothing major has changed on this system since or before this started.
I think its a hardware problem (controller/buffer cache/data block ?) because after my database crashes the UNIX system doesn't work properly. For example, sometimes I can't even do a ps -ef or cat/more a file. The SA can't reboot the system without flipping the switch but still thinks its a database problem. Once the SA flips the switch (fsck runs fine) then I can start the database. The UNIX system has hung on one occasion with the database shutdown. It also happened once in the middle of a cold backup of the database.
Thanks in advance!
Val
Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
[EMAIL PROTECTED]
704-566-5321
