These steps cover how to install Oracle 8i Release 2 (Oracle 8.1.6), then create and configure a database.
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:
orcl.hostname
and then select Next.Completing the above steps installs the Oracle 8i code and creates a global database named orcl.hostname.database_domain.
To use an Oracle database with WebSphere Application Server, you must configure the database:
On Windows NT, the initialization file is typically located at \Oracle\Ora81\database\Initxxx.ora, where xxx is your SID (example, orcl).
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.
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
EJB
and then click
Apply.After a message displays indicating a successful connection, enter
exit