Yearly Archives: 2020

Some Operations performed by the Grid Control Agent 10g or 11g Fail With ‘ERROR: NMO Not Setuid-root (Unix-only)’

APPLIES TO: Enterprise Manager Base Platform - Version 10.1.0.2 to 11.1.0.1 [Release 10.1 to 11.1] Generic UNIX SYMPTOMS: The Grid Control Management Agent has been installed in a Unix machine.…

Read More

EM 12c, EM 13c: Fix the Cloud Control Agent error ‘ERROR: NMO Not Setuid-root (Unix-only)’

APPLIES TO: Enterprise Manager Base Platform - Version 12.1.0.1.0 and later Generic UNIX Generic Linux SYMPTOMS: The Cloud Control Management Agent has been installed on a Unix machine. Trying to…

Read More

adapcctl.sh exiting with status 150

adapcctl.sh: exiting with status 150 adapcctl.sh: exiting with status 150 After resolve adoafmctl.sh: exiting with status 204, when i try to start application tier services then getting below error message:…

Read More

ORA-609-opiodr aborting process unknown ospid

ORA-609 : opiodr aborting process unknown ospid Solution: Increase the values for INBOUND_CONNECT_TIMEOUT at both listener and server side sqlnet.ora file as a preventive measure. If the problem  is due…

Read More

ORA-20100 File o2127370.tmp creation failed

ORA-20100: ORA-20100: File o2127370.tmp creation failed. Concurrent request failed with the following error in log file. Error ——– ORA-20100: ORA-20100: File o2127370.tmp creation failed. File could not be opened or…

Read More

Workflow Notification Mailer Not Sending Notifications As event oracle.apps.wf.notification.send.group Is Disabled

APPLIES TO: Oracle Workflow - Version 12.1.3 to 12.2 [Release 12.1 to 12.2] Information in this document applies to any platform. SYMPTOMS: On Oracle Applications Release 12.1.3 When attempting to…

Read More

How To Query And Change The Oracle Hidden Parameters In Oracle 10g and Later

  GOAL: Q1: How to query the hidden initialization parameters in sql ? Q2: How to change these hidden parameters? SOLUTION: A1: The hidden parameters start with an "_".They can…

Read More

AutoConfig: Parallel Run Option on R12.1.1

AutoConfig: Parallel Run Option on R12.1.1 The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one…

Read More

Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4

We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where…

Read More

AP Invoice Attachments Extraction

select distinct aia.invoice_id, aia.Voucher_Number, d.file_name, d.url from fnd_attached_documents fad, ap_invoices_all aia, fnd_documents d where 1=1 and aia.invoice_id = fad.pk1_value and fad.entity_name = ‘AP_INVOICES’ and fad.document_id = d.document_id;

Read More