Configuring Oracle 8i Release 3 (8.1.7) for use with WebSphere Application Server

This article describes how to create the Oracle user or users required by WebSphere Application Server. The procedures in this article assume that you have installed Oracle8i.

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/inityour_SID.ora as follows:
  3. Restart your Oracle database. Start the database by entering the following commands: $ svrmgrl SVRMGR> connect internal SVRMGR> startup

    You can need to stop the database before restarting it. To stop the database, enter the following commands:

    $ svrmgrl SVRMGR> connect internal SVRMGR> shutdown
  4. Ensure that the Oracle listener is started or start it by entering the following commands:
    $ lsnrctl
    LSNRCTL> start
  5. You must create the Oracle user EJSADMIN required by WebSphere Application Server. You might or might not want to grant this user dba authority. You must also create an Oracle user EJB and grant this user authority.

    If you do want to grant dba authority to the user EJSADMIN, enter the following 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> create user EJB identified by EJB; 
    SQL> grant connect, resource to EJB; 
    SQL> quit

    If you do not want to grant dba authority to the user EJSADMIN, perform the following two steps:

    1. Enter the following 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 quota 100M
       on SYSTEM;
      SQL> create user EJB identified by EJB quota 100M on USERS; 
      SQL> grant connect, resource to EJSADMIN; 
      SQL> grant connect, resource to EJB; 
      SQL> quit

    2. When you later start the WebSphere Administrative Console, you must edit the data source for the HitCount bean. Do this by selecting Default Server, Default Container, HitCount Bean, and DataSource so the User ID and Password are set to EJB. Then click Apply.
  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 opens indicating a successful connection.
    2. Enter the command $ exit to log out as the EJSADMIN user.