Installing Oracle 8i Release 3 and creating a database

These steps cover how to install Oracle 8i Release 3 (Oracle 8.1.7), then create and configure a database.

Installing Oracle 8i

This section briefly describes how to install Oracle 8i. For detailed information on installation, see the Oracle documentation and the Oracle Web site.

To install Oracle 8i:

  1. Insert the Oracle CD into your machine's CD drive.
  2. On the main Oracle dialog, select Install/Deinstall Products.
  3. On the Welcome dialog, select Next.
  4. On the File Locations dialog, verify the destination for Oracle 8i and click Next.
  5. On the Available Products dialog, select Oracle8i Enterprise Edition 8.1.7.0.0 and click Next.
  6. On the Installation Types dialog, select Typical and then Next.
  7. On the Database Identification dialog, for Global Database Name type in orcl.hostname and then select Next.
  8. On the Summary dialog, select Install.
  9. After installation, on the Oracle Database Configuration Assistant dialog, click OK.
  10. On the End of Installation dialog, click Exit.

Completing the above steps installs the Oracle 8i code and creates a global database named orcl.hostname.database_domain.

Configuring an Oracle 8i database

To use an Oracle database with WebSphere Application Server, you must configure the database:

  1. Add the following line to the initialization file: open_cursors = 220

    On Windows NT or 2000, the initialization file is typically located at \Oracle\Ora81\database\Initxxx.ora, where xxx is your SID (example, orcl).

  2. Using a Services panel, stop and restart the Oracle services OracleServiceORCL and OracleOraHome81TNSListener.
  3. Define a WebSphere administration ID with database authority by creating the Oracle user EJSADMIN using the commands below. For the values needed in the first command, enter system as the ID and manager as the default password. As to the second command, EJSADMIN_password is the password for EJSADMIN.
    sqlplus system/manager
    create user EJSADMIN identified by EJSADMIN_password;
    grant connect,resource,dba to EJSADMIN;
    quit

    If you are using EJB functionality or will use the WebSphere Application Server samples, define an ID for use in deploying entity beans. As to the second command, EJB_password is the password for EJB.

    sqlplus system/manager
    create user EJB identified by EJB_password;
    grant connect,resource,dba to EJB;
    quit
  4. Test access to the new database using the EJSADMIN user ID: sqlplus ejsadmin/ejsadmin

    After a message displays indicating a successful connection, enter exit