Installing DBMS_CLOUD on 19c
Description DBMS_CLOUD is the Oracle package that lets the database connect to cloud object storage (OCI, Amazon S3, Azure Blob Storage) to create credentials, query external tables over cloud files,…
Read MoreADOP Prepare Phase Failure
Issue Summary While executing the ADOP Prepare phase in Oracle E-Business Suite, the process fails because the Internal Concurrent Manager (ICM) status cannot be determined. Error Message [STATEMENT] ICM status…
Read MoreInstalling Oracle E-Business Suite Integrated SOA Gateway
Descripton: Configuring Oracle E-Business Suite REST Services on Oracle Cloud Infrastructure. Steps: 1.EBS version: Must be Oracle E-Business Suite Release 12.2 or higher. Patches required: AD and TXK latest delta…
Read MoreUnable to Launch the Application: JAR Resources in JNLP File Are Not Signed by the Same Certificate
Description: Getting the Error when try to open R12.2 application form Cause: There are cached expired certificates or JAR files from an earlier version. Solution: 1. Delete all certificates from…
Read MoreOracle Autonomous Health Framework Fleet Insights Configuration
Introduction: AHFFI is a function that collects data collected by AHF from multiple servers and displays it on a single screen. Why we need to do Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root cause of each issue-If necessary, drill down into specific insight reports to identify detailed. Support Platform: (OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later system requirements for ahffi : 4 cores CPU, 16GB RAM, 4GB disk space yum install cronie sudo yum install iproute sudo yum install hostname INSTALLATION STEPS: Download ahffi from link 3043060.1 mos Prerequisite setup Install jdk-24 Install instant client sqlplus 23.4.0 Install instant client basic 23.4.0 Create a user for ahffi on 23ai database create user ahffi identified by ahffi; grant create session to ahffi; grant connect, resource to ahffi; grant create table to ahffi; grant insert any table to ahffi; alter user ahffi quota unlimited on users; Download the ahffi file and upload it to the server …
Read MoreLoad Data into Snowflake DB Table
Introduction After creating db tables in Snowflake, the next step is to load data into them. Snowflake supports various methods to ingest data from local files, cloud storage, or external…
Read Moreoacore_server1- failed to startup with javax.naming.NameNotFoundException Error
DESCRIPTION: Getting oacore_server1- failed to startup Error when starting EBS R12.2.5 after clone. CAUSES: oaea_server1 is not registered in cloned Weblogic console. SOLUTION: Add the datasource of oaea_server1 in Weblogic…
Read MoreRemoving node name in EBS R12.2
DESCRIPTION: After EBS Test Clone EBS Prod URL Redirecting to EBS Test URL. CAUSES: EBSTEST Node Name is Added into EBS PROD’s Node table. SOLUTION: Remove the EBSTEST Node name…
Read MoreDB Alert Log: “Shutdown Waiting for Active Calls to Complete”
DESCRIPTION: When attempting to shut down database, the database hangs and the alert log contains the below messages. “SHUTDOWN: Waiting for active calls to complete” CAUSES: Database is waiting for…
Read MoreExcessive MMON Trace Files Generation in DB Trace File Location
DESCRIPTION: The size MMON trace files gets increased which is causing trace file Location Overflow. CAUSE: Trace files generation with message “AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1”. Regarding…
Read More