Perform the following steps to configure Oracle 8i for use with WebSphere Application Server:
You might also need to set processes to more than the default (50), for example:
If you need to stop the database, use the commands:
$ lsnrct LSNRCTL> start
If you do want to grant dba authority to the user EJSADMIN, enter the following set of 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 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.$ sqlplus ejsadmin/EJSADMIN_password
. A message is displayed
indicating a successful connection.$ exit
to log out as the EJSADMIN user.