ORA-01119: error in creating database file '+dbdg'
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01119: error in creating database file '+dbdg'

  1. #1
    Join Date
    Sep 2005

    Exclamation ORA-01119: error in creating database file '+dbdg'


    I have 10TB space left in dbdg (Diskgroup) even then when i am trying to add a datafile i am getting following error.

    ORA-01119: error in creating database file '+dbdg'
    ORA-17502: ksfdcre:4 Failed to create file +dbdg
    ORA-15041: diskgroup space
    ORA-24338: statement handle not executed

    SP2-0625: Error printing variable "ret_summary"

    Soma Sekhar Karri

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Oracle thinks otherwise.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2006


    That one is taff. R u using
    We had such case, so we patched the ASM to, then created a new group, moved the files there and dropped the old one. That fixed the problem (at least for now)
    You might try manual rebalance of the disk group, sometimes it helps.
    Also try just creating a new group and moving one of your files there, that will trigger a rebalance, which seems to be a bit different than the manual one.
    Also, avoid autoextensible files, there are some bugs around that. Extend by hand, as rare as possible

    Good luck

    See Metalink Note:389877.1
    Last edited by Bore; 10-29-2007 at 05:43 AM.

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