ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 14 Apr 2004 20:32:14 -0700
Message-ID: <480cb9d4.0404141932.56db6822@posting.google.com>

I am getting this error during RAC DB creation db using dbca.

My RAC History:
Hardware:
1. Compaq DL350 Serves with SCSI harddrives. 2. External Disk Encloser Fire WireDrive (StarTech 4 Port IEEE-1394 PCI Firewire Card).

Software:

1. RedHat AS2.1 (Kernal 2.4.20-18.10.1)
2. OCFS (ocfs-2.4.9-e-1.0.9-9.i686.rpm, ocfs-tools-1.0.9-9.i686.rpm,
ocfs-support-1.0.9-9.i686.rpm)

3. Oracle v9.2.0.4

Reference Doc:
Installing Oracle 9i Real Application Cluster (RAC) on Red Hat Linux Advanced Server 2.1 by Werner's Oracle.

I am following Mr.Werner's Document to create 2 node RAC using Redhat 2.1AS + OCFS using Firewire drive. I can able to ping each node and communicating each other. I installed and comfigured ocfs and it is working fine. I installed cluster manager, some times starting ocmstat.sh is giving me lot of trouble on 2nd node but some times its start first time on both nodes.

My shared drive path is "/var/opt/oracle/oradata/orcl" and i modify file permissions to 777 and oracle owner for oracle, oradata and orcl directorys. I checked this filesystem and i found /var/opt/oracle/oradata/orcl/orcl/control01.ctl, control02.ctl, control03.ctl files were exist durint the dbca error generation time.  

My initorcl.ora file has got the same path ("/var/opt/oracle/oradata/orcl") for all my data, temp, index, undo, tools, system, control, redolog files and I saw these tablespaces creating during dbca creation db process.

I will check what every you pointed out in my configuration.

Thanks. Received on Wed Apr 14 2004 - 22:32:14 CDT