Configuring Oracle 8i Release 2 (8.1.6) for use with WebSphere Application Server

Perform the following steps to configure Oracle 8i for use with WebSphere Application Server:

  1. Ensure that you are logged in as the user oracle.
  2. Edit the initialization file $ORACLE_HOME/dbs/init<your_SID>.ora so it includes the following line: open_cursors = 200

    You might also need to set processes to more than the default (50), for example:

    processes = 100
  3. Restart your Oracle database. You can start the database by entering the commands: $ svrmgrl SVRMGR> connect internal SVRMGR> startup

    If you need to stop the database, use the commands:

    $ svrmgrl SVRMGR> connect internal SVRMGR> shutdown
  4. Start the Oracle listener. At a command line, enter the following commands:
    $ lsnrct 
    LSNRCTL> start
  5. You must create the EJSADMIN Oracle user required by WebSphere Application Server and grant this user dba authority. To do this, enter the following set of commands using these values: the system variable is the user ID; the manager variable is the default password; and the EJSADMIN_password is the password you assign to user EJSADMIN.

    $ sqlplus system/manager 
    SQL> create user EJSADMIN identified by EJSADMIN_password;
    SQL> grant connect, resource, dba to EJSADMIN;
    SQL> quit
  6. Test access to the new database with the EJSADMIN user ID by doing the following:
    1. Enter the command $ sqlplus ejsadmin/EJSADMIN_password. A message is displayed indicating a successful connection.
    2. Enter the command $ exit to log out as the EJSADMIN user.