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:
open_cursors = 200
.50
for the processes
parameter is sufficient for your database by reading the information in your
inityour_SID.ora file. To increase the value of this parameter, add
and remove comment markers to specific lines related to processes.You can need to stop the database before restarting it. To stop the database, enter the following commands:
$ lsnrctl LSNRCTL> start
$ 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
$ sqlplus ejsadmin/EJSADMIN_password
. A message opens
indicating a successful connection.$ exit
to log out as the EJSADMIN user.