Ora-01119
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Ora-01119

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Ora-01119

    Hi,

    I am having problem creating tablespace on the 1 logical RAW partion.
    Whereas on 2nd partion, it works. I guess the first one is Extended and second is Linux. What is the reason ?

    My layout is as follows:

    # fdisk -l /dev/sdc

    Disk /dev/sdc: 106 MB, 106954752 bytes
    64 heads, 32 sectors/track, 102 cylinders
    Units = cylinders of 2048 * 512 = 1048576 bytes

    Device Boot Start End Blocks Id System
    /dev/sdc1 1 30 30704 5 Extended
    /dev/sdc2 31 41 11264 83 Linux



    [root@localhost dev]#


    SQL> create tablespace Dat01 datafile '/dev/sdc1';
    create tablespace Dat01 datafile '/dev/sdc1'
    *
    ERROR at line 1:
    ORA-01119: error in creating database file '/dev/sdc1'
    ORA-27044: unable to write the header block of file
    Additional information: 7


    SQL> create tablespace Dat02 datafile '/dev/sdc2';

    Tablespace created.

    SQL>
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,479

    Cool That is a NO-NO

    1) You should not (cannot) mix different disk format(s) for database files.
    2) You cannot directly create a tablespace on a raw disk, you need to use ASM or some kind of "DirectIO" option.
    3) Again: DO NOT mix filesystem formats (types) for database files.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    Hi,

    What i am doing is, i have added few disks to my enterprise linux 4 box viz., sda,sdb,sdc etc.

    After this i am using fdisk to create partition on these disks.

    fdisk /dev/sda..... etc.....

    Now i am creating tablespaces on these raw devices.

    Is this not recommended ? Is this not correct ?

    Of course, I know that future release will not support raw, etc.....
    I am doing this for some benchmarking. I am using Oracle 10.2
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by bang_dba View Post
    I know that future release will not support raw
    really?... do tell please.
    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.

  5. #5
    Join Date
    Jan 2008
    Posts
    31
    Quote Originally Posted by PAVB View Post
    really?... do tell please.
    Note:578455.1

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,479

    Cool Barbeque the disks?

    Note:578455.1
    ...
    Customers who create a new 11.2 database will need to store their database files in either ASM, a file system, or on an NFS file...
    That is why you need to either "cook" (format) the partitions or use ASM.
    Anyway you do it you still CANNOT mix file formats for database files.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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