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:
- Insert the Oracle CD into your machine's CD drive.
- On the main Oracle dialog, select Install/Deinstall Products.
- On the Welcome dialog, select Next.
- On the File Locations dialog, verify the destination for Oracle 8i and
click Next.
- On the Available Products dialog, select
Oracle8i Enterprise Edition 8.1.7.0.0
and click Next.
- On the Installation Types dialog, select Typical and then Next.
- On the Database Identification dialog, for Global Database Name type in
orcl.hostname and then select Next.
- On the Summary dialog, select Install.
- After installation, on the Oracle Database Configuration Assistant dialog, click
OK.
- 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:
- 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).
- Using a Services panel, stop and restart the Oracle services OracleServiceORCL
and OracleOraHome81TNSListener.
- 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
If you are using the Advanced Edition and do not want EJSADMIN to have
dba authority, do not enter the commands above but, instead, complete the
following two steps.
- Enter the commands:
sqlplus system/manager
create user EJSADMIN identified by EJSADMIN_password quota 100M on SYSTEM;
grant connect,resource to EJSADMIN;
create user EJB identified by EJB_password quota 100M on USERS;
grant connect,resource to EJB;
quit
- After you later start the WebSphere Admininstrative Console,
edit the data source for the HitCount bean (select Default Server,
Default Container, HitCount Bean, and DataSource) so
the User ID and Password are set to
EJB and then click
Apply.
- Test access to the new database using the EJSADMIN user ID:
sqlplus ejsadmin/ejsadmin
After a message displays indicating a successful connection, enter
exit
|
|