< Previous  | TOC | Index | Next  >

Handling of RAW files with ODM enabled for Oracle 10g

Oracle can use RAW files for data files, control files and redo logs. Previously, the SQL REUSE clause was ignored if the associated file was a RAW file. From Oracle 10g onwards, the REUSE clause of SQL is mandatory when Oracle Disk Manager (ODM) is enabled. [540429]

There are two workarounds for this issue.

First Workaround: To create database files on raw volumes, you must set the REUSE option in the SQL commands. For examples of error messages and SQL workarounds, see the following Technical Support TechNote:

http://entsupport.symantec.com/docs/283362

Second Workaround: Perform the following steps:

1. Disable ODM

   $ cd $ORACLE_HOME/lib

   $ ln -s libodm10.so libodm10.so

2. Use DBCA and create database.
3. Shutdown database. Make sure all instances of RAC are down.

   If Database instance is under VCS control

   # /opt/VRTSvcs/bin/hares -offline <oracle_resource> -sys galaxy

   # /opt/VRTSvcs/bin/hares -offline <oracle_resource> -sys nebula

   If Oracle database instance is not under VCS control, use native Oracle commands.

4. Enable ODM

$ cd $ORACLE_HOME/lib

For 64 bit Oracle

$ ln -s /usr/lib/amd64/libodm.so libodm10.so

For 32 bit Oracle

$ ln -s /usr/lib/libodm.so libodm10.so

5. Bring up each instance of RAC.

If Database instance is under VCS control

# /opt/VRTSvcs/bin/hares -online <oracle_resource> -sys galaxy

# /opt/VRTSvcs/bin/hares -online <oracle_resource> -sys nebula

If Oracle database instance is not under VCS control, use native Oracle commands.