How to set the value of optimizer_adaptive_features parameter from SQL prompt in Oracle Database 12c?


Introduction

OPTIMIZER_ADAPTIVE_FEATURES enables or disables all of the adaptive optimizer features, including adaptive plan (adaptive join methods and bitmap plans), automatic re-optimization, SQL plan directives, and adaptive distribution methods.

Continue reading
  0 Comments

How to analyze AD and TXK issues in EBS Release 12.2.x?


Issue

There are times when we need to analyze the diagnostic information in relation to AD and TXK Patches while upgrading from Release 12.2 to 12.2.x. It could be in view of missing patches or errors in applying patches.

Continue reading
  0 Comments

ERROR: ORA-12516: TNS:listener could not find available handler with matching protocol stack


Issue

Error comes while running Release 12.2.5 Release Update Pack (RUP).

Continue reading
  0 Comments

Error: FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-04062

Issue

Following errors are coming in almost all forms after installing Oracle E-Business Suite Release 12.2.4 VM under Oracle Virtualbox:

Continue reading
  0 Comments

Error while applying patch in Fusion Middleware: Error checking inventory. Error code: 1.

Issue

Set the environment for WebTier under Fusion Middleware in Applications Tier. Then issue following command on terminal and get error:

Continue reading
  0 Comments

Error: Inventory load failed. OPatch cannot load inventory for the given Oracle Home.

Issue

Error comes with following command was issued from terminal under Oracle DB Tier environment:

Continue reading
  0 Comments

How to list down Linux Groups Names?


Issue

I would like to list down all the Linux Group Names in Oracle Linux. What commond should I use?

Continue reading
  0 Comments

Unable to locate 'ld' utility in path

IssueRapidinstall wizard throws the following errors:Checking for make...Unable to locate 'make' utility in pathChecking for ld...Unable to locate 'ld' utility in pathChecking for ar...Unable to locate 'ar' utility in pathUnable to locate all utilities with system path.PATH = /usr/bin::/usr/sbin

Investigation DoneThe required operating system utilities such as 'ld', 'ar', 'make' are located in /usr/ccs/bin on most releases of unix. This path should be referenced in the unix PATH environment variable.

Continue reading
  0 Comments

Oracle EBS 11i Installation: AC-00401: Driver file missing for disk: 1 in the location


Issue

After launching rapidwiz, the installation log file shows the following error. The error continuously comes up and installation stalls.

Continue reading
  0 Comments

RW-50004: Error code received when running external process




Issue

Got the following error in Rapidwiz, when it shows Step2 of 5 20% completed:

Continue reading
  0 Comments

Error: Unable to find PD KSH Version during installation using RapidWiz



Issue

Error under RapidWiz validation which states that "Unable to find PD KSH Version".

Continue reading
  0 Comments

Where to download software for Oracle E-Business Suite 11i (11.5.10.2)?



Issue

Option to download Oracle E-Business Suite 11i (11.5.10.2) is not available in regular place in Oracle eDelivery Cloud. From where can I download the software dump?

Continue reading
  0 Comments

How to register and deploy a new domain under Oracle Weblogic Server in Oracle EBS Environment for a specific application.















Post Weblogic Server Installation, Follow the steps below to create the new domain to deploy EBS apps:

Note: To create new Weblogic domain using GUI, you need to have enabled x11 ssh forwarding in the server and ensure to have any of third party tool like x-shell, humming bird etc.

Continue reading
  0 Comments

fapostimportaad.sql taking too long to complete - R12.2.0 to R12.2.4 upgrade

b2ap3_thumbnail_1.jpg

Issue

Upgrade patch 17919161 is taking very long time to apply (upgrading from R12.2.0 to 12.2.4). It has been already over 2 days but some scripts seem to got hung under the patch.

Continue reading
  0 Comments

Weblogic bsu utility Unable to locate any supported product installations

b2ap3_thumbnail_weblogic_bsu_error.jpg

Issue

Following error is thrown when Weblogic bsu utility gets launched for applying patches:

Continue reading
  0 Comments

Oracle HTTP Server (OHS) instance - adapcctl.sh: exiting with status 204

b2ap3_thumbnail_http_server_error.jpg

Issue

Error while running ADOP cutover phase while applying pre-upgrade AD and TXK Patches (for upgrading from R12.2.0 to 12.2.4)

Continue reading
  0 Comments

Oracle EBS > Diagnostics > Examine gives error Function Not Available to this Responsibility

b2ap3_thumbnail_oracle_examine_error.jpg

Error

Function Not Available to this Responsibility. Please check with your system administrator.

Continue reading
  0 Comments

status failure - test failed io error got minus one from a read call SQL Developer

b2ap3_thumbnail_oracle_sqldeveloper_error.jpg

Error Description 

status failure - test failed io error got minus one from a read call, while connecting to Oracle EBS Database from SQL Developer

Continue reading
  0 Comments

ORA-04023: Object alter view, ERROR at line 1:

Issue

Getting the following error while recompiling a specific database object:

Continue reading
  0 Comments

Dictionary Corrupted while running ADOP Prepare phase: TS mismatch error

Issue

ADOP Prepare phase completed in error and would not complete.

Continue reading
  0 Comments