weblogic.store.io.jdbc.JDBCStoreException: [Store:280065] (Doc ID 1395613.1)

Last updated on AUGUST 18, 2023

Applies to:

Symptoms

Customers report being unable to start the server. The following error is received:

<Jan 6, 2012 1:20:21 PM EST> <Error> <Store> <BEA-280072> <JDBC store "p13nJMSPersistenceStore_auto_1" failed to open table "qa-_1WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280065][Store:280068]JDBC store failed to initialize. It did not find its database table and failed trying to create a new empty table using the commands in file "/weblogic/store/io/jdbc/ddl/oracle.ddl". (server="<SERVERNAME1>" store="p13nJMSPersistenceStore_auto_1" table="qa-_1WLStore")Linked Cause, "java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option")
at weblogic.store.io.jdbc.JDBCStoreIO.createTable(JDBCStoreIO.java:609)
at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:346)
at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:332)
at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:323)
at weblogic.store.admin.AdminHandler.activate(AdminHandler.java:135)
Truncated. see log file for complete stacktrace

Changes

Following is configuration snippet in config.xml:

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.