Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2002
    Posts
    6

    Post Unanswered: Raw Devices in Oracle 9i on Windows 2000

    Hello All,

    I am trying to set up a few tablespaces on raw devices (raw logical drives) in Oracle 9.2.0 on Windows 2000.
    I DO NOT have a cluster environment (RAC) set up on this machine, I just want to set up a few tablespaces on raw devices for testing purposes.
    My problem is that I do not know how to do this or where to obtain the required info. The Oracle 9i Creating Raw Devices doc is useless as it talks about setting raw devices up in RAC and the utilities that it explains (importsymlinks, exportsymlinks, etc.) do not work in the way that the document explains. I tried looking on the web for any relavant docs, but with no success. Setting up raw table spoaces in Unix is a walk in the park. On Windows 2000, I am having major difficulties though because of the nature of this limited OS.
    I would appreciate anybody's help very much.

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Raw Devices in Oracle 9i on Windows 2000

    Hi.

    I did it with 8i and Win 2K. I thinks it's the same for the new release.
    You need the EE not the SE release of the engine.
    The oracle manuals of 8i are quite fine. This information is in effect a part of OPS/RAC but can be used independently of them.

    The level of difficulty is the same in Win as in Unix:
    1) prepare a locical disk partition
    2) give a name to the disk partition
    3) use that name (like \\.\REDO_01) in oracle statemnts as they were file names.

    The real plus of raw is the reactivity in on-line redo logs writing,
    and in RBS/TEMP writing.

    I'll feed the detailed infos here as soon as possible (now I cannot).

    see you soon.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  3. #3
    Join Date
    Sep 2002
    Posts
    6
    Thanks Franco.
    So I did create a tablespace on raw partition using the command

    create tablespace "raw_1"
    datafile '\\.\U:' size 100MB;

    This created a tablespace raw_1 on the raw partition that I created and assigned a drive name U:.
    Now your example talks about giving the raw partition some sort of a symbolic link. In your example the tablespace would be created in the following way:

    create tablespace "raw_1"
    datafile '\\.\some_raw_link' size 100MB;

    How do you make the correspondance of some_raw_link to the raw partition (i.e. how do you name the raw partition some_raw_link)?

    Thanks a lot for your help,

  4. #4
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53
    Hi.
    The following commands (in ORACLE_HOME/opspreinstall in 8iEE):

    crlogdr /d2 /s 252 /l TEMP_01
    crlogdr /d2 /s 252 /l REDO_01
    crlogdr /d2 /s 252 /l REDO_02
    crlogdr /d2 /s 252 /l REDO_03
    crlogdr /d2 /s 252 /l REDO_04

    produce this disk configuration:
    TEMP_01 \Device\Harddisk2\Partition1 250.00M
    REDO_01 \Device\Harddisk2\Partition2 250.00M
    REDO_02 \Device\Harddisk2\Partition3 250.00M
    REDO_03 \Device\Harddisk2\Partition4 250.00M
    REDO_04 \Device\Harddisk2\Partition5 250.00M

    Do not user Partition0 because it means all the physical disk !!
    I'm afraid of assigning unit name (like u because Win will ask your junior DBA to format it .....

    This is a small man page for row utilities:

    deletedisk /dm /q /fsd remove all partitions of the disk "m"
    crlogdr /dm /p list all partitions and their labels of disk "m"
    crlogdr /dm /r /n k remove of partition k of "m"
    crlogdr /dm /n k /l label let "label" be the name of partition k of "m"
    crlogdr /dm /s xxx /l label create a new partition at the end of the
    logic partition (DOS) of disk "m", with name
    "label" and dimention of xxx Mb

    So you can use them in SQL statems like the bottom of the message.
    If someone says you that there are no performance gains using raw devices (or that FSs cache performs better), you have to remeber them that they tooke the wrong bench.

    I've cut&past&patched the above hints so many times that some trivial error can be present. Pay attention to what you are doing and remember you have to use a logic/extended (DOS) partition not a primary one.

    Good luck.

    CREATE DATABASE dummy
    LOGFILE
    GROUP 1 '\\.\REDO_01' SIZE 250M,
    GROUP 2 '\\.\REDO_02' SIZE 250M,
    GROUP 3 '\\.\REDO_03' SIZE 250M,
    GROUP 4 '\\.\REDO_04' SIZE 250M
    DATAFILE 'D:\DATABASE\SYSTEM_1.DBF' SIZE 2000M AUTOEXTEND OFF
    MAXLOGFILES 40
    MAXLOGMEMBERS 1
    MAXDATAFILES 256
    MAXINSTANCES 1
    ARCHIVELOG
    CHARACTER SET WE8ISO....;


    CREATE TEMPORARY TABLESPACE TEMP
    TEMPFILE '\\.\TEMP_01' SIZE 250M AUTOEXTEND OFF
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16400K ;
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  5. #5
    Join Date
    Sep 2002
    Posts
    6
    That answers my questions.
    Thanks Franco.

  6. #6
    Join Date
    Sep 2002
    Posts
    6
    I tried to use the crlogdr utility and with no result

    First I wanted to list information about my disk, so I typed:
    crlogdr /d0 /p
    The message I got back was:
    One or more primary partition on the disk.

    crlogdr /d1 /p resulted in the same message being printed.

    Also,

    crlogdr /d0 /s /252 /l /TOM_01
    produced a message:
    One or more primary partitions on the disk.

    Same message, no matter what I do. Why are these tools not working for me

  7. #7
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    The error message is Ok

    The disk you are using have to be comprised of an EXTENDED partition,
    not a primary one.
    You can make a raw only from extended partitions. No way out.

    Best regards.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  8. #8
    Join Date
    Sep 2002
    Posts
    6
    I understand that.
    What if I have a combination. As you know Windows will allow me to set up extended partitions and primary ones on the same physical disk.
    Will Oracle's tools have a problem with this if I am using primary partitions combined with extended ones (logical drives being part of my extended partitions)?
    If I give the logical drives disk names, I can create my tablespaces using the disk names i.e. \\.\E: - no problem.
    But for some reason thoise Oracle tools don't work well if my disk has primary partitions and extended partitions...in which case I see only one solution - the disk has to have only extended partitions with logical drives - NOTHING ELSE ON IT. Is that the case?

  9. #9
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53
    I've tried only the all-the-disk-to-oracle solution,
    so I cannot assure you about the rest.
    I believe that if you have and extended partition, in that place you can do what you want, but I'm not sure at all.

    Best regards.
    Greetings from Italy.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  10. #10
    Join Date
    Sep 2002
    Posts
    6
    Well - thanks Franco for all your help.
    You have certainly helped me a lot in this matter.

    Cheers,
    g7tommyB

Posting Permissions

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