Re: Create RAC database manually on Linux

On 11 Apr 2004 15:20:37 -0700, chan01 <chandra_2000_us_at_yahoo.com> wrote:

> Thank you for your advise, yes may be i need to go through the docs
> once again. I am trying to create rac instance using dbca but i got
> struck up with problem like unable to access control file. Do you have
> any idea why i am getting this proble. my alert.log file is

> CREATE DATABASE orcl
> MAXINSTANCES 32
> MAXLOGHISTORY 0
In the first place, I warn you now that this setting for MAXLOGHISTORY is an absolute disaster in the making. It will mean that database recoveries on the RAC will become a matter of pure guesswork. It happens to be one of DBCA's worst defaults, and you need to correct it (it's on the penultimate page, where you see the details of the tablespaces, datafiles and redo logs the assistant is going to create for you. Click on the Control Files branch of the tree, and hunt around a bit, and you'll see it there. Again, documented on my website).

> MAXLOGFILES 192
> MAXLOGMEMBERS 3
> MAXDATAFILES 1024
> DATAFILE '/var/opt/oracle/oradata/orcl/orcl/system01.dbf' SIZE 250M

That doesn't sound very plausible, does it? Is /var/opt/oracle/oradata on the shared disk? Sounds more like a normal file system to me. Which means I have no confidence that you are actually trying to create a RAC database properly.

> REUSE AUTOEXTEND ON
Autoextend on is also a hint that you are creating this file on a regular file system, and not using raw devices. It could be that you're using a cluster file system, I suppose. But the path still makes me believe that's not the case.

[snip]

> Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
> ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'

Well, this sounds like a permissions problem. Or a location problem.

What is the setting for CONTROL_FILES in either your spfile or your init.ora? Does it point precisely to /var/opt/oracle/oradata/.....?

And if that's the case, did you chown the oradata directory as part of your pre-installation setup to make the Oracle User the owner of the installation directory?

Let me put it this way, the Assistant by default will create databases, if memory serves, in ORACLE_BASE/oradata. And ORACLE_BASE is set up when *installing* Oracle, and needs to be owned by the Oracle User who is created to perform the installation.

/var/opt/oracle does not sound like a viable ORACLE_BASE to me. I doubt it will be owned by the Oracle User, and I have a sneaking suspicion you might have installed Oracle as root... I hope you didn't.

I think you need to take a deep breath, and review the www.dizwell.com installation of 9i on Advanced Server 2.1 insructions. That's just to get a working single-instance install.

Then you need to think carefully about whether this server is truly part of a cluster, and where your shared hard disk is, and whether you have a cluster file system, or are using raw partitions. And then you need to make sure the CFS is working, or whether you have created the raw partitions appropriately.

And only when you've done all of that does it make much sense to re-send your original question as though we can magically make happen something for which, apparently, none of the required preparation work has been done properly.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================