This discussion is archived
4 Replies Latest reply: Feb 15, 2013 8:42 AM by onedbguru RSS

please urgently database help

Mahmoud_Hagi Newbie
Currently Being Moderated
please help me
I'm not a database man and I have no idea what is this error I've searched so long on the internet but I have reached nothing at all

the maximum I could reach is this
when the cluster try to start the database it fails and gives the following error
unable to create audit trail file
Permission denied

when I look in the alert.log I found the following error
unable to identify/lock datafile21
datafile 21 : /usr1/oracle/app/oracle/oradata/....
unable to obtain file status
no such file or directory

eventhough I checked the mentioned file and it's there

so can any one give me any help specially that I know nothing about database


Thanks i advance
  • 1. Re: please urgently database help
    Sunny kichloo Expert
    Currently Being Moderated
    What is your OS and Oracle Database Version??

    Also have you checked on whether OS user have permission on above mentioned directory.
  • 2. Re: please urgently database help
    KuljeetPalSingh Guru
    Currently Being Moderated
    857529 wrote:
    please help me
    I'm not a database man and I have no idea what is this error I've searched so long on the internet but I have reached nothing at all

    the maximum I could reach is this
    when the cluster try to start the database it fails and gives the following error
    unable to create audit trail file
    Permission denied
    Are you starting the oracle from correct OS user. check owner/permission of audit destination file.
  • 3. Re: please urgently database help
    982217 Newbie
    Currently Being Moderated
    When starting up Oracle, it still relies on OS's ACL/permission to read/write/spawn process.

    It is common in multi-Oracle-and-database server, people use root to verify the files, but use regular non-Oracle user to startup Oracle database.

    This looks like your case. If you can provide output of following

    1. uname -a
    2. ls -la /opt/oradata/database but replace the it with the Oracle data file directory
    3. id
    4. Oracle startup steps, if it is a script, paste the whole script here

    The more you tell, the clearer we know what's wrong in your steps
  • 4. Re: please urgently database help
    onedbguru Pro
    Currently Being Moderated
    also
    df -h on the /usr1

    Make sure the filesystem has not been set to ReadOnly.

    also make sure the device is not full and as other stated, make sure the directory structure has the correct permissions.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points