Posts by Abishek Kathiresan

Deprecation of the embedded PL/SQL Gateway and mod_plsql

Introduction: Beginning with Oracle APEX 20.2, the only supported Web listener is Oracle REST Data Services (ORDS). What is ORDS? Oracle REST Data Services (ORDS) is a data service which…

Read More

12.2 ADOP Prepare Phase Issue : prepare failed with “Use of uninitialized value $result in split” in txkADOPValidations.error

12.2 ADOP Prepare Phase Fails with below error message, Error: Validating configuration on node: [apps]. Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps [UNEXPECTED]Error occurred running “perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps -promptmsg=hide” [UNEXPECTED]Error 1 occurred…

Read More

How to Change APEX admin password using SQL

Steps to change APEX admin password using SQL, 1. Change the current schema to the one relevant for your APEX version ALTER SESSION SET CURRENT_SCHEMA = APEX_050000; 2. Find the…

Read More

Script (.sh) scheduled in Crontab is not working

Issue: In Linux Environment, script scheduled in Crontab is not working. Impact: Not able to do any automatic healthcheck, schedule a backup etc.. in Production Database and Application. Solution: Need…

Read More

Step by Step Oracle Database Firewall Installation on VMware

Introduction: This post is a guide to install Oracle Database Firewall 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Database Firewall 12.2.0.8 4. Post…

Read More

Step by Step Oracle Audit Vault Installation on VMware

Introduction: This post is a guide to install Oracle Audit Vault 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Audit Vault 12.2.0.8 4. Post…

Read More

Step by step Creating a Custom Application top for EBS 12.2 Using AD Splice

Introduction: This post is to guide to Create a Custom Application top for EBS 12.2 Using AD Splice. Steps to create a Custom Application top for EBS 12.2 Using AD…

Read More

SSL/HTTPS Implementation for apex application deployed on Apache Tomcat

Introduction: This article shows how to enable HTTPS for Tomcat. It uses a self-signed certificate, but you could replace this with a valid Certificate Authority (CA) certificate. In our case…

Read More

How to configure two OC4j containers for two different applications running on same server

How to configure two OC4j containers for two different applications running on same server. Introduction: The default port for the OC4j container is 8888. You may not be able to…

Read More

OC4j: How to Resolve the sharing violation by ending the process currently holding the file lock or by using a different persistence directory for one or both processes

Introduction: Requirement to configure additional OC4J instance for PDF printing for two different application. Error: ERROR ServerFile[PersistentMap,/u02/oc4j/j2ee/home/persistence/jms.state]: persistence file could not be locked. Resolve the sharing violation by ending the…

Read More