topic Re: DB creation problem. in Operating System - HP-UX

DB creation problem.

AnthonySN — Thu, 04 Oct 2007 02:32:25 GMT

We are installing Oracle10g RAC on a 2 node(rp3440) cluster using EVA4000 for shared storage.
Operating System - HP-UX 11.23 (PA-RISC 64-bit)
Configured Disk Groups and Volums using Veritas Storage Foundation 5.0
LUN size 360 GB.
Installed Oracle Clusterware 10g R2 (cluster registry and vote disk installed on raw devices)
Installed Oracle 10g R2 RAC
Applied patch 4637591
Tried to create a test database using DBCA
DBCA fails at 80%. giving Error : ORA-00301 and ORA-17502
note: Installed Oracle Clusterware, Installed Oracle 10g RAC and Relinking was done with the Oracle SFRAC configuration Program (installsfrac) provided by Veritas.

Re: DB creation problem.

Frank de Vries — Fri, 05 Oct 2007 02:01:21 GMT

There are 2 seperate things.
One is installing the software and relinking.
If that is happened okay then you passed that one.

Second the creation of the db.
Please know that DBCA is not infallable.
Why do you not just create your test atabase using a create script.

Did you look on http://metalink.oracle.com
to see in which direction the errors are pointing.

Re: DB creation problem.

AnthonySN — Fri, 05 Oct 2007 03:50:21 GMT

Installation of the software and relinking is done without any problem.

We are creating a test db only
Second the creation of the db.

We have cheked the metalink but no clue.

Re: DB creation problem.

Yogeeraj_1 — Fri, 05 Oct 2007 05:40:05 GMT

hi,

If you have metalink access, it would be preferrable to log a service request there.

the problem resolution will be much faster.

kind regards
yogeeraj

Re: DB creation problem.

Hein van den Heuvel — Fri, 05 Oct 2007 10:32:57 GMT

fwiw... the underlying error seems 'easy' enough. 17502 translates to:

"file creation failed due to either insufficient OS permission or the file already exists"

and that 301

ORA-00301: error in adding log file 'string' - file cannot be created

Cause: The creation of the redo log file failed

Action: Check: 1) there is enough storage space on the device 2) the name of the file is valid 3) the device is online 4) an IO error occurred Also, it is possible REUSE was specified on the command line and a file of the incorrect size exists. Either do not specify REUSE or use a file of the correct size.

I often just try to manually, individually, create the files required to see where it goes wrong.

Cheers,
Hein.

Re: DB creation problem.

Alexander M. Ermes — Fri, 12 Oct 2007 07:19:14 GMT

Hi there.
In addition to Hein's posting pls check the owner and rights of the files and directories.
Rgds
Alexander M. Ermes