oracle

Kinsing (kdevtmpfsi and dbused) malware in linux impacting oracle

Introduction: Do you know there is malware in Linux that impacts your Oracle Database and Oracle Applications environment?  This malware impacting critical Linux/Oracle systems is by Kinsing. The Malware’s primary…

Read More

Find Database Query From the Linux PID

 Find Database Query From the Linux PID PID=32370 select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t where p.addr=s.paddr and s.sql_address=t.address and s.sql_hash_value=t.hash_value and p.spid = 32370;  

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

Oracle Invisible Columns

Oracle allows columns to be hidden from application. Columns can be made invisible in the CREATE TABLE statement or using an ALTER TABLE statement.By default columns are visible. Invisible columns…

Read More

STANDBY LOG NOT APPLYING IN STANDBY DATABASE

Issue: We found standby log was not applying in standby database and the difference count was keep increasing. Media recover process also not starting up. Cause: Upon receiving such alert…

Read More

Oracle apps adpatch fails

Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…

Read More

FRM-92102 Errors when Accessing a Forms Module

When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its…

Read More

Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches

Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could not do it automatically for you, due to some issues.…

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

Oracle ETRM

The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of database design and dependency information for Oracle E-Business Suite. Earlier it was available in online in the…

Read More