- Ensure that you are logged in as the user oracle.
- Edit the initialization file $ORACLE_HOME/dbs/init<your_SID>.ora
so it includes the following line:
open_cursors = 220
You might also need to set processes to more than the default (50), for example:
processes = 100
- Restart your Oracle database. You can start the database by entering the commands:
$ svrmgrl
SVRMGR> connect internal
SVRMGR> startup
If you need to stop the database, use the commands:
$ svrmgrl
SVRMGR> connect internal
SVRMGR> shutdown
- Start the Oracle listener. At a command line, enter the following commands:
$ lsnrct
LSNRCTL> start
- You must create the EJSADMIN Oracle user required by WebSphere Application Server and grant this user
dba authority. To do this, 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> quit
- Test access to the new database with the EJSADMIN user ID by doing the following:
- Enter the command
$ sqlplus ejsadmin/EJSADMIN_password
. A message is displayed
indicating a successful connection.
- Enter the command
$ exit
to log out as the EJSADMIN user.