Posts by Sundaraiya Balu

Oracle 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 More

Load 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 More

oacore_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 More

Removing 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 More

DB 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 More

Excessive 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

Oracle Forms and Reports 11.1.2.2.0 Installation: “invoking target agent” Error

Description: During installation of Oracle Forms and Reports 11.1.2.2.0 on Oracle Linux 7.2 the following error occurs at 92% of progress. Cause: This is a bug occurs on EM Agent…

Read More

Forms and Report 11gR2 Configuration: Report Component Failed

Description: During configuration of forms and report, component of report configuration failed with the below Error. Step Executing: opmnctl startproc ias-component=RptSvr_xxxxxx_asinst_1 failed Configuration Action ‘Executing: opmnctl startproc ias component=RptSvr_xxxxxx_asinst_1’ has…

Read More

WebLogic AdminServer Error-“unable to get file lock, will retry”

Cause: When WebLogic Server Starts,it creates a lock file with .lok extension under           $DOMAIN_HOME/server/<Server_Name>/tmp location It cleans .lok file when weblogic server stops If OS or Server abnormally rebooted during…

Read More

EBS-R12.2.5:adpreclone.pl Fails with Error Message – Edit session is enabled in domain

Getting ”edit session is enabled error” when running adpreclone.pl command in ebs R12.2.5 Cause: Lock&Edit session is enabled in weblogic console. Solution: Login to weblogic console Click Release configuration on…

Read More