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 DATABASEWhen 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?
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/c0t0d0s6Similarly 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
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in December 2002