Ameer Khan

Recently I came across a requirement from a customer where they wanted to enable audit trail on EBS Application. Today I will show how to enable it. Step 1. As an example, I will be enabling auditing on table AP_CHECKS_ALL     Navigate to Responsibility: System Administrator    Navigation:   Profile > System    Query Profile: ‘AuditTrail:Activate’. Click FIND    Set it… Continue Reading

How to change admin password in Apex 23.2 In apex , admin password can be changed using two methods such as Method 1. By executing apxchpwd.sql Method 2. By executing sql command Method 1. By executing apxchpwd.sql Login to Database server  and navigate to apex installation folder and execute apxchpwd.sql as sys user. [oracle@ocisoumya-2 ~]$ cd… Continue Reading

Before we proceed, the first part that includes apex installation and configuration can be found here Download ORDS 23.4 Ords can be downloaded from Here Download oracle JDK 17 + https://www.oracle.com/in/java/technologies/downloads/#java17 Create following directories. mkdir /u01/apex/ords_23.4cd /u01/apex/ords_23.4mkdir /u01/apex/ords_23.4/configmkdir /u01/apex/ords_23.4/config/ords/standalone/logs Unzip the downloaded directory [oracle@ocisoumya ords_23.4]$ unzip ords-23.4.0.346.1619.zip -d /u01/apex/ords_23.4/ Install ORDS on linux 8 [oracle@ocisoumya ~]$ cd… Continue Reading

Issue: We had a requirement for a customer, where oracle 19c database was running on Windows server 2019. Customer wanted to monitor tablespace’s datafile usage and get email alert incase the used space is less than 80% To mitigate this , we developed a batch script leveraging powershell’s Send-Maillmessage command to achieve this. Step 1.… Continue Reading

Oracle Application Express 23.2 Installation Steps  Before installing Oracle Application Express, you must verify your configuration meets the minimum installation requirements. •                Oracle Database Requirements Oracle Application Express release 23.2 requires an Oracle Database release 19c or later, including Enterprise Edition and Standard Edition (SE) and Database 23c Free. Oracle Application Express can be installed in single-instance database and in… Continue Reading

Steps to Fix Output Post Processor Startup In Oracle E-Business Suite, there are occasions when we encounter issues such as the Output Post Processor failing to start up, resulting in a mismatch between the actual number of processes and the target number of processes. Consequently, many concurrent programs end up completing with errors or warnings.… Continue Reading

In this post I will describe the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit. The installation require a minimum of 2g swap memory and secure Linux set to permissive. ·       Download Software Oracle Database 19c (19.3) Software (64-bit) Add hosts entry in hosts file [oracle@ocisoumya-2 PDB1]$ cat /etc/hosts127.0.0.1   localhost localhost.localdomain localhost4… Continue Reading

Issue:-  We had a situation for a customer where his server was shutdown abruptly due to power cut at datacenter. After resuming the power, when he tried to start his database he encountered following error“ORA-00742: Log read detects lost write in thread 1 sequence 5789 block 805653” Environment :- Windows 2019 DB Version:-     12.2.0.1 Solution:… Continue Reading

In this comprehensive guide, we’ll walk you through the process of converting a Non-CDB (Non-Container Database) to a Pluggable Database (PDB) using an existing CDB (Container Database). Follow these clear and concise steps for a seamless transformation: Assumption: Before converting a Non-CDB oracle instance into CDB , it is assumed an oracle CDB instance is… Continue Reading

In this post I will be showing step by step guide to apply CPU patch on oracle database 19c. I will be applying CPU patch for December 2023(Patch no :- 35643107) Activity Steps: 1. Check Opatch Tool Version: 2.Download Opatch Tool (if needed): 3. Install Opatch Tool : Take backup of existing Opatch directory before… Continue Reading