Hello all...
I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
- sqlplus, create database --
SQL> onnect / as sysdba;
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 135336428 bytes
Fixed Size 451052 bytes
Variable Size 96468992 bytes
Database Buffers 37748736 bytes
Redo Buffers 667648 bytes
SQL> create database EASTWEST
maxinstances 5
maxlogfiles 10
character set "we8iso8859p1"
datafile '/ocfs/oradata/EASTWEST/sysEASTWEST01.dbf' size 500m reuse
default temporary tablespace tempts tempfile
'/ocfs/oradata/EASTWEST/tmpEASTWEST01.dbf'
size 50m reuse
undo tablespace UNDO_WEST datafile
'/ocfs/oradata/EASTWEST/undEASTWEST01.dbf' size 50m reuse
logfile
'/ocfs/oradata/EASTWEST/logEASTWEST01a.dbf' size 25m
reuse,
'/ocfs/oradata/EASTWEST/logEASTWEST01b.dbf' size 25m
reuse;
2 3 4 5 6 7 8 9 10 11 create database EASTWEST
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-29702: error occurred in Cluster Group Service operation
- cm.log output --
oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:39:05 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998)
{Wed Jan 8 02:39:05 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998)
{Wed Jan 8 02:39:05 2003 }
>WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192
file = oem.c, line = 491 {Wed Jan 8 02:39:05 2003 }
InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:39:05 2003 }
InitializeCM: Kernel module iofence-timer is not loaded, try to
load(/sbin/insmod iofence-timer) {Wed Jan 8 02:39:05 2003 }
ClusterListener (pid=13717, tid=24580): Registered with watchdog daemon.
{Wed Jan 8 02:39:05 2003 }
>WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded,
please check if the module is in system lib path., tid = main:8192 file =
cmstartup.c, line = 311 {Wed Jan 8 02:39:08 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.9
{Wed Jan 8 02:39:08 2003 }
NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:13 2003
}
HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:39:15 2003 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:39:15
2003 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:15
2003 }
Successful reconfiguration, 1 active node(s) node 0 is the master, my
node num is 0 (reconfig 1) {Wed Jan 8 02:39:15 2003 }
oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:44:00 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998)
{Wed Jan 8 02:44:00 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998)
{Wed Jan 8 02:44:00 2003 }
>WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192
file = oem.c, line = 491 {Wed Jan 8 02:44:00 2003 }
InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:44:00 2003 }
InitializeCM: Kernel module iofence-timer is not loaded, try to
load(/sbin/insmod iofence-timer) {Wed Jan 8 02:44:00 2003 }
ClusterListener (pid=13800, tid=24580): Registered with watchdog daemon.
{Wed Jan 8 02:44:00 2003 }
>WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded,
please check if the module is in system lib path., tid = main:8192 file =
cmstartup.c, line = 311 {Wed Jan 8 02:44:00 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.9
{Wed Jan 8 02:44:00 2003 }
NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:05 2003
}
HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:44:07 2003 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:44:07
2003 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:07
2003 }
Successful reconfiguration, 1 active node(s) node 0 is the master, my
node num is 0 (reconfig 1) {Wed Jan 8 02:44:07 2003 }
>WARNING: ReadCommPort: received error=104 on recv()., tid =
ClientProcListener:81929 file = unixinc.c, line = 762 {Wed Jan 8 02:45:16
2003 }
>WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:90121 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16
2003 }
>WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:98313 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16
2003 }
>WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:106505 file = unixinc.c, line = 754 {Wed Jan 8
02:45:16 2003 }
- cmcfg.ora --
HeartBeat=10000
ClusterName=Oracle Cluster Manager, version 9i
PollInterval=300
PrivateNodeNames=zenith utopia
PublicNodeNames=zenith utopia
ServicePort=9998
HostName=zenith
CmDiskFile=/ocfs/oradata/foo
- ocmargs.ora --
oracm /a:0
norestart 1800
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: From
INET: l-oracle_at_hypno.iheavy.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 09 2003 - 17:19:46 CST