Urgent --datafile error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent --datafile error

  1. #1
    Join Date
    Oct 2000
    Posts
    20
    Hi,everyone,
    Today, I change the privilege of all datafile using NT security. After doing it, most datafile is available to be accessed by client.But this action affects two datafile to offline and when I alter them online,the error occurs. Then I do follow:
    1. shutdown DB
    2. startup it with mount option
    3. recover database using backup controlfile
    I specify the last log file to DB.
    4. alter database open resetlogs;
    But when I do step 4,the error occur again,the error code is:
    ORA-0113
    ORA-0110

    Please tell me what can I do?Thanks in advance.

  2. #2
    The user who start the service is who has to have all privileges.
    You can see this user editing the service if there is no one, the user is SYSTEM, this is a NT user who acts as the "system".
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width