fresh installation of 1.0.2 fails

[Radha]

here is an error that i encounter during a fresh installation of 1.0.2. I will really appreciate any inputs from anyone.

2005-07-15 16:33:55,245 [ main] ERROR rdbms.RDBMSEngine - select t0.id as "id",
       t0.name as "name"
from vcx_event_types t0
where t0.id = ?
java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1826)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446)
        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:490)
        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:433)
        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:267)
        at com.redhat.persistence.Cursor.execute(Cursor.java:134)
        at com.redhat.persistence.Cursor.next(Cursor.java:118)
        at com.redhat.persistence.Session.retrieve(Session.java:126)
        at com.arsdigita.persistence.Session.retrieve(Session.java:346)
        at com.arsdigita.versioning.EventType.getDataObject(EventType.java:81)
        at com.arsdigita.versioning.EventType.initialize(EventType.java:75)
        at com.arsdigita.versioning.Initializer.startup(Initializer.java:49)
        at com.arsdigita.initializer.Script.startup(Script.java:234)
        at com.arsdigita.initializer.Script.startup(Script.java:205)
        at com.arsdigita.runtime.LegacyInitializer.init(LegacyInitializer.java:138)
        at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
        at com.arsdigita.core.Initializer.init(Initializer.java:155)
        at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
        at com.arsdigita.runtime.Startup.run(Startup.java:246)
        at com.arsdigita.packaging.Loader.loadData(Loader.java:129)
        at com.arsdigita.packaging.Load.run(Load.java:366)
        at com.arsdigita.packaging.MasterTool.main(MasterTool.java:96)
2005-07-15 16:33:55,257 [ main] ERROR rdbms.RDBMSEngine - [1]
2005-07-15 16:33:55,261 [ main] ERROR rdbms.RDBMSEngine - [NUMERIC]
2005-07-15 16:33:55,262 [ main] ERROR rdbms.RDBMSEngine - {}
com.redhat.persistence.engine.rdbms.RDBMSEngine$4: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [],
[], [], []

        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:516)
        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:433)
        at com.redhat.persistence.engine.rdbms.RDBMSEngine.execute(RDBMSEngine.java:267)
        at com.redhat.persistence.Cursor.execute(Cursor.java:134)
        at com.redhat.persistence.Cursor.next(Cursor.java:118)
        at com.redhat.persistence.Session.retrieve(Session.java:126)
        at com.arsdigita.persistence.Session.retrieve(Session.java:346)
        at com.arsdigita.versioning.EventType.getDataObject(EventType.java:81)
        at com.arsdigita.versioning.EventType.initialize(EventType.java:75)
        at com.arsdigita.versioning.Initializer.startup(Initializer.java:49)
        at com.arsdigita.initializer.Script.startup(Script.java:234)
        at com.arsdigita.initializer.Script.startup(Script.java:205)
        at com.arsdigita.runtime.LegacyInitializer.init(LegacyInitializer.java:138)
        at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
        at com.arsdigita.core.Initializer.init(Initializer.java:155)
        at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
        at com.arsdigita.runtime.Startup.run(Startup.java:246)
        at com.arsdigita.packaging.Loader.loadData(Loader.java:129)
        at com.arsdigita.packaging.Load.run(Load.java:366)
        at com.arsdigita.packaging.MasterTool.main(MasterTool.java:96)

[bobhilton]

I think I also had that error at some point.

Did you run

ccm hostinit-bundle --name aplaws-plus-standard -container=tomcat --parameter http-port=8080 --parameter shutdown-port=8081

After running:

ccm load-bundle --interactive --name aplaws-plus-standard

Hope it helps.

[Radha]

No, actually i just added 1 statement in the end of the oracle-se-create.sql file. and everything worked fine.
This statement is:

commit;

somehow the insert statements had put in the data in the tables but transactions were not getting committed..

at some point when the initializers start to run (in the same session) especially the com.arsdigita.versioning.Initializer, some data is read from the tables and this was blowing up as the data was not comitted into the tables.

After making the change to the file oracle-se-create.sql , i had to recreate the ccm-core-6.1.1-sql.jar file.

[Alan Pevec]

Radha,
ORA-00600 means you hit either Oracle bug or corrupted datastructure. Also, commit is implict after DDL statements, it is not clear why commit at the end helped you.
Please detail your Oracle DB and JDBC versions and platforms you are running on.