1 Reply Latest reply on Apr 26, 2012 10:09 AM by Bill Robinson

    Oracle Schema Error : CREATE TABLE as_time_zone

    Erez Frenkel

      Hello,

      I try to create the DB schema for Bladelogic 8.2 on Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit, (Linux Machine)

       

      I run the script according to page 328 (bsa82_online_doc_export.pdf): SQL> start <master_script.sql> <BL_DATA> <BL_INDEX>

      Until that step everything completed successfully, but when we run the command: start master_script.sql, we receive an error from one table, others tables were created successfully

       

      The error :

      CREATE TABLE as_time_zone(

      *

      ERROR at line 1:

      ORA-03135: connection lost contact

      Process ID: 15586

      Session ID: 204 Serial number: 5665

       

      We try to run the create table manually, but the same error occur again and again, with any other create table - it immediately completed successfully,
      We also tried to create the table on other Oracle installations (older versions) but still the same error

       

      Does anyone has saw that problem before?

       

      Thanks a lot,

       

      Erez

       

      I attached the output from the command:

       

      Table created.

       

       

      Table created.

       

       

      Table created.

       

       

      Table created.

       

       

      Table created.

       

       

      Table created.

       

       

      Table created.

       

      CREATE TABLE as_time_zone(

      *

      ERROR at line 1:

      ORA-03135: connection lost contact

      Process ID: 15586

      Session ID: 204 Serial number: 5665

       

       

      ERROR:

      ORA-03114: not connected to ORACLE

       

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, Automatic Storage Management, OLAP, Data Mining

      and Real Application Testing options