Configuring Oracle8i Release 3 (8.1.7)

This article describes how to create the Oracle users required by WebSphere Application Server. These instructions assume that you have installed Oracle8i.

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

  1. Ensure that you are logged in as the user named oracle.
  2. Edit the initialization file $ORACLE_HOME/dbs/inityour_SID.ora, as follows:
    • Add the line open_cursors = 200
    • Ensure that the default value of 50 for the processes setting is sufficient for your database by reading the information included in the inityour_SID.ora file. To increase the value of this setting, comment or uncomment the appropriate lines in the file.
  3. Restart your Oracle database by using the startup command, as follows:
    $ svrmgrl
    SVRMGR> connect internal
    SVRMGR> startup
    SVRMGR> quit

    Note: You might need to stop the database before you are able to restart it. Stop the Oracle database by using the shutdown command, as follows:

    $ svrmgrl
    SVRMGR> connect internal
    SVRMGR> shutdown
    SVRMGR> quit
  4. Ensure that the Oracle listener process is started. If necessary, start the it by using the start command, as follows:
    $ lsnrctl
    LSNRCTL> start
    LSNRCTL> quit
  5. Create the Oracle users named EJSADMIN and EJB required by WebSphere Application Server. You might or might not want to grant user EJSADMIN dba authority. Create these users with the proper authorities, by entering the following set of commands using these values: SYSTEM is user account created by the Oracle Database Configuration Assistant; manager is the default password for the SYSTEM account; and the EJSADMIN_password is the password you specify for the user named EJSADMIN.
    • If you do want to grant dba authority to the user EJSADMIN, enter the following commands:
      $ 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, enter the following commands:
      $ 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
  6. If any of your applications use JTA datasources, enter the following commands using these values: SYS is user account created by the Oracle Database Configuration Assistant; change_on_install is the default password for the SYS account.
    $ sqlplus SYS/change_on_install
    SQL> grant select on dba_pending_transactions to EJB;
    SQL> quit
  7. 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 SQL> exit to log out as the EJSADMIN user.