I would like to know how can i create RAC db manually on Linux. When i
am using dbca to create rac i am getting all kind of error like unable
to write to controlfile etc.
My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit

Thanks for your help.

"chan01" <chandra_2000_us@yahoo.com> wrote in message
news:480cb9d4.0404110856.5f3cf76@posting.google.co m...
> I would like to know how can i create RAC db manually on Linux. When i
> am using dbca to create rac i am getting all kind of error like unable
> to write to controlfile etc.
> My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
>
> Thanks for your help.

Go read the concepts about RAC on http://tahiti.oracle.com - sounds like you
need to

chan01 wrote:

> I would like to know how can i create RAC db manually on Linux. When i
> am using dbca to create rac i am getting all kind of error like unable
> to write to controlfile etc.
> My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
>
> Thanks for your help.

There is no problem doing this so you likely have not read the
documentation. DBCA works just fine.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

On 11 Apr 2004 09:56:04 -0700, chan01 <chandra_2000_us@yahoo.com> wrote:

> I would like to know how can i create RAC db manually on Linux. When i
> am using dbca to create rac i am getting all kind of error like unable
> to write to controlfile etc.
> My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
>
> Thanks for your help.

Well, you could use dbca to create just the scripts that create a
database, but not get it to actually create the database itself. Then you
can read those scripts in vi, and see what it does. But it doesn't
actually do very much more than create a perfectly normal database in a
perfectly normal manner. It adds an extra set of redo logs, true. It adds
an extra undo tablespace if you're using automatic undo, true. It has to
set some instance-specific parameters, such as instance name and instance
number, true. But it still looks remarkably like a single-instance create
database statement.

If you're interested specifically in what's needed, the article on Windows
laptop RAC (especially the last section) at www.dizwell.com goes through
it step by step.

But let's be blunt here: if DBCA is having problems, you're going to have
problems. You don't say much about your hardware setup -how many nodes,
what sort of interconnect, what sort of shared disk environment you have.
You don't report whether cluster tests work (can each node ping each other
node; can a node write to the shared disk, and have its work read by all
other nodes; and so on). You don't say how you have setup your shared disk
to house the eventual database: raw partitions? Cluster File System? So
because you don't say very much about all those rather important matters,
it's very difficult to offer you very much by way of help or advice.

But I will say that you need to fix the underlying problems before going
any further, because merely switching from dbca to manual database
creation isn't going to help.

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

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
================================================== =============
Starting ORACLE instance (normal)
Sun Apr 11 12:07:59 2004
Global Enqueue Service Resources = 64, pool = 1
Sun Apr 11 12:07:59 2004
Global Enqueue Service Enqueues = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 1 Senders 1
GES IPC: Buffers Receive 1000 Send 530 Reserve 300
GES IPC: Msg Size Regular 396 Batch 2048
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 150994944
large_pool_size = 33554432
java_pool_size = 16777216
control_files = /var/opt/oracle/oradata/orcl/control01.ctl,
/var/opt/oracle/oradata/orcl/control02.ctl,
/var/opt/oracle/oradata/orcl/control03.ctl
db_block_size = 8192
db_cache_size = 50331648
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
cluster_database_instances= 1
thread = 1
fast_start_mttr_target = 300
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
local_listener = LISTENER_ORCL1
remote_listener = LISTENERS_ORCL
hash_join_enabled = TRUE
background_dump_dest = /ora01/oracle/admin/orcl/bdump
user_dump_dest = /ora01/oracle/admin/orcl/udump
core_dump_dest = /ora01/oracle/admin/orcl/cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 60817408
Sun Apr 11 12:07:59 2004
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2 Version 1.0
PMON started with pid=2
DIAG started with pid=3
LMON started with pid=4
LMD0 started with pid=5
DBW0 started with pid=6
LGWR started with pid=7
CKPT started with pid=8
SMON started with pid=9
RECO started with pid=10
Sun Apr 11 12:08:02 2004
CREATE DATABASE orcl
MAXINSTANCES 32
MAXLOGHISTORY 0
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/var/opt/oracle/oradata/orcl/orcl/system01.dbf' SIZE 250M
REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'/var/opt/oracle/oradata/orcl/orcl/temp01.dbf' SIZE 40M REUSE
AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/var/opt/oracle/oradata/orcl/orcl/undotbs01.dbf' SIZE 20M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/var/opt/oracle/oradata/orcl/orcl/redo01.log') SIZE
5M REUSE,
GROUP 2 ('/var/opt/oracle/oradata/orcl/orcl/redo02.log') SIZE 5M REUSE
Sun Apr 11 12:08:02 2004
lmon registered with NM - instance id 1 (internal mem no 0)
Sun Apr 11 12:08:03 2004
Reconfiguration started
List of nodes: 0,
Global Resource Directory frozen
one node partition
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Resources and enqueues cleaned out
Resources remastered 0
set master node info
Submitted all remote-enqueue requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
0 GCS shadows traversed, 0 replayed, 0 unopened
Submitted all GCS remote-cache requests
Sun Apr 11 12:08:03 2004
Reconfiguration complete
Post SMON to start 1st pass IR
Sun Apr 11 12:08:24 2004
Database mounted in Exclusive Mode.
Sun Apr 11 12:08:35 2004
Successful mount of redo thread 1, with mount id 1051001763.
Assigning activation ID 1051001763 (0x3ea503a3)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0:
/var/opt/oracle/oradata/orcl/orcl/redo01.log
Successful open of redo thread 1.
Sun Apr 11 12:08:38 2004
SMON: enabling cache recovery
Sun Apr 11 12:08:38 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Sun Apr 11 12:08:38 2004
create tablespace SYSTEM datafile
'/var/opt/oracle/oradata/orcl/orcl/system01.dbf' SIZE 250M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Sun Apr 11 12:10:08 2004
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'
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2
Sun Apr 11 12:10:08 2004
Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2
Sun Apr 11 12:10:08 2004
CKPT: terminating instance due to error 221
Sun Apr 11 12:10:09 2004
System state dump is made for local instance
Sun Apr 11 12:10:09 2004
Trace dumping is performing id=[cdmp_20040411121009]
Sun Apr 11 12:10:13 2004
Instance terminated by CKPT, pid = 16649


================================================== =============


Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1081707695.164951@yasure>...
> chan01 wrote:
>
> > I would like to know how can i create RAC db manually on Linux. When i
> > am using dbca to create rac i am getting all kind of error like unable
> > to write to controlfile etc.
> > My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
> >
> > Thanks for your help.
>
> There is no problem doing this so you likely have not read the
> documentation. DBCA works just fine.

On 11 Apr 2004 15:20:37 -0700, chan01 <chandra_2000_us@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-
===========================================

Howard J. Rogers wrote:

>> 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.

I agree. In fact this is probably a good time to ask a few questions.

1. What hardware and operating system?
2. What is the shared storage?
3. What is providing the clustered file system or is this being done
with RAW?

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

First of all Thanks to all of you. I am sorry for the lake of
information and detail.

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. During trouble starting ocmstat.sh on
second node here is the output from cm.log file...
================================================== ======================
>TRACE: HandleJoin(): JOIN from node(1)->(1), tid =
ClusterListener:3076 file = nmlisten.c, line = 362 {Thu Apr 10
21:39:10 2003 }
>TRACE: HandleStatus(): node(0) UNKNOWN, tid = ClusterListener:3076
file = nmlisten.c, line = 404 {Thu Apr 10 21:39:11 2003 }
>TRACE: HandleStatus(): src[0] dest[1] dom[0] seq[33] sync[10], tid =
ClusterListener:3076 file = nmlisten.c, line = 415 {Thu Apr 10
21:39:11 2003 }
>TRACE: HandleSync(): src[0] dest[1] dom[0] seq[34] sync[10], tid =
ClusterListener:3076 file = nmlisten.c, line = 506 {Thu Apr 10
21:39:11 2003 }
>TRACE: SendAck(): node(0) domain(0) syncSeqNo(10) type(11), tid =
ClusterListener:3076 file = nmmember.c, line = 1913 {Thu Apr 10
21:39:11 2003 }
>TRACE: HandleVote(): src[0] dest[1] dom[0] seq[35] sync[10], tid =
ClusterListener:3076 file = nmlisten.c, line = 643 {Thu Apr 10
21:39:12 2003 }
>TRACE: SendVoteInfo(): node(0) domain(0) syncSeqNo(10), tid =
ClusterListener:3076 file = nmmember.c, line = 1727 {Thu Apr 10
21:39:12 2003 }
>TRACE: HandleShutdown(): src[0] dest[1] dom[0] seq[0] sync[10]
type[4], tid = ClusterListener:3076 file = nmlisten.c, line = 1087
{Thu Apr 10 21:39:13 2003 }
>TRACE: IncrementEventValue: *(80f2920) = (1, 1), tid =
ClusterListener:3076 file = unixinc.c, line = 253 {Thu Apr 10 21:39:13
2003 }
--- End Dump ---
oracm, version[ 9.2.0.2.0.47 ] started {Thu Apr 10 21:40:07 2003 }
KernelModuleName is hangcheck-timer {Thu Apr 10 21:40:07 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.50 (port 9998)
{Thu Apr 10 21:40:07 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.51 (port 9998)
{Thu Apr 10 21:40:07 2003 }
>WARNING: OemInit2: Opened
file(/var/opt/oracle/oradata/orcl/CMQuorumFile 8), tid = main:1024
file = oem.c, line = 491 {Thu Apr 10 21:40:07 2003 }
Debug Hang : ClusterListener (PID=2541) Registered withwatchdog
daemon. {Thu Apr 10 21:40:09 2003 }
InitializeCM: ModuleName = hangcheck-timer {Thu Apr 10 21:40:09 2003 }
InitializeCM: Kernel module hangcheck-timer is already loaded {Thu Apr
10 21:40:09 2003 }
Debug Hang : CmConnectListener (PID=2542):Registered with watchdog
daemon. {Thu Apr 10 21:40:09 2003 }
Debug Hang :StartNMMon (PID=2536) Registered with watchdog daemon.
{Thu Apr 10 21:40:09 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.51
{Thu Apr 10 21:40:09 2003 }
Debug Hang :PollingThread (PID=135159169): Registered with {Thu Apr 10
21:40:09 2003 }
Debug Hang : DiskPingThread (PID=135159169): Registered with {Thu Apr
10 21:40:09 2003 }
Debug Hang :SendingThread (PID=135159169): Registered with {Thu Apr 10
21:40:09 2003 }
--- DUMP GROUP STATE DB ---
--- END OF GROUP STATE DUMP ---
--- Begin Dump ---
>TRACE: LogListener: Spawned with tid 0x803., tid = 2051 file =
logging.c, line = 116 {Thu Apr 10 21:40:07 2003 }
oracm, version[ 9.2.0.2.0.47 ] started {Thu Apr 10 21:40:07 2003 }
>TRACE: Can't read registry value for WatchdogTimerMargin, tid =
main:1024 file = unixinc.c, line = 1011 {Thu Apr 10 21:40:07 2003 }
>TRACE: Can't read registry value for WatchdogSafetyMargin, tid =
main:1024 file = unixinc.c, line = 1011 {Thu Apr 10 21:40:07 2003 }
KernelModuleName is hangcheck-timer {Thu Apr 10 21:40:07 2003 }
>TRACE: Can't read registry value for ClientTimeout, tid = main:1024
file = unixinc.c, line = 1011 {Thu Apr 10 21:40:07 2003 }
>TRACE: InitNMInfo: setting clientTimeout to 215s based on MissCount
215 and PollInterval 1000ms, tid = main:1024 file = nmconfig.c, line =
137 {Thu Apr 10 21:40:07 2003 }
>TRACE: InitClusterDb(): getservbyname on CMSrvr failed - 22 :
assigning 9998, tid = main:1024 file = nmconfig.c, line = 212 {Thu Apr
10 21:40:07 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.50 (port 9998)
{Thu Apr 10 21:40:07 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.51 (port 9998)
{Thu Apr 10 21:40:07 2003 }
>TRACE: OemCreateListenPort: bound at 9998, tid = main:1024 file =
oem.c, line = 858 {Thu Apr 10 21:40:07 2003 }
>TRACE: InitClusterDb(): found my node info at 1 name rac2, priv
rac2priv, port 3623, tid = main:1024 file = nmconfig.c, line = 265
{Thu Apr 10 21:40:07 2003 }
>TRACE: InitClusterDb(): Local Node(1) NodeName[rac2], tid = main:1024
file = nmconfig.c, line = 283 {Thu Apr 10 21:40:07 2003 }
>TRACE: InitClusterDb(): Cluster(Oracle) with (2) Defined Nodes, tid =
main:1024 file = nmconfig.c, line = 286 {Thu Apr 10 21:40:07 2003 }
>TRACE: OEMInits(): CM Disk File
(/var/opt/oracle/oradata/orcl/CMQuorumFile), tid = main:1024 file =
oem.c, line = 243 {Thu Apr 10 21:40:07 2003 }
>WARNING: OemInit2: Opened
file(/var/opt/oracle/oradata/orcl/CMQuorumFile 8), tid = main:1024
file = oem.c, line = 491 {Thu Apr 10 21:40:07 2003 }
>TRACE: ReadOthersDskInfo(): node(0) rcfg(11) wrtcnt(1052) lastcnt(0)
alive(1052), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(1) rcfg(10) wrtcnt(2) lastcnt(0)
alive(1), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(2) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(3) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(4) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(5) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(6) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(7) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(8) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(9) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(10) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(11) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(12) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(13) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(14) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(15) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(16) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(17) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(18) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(19) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(20) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(21) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(22) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(23) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(24) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(25) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(26) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(27) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(28) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(29) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(30) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(31) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(32) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(33) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(34) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(35) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(36) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(37) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(38) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(39) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(40) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(41) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(42) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(43) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(44) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(45) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(46) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(47) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(48) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(49) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(50) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(51) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(52) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(53) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(54) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(55) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(56) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(57) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(58) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(59) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(60) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(61) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(62) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ReadOthersDskInfo(): node(63) rcfg(0) wrtcnt(0) lastcnt(0)
alive(0), tid = main:1024 file = oem.c, line = 1442 {Thu Apr 10
21:40:09 2003 }
>TRACE: ClusterListener: Spawned with tid 0xc04., tid = 3076 file =
nmlistener.c, line = 53 {Thu Apr 10 21:40:09 2003 }
Debug Hang : ClusterListener (PID=2541) Registered withwatchdog
daemon. {Thu Apr 10 21:40:09 2003 }
>TRACE: ClusterListener (pid=2541, tid=3076): Registered with watchdog
daemon., tid = 3076 file = nmlistener.c, line = 75 {Thu Apr 10
21:40:09 2003 }
InitializeCM: ModuleName = hangcheck-timer {Thu Apr 10 21:40:09 2003 }
InitializeCM: Kernel module hangcheck-timer is already loaded {Thu Apr
10 21:40:09 2003 }
>TRACE: CmConnectListener: Spawned with tid 0x1005., tid = 4101 file =
cmclient.c, line = 215 {Thu Apr 10 21:40:09 2003 }
Debug Hang : CmConnectListener (PID=2542):Registered with watchdog
daemon. {Thu Apr 10 21:40:09 2003 }
>TRACE: CmConnectListener (pid=2542, tid=4101): Registered with
watchdog daemon., tid = 4101 file = cmclient.c, line = 246 {Thu Apr 10
21:40:09 2003 }
Debug Hang :StartNMMon (PID=2536) Registered with watchdog daemon.
{Thu Apr 10 21:40:09 2003 }
>TRACE: StartNMMon (pid=2536, tid=1024): Registered with watchdog
daemon., tid = main:1024 file = cmnodemon.c, line = 251 {Thu Apr 10
21:40:09 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.51
{Thu Apr 10 21:40:09 2003 }
>TRACE: StartClusterJoin(): clusterState(0) nodeState(0), tid =
main:1024 file = nmmember.c, line = 277 {Thu Apr 10 21:40:09 2003 }
>TRACE: PollingThread: Spawned with tid 0x1406., tid = 5126 file =
nmmember.c, line = 742 {Thu Apr 10 21:40:09 2003 }
Debug Hang :PollingThread (PID=135159169): Registered with {Thu Apr 10
21:40:09 2003 }
>TRACE: PollingThread (pid=2543, tid=5126): Registered with watchdog
daemon., tid = 5126 file = nmmember.c, line = 760 {Thu Apr 10 21:40:09
2003 }
>TRACE: DiskPingThread: Spawned with tid 0x1807., tid = 6151 file =
nmmember.c, line = 1050 {Thu Apr 10 21:40:09 2003 }
Debug Hang : DiskPingThread (PID=135159169): Registered with {Thu Apr
10 21:40:09 2003 }
>TRACE: DiskPingThread (pid=2544, tid=6151): Registered with watchdog
daemon., tid = 6151 file = nmmember.c, line = 1074 {Thu Apr 10
21:40:09 2003 }
>TRACE: SendingThread: Spawned with tid 0x1c08, 0x0., tid = 7176 file
= nmmember.c, line = 511 {Thu Apr 10 21:40:09 2003 }
Debug Hang :SendingThread (PID=135159169): Registered with {Thu Apr 10
21:40:09 2003 }
>TRACE: SendingThread (pid=2545, tid=7176): Registered with watchdog
daemon., tid = 7176 file = nmmember.c, line = 576 {Thu Apr 10 21:40:09
2003 }
>TRACE: HandleJoin(): src[1] dest[1] dom[0] seq[1] sync[0], tid =
ClusterListener:3076 file = nmlisten.c, line = 346 {Thu Apr 10
21:40:09 2003 }
>TRACE: HandleJoin(): JOIN from node(1)->(1), tid =
ClusterListener:3076 file = nmlisten.c, line = 362 {Thu Apr 10
21:40:09 2003 }
>TRACE: HandleStatus(): node(0) UNKNOWN, tid = ClusterListener:3076
file = nmlisten.c, line = 404 {Thu Apr 10 21:40:10 2003 }
>TRACE: HandleStatus(): src[0] dest[1] dom[0] seq[36] sync[11], tid =
ClusterListener:3076 file = nmlisten.c, line = 415 {Thu Apr 10
21:40:10 2003 }
>TRACE: HandleSync(): src[0] dest[1] dom[0] seq[37] sync[11], tid =
ClusterListener:3076 file = nmlisten.c, line = 506 {Thu Apr 10
21:40:10 2003 }
>TRACE: SendAck(): node(0) domain(0) syncSeqNo(11) type(11), tid =
ClusterListener:3076 file = nmmember.c, line = 1913 {Thu Apr 10
21:40:10 2003 }
>TRACE: HandleVote(): src[0] dest[1] dom[0] seq[38] sync[11], tid =
ClusterListener:3076 file = nmlisten.c, line = 643 {Thu Apr 10
21:40:11 2003 }
>TRACE: SendVoteInfo(): node(0) domain(0) syncSeqNo(11), tid =
ClusterListener:3076 file = nmmember.c, line = 1727 {Thu Apr 10
21:40:11 2003 }
>TRACE: HandleShutdown(): src[0] dest[1] dom[0] seq[0] sync[11]
type[4], tid = ClusterListener:3076 file = nmlisten.c, line = 1087
{Thu Apr 10 21:40:12 2003 }
>TRACE: IncrementEventValue: *(80f2920) = (1, 1), tid =
ClusterListener:3076 file = unixinc.c, line = 253 {Thu Apr 10 21:40:12
2003 }
--- End Dump ---
================================================== ======================

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.

Again thanks for your information.







"Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<opr6a9n9hn3d8uqx@news.optusnet.com.au>...
> On 11 Apr 2004 09:56:04 -0700, chan01 <chandra_2000_us@yahoo.com> wrote:
>
> > I would like to know how can i create RAC db manually on Linux. When i
> > am using dbca to create rac i am getting all kind of error like unable
> > to write to controlfile etc.
> > My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
> >
> > Thanks for your help.
>
> Well, you could use dbca to create just the scripts that create a
> database, but not get it to actually create the database itself. Then you
> can read those scripts in vi, and see what it does. But it doesn't
> actually do very much more than create a perfectly normal database in a
> perfectly normal manner. It adds an extra set of redo logs, true. It adds
> an extra undo tablespace if you're using automatic undo, true. It has to
> set some instance-specific parameters, such as instance name and instance
> number, true. But it still looks remarkably like a single-instance create
> database statement.
>
> If you're interested specifically in what's needed, the article on Windows
> laptop RAC (especially the last section) at www.dizwell.com goes through
> it step by step.
>
> But let's be blunt here: if DBCA is having problems, you're going to have
> problems. You don't say much about your hardware setup -how many nodes,
> what sort of interconnect, what sort of shared disk environment you have.
> You don't report whether cluster tests work (can each node ping each other
> node; can a node write to the shared disk, and have its work read by all
> other nodes; and so on). You don't say how you have setup your shared disk
> to house the eventual database: raw partitions? Cluster File System? So
> because you don't say very much about all those rather important matters,
> it's very difficult to offer you very much by way of help or advice.
>
> But I will say that you need to fix the underlying problems before going
> any further, because merely switching from dbca to manual database
> creation isn't going to help.
>
> Regards
> HJR