Integration

Good morning
This is an odd error. I am installing a brand new environment for SOA-SUITE 11g on a test database before going through the pain to complete this in our development environment. I am using RCU to build the environment as instructed and am allowing RCU to handle everything but constructing the schemas. I have created the schemas manually via SQL*Plus.

This process has worked in the past so I'm at a loss for explaining these errors. In creating the SOAINFRA, I am receving the following errors:

ORA-60019: Creating initial extent of size 14 in tablespace of extent size 13
ORA-06512: at "SYS.DBMS_AQADM", line 81
ORA-06512: at line 2

JDBC SQLException handled by error handler


2012-06-08 09:09:30.929 rcu:Extracting Statement from File Name: 'D:\rcuHome\rcu\integration\soainfra\sql\fabric\createschema_edndb_oracle.sql'Line Number: 157
2012-06-08 09:09:30.929 rcu:Extracted SQL Statement: [begin
DBMS_AQADM.create_queue_table(queue_table=>'edn_oaoo_delivery_table', queue_payload_type=>'edn_oaoo_delivery',
multiple_consumers=>TRUE);
DBMS_AQADM.create_queue(queue_name=>'edn_oaoo_queue', queue_table=>'edn_oaoo_delivery_table');
DBMS_AQADM.start_queue(queue_name=>'edn_oaoo_queue');
end;
]
2012-06-08 09:09:30.929 rcu:Statement Type: 'BEGIN/END Anonymous Block'
JDBC SQLException - ErrorCode: 60019SQLState:99999 Message: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 13
ORA-06512: at "SYS.DBMS_AQADM", line 81
ORA-06512: at line 2

JDBC SQLException handled by error handler


2012-06-08 09:09:35.547 rcu:Extracting Statement from File Name: 'D:\rcuHome\rcu\integration\soainfra\sql\fabric\createschema_edndb_oracle.sql'Line Number: 167
2012-06-08 09:09:35.547 rcu:Extracted SQL Statement: [declare
sub sys.aq$_agent;
begin
sub := sys.aq$_agent('edn_java_subscriber', NULL, NULL);
DBMS_AQADM.add_subscriber(queue_name=>'edn_event_queue', subscriber=>sub);
end;
]
2012-06-08 09:09:35.547 rcu:Statement Type: 'BEGIN/END Anonymous Block'
JDBC SQLException - ErrorCode: 24010SQLState:99999 Message: ORA-24010: QUEUE EDN_EVENT_QUEUE does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6268
ORA-06512: at "SYS.DBMS_AQADM", line 364
ORA-06512: at line 5

JDBC SQLException handled by error handler


2012-06-08 09:09:35.781 rcu:Extracting Statement from File Name: 'D:\rcuHome\rcu\integration\soainfra\sql\fabric\createschema_edndb_oracle.sql'Line Number: 174
2012-06-08 09:09:35.781 rcu:Extracted SQL Statement: [declare
sub sys.aq$_agent;
begin
sub := sys.aq$_agent('edn_oaoo_subscriber', NULL, NULL);
DBMS_AQADM.add_subscriber(queue_name=>'edn_oaoo_queue', subscriber=>sub);
end;
]
2012-06-08 09:09:35.781 rcu:Statement Type: 'BEGIN/END Anonymous Block'
JDBC SQLException - ErrorCode: 24010SQLState:99999 Message: ORA-24010: QUEUE EDN_OAOO_QUEUE does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6268
ORA-06512: at "SYS.DBMS_AQADM", line 364
ORA-06512: at line 5

JDBC SQLException handled by error handler

Now, I thought this was a tablespace space issue but here is a report on the status of all tablespaces.

Free Space Layout

Total Max Total
Number Free Free Available
Tablespace of Space Space Space Percent
Name Fragments (Meg) (Meg) (Meg) Free
------------------------------ --------- -------- -------- --------- --------
EXAMPLE 3 36 33 346 10.271
SOA_SUITE_DATA_01 1 101 101 101 99.853
SOA_SUITE_DATA_02 1 101 101 101 99.853
SYSAUX 114 560 500 1,161 48.272
SYSTEM 2 503 499 1,241 40.532
UNDOTBS1 18 40 21 105 37.917
USERS 2 101 100 106 95.224
--------- -------- ---------

I even granted RESOURCE in case the tool needed UNLIMITED TABLESPACE.

Does anyone have any ideas here? Any help would be greatly appreciated

Stephen Karniotis