Problem starting Application Server 3.5

[luthriaajay]

I have installed Websphere version 3.5 on Solaris 8.


When I try to invoke the Application server by :

./startupServer.sh

I get the following message:

InstantDB - Version 3.13
Copyright (c) 1997-2000 Instant Computer Solutions Ltd.
[02.03.27 13:45:01:264 GMT+00:00] 1c90489 DrAdminServer A DrAdmin available on p
ort 35,275
[02.03.27 13:45:01:248 GMT+00:00] 4d266 AdminServer A Initializing WebSphere A
dministration server
InstantDB - Version 3.13
Copyright (c) 1997-2000 Instant Computer Solutions Ltd.
[02.03.27 13:45:31:138 GMT+00:00] 3eaf33 CreateNsTable W Failed to create tables
java.sql.SQLException
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:82)
at jdbc.idbConnection.<init>(idbConnection)
at jdbc.idbDriver.connect(idbDriver)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xCo
nnectionFactory.java:19)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.ja
va:635)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(Compiled
Code)
@
&quot;tracefile&quot; 4038 lines, 262975 characters

Please can any one tell me whats the problem?

ajayluthria@hotmail.com

 

[Einstein47]

What DB engine are you using as your repository? Did you create the WAS DB when you installed?

Although the WebSphere documentation says that it creates the WebSphere tables, my experience has been that you need to physically create the WAS database.

I am using DB2, and it requires several users to be created, an instance to be created, and then the database to be defined, and finally some sizing of the database parameters. All this before installing WebSphere to build the correct admin tables. (your milage may vary, see dealer for details)

Of course, all this is moot if you have already do these steps and you are still getting the &quot;Failed to create tables&quot; message. Einstein47
(Love is like PI - natural, irrational, endless, and very important.)

 

[luthriaajay]

Hello,

I am using Oracle 8i as the Database Engine.

How do you propose I create a WAS Database.?
I dont have any manuals at all for any help.

The configuration is: Solaris 8 - IBM WebApplication Server with IBM HTTP Server.

The documentation what i have is from the Net and it tells the steps to run the application server with
./startupServer.sh

We have created the Oracle Instance and created 2 users as defined by this document downloaded.

Please suggest

 

[Einstein47]

I know that you need to modify the admin.config file to instruct WebSphere which DB to use, where it is located, the correct username/password, and any other info. These things are prompted during the WebSphere install (or at least they should have been).

Please look in your admin.config and list the appropriate lines here. (you should replace the acutal username and password with #### for security sake).

Have you read this document:

http://www-3.ibm.com/software/webse...infocenter/was/pdf/solaris_adv_ihs_oracle.pdf

Hope this helps, Einstein47
(Love is like PI - natural, irrational, endless, and very important.)

 

[luthriaajay]

Hello,

Thank you very much.
I am presently modifying the admin.config file
But where shud I give the db INSTANCE NAME PLEASE?
There is a file called intial_setup.config in the properties directory.Do I need to change this?


Do guide as this is my 3rd day trying to configure this.

ajayluthria@hotmail.com

 

[luthriaajay]

The 'tracefile' logs under WAS_HOME/logs show:

ie : tail -f tracefile

at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at com.ibm.ejs.ras.CBuffLogger.fatalEvent(Compiled Code)
at com.ibm.ejs.ras.Tr.fireTraceEvent(Compiled Code)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:859)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:192)
at com.ibm.ejs.sm.server.AdminServer.startConnectionMgr(AdminServer.java

at com.ibm.ejs.sm.server.AdminServer.initializeRuntime(AdminServer.java:

at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:353)

I guess this shud show : open for e-business if all is right

 

[Einstein47]

The lines you need to be concerned with are:

com.ibm.ejs.sm.adminServer.dbUser=####
com.ibm.ejs.sm.adminServer.dbDriver=COM.ibm.db2.jdbc.app.DB2Driver
com.ibm.ejs.sm.adminServer.dbUrl=jdbc\:db2\:WAS
com.ibm.ejs.sm.adminServer.dbPassword=####

The dbUser and dbPassword should be obvious. The dbDriver needs to be the java reference for Oracle. The dbUrl is a reference to the database that you will hold your WebSphere configuration data.

I didn't create any of these lines, the installer did this for me. Look in your admin.config file for similar lines and post their values here.
Einstein47
(Love is like PI - natural, irrational, endless, and very important.)