Sajid's Oracle DBA Blog: September 2021

How To Hide workflow 'Work List Bell Icon' in R12.2.5 to R12.2.8 [Release 12.2]

For security point of view, sometimes we don't want to shows notifications on homepage. So if you have the requirement to hide those notifications on bell icon. To do so we need to follow the below plan of action.

See that the Worklist bell icon is showing on homepage.

1. System Administrator

2. Profile

3. System

4. Select Site

5. Enter "WF: Enable Worklist Global Header"

6. Select Find

7. Change proifle setting to "NO"

8. Select Save

9. Log out

10. Log back in and the worklist and bell icon is no longer seen.

Note:- The profile however does not display or remove the bell icon below R12.2.5.

fs_clone failed | After successfully add external node still showing Node was abandoned in previous patching cycle

After successfully add external node still showing Node was abandoned in previous patching cycle during fs_clone. In my case external(secondary) node working fine and no any issue. But fs_clone failed, because earlier external node was abandoned after that deleted and re-added successfully.

$adop phase=fs_clone

The node was abandoned during cutover session 26, see below:

START 2021/08/23 16:57:15] Arguments passed to adop

phase=cutover mtrestart=no

[END 2021/08/23 16:57:15] Arguments passed to adop

[STATEMENT] Verifying parameters

[STATEMENT] Sourcing Run edition environment /oracle/prd/EBSFS/fs2/EBSapps/appl/APPSprd_prdsrv.env

[EVENT] Validating system setup.

[STATEMENT] Checking for required environment

[PROCEDURE] Running: adpawc -nodisp

[STATEMENT] Using 40 workers (Default: 40, Recommended maximum limit: 400)

[PROCEDURE] [START 2021/08/23 16:57:53] Identifying Admin server node

[STATEMENT] Admin node : "prdsrv"

[PROCEDURE] [END 2021/08/23 16:57:54] Identifying Admin server node

[EVENT] Node registry is valid.

[STATEMENT] Value of nodes : "prdisupplier,prdsrv"

..snip...

[UNEXPECTED]txkADOPValidation failed on node(s) : prdisupplier

If you choose to proceed with cutover, node(s) <prdisupplier> will be marked as abandoned.

Do you want adop to continue processing on completed nodes [y/n]?

Continuing with processing on node(s): prdsrv

You will need to remove the node and re-add it in via the cloning note:

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone ( Doc ID 1383621.1 ) Delta 7

5.4 Deleting an Application Tier Node:-

To check the adop_sessions.

set markup html on

spool adop_sessions.html

set timing on

set linesize 120

set pagesize 300

show user

SELECT adop_session_id "SESSION ID" ,NODE_NAME,NODE_TYPE,DECODE (prepare_status,'Y' , 'PHASE IS DONE', 'N' , 'NOT COMPLETED', 'X' , 'NOT APPLICABLE', 'R' , 'PHASE IS RUNNING', 'F' , 'PHASE FAILED', 'C' , 'COMPLETED') "PREPARE STATUS" ,DECODE (apply_status,'Y' , 'PHASE IS DONE', 'N' , 'NOT COMPLETED', 'X' , 'NOT APPLICABLE', 'R' , 'PHASE IS RUNNING', 'F' , 'PHASE FAILED', 'P','AT LEAST ONE PATCH APPLIED' , 'C' , 'COMPLETED') "APPLY STATUS" ,DECODE(cutover_status,'N' , 'NOT STARTED', 'R' , 'RUNNING', 'F' , 'FAILED', 'C' , 'COMPLETED', 'P' , 'ACTIVE', 'Y' , 'COMPLETED', 'X' , 'NOT APPLICABLE', '0' , 'FORCE_SHUTDOWN_BEGIN', '1' ,'FORCE_SHUTDOWN_COMPLETED_DB_CUTOVER_BEGIN', '3' , 'DB_CUTOVER_COMPLETED_FLIP_SNAPSHOTS_BEGIN', 'D' , 'FLIP_SNAPSHOTS_COMPLETED_FS_CUTOVER_BEGIN', '4' , 'FS_CUTOVER_COMPLETED_ADMIN_STARTUP_BEGIN', '5' , 'ADMIN_STARTUP_COMPLETED_FORCE_STARTUP_BEGIN', '6' , 'FORCE_STARTUP_COMPLETED') "CUTOVER STATUS" ,DECODE (abort_status,'Y' , 'PHASE IS DONE', 'N' , 'NOT COMPLETED', 'X' , 'NOT APPLICABLE', 'R' , 'PHASE IS RUNNING', 'F' , 'PHASE FAILED', 'C' , 'COMPLETED') "ABORT STATUS" ,DECODE (cleanup_status,'Y' , 'PHASE IS DONE', 'N' , 'NOT COMPLETED', 'X' , 'NOT APPLICABLE', 'R' , 'PHASE IS RUNNING', 'F' , 'PHASE FAILED', 'C' , 'COMPLETED') "CLEANUP STATUS" ,DECODE (status,'Y' , 'PHASE IS DONE', 'N' , 'NOT COMPLETED', 'X' , 'NOT APPLICABLE', 'R' , 'PHASE IS RUNNING', 'F' , 'PHASE FAILED', 'C' , 'COMPLETED') "STATUS" ,ABANDON_FLAG FROM ad_adop_sessions ORDER BY adop_session_id DESC;

set timing off

set markup html off

spool off

You might have to try the following but be aware this is just a workaround that has not been tested and therefore we cannot guarantee it will produce the expected results and you will need to make sure to have a valid backup of your system before proceeding.

1. Confirm secondary node is properly registered in fnd_nodes and adop_valid_nodes table.

2. Then, update ad_adop_sessions table for session 26.

SESSION ID NODE_NAME NODE_TYPE PREPARE STATUS APPLY STATUS CUTOVER STATUS ABORT STATUS CLEANUP STATUS STATUS ABANDON_FLAG

26 prdsrv master PHASE IS DONE PHASE IS DONE COMPLETED NOT APPLICABLE PHASE IS DONE COMPLETED

26 prdisupplier slave PHASE IS DONE PHASE IS DONE FS_CUTOVER_COMPLETED_ADMIN_STARTUP_BEGIN NOT APPLICABLE NOT COMPLETED PHASE

FAILED 26 <--------

1. Backup Table

create table ad_adop_sessions_bk as select * from ad_adop_sessions

2. Update table

SQL>update ad_adop_sessions set abandon_flag=null where node_name="prdisupplier" and session_id = 26;

SQL> Commit;

3. Retest the issue.

After above action now fs_clone will complete successfully.

perl adcfgclone.pl dbTier failed as ouicli.pl INSTE8_APPLY 1

$perl adcfgclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Running: Context clone...

Log file located at /testdata02/oraphase2cln/appsutil/clone/bin/CloneContext_0709132706.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [testapps] :

Target System Base Directory : /testdata02

Target Instance is RAC (y/n) [n] : n

Target System Database SID : PHASE2

Role separation is supported y/n [n] ? :

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [5] : 3

Target System DATA_TOP Directory 1 : /testdata01/datafiles

Target System DATA_TOP Directory 2 : /testdata02/phase2clndatafiles

Target System DATA_TOP Directory 3 : /11.22_SPtest/oracle_datafiles

Target System RDBMS ORACLE_HOME Directory [/testdata02/11.2.0] : /testdata02/oraphase2cln

Do you want to preserve the Display [testtest:0.0] (y/n) : n

Target System Display [testapps:0.0] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 5

Checking the port pool 5

done: Port Pool 5 is free

Report file located at /testdata02/oraphase2cln/appsutil/temp/portpool.lst

The new database context file has been created :

/testdata02/oraphase2cln/appsutil/PHASE2_testapps.xml

Check Clone Context logfile /testdata02/oraphase2cln/appsutil/clone/bin/CloneContext_0709132706.log for details.

Running Rapid Clone with command:

Running:

perl /testdata02/oraphase2cln/appsutil/clone/bin/adclone.pl java=/testdata02/oraphase2cln/appsutil/clone /bin/../jre mode=apply stage=/testdata02/oraphase2cln/appsutil/clone component=dbTier method=CUSTOM dbc txtg=/testdata02/oraphase2cln/appsutil/PHASE2_testapps.xml showProgress contextValidated=true

Beginning database tier Apply - Fri Jul 9 13:28:51 2021

/testdata02/oraphase2cln/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompli ant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/testdata02/oraphase2cln/oui -classpath / testdata02/oraphase2cln/appsutil/clone/jlib/xmlparserv2.jar:/testdata02/oraphase2cln/appsutil/clone/jlib /ojdbc6.jar:/testdata02/oraphase2cln/appsutil/clone/jlib/java:/testdata02/oraphase2cln/appsutil/clone/jl ib/oui/OraInstaller.jar:/testdata02/oraphase2cln/appsutil/clone/jlib/oui/ewt3.jar:/testdata02/oraphase2c ln/appsutil/clone/jlib/oui/share.jar:/testdata02/oraphase2cln/appsutil/clone/jlib/oui/srvm.jar:/testdata 02/oraphase2cln/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /testdata02/orapha se2cln/appsutil/PHASE2_testapps.xml -stage /testdata02/oraphase2cln/appsutil/clone -showProgress

APPS Password : Log file located at /testdata02/oraphase2cln/appsutil/log/PHASE2_testapps/ApplyDBTier_07 091328.log

\ 0% completed RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

ERROR while running Apply...

Fri Jul 9 13:30:03 2021

ERROR: Failed to execute /testdata02/oraphase2cln/appsutil/clone/bin/adclone.pl

Please check logfile.

Autoconfig error:-

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -31024: ORA-31024: Parser initialization failed with LPX-201 error

while parsing a stream to XOB has been detected in FND_GSM_UTIL.upload_context_file.

oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -31024: ORA-31024: Parser initialization failed with LPX-201 error

while parsing a stream to XOB has been detected in FND_GSM_UTIL.upload_context_file.

at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)

at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)

at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:762)

at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:233)

at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)

at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:787)

FAILED

COMPLETED

ApplyDBTier_07091328.log:-

ouicli.pl INSTE8_APPLY 1

txkcreateACL.sh: exiting with status 1

Solution:-

To resolve this issue we need to remove or rename and rerun the adcfclone.pl on dbTier.

rm -rf /etc/oraInventory/*

API to reset password and add/end responsibility to user in oracle apps

To reset password and responsibility below API will is very useful. Put the username once and it will reuse till all task done.

DECLARE

lb_status BOOLEAN;

v_username varchar2(100):='&&Username';

v_password varchar2(200);

BEGIN

select user_password into v_password from ace_users where user_code=v_username ;

if v_password is not null then

lb_status := FND_USER_PKG.CHANGEPASSWORD

(

username => v_username,

newpassword => v_password

);

end if ;

IF lb_status

THEN

DBMS_OUTPUT.PUT_LINE('Request processed sucessfully');

ELSE

DBMS_OUTPUT.PUT_LINE('Error while processing the request');

END IF;

END;

-----------------------------------------------------------------

-- API to end date user responsibility in oracle apps

-- -----------------------------------------------------------------

DECLARE

v_user_name VARCHAR2 (100) := '&&Username';

v_responsibility_name VARCHAR2 (100) := 'Sourcing Supplier';

v_application_name VARCHAR2 (100) := NULL;

v_responsibility_key VARCHAR2 (100) := NULL;

v_security_group VARCHAR2 (100) := NULL;

BEGIN

SELECT fa.application_short_name,

fr.responsibility_key,

frg.security_group_key

INTO v_application_name,

v_responsibility_key,

v_security_group

FROM fnd_responsibility fr,

fnd_application fa,

fnd_security_groups frg,

fnd_responsibility_tl frt

WHERE fr.application_id = fa.application_id

AND fr.data_group_id = frg.security_group_id

AND fr.responsibility_id = frt.responsibility_id

AND frt.LANGUAGE = USERENV ('LANG')

AND frt.responsibility_name = v_responsibility_name;

fnd_user_pkg.delresp

( username => v_user_name,

resp_app => v_application_name,

resp_key => v_responsibility_key,

security_group => v_security_group

);

COMMIT;

DBMS_OUTPUT.put_line ( 'Responsiblity '

|| v_responsibility_name

|| ' is removed from the user '

|| v_user_name

|| ' Successfully'

);

EXCEPTION

WHEN OTHERS THEN

DBMS_OUTPUT.put_line

( 'Error encountered while deleting responsibilty from the user and the error is '

|| SQLERRM

);

END;

----------------------------------------------------------------

---------API Script to add responsibility to user in oracle apps

----------------------------------------------------------------

DECLARE

v_user_name VARCHAR2 (30) := '&&Username';

v_responsibility_name VARCHAR2 (100) := 'ACE TA/DA Users';

v_application_name VARCHAR2 (100) := NULL;

v_responsibility_key VARCHAR2 (100) := NULL;

v_security_group VARCHAR2 (100) := NULL;

v_description VARCHAR2 (100) := NULL;

BEGIN

SELECT fa.application_short_name, fr.responsibility_key,

fsg.security_group_key, frt.description

INTO v_application_name, v_responsibility_key,

v_security_group, v_description

FROM apps.fnd_responsibility fr,

fnd_application fa,

fnd_security_groups fsg,

fnd_responsibility_tl frt

WHERE frt.responsibility_name = v_responsibility_name

AND frt.LANGUAGE = USERENV ('LANG')

AND frt.responsibility_id = fr.responsibility_id

AND fr.application_id = fa.application_id

AND fr.data_group_id = fsg.security_group_id;

fnd_user_pkg.addresp (username => v_user_name,

resp_app => v_application_name,

resp_key => v_responsibility_key,

security_group => v_security_group,

description => v_description,

start_date => SYSDATE,

end_date => NULL

);

COMMIT;

DBMS_OUTPUT.put_line( 'Responsiblity '

|| v_responsibility_name

|| ' is attached to the user '

|| v_user_name

|| ' Successfully'

);

EXCEPTION

WHEN OTHERS

THEN

DBMS_OUTPUT.put_line

( 'Unable to attach responsibility to user due to'

|| SQLCODE

|| ' '

|| SUBSTR (SQLERRM, 1, 100)

);

END;

SHOW ERR;

exit;

E-Business Suite R12.2 : Login To External Node Gets Redirected To Internal Node

To resolve the redirection issue from external to internal and vice versa . Need to be update the configuration file mod_wl_ohs.conf and apps.conf accordingly.

Internal node:-appsprod.abc-cranes.com

External node:-abcisupplier.abc-cranes.com

In $IAS_ORACLE_HOME/instances/EBS_web_<SID>_OHS1/config/OHS/EBS_web_<SID>/mod_wl_ohs.conf, it has the following setting :-

# +======================================================================+

# | Version 12.0.0 |

# +======================================================================+

# $Header: mod_wl_ohs_conf_FMW.tmp 120.7.12020000.7 2016/11/22 07:45:33 kmandal ship $

# This template is used to seed the initial mod_wl_ohs.conf. After that, AutoConfig does not manage mod_wl_ohs.conf changes.

# It is advisable to perform OHS configuration changes through EM console.

# The default EM console URL is http://%s_hostname%.%s_domainname%:%s_wls_adminport%/em

####################################################################

# mod_wl_ohs.so - The plug-ins allow requests to be proxied from an

# Apache HTTP Server, Oracle HTTP Server, or Microsoft Internet Information Server (IIS)

# to WebLogic Server. In this way, plug-ins enable the HTTP server to communicate

# with applications deployed on the WebLogic Server.

# For further information refer http://download.oracle.com/docs/cd/E14571_01/web.1111/e16435/overview.htm#BABGIJBI

# WebLogicCluster - List of member server and port in server:port,server1:port1 format

# For further information refer Configure the Apache HTTP Server Plug-In here:

# http://download.oracle.com/docs/cd/E14571_01/web.1111/e16435/apache.htm#CDEHDGJG

####################################################################

LoadModule weblogic_module "${ORACLE_HOME}/ohs/modules/mod_wl_ohs.so"

DynamicServerList OFF

SetHandler weblogic-handler

WebLogicCluster abcisupplier.abc-cranes.com:7201,appsprod.abc-cranes.com:7201

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WLCookieName JsessionIDForms

WebLogicCluster appsprod.abc-cranes.com:7401,abcisupplier.abc-cranes.com:7412

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WLCookieName JsessionIDOAFM

WebLogicCluster abcisupplier.abc-cranes.com:7601,appsprod.abc-cranes.com:7603

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WLCookieName JsessionIDFORMS-C4WS

WebLogicCluster abcisupplier.abc-cranes.com:7801,appsprod.abc-cranes.com:7803

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WLCookieName JsessionIDEkanban

WebLogicCluster abcisupplier.abc-cranes.com:6812

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WebLogicCluster abcisupplier.abc-cranes.com:6812

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

SetHandler weblogic-handler

WLCookieName JsessionIDYMS

WebLogicCluster abcisupplier.abc-cranes.com:6812

WLTempDir ${ORACLE_INSTANCE}/tmp

#SecureProxy ON

#WLProxySSL ON

#WLSSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/default"

</Location>

</IfModule>

In $FMW_HOME/webtier/instances/EBS_web_VIS_OHS1/config/OHS/EBS_web_VIS/apps.conf, it has the following setting:

# $Header: apps_conf_FMW.tmp 120.10 2012/01/31 11:27:58 ttsharma ship $

# This template would not be instantiated using Autoconfig API. The API

# <FND_TOP>/patch/115/bin/txkSetAppsConfig.pl is used to instantiate OR

# regenerate <webtier_home>/config/OHS/<s_ohs_component>/apps.conf file.

# It is advisable to perform OHS configuration changes through EM console.

# The default EM console URL is http://<s_hostname>.<s_domainname>:<s_wls_adminport>/em

# NOTE : This is a template to add apps specific configuration in httpd.conf

################################################################################

# Small note on directive used in this config file

# ProxyPass - This directive allows remote servers to be mapped into the spabc of

# the local server; the local server does not act as a proxy in the conventional sense,

# but appears to be a mirror of the remote server. The local server is often called a

# reverse proxy or gateway. Please see http://httpd.apache.org/docs/2.2/mod/mod_proxy.html#proxypass

# for details.

# ProxyPass balancer://oacorecluster_oamedia - If the Proxy directive scheme starts with the

# balancer:// (eg: balancer://cluster/, any path information is ignored) then a virtual worker

# that does not really communicate with the backend server will be created. Instead it is responsible

# for the management of several "real" workers. In that case the special set of parameters can be

# add to this virtual worker.

# See mod_proxy_balancer for more information about how the balancer works.

# ProxyPassReverse - Adjusts the URL in HTTP response headers sent from a reverse proxied server

# Please refer http://httpd.apache.org/docs/2.2/mod/mod_proxy.html#proxypassreverse for more details.

# mod_proxy_balancer - mod_proxy extension of load balancer.

# Please refer "http://httpd.apache.org/docs/2.2/mod/mod_proxy_balancer.html" for details.

# BalancerMember - This directive adds a member to a load balancing group. It could be used within a

# <Proxy balancer://...> container directive, and can take any of the key value pairs available to

# ProxyPass directives.

###################################################################################

LoadModule proxy_balancer_module "${ORACLE_HOME}/ohs/modules/mod_proxy_balancer.so"

ProxyRequests off

ProxyRequests Off

######################

# for oacore

######################

ProxyPass balancer://oacorecluster_oamedia

ProxyPassReverse balancer://oacorecluster_oamedia

</Location>

BalancerMember http://abcisupplier.abc-cranes.com:7201/OA_HTML/media

BalancerMember http://appsprod.abc-cranes.com:7201/OA_HTML/media

</Proxy>

ProxyPass balancer://oacorecluster_oajava

ProxyPassReverse balancer://oacorecluster_oajava

</Location>

BalancerMember http://abcisupplier.abc-cranes.com:7201/OA_HTML/classes

BalancerMember http://appsprod.abc-cranes.com:7201/OA_HTML/classes

</Proxy>

ProxyPass balancer://oacorecluster_oacgi/OA_HTML/txkFNDWRR.pl

ProxyPassReverse balancer://oacorecluster_oacgi/OA_HTML/txkFNDWRR.pl

</Location>

BalancerMember http://abcisupplier.abc-cranes.com:7201

BalancerMember http://appsprod.abc-cranes.com:7201

</Proxy>

######################

# for forms

######################

ProxyPass balancer://formscluster_oamedia

ProxyPassReverse balancer://formscluster_oamedia

</Location>

BalancerMember http://appsprod.abc-cranes.com:7401/OA_HTML/media

BalancerMember http://abcisupplier.abc-cranes.com:7412/OA_HTML/media

</Proxy>

ProxyPass balancer://formscluster_oajava

ProxyPassReverse balancer://formscluster_oajava

</Location>

BalancerMember http://appsprod.abc-cranes.com:7401/OA_HTML/classes

BalancerMember http://abcisupplier.abc-cranes.com:7412/OA_HTML/classes

</Proxy>

</IfModule>

# Environment settings to be passed to CGI programs from external env

PassEnv NLS_LANG

# Set Limit of ENV Variables

# The LimitRequestFieldSize directive allows the server administrator to

# reduce or increase the limit on the allowed size of an HTTP request header

# field. A server needs this value to be large enough to hold any one header

# field from a normal client request

LimitRequestFieldSize 4096

# The LimitRequestFields directive allows the server administrator to

# modify the limit on the number of request header fields allowed in an HTTP

# request. A server needs this value to be larger than the number of fields

# that a normal client request might include. The number of request header

# fields used by a client rarely exceeds 20, but this may vary among different

# client implementations, often depending upon the extent to which a user has

# configured their browser to support detailed content negotiation

LimitRequestFields 32

# The LimitRequestBody directive allows the user to set a limit on

# the allowed size of an HTTP request message body within the context in which

# the directive is given (server, per-directory, per-file or per-location). If

# the client request exceeds that limit, the server will return an error

# response instead of servicing the request. The size of a normal request

# message body will vary greatly depending on the nature of the resource and

# the methods allowed on that resource

LimitRequestBody 0

# The LimitRequestLine directive allows the server administrator to

# reduce the limit on the allowed size of a client's HTTP request-line

# below the normal input buffer size compiled with the

# server. Since the request-line consists of the HTTP method, URI, and protocol

# version, the LimitRequestLine directive plabcs a restriction on the length of

# a request-URI allowed for a request on the server. A server needs this value

# to be large enough to hold any of its resource names, including any

# information that might be passed in the query part of a GET request

LimitRequestLine 4096

# Caching static contents

ExpiresActive On

ExpiresByType image/gif "access plus 1 month"

ExpiresByType image/jpeg "access plus 1 month"

ExpiresByType text/txt "access plus 1 month"

</Location>

ExpiresByType image/gif "access plus 1 month"

ExpiresByType image/jpg "access plus 1 month"

# ExpiresByType text/html "access plus 1 month"

ExpiresByType text/css "access plus 1 month"

# ExpiresByType text/js "access plus 1 month"

</Location>

</IfModule>

# To facilitate reloading of the html on change

Header always add Cache-Control no-cache

Header always merge Cache-Control must-revalidate

Header always merge Cache-Control no-store

</Location>

Solution:-

To fix this issue, pls make the following changes to the run file system of the external node:

Check the ohs directory.

$grep ohs $CONTEXT_FILE

1. Modify $IAS_ORACLE_HOME/instances/EBS_web_<SID>_OHS1/config/OHS/EBS_web_<SID>/mod_wl_ohs.conf

-> Remove any reference to Internal.<DOMAIN>.

Change:

WebLogicCluster internal.<DOMAIN>:8000:7201,external.<DOMAIN>:7201

WebLogicCluster internal.<DOMAIN>:8000:7401,external.<DOMAIN>:7401

WebLogicCluster internal.<DOMAIN>:8000:7601,external.<DOMAIN>:7601

WebLogicCluster internal.<DOMAIN>:8000:7801,external.<DOMAIN>:7801

To:

WebLogicCluster external.<DOMAIN>:8000:7201

WebLogicCluster external.<DOMAIN>:8000:7401

WebLogicCluster external.<DOMAIN>:8000:7601

WebLogicCluster external.<DOMAIN>:8000:7801

2. In the apps.conf

-> remove any reference to Internal.<DOMAIN>

Change:

BalancerMember http://internal.<DOMAIN>:7201/OA_HTML/media

BalancerMember http://external.<DOMAIN>:7201/OA_HTML/media

BalancerMember http://internal.<DOMAIN>:7201/OA_HTML/classes

BalancerMember http://external.<DOMAIN>:7201/OA_HTML/classes

BalancerMember http://internal.<DOMAIN>:7201

BalancerMember http://external.<DOMAIN>:7201

BalancerMember http://internal.<DOMAIN>:7401/OA_HTML/media

BalancerMember http://external.<DOMAIN>:7401/OA_HTML/media

BalancerMember http://internal.<DOMAIN>:7401/OA_HTML/classes

BalancerMember http://external.<DOMAIN>:7401/OA_HTML/classes

To:

BalancerMember http://external.<DOMAIN>:7201/OA_HTML/media

BalancerMember http://external.<DOMAIN>:7201/OA_HTML/classes

BalancerMember http://external.<DOMAIN>:7201

BalancerMember http:/external.<DOMAIN>:7401/OA_HTML/media

BalancerMember http://external.<DOMAIN>:7401/OA_HTML/classes

3. Restart the internal node.

4. Restart the external node.

5. Try to reproduce the issue.

Sajid's Oracle DBA Blog

How To Hide workflow 'Work List Bell Icon' in R12.2.5 to R12.2.8 [Release 12.2]

fs_clone failed | After successfully add external node still showing Node was abandoned in previous patching cycle

perl adcfgclone.pl dbTier failed as ouicli.pl INSTE8_APPLY 1

API to reset password and add/end responsibility to user in oracle apps

E-Business Suite R12.2 : Login To External Node Gets Redirected To Internal Node

Blog Archive

Popular Posts