Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

DB creation problem.

AnthonySN
Respected Contributor

DB creation problem.

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.
5 REPLIES
Frank de Vries
Respected Contributor

Re: DB creation problem.

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.
Look before you leap
AnthonySN
Respected Contributor

Re: DB creation problem.

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.
Yogeeraj_1
Honored Contributor

Re: DB creation problem.

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Hein van den Heuvel
Honored Contributor

Re: DB creation problem.


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.

Alexander M. Ermes
Honored Contributor

Re: DB creation problem.

Hi there.
In addition to Hein's posting pls check the owner and rights of the files and directories.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"