database parameters recommendations


Comments

Post a Comment

Popular posts from this blog

Troubleshooting EBS login page issue in R12.2:

Troubleshooting EBS login page issue in R12.2: ------------------------------------------------------------------------------------------------------------------- 1. If the login page doesn't comes up then we have to focus on the varios logs present under $LOG_HOME directory. In case of EBS 12.2(as it is the latest release), 1) OHS (apache) failure If OHS is not running or not responding, one would see a message as below. If OHS is not running then there will not be any messages in any EBS log file for this request. Firefox: “The connection was reset” Steps to take Check OHS has started OK adapcctl.sh status adapcctl.sh stop adapcctl.sh start 2 OACore JVM process not available If the OACore JVM is not running or not reachable, then one will likely see the following message in the browser: Failure of server APACHE bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. There could be two reas...
Read more

ADUTILITIES in R12.1/R12.2 EBS

ADUTILITIES in R12.1/R12.2 EBS --------------------------------------------- Forms Compilation: ------------------- frmcmp_batch.sh module=/u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/forms/US/ XXX.fmb userid=APPS/APPS output_file=/u01/oracle/TEST/apps/apps_st/appl/inv/ 12.0.0/forms/US/XXX.fmx module_type=form compile_all=special ADLICMGR: ========== 1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed.  License manager can be run 2 ways: a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration tab -> License Manager b. run adlicmgr.sh  from AD_TOP/bin Using both methods you can license by Module or by individual Product. Select the check box for the Module/Product to be licensed and Save/Next 2. The Products are now licensed but not ready to be used as none of the Forms/Packages etc would have been compiled and loade...
Read more

ADOP PREPARE phase, does a series of validations

 In the PREPARE phase, ADOP does a series of validations and then “prepares” the system for an online patching cycle. Here is a rundown of what happens step-by-step when we run adop phase=prepare First, it preforms the verification of parameters and checks for various minor pre-reeqs Performing verification of parameters Sourcing the Run Edition environment Validating system setup… Determining admin node Node registry is valid. Performing database sanity checks Acquire lock on sessions table Checking for pending adop sessions active hotpatch session… active cleanup session active FS_CLONE session Staging new adop session… Checking if node “<node_name>” previously failed New row inserted into ad_adop_sessions table with session id : 100 Unlocking sessions table createPatchCtxFile() check if patch context file exists, else generate it (from where?) Checking the status of phase select  count(1)   from  ad_adop_sessions  where  adop_session_id=100   ...
Read more