Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create database using dbca on raw partition in Oracle 9i on MS-Windows 2000

Create database using dbca on raw partition in Oracle 9i on MS-Windows 2000

From: Bruce <brucemcgill.nyc_at_gmail.com>
Date: 13 Apr 2007 05:29:23 -0700
Message-ID: <1176467363.526807.17830@y5g2000hsa.googlegroups.com>


Hello All,

    I had posted a similar message earlier but I have a different query this time.

    I am able to create database on raw partitions in Windows 2000. It is NOT a part of RAC setup. I was able to create a database manually on raw partitions

in MS-Windows 2000. But I want to create database using dbca.

I have two IDE disks. Disk 0 is the system disk and Oracle 9i softare is on the . The other is unformatted. After creating the extended parttion on the

second disk, I used the Disk Management to create logical drives of desired capacities and chose not to assign a drive letter.

I copied all the files from from Oracle 9i Disk1\preinstall_rac\olm to C:\temp. I changed the sample.tbl file. The contents of sample.tbl file are:

db01_redo1         \Device\Harddisk1\Partition1     100
db01_redo2         \Device\Harddisk1\Partition2     100
db01_system      \Device\Harddisk1\Partition3     400
db01_undo          \Device\Harddisk1\Partition4     250
db01_temp          \Device\Harddisk1\Partition5     100
db01_control1     \Device\Harddisk1\Partition6     100
db01_control2     \Device\Harddisk1\Partition7     100
db01_spfile          \Device\Harddisk1\Partition8     50

I ran this command to create symbolic links:

C:\temp>ImportSYMLinks.exe /f:c:\temp\sample.tbl

DosName: db01_redo1 DeviceName: \Device\Harddisk1\Partition1 Size: 100
DosName: db01_redo2 DeviceName: \Device\Harddisk1\Partition2 Size: 100
DosName: db01_system DeviceName: \Device\Harddisk1\Partition3 Size: 400
DosName: db01_undo DeviceName: \Device\Harddisk1\Partition4 Size: 250
DosName: db01_temp DeviceName: \Device\Harddisk1\Partition5 Size: 100
DosName: db01_control1 DeviceName: \Device\Harddisk1\Partition6 Size: 100
DosName: db01_control2 DeviceName: \Device\Harddisk1\Partition7 Size: 100
DosName: db01_spfile DeviceName: \Device\Harddisk1\Partition8 Size: 50

Links imported from file c:\temp\sample.tbl

ImportSYMLinks completed successfully

Since I have to create database using dbca, I ran the command.

Please advise the entries I should make in the Database Configuration Assistant Database Storage Page, step 8 of 9. For example, the spfile is db01_spfile

which is actually a symbolic link. In the Database Configuration Assistant Database Storage Page:

  1. what entry should be mentioned in the file name clause?
  2. what entry should be mentioned in the file directory clause?

Please refer to the following link
http://www.lc.leidenuniv.nl/awcourse/oracle/rac.920/a96600/dbcacrea.htm

Best Regards,

Bruce Received on Fri Apr 13 2007 - 07:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US