Customizing developer toolkit for Oracle database

Configure the developer toolkit to use a compatible Oracle database version.

Before you begin

Ensure that you have configured the developer toolkit environment and the docker_default network is created.

Procedure

  1. Create the container by running the following command:

    docker run -d -it --name oraserver -h oraserver --net=docker_default -p 1521:1521 store/oracle/database-enterprise:<oracle version>

  2. Enter the Oracle database container by running the following command:
    docker exec -it oraserver bash

    You are now inside the Oracle database container that is running SQL plus.

  3. Start the SQL Plus batch query tool.
    source /home/oracle/.bashrc; sqlplus sys/Oradoc_db1@ORCLCDB as sysdba
  4. Run the following SQL query: 
    alter user sys identified by password;
alter session set "_ORACLE_SCRIPT"=true;​
create user omdb identified by omdb;
grant dba to omdb;
  5. Enter the om-runtime container by running the following command:

    docker exec -it om-runtime /bin/bash

  6. Copy the ojdbc8.jar file to your om-runtime container by running the following command:

    docker cp ojdbc8.jar om-runtime:/opt/ssfs/runtime/dbjar/jdbc/ORACLE

    Note: By default, the Oracle directory is not created. To maintain a proper directory structure, it is recommended that you create the directory and copy the ojdbc8.jar file to that directory.
  7. Install the jar by running the following command:

    bin]$ ./install3rdParty.sh Oracle <oracle version> -d /opt/ssfs/runtime/dbjar/jdbc/ORACLE/ojdbc8.jar -targetJVM EVERY

    Known issue: Update AGENTDynamicclasspath.cfg.in and APPDynamicclasspath.cfg.in properties to include the following Oracle variables:
    • VENDOR_JAR=&INSTALL_DIR;/dbjar/jdbc/ORACLE/ojdbc8.jar 
    • DB_JAR=&INSTALL_DIR;/dbjar/jdbc/ORACLE/ojdbc8.jar
  8. Update Sandbox with the following ORA information. 
    ORA_HOST=om-oraserver
ORACLE=true 
ORA_DATA=ORCLCDB 
ORA_USER=omdb 
ORA_PASS=omdb 
ORA_PORT=1521 
ORACLE_NLS_LENGTH_SEMANTICS=BYTE 
ORA_TS=CTXCAT
  9. Update system_overrides.properties with the following information: 
    jdbcService.oraclePool.dbvendor=oracle
jdbcService.oraclePool.systemPool=true
jdbcService.oraclePool.url=jdbc:oracle:thin:@oraserver:1521:ORCLCDB
#jdbcService.oraclePool.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=<db_host>)(Port=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=ORCLCDB)))
jdbcService.oraclePool.catalog=ORCLCDB
jdbcService.oraclePool.dbname=ORCLCDB
jdbcService.oraclePool.user=omdb
jdbcService.oraclePool.password=omdb
jdbcService.oraclePool.schema=omdb
  10. Run the setup files by running the following command:

    ./setupfiles.sh

  11. Run DB Verify by running the following command:

    ./dbverify.sh

  12. Run the entity deployer to activate the changes by running the following command:

    ./deployer.sh -t entitydeployer

  13. Add the factory setup data to the newly created tables by running the following command:

    ./loadFactorySetup.sh

  14. Build the EAR file by running the following command:

    ./buildear.sh -Dwarfiles=smcfs,sbc,sma -Dearfile=smcfs.ear -Dnowebservice=true -Dappserver=websphere -Ddevmode=true -Dvendor=shell create-ear

  15. Restart the application server by running the following command:

    docker exec -it om-appserver bash cd /opt/ibm/wlp/bin ./server stop ./server start