Using the BPEL Designer and Service Engine

Oracle

Create the Oracle database user with required privileges and tablespace for BPEL Service Engine persistence.

ProcedureTo create the Oracle database user

  1. Log into Oracle as sysdba. For example, from the command prompt enter: sqlplus "sys/syspassword@tnsentry as sysdba". You need to include sqlplus in the path and the tns entry for the Oracle database.

  2. Execute the following script using the default values:


    CREATE TABLESPACE bpelsedb DATAFILE 'bpelsedb.dat' SIZE 512M
     REUSE AUTOEXTEND ON NEXT 2048M MAXSIZE UNLIMITED;
    CREATE USER bpelse_user IDENTIFIED BY bpelse_user DEFAULT TABLESPACE
     bpelsedb QUOTA UNLIMITED ON bpelsedb TEMPORARY TABLESPACE temp QUOTA 0M ON system;
    GRANT CREATE session to bpelse_user;
    GRANT CREATE table to bpelse_user;
    GRANT CREATE procedure to bpelse_user;
    GRANT select on sys.dba_pending_transactions to bpelse_user;
    GRANT select on sys.pending_trans$ to bpelse_user;
    GRANT select on sys.dba_2pc_pending to bpelse_user;
    GRANT execute on sys.dbms_system to bpelse_user;
    GRANT select on SYS.dba_2pc_neighbors to bpelse_user;
    GRANT force any transaction to bpelse_user;

    Click Here, for more information and to download the scripts for Oracle.


    Note –

    The above code is wrapped for display purposes.



    Tip –

    The user can also connect to the database from NetBeans or other SQL clients by giving the username "sys as sysdba". The password should be the same as that of the system user. You can also change the user, tablespace and datafile name, and size/quota, as per your choice and requirements.