Post-installation

There are a number of post-installation tasks which must be performed:

Create an Oracle role for the application server(s).

Note: The post-installation tasks require connecting to Oracle as the privileged 'sys' user. Immediately after installing Oracle, the password for this user is 'change_on_install'. Oracle requires that this be changed.

Create an Oracle role for Application Servers

The application needs certain privileges in order to use the Oracle XA interface. Later, when configuring the application, the username under which the server connects to Oracle is specified. The appropriate privileges must be assigned to this username for the server to work successfully.

An easy way to bundle together the various privileges required is to create an Oracle Role. Privileges can be granted to this role. Later this role can be granted to your users, thereby granting all the privileges associated with that role.

The following commands create a role calledCURAM_SERVER and give it the necessary privileges. A user namedCURAM_USER is then assigned that role and given the passwordPASSWORD. The commands should be run from an SQL prompt.

Note: To run the commands from an SQL prompt, log in as the user who installed Oracle, and type the following at a command prompt: sqlplus ?/? as SYSDBA

Figure 1. Oracle Configuration

CREATE ROLE "CURAM_SERVER";

GRANT RESOURCE TO "CURAM_SERVER";

@$ORACLE_HOME/rdbms/admin/xaview.sql

GRANT SELECT ON V$XATRANS$ TO PUBLIC;

GRANT SELECT ON PENDING_TRANS$ TO PUBLIC;

GRANT SELECT ON DBA_2PC_PENDING TO PUBLIC;

GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO PUBLIC;

GRANT EXECUTE ON DBMS_SYSTEM TO CURAM_SERVER;

CREATE USER <CURAM_USER> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";

GRANT "CONNECT", "CURAM_SERVER", UNLIMITED TABLESPACE TO <CURAM_USER>;

Note: Replace<CURAM_USER> and<PASSWORD> in theCREATE USER command with the username and password you wish to use for the database user.