10g/AIX: cluster schema creation problem

From: Alvaro Fuentes <alvarof2_at_hotmail.com>
Date: Thu, 08 Jul 2004 20:58:46 -0500
Message-ID: <ccktng$kii$1@ausnews.austin.ibm.com>

Fellow Oracle Users:

I am running Oracle10g Server on AIX 5.2.

I can create other schemas, including large tables, AND clusters, but when I tried to create the following cluster (also a user other than sys and system), it failed with the following:

"....Connected to:
Oracle Database 10g Release 10.1.0.2.0 - 64bit Production

Elapsed: 00:00:00.00
SQL>
SQL> create cluster mycluster (

   2    c_id number
   3  , c_d_id number
   4  , c_w_id number

   5 )
   6 single table
   7 hashkeys 3000000
   8 hash is ( (c_id * ( 100 * 10 ) + c_w_id * 10 + c_d_id) )    9 size 350
  10 pctfree 0 initrans 3
  11 storage ( buffer_pool recycle ) parallel ( degree 4 )   12 tablespace my_tablespace;
create cluster mycluster (
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel"

(Obviously tablespace "my_tablespace" is there in a filesystem with permissons 755 for oracle:dba)
Now, I search (OTN, Google, etc, etc) for ORA-03113 and I verified that the listener was running, since I could create right before this cluster other tables and clusters successfully.

Any ideas/advice what I am missing?

Thanks in advance,

Fuentes 512-297-9937

Received on Thu Jul 08 2004 - 20:58:46 CDT