Ask the Expert

Creating a database on raw partition

I tried to create a database on raw partition with the command:
CREATE DATABASE RAW
LOGFILE '\.L:' SIZE 10M,
    '\.M:' SIZE 10M,
    '\.N:' SIZE 10M
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE '\.S:' SIZE 20M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
and I got the error:
 
ORA-02165: invalid option for CREATE DATABASE
When I tried:
 
ALTER DATABASE ADD LOGFILE GROUP 4 ('\.J:')
on database that wasn't created on raw partition, it works. Does it mean I can't create a database on raw partition, just create tablespace or logfile and to add them to an existing database?

    Requires Free Membership to View

    Login

You should be able to create the DB on raw partition just fine. Before creating the database you need to prepare the partitions on which datafiles will be created. The size of the partitions should be greater (at least two Oracle blocks) than the datafile size that you are going to create. You can create the partitions using "format" command as root user. Once partitions are created, change the owner and group of raw partition to oracle and dba. If your raw partition is /dev/rdsk/c0t0d0s6 

chown oracle:dba /dev/rdsk/c0t0d0s6
Similarly for all the raw partitions. Note that the raw partition should be character device (and not block device).

Now, create the database with REUSE option for each datafile and logfile which are going to be on the raw partition.

For More Information


This was first published in December 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top