4 Replies Latest reply: Feb 15, 2013 10:42 AM by onedbguru RSS

    please urgently database help

    Mahmoud_Hagi
      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
          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
            kuljeet singh -
            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
              feels1
              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
                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.