This article describes how to create the Oracle users required by WebSphere Application Server. The procedures in this article assume that you have installed Oracle 8i.
Perform the following steps to configure Oracle 8i for use with WebSphere Application Server:
open_cursors = 220
appears in the file.
(The value for this parameter must be 220
.)processes
parameter is sufficient
for your database by reading the information within the inityour_SID.ora file.
To increase the value of this parameter, add comment markers to or remove comment markers from
the specific lines within the file related to processes. $ svrmgrl SVRMGR> connect internal SVRMGR> startup
Note: You might need to stop the database before you are able to restart it. To stop the database, enter the following commands:
$ svrmgrl SVRMGR> connect internal SVRMGR> shutdown
$ lsnrctl LSNRCTL> start
If you do want to grant dba authority to the user EJSADMIN, enter the following commands using these values: the system variable is the user ID; the manager variable is the default password; and the EJSADMIN_password is the password you assign to the user EJSADMIN.
$ 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, perform the following two steps:
$ 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
EJB
. Then click Apply.SYS
is a user account created by the Oracle Database Configuration Assistant;
change_on_install
is the password for the SYS
account created by
the Oracle Database Configuration Assistant.
$ sqlplus SYS/change_on_install SQL> grant select on dba_pending_transactions to EJB; SQL> quit
$ sqlplus ejsadmin/EJSADMIN_password
A message is displayed indicating a successful connection.
$ exit