dbca issue

Dbca for 9204 rac issue

The information in this article applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.4 Linux x86
Using NetApp Filer as storage devices for RAC 9.2.0.4 on Linux Advanced server 2.1.

 

Symptoms:

When running dbca to create RAC database on NetApp Filer with following command:

dbca -datafileDestination /ora/data/new

get following message from pop up window:

stat for /ora/data/new/TEST/spfileTEST.ora file failed

The filename "/ora/data/new/TEST/spfileTEST.ora" entered for the persistent initialization parameters file
(spfile) is not a valid raw device. Please enter a valid raw device name with its full path.

When tracing dbca, it shows in trace file:

[AWT-EventQueue-0] [12:34:36:36] [UnixSystem.:118] loaded libraries
[AWT-EventQueue-0] [12:34:36:65] [RawDeviceResult.:44] NativeResult: The String obtained is0|Unknown error 137752448|stat for /ora/data/new/TEST/spfileTEST.ora file failed
[AWT-EventQueue-0] [12:34:36:94] [RawDeviceResult.:44] The status string is: 0
[AWT-EventQueue-0] [12:34:36:122] [RawDeviceResult.:44] The result string is: Unknown error 137752448 2

Changes:

/ora/data/new is a shared device, rsh to create a file to its own node and remote nodes all succeed.
There is no permission issue for the file created on this location, it can be viewed and edited by all nodes.
NetApp filer is mounted with "noac" option.

 

Caus:

The pathname specified in dbca command is not a mount point for NetApp filer but rather one level down from mount point
eg: /ora/data is the mount point of NetApp Filer, but the pathname in given command is: /ora/data/new

 

Fix:

specifiy mount point of the shared file system (NetApp Filer), eg:

dbca -datafileDestination /ora/data

Note: from 9.2.0.4, the trailing "/" in above command is not necessary.