Error while starting WebSphere Admin Server while creating the tables
Vinod
Env Solaris 2.8
When i start the adminserver i m get the following error message
*****************************************************************************
************* End Display Current Environment *************
[02.05.22 12:29:23:775 EDT] 3a5794 Server U Version : 4.0.1
[02.05.22 12:29:24:049 EDT] 3a5794 Server U Edition: Advanced
Edition for Multiplatforms
[02.05.22 12:29:24:058 EDT] 3a5794 Server U Build date: Thu
Aug 09 00:00:00 EDT 2001
[02.05.22 12:29:24:059 EDT] 3a5794 Server U Build number:
a0131.07
[02.05.22 12:29:28:872 EDT] 3a5794 ORBRas W
com.ibm.CORBA.iiop.Util Util P=965090:O=0:CT JORB0012: Pass by
reference has been set to: true (NoLocalCopies = true)
[02.05.22 12:29:49:265 EDT] 3a5794 DBMgr F SMTL0026E:
Failure to create a data source: java.sql.SQLException: ORA-00903:
invalid table name
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.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1610)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1535)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2053)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:760)
at com.ibm.ejs.cm.portability.PortabilityLayerImpl.createTable(PortabilityLayerImpl.java:234)
at com.ibm.ejs.cm.pool.ConnectO.createTable(ConnectO.java:1897)
at com.ibm.ejs.cm.proxy.ConnectionProxy.createTable(ConnectionProxy.java:170)
at com.ibm.ejs.cm.lock.TableLockLock.<init>(TableLockLock.java:40)
at com.ibm.ejs.cm.portability.OraclePortabilityLayer.createLock(OraclePortabilityLayer.java:243)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:212)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1135)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:943)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
java.lang.Throwable
at com.ibm.ejs.ras.TraceLogger.fatalEvent(TraceLogger.java:219)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1402)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1346)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:854)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:220)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1135)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:943)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
*****************************************************************************
Dont why its not able to create the data source. Admin.config is
having all the required enteries for the db variables
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=oracle.jdbc.pool.OracleConnectionPoolDataSource
com.ibm.ejs.sm.adminServer.dbserverName=servername_val
com.ibm.ejs.sm.adminServer.dbportNumber=port_val
com.ibm.ejs.sm.adminServer.dbdatabaseName=sid_val
com.ibm.ejs.sm.adminServer.dbuser=username_val
com.ibm.ejs.sm.adminServer.dbpassword={xor}KD4sazs6KQ==
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
# URL is only valid for Oracle
com.ibm.ejs.sm.adminServer.dbURL=jdbc:oracle:thin:@servername_val:port_val:sid_val
any clues y this error
Thanks
Vinod