Application Tier Cloning Errors
Configuring: Run file system....
LogFile located at /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/RCloneApplyAppstier_02250759.log
ERROR: Failed to configure the target system,
please check the logfile in : /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone
-------------------------------------------------------------------------------
START: Creating new WLS domain.
Running /u01/TEST/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u01/TEST/fs2/EBSapps/comn/util/jdk64 -al /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u01/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST -tmw /u01/TEST/fs2/FMW_Home -mpl /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/wlsT2PApply -silent true -debug true -domainAdminPassword /u01/TEST/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 2102 milliseconds, returning status 255
ERROR: Script failed, exit code 255
--------------------------------------------------------------------------------
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20372 Server port validation failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20372 Possible causes were :Ports of following servers - AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821) - were not available.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20372 Provide valid free ports or if those servers are targeted to non admin host, then use temporary port range mechanism.
java.lang.Exception: Error in validating "SERVER_CONFIG" parameters in "moveplan".
at oracle.as.clone.cloner.component.j2ee.util.J2EEGenericValidationUtil.validateServerConfig(J2EEGenericValidationUtil.java:218)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.getServerConfig(GenericPasteConfigSteps.java:922)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.executeGenericPasteConfig(GenericPasteConfigSteps.java:385)
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:259)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:314)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
SEVERE : Feb 23, 2018 11:32:19 - SEVERE - CLONE-20937 "pasteConfig" operation of J2EE domain failed. Check clone log and error files for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20237 Restoring the sourceid "J2EECOMPONENT@EBS_domain_PROD" has failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20237 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20237 Check the clone log for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20218 Cloning is not successful.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20218 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20218 Provide the clone log and error file for investigation.
Relevance to the Issue
Script failed because the following ports weren't available:
AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821)
Cause
Clone was configured with a public ip address in /etc/hosts.
Solution
Generally, a public ip address is not bindable in cloud setup.
Only private ip addresses are bindable.
1. Ensure a valid backup exists of the /etc/hosts file.
2. Configure /etc/hosts with PRIVATE ip addresse and redo the application tier cloning.
Reference
12.2 E-Business Suite Cloud Administration Task Running 'perl adcfgclone.pl appsTier dualfs' on Oracle Cloud Reports Ports were not Available (Doc ID 2278401.1)
Monday, February 26, 2018
Saturday, February 24, 2018
Important Docs of Oracle Compute Cloud Service
Creating an Oracle E-Business Suite Development Environment in Oracle Cloud Infrastructure Compute Classic
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/creating_ebs_dev/03devinstall.html
Creating an SSH-Enabled User on an Oracle Compute Cloud Service Instance
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html#section1
Managing Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/creating_ebs_dev/03devinstall.html
Creating an SSH-Enabled User on an Oracle Compute Cloud Service Instance
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html#section1
Managing Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/managing_ebs_on_cloud_using_cloud_admin_tool/14manage_env/14manage_env.html
Cloning Oracle E-Business Suite From On-Premises to Oracle Cloud Infrastructure Classic Using EBS Cloud Tools
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/cloning_ebs_from_on-prem_to_oracle_cloud/10cloning/10cloning.html#section1
Friday, February 23, 2018
Oracle EBS 12.2 Cloning Document
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
Wednesday, February 21, 2018
Oracle Database 18c
Release Schedule of Current Database Releases (Doc ID 742060.1)
Release Update Introduction and FAQ (Doc ID 2285040.1)
Oracle 18c New Feature: “Read Only Oracle Home”.. !!
Release Update Introduction and FAQ (Doc ID 2285040.1)
Oracle 18c New Feature: “Read Only Oracle Home”.. !!
Thursday, January 25, 2018
Oracle Standby Database Issue - ORA-16191: Primary log shipping client not logged on standby
Error : ORA-16191: Primary log shipping client not logged on standby
Resolution:
Issue can be resolved after creating password files in both primary and standby databases.
orapwd file=orapwPROD password=oracle entries=10 ignorecase=Y
Then start the synchronization again with below.
SQL> alter database recover managed standby database disconnect from session;
Wednesday, November 15, 2017
Oracle EBS 12.2.7 Docs
Installation
=========
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 ( Doc ID 1330701.1 )
Troubleshooting Rapid Install for E-Business Suite Release 12.2 ( Doc ID 1378579.1 )
ETCC Patches
===============
1) How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? ( Doc ID 2008451.1 )
2) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes ( Doc ID 1594274.1 )
3) Oracle E-Business Suite 12.2 Patching Technology Components Guide ( Doc ID 1355068.1 )
4) For post-install steps for RDBMS Patches, run "datapatch"
Upgrading AD/TXK
================
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 ( Doc ID 1617461.1 )
12.2.7
=====
Oracle E-Business Suite Release 12.2.7 Readme ( Doc ID 2230783.1 )
Additional Resources
=================
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Useful E-Business Suite 12.2 Documents ( Doc ID 1585889.1 )
Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
=========
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 ( Doc ID 1330701.1 )
Troubleshooting Rapid Install for E-Business Suite Release 12.2 ( Doc ID 1378579.1 )
ETCC Patches
===============
1) How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? ( Doc ID 2008451.1 )
2) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes ( Doc ID 1594274.1 )
3) Oracle E-Business Suite 12.2 Patching Technology Components Guide ( Doc ID 1355068.1 )
4) For post-install steps for RDBMS Patches, run "datapatch"
Upgrading AD/TXK
================
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 ( Doc ID 1617461.1 )
12.2.7
=====
Oracle E-Business Suite Release 12.2.7 Readme ( Doc ID 2230783.1 )
Additional Resources
=================
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Useful E-Business Suite 12.2 Documents ( Doc ID 1585889.1 )
Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
Friday, August 4, 2017
Kill Oracle EBS Database Sessions
Issue : Oracle EBS Database does not shutdown properly during the scheduled backup script.
Solution : Schedule below command to kill the Oracle database sessions few minutes after database shutdown initiation.
ps -ef|grep 'oraclePROD (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs kill -9
Solution : Schedule below command to kill the Oracle database sessions few minutes after database shutdown initiation.
ps -ef|grep 'oraclePROD (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs kill -9
Monday, May 8, 2017
EBS 12.2 Apps Cloning Error in OEL 6.7
Error
txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127
Solution
yum install glibc-devel.i686
txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127
Solution
yum install glibc-devel.i686
Friday, May 5, 2017
After 12.2.5 upgrade adop phase=fs_clone fails ( adop exiting with status = 1 (Fail) )
Error
Use of uninitialized value $result in split at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.
Solution
Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)
Use of uninitialized value $result in split at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.
Solution
Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)
Thursday, March 23, 2017
SLA Hot Patch for After Upgrade Data Migration
a. Run this SQL script:
select * from gl_period_statuses where migration_status_code='P'
-- this script should return zero rows, only then should you consider running the SLA Hot Patch.
b. Take a backup of the xla_upgrade_dates table before running the SLA Hot Patch
c. Set a realistic date for the SLA: Initial Date for Historical Upgrade profile.
(i) Change the SLA: Initial Date for Historical Upgrade profile to 01-OCT-2015
(ii) Then run the Hot Patch
adop phase=apply options=nocopyportion patchtop=$XLA_TOP/patch/115 patches=driver:xla5584908.drv hotpatch=yes options=forceapply
(iii) Repeat the above steps for 6-month increments until all the data from start has been upgraded.
The 6-month increment is not a rule because it depends of the amount of history to be upgraded.
select * from gl_period_statuses where migration_status_code='P'
-- this script should return zero rows, only then should you consider running the SLA Hot Patch.
b. Take a backup of the xla_upgrade_dates table before running the SLA Hot Patch
c. Set a realistic date for the SLA: Initial Date for Historical Upgrade profile.
(i) Change the SLA: Initial Date for Historical Upgrade profile to 01-OCT-2015
(ii) Then run the Hot Patch
adop phase=apply options=nocopyportion patchtop=$XLA_TOP/patch/115 patches=driver:xla5584908.drv hotpatch=yes options=forceapply
(iii) Repeat the above steps for 6-month increments until all the data from start has been upgraded.
The 6-month increment is not a rule because it depends of the amount of history to be upgraded.
Friday, March 17, 2017
Important Queries to check Oracle EBS users logged
select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);
select * from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)
select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
from apps.icx_sessions icx
join apps.fnd_user usr on usr.user_id=icx.user_id
left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'
AND USER_NAME <>'GUEST'
select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1/24 and user_id != '-1';
select * from v$license;
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);
select * from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)
select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
from apps.icx_sessions icx
join apps.fnd_user usr on usr.user_id=icx.user_id
left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'
AND USER_NAME <>'GUEST'
select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1/24 and user_id != '-1';
select * from v$license;
Monday, December 12, 2016
After Upgrading Oracle FMW WebTier of Oracle EBS 12.2 to 11gR1 PatchSet 6 (11.1.1.7) adop phase=fs_clone fails
Error in adop phase=fs_clone
after following below document
Upgrading the Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to 11gR1 PatchSet 6 (11.1.1.7) (Doc ID 2002603.1)
after following below documentUpgrading the Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to 11gR1 PatchSet 6 (11.1.1.7) (Doc ID 2002603.1)
Beginning application tier FSCloneStage - Mon Dec 12 03:50:20 2016
/u01/PROD/fs1/EBSapps/comn/util/jdk32/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/PROD/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/PROD/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/PROD/fs1/EBSapps/comn/java/classes:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/PROD/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/PROD/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/PROD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/PROD/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneStageAppsTier -e /u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -targ /u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -stage /u01/PROD/fs1/EBSapps/comn/adopclone_ebis -tmp /tmp -component appsTier -nopromptmsg
Log file located at /u01/PROD/fs1/inst/apps/PROD_ebis/admin/log/clone/FSCloneStageAppsTier_12120350.log
Exception in thread "main" java.lang.NoSuchMethodError: oracle.jdbc.driver.PhysicalConnection.getDefaultAutoRefetch()Z
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:762)
at oracle.jdbc.driver.T4CStatement.<init>(T4CStatement.java:1255)
at oracle.jdbc.driver.T4CDriverExtension.allocateStatement(T4CDriverExtension.java:48)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3460)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3425)
at oracle.apps.ad.clone.util.CloneUtil.getServerNamesFromDB(CloneUtil.java:950)
at oracle.apps.ad.clone.util.CloneUtil.getAllServerNamesFromDB(CloneUtil.java:903)
at oracle.apps.ad.clone.FSCloneStageAppsTier.doStage(FSCloneStageAppsTier.java:362)
at oracle.apps.ad.clone.FSCloneStageAppsTier.<init>(FSCloneStageAppsTier.java:149)
at oracle.apps.ad.clone.FSCloneStageAppsTier.main(FSCloneStageAppsTier.java:667)
ERROR while running FSCloneStage...
Mon Dec 12 03:50:23 2016
*******FATAL ERROR*******
PROGRAM : (/u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME : Mon Dec 12 03:50:24 2016
FUNCTION: main::runFSCloneStage [ Level 1 ]
ERRORMSG: /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl did not go through successfully.
[UNEXPECTED]Error occurred while executing "perl /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -patchcontextfile=/u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -promptmsg=hide -console=off -mode=create -sessionid=31 -timestamp=20161212_034649 -outdir=/u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis"
[UNEXPECTED]Error occurred while CLONE Patch File System from Run File System using command: "perl /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -patchcontextfile=/u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -promptmsg=hide -console=off -mode=create -sessionid=31 -timestamp=20161212_034649 -outdir=/u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis".
Releasing the managed servers ports...
Log: /u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis/txkCloneAcquirePort.log
Stopping services on patch file system...
Stopping admin server...
Solution
1. Download JDBC driver (ojbdc6.jar) from below URL, relevant to the database version.
Getting Version of JDBC jar File Reports Invalid Or Corrupt Jarfile Ojdbc6.jar Error Message ( Doc ID 1665927.1 )
2. Copy ojbdc6.jar to following directories.
/u01/PROD/fs1/FMW_Home/webtier/jdbc/lib
/u01/PROD/fs2/FMW_Home/webtier/jdbc/lib
3. Then execute adop phase=fs_clone again.
adop exiting with status = 0 (Success)
Monday, November 14, 2016
Upgraded 12.2.5 Instance Database Tier Cloning Issue Resolution - fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.
Database Tier Cloning Issue
ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") 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 -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") 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:757)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:228)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)
at oracle.apps.ad.clone.ApplyDatabase.runCVM(ApplyDatabase.java:3108)
at oracle.apps.ad.clone.ApplyDatabase.runCVMAndAutoConfig(ApplyDatabase.java:3050)
at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:678)
at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Solution
drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;
[oraprdcl@r1225td PRDCL_r1225td]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/PRDCL/db/tech_st/11.2.0/appsutil/log/PRDCL_r1225td/11140209/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/PRDCL/db/tech_st/11.2.0
Classpath : :/u01/PRDCL/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java:/u01/PRDCL/db/tech_st/11.2.0/jlib/netcfg.jar:/u01/PRDCL/db/tech_st/11.2.0/jlib/ldapjclnt11.jar
Using Context file : /u01/PRDCL/db/tech_st/11.2.0/appsutil/PRDCL_r1225td.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") 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 -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") 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:757)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:228)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)
at oracle.apps.ad.clone.ApplyDatabase.runCVM(ApplyDatabase.java:3108)
at oracle.apps.ad.clone.ApplyDatabase.runCVMAndAutoConfig(ApplyDatabase.java:3050)
at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:678)
at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Solution
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;
Enter the APPS user password:
The log file for this session is located at: /u01/PRDCL/db/tech_st/11.2.0/appsutil/log/PRDCL_r1225td/11140209/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/PRDCL/db/tech_st/11.2.0
Classpath : :/u01/PRDCL/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java:/u01/PRDCL/db/tech_st/11.2.0/jlib/netcfg.jar:/u01/PRDCL/db/tech_st/11.2.0/jlib/ldapjclnt11.jar
Using Context file : /u01/PRDCL/db/tech_st/11.2.0/appsutil/PRDCL_r1225td.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Tuesday, August 9, 2016
New Feature on AD/TXK 7 - Oracle EBS 12.2.5 Application Tier Cloning With Dualfs Option
In Oracle EBS 12.2.2, 12.2.3 & 12.2.4, application tier cloning has to be done for each RUN & PATCH file systems separately.
But now in Oracle EBS 12.2.5, with AD/TXK 7 application tier cloning for both RUN & PATCH file systems can be done at once by using the new feature option dualfs as follows. This is very useful in reducing the time required for cloning.
Let's assume source instance RUN file system is fs2.
Then copy the source instance fs2 RUN file system EBSapps directory to target instance fs2 directory. After the cloning, fs2 will become the RUN file system of the instance and fs1 will become PATCH file system automatically.
$ perl adcfgclone.pl appsTier dualfs
But now in Oracle EBS 12.2.5, with AD/TXK 7 application tier cloning for both RUN & PATCH file systems can be done at once by using the new feature option dualfs as follows. This is very useful in reducing the time required for cloning.
Let's assume source instance RUN file system is fs2.
Then copy the source instance fs2 RUN file system EBSapps directory to target instance fs2 directory. After the cloning, fs2 will become the RUN file system of the instance and fs1 will become PATCH file system automatically.
$ perl adcfgclone.pl appsTier dualfs
Saturday, July 16, 2016
Patch Timeout in Jsp Compilation During the TXK delta 7 Upgrade
Error
During the TXK delta 7 upgrade while applying following patches below error occurs in jsp compilation.
adop phase=apply patches=20784380,22363475,22495069 merge=yes
[root@test Desktop]# tail -f /u01/TEST/fs2/inst/apps/TEST_ebis/logs/appl/rgf/ojsp/ojspc_error.log
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] !!SEVERE WARNING!! TIMEOUT[600 seconds] EXPIRED DURING COMPILATION
Solution
Set ojspCompile.conf files in fs1 and fs2 java_home to respective values as below.
/u01/TEST/fs1/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf
/u01/TEST/fs2/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf
java_home = /u01/TEST/fs1/EBSapps/comn/util/jdk64
java_home = /u01/TEST/fs2/EBSapps/comn/util/jdk64
Then execute below to proceed with jsp compilation;
[oratest@test TEST]$ strace -t -o jspcompile.txt perl -x $FND_TOP/patch/115/bin/ojspCompile.pl --compile -p 6 -log /tmp/ojspCompile.log
logfile set: /tmp/ojspCompile.log
starting...(compiling delta)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
loading deplist...7829
enumerating jsps...7829
updating dependency...0
initializing compilation:
eliminating children...5954 (-1875)
searching uncompiled...4529
translating and compiling:
searching untranslated...0
compiling jsps...4529/4529 in 11m55s
Finished!
Then execute the adop phase=apply patches=20784380,22363475,22495069 merge=yes restart=yes
During the TXK delta 7 upgrade while applying following patches below error occurs in jsp compilation.
adop phase=apply patches=20784380,22363475,22495069 merge=yes
[root@test Desktop]# tail -f /u01/TEST/fs2/inst/apps/TEST_ebis/logs/appl/rgf/ojsp/ojspc_error.log
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] !!SEVERE WARNING!! TIMEOUT[600 seconds] EXPIRED DURING COMPILATION
Solution
Set ojspCompile.conf files in fs1 and fs2 java_home to respective values as below.
/u01/TEST/fs1/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf
/u01/TEST/fs2/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf
java_home = /u01/TEST/fs1/EBSapps/comn/util/jdk64
java_home = /u01/TEST/fs2/EBSapps/comn/util/jdk64
Then execute below to proceed with jsp compilation;
[oratest@test TEST]$ strace -t -o jspcompile.txt perl -x $FND_TOP/patch/115/bin/ojspCompile.pl --compile -p 6 -log /tmp/ojspCompile.log
logfile set: /tmp/ojspCompile.log
starting...(compiling delta)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
loading deplist...7829
enumerating jsps...7829
updating dependency...0
initializing compilation:
eliminating children...5954 (-1875)
searching uncompiled...4529
translating and compiling:
searching untranslated...0
compiling jsps...4529/4529 in 11m55s
Finished!
Then execute the adop phase=apply patches=20784380,22363475,22495069 merge=yes restart=yes
Sunday, July 10, 2016
Upgrade Oracle FMW WebTier of Oracle EBS 12.2 to 11gR1 PatchSet 6 (11.1.1.7)
Upgrading the Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to 11gR1 PatchSet 6 (11.1.1.7) (Doc ID 2002603.1)
Friday, July 8, 2016
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space in Weblogic Patch application
$ sh bsu.sh -prod_dir=/u01/TEST/fs2/FMW_Home/wlserver_10.3 -patchlist=EJUW -verbose -install
Checking for conflicts....
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch EJUW is mutually exclusive and cannot coexist with patch(es): Y5AP,BLTG,FCX7,1LRI,VKXF,2GYW,CW9T
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.AbstractCollection.toArray(AbstractCollection.java:136)
at java.util.ArrayList.addAll(ArrayList.java:530)
at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.getProperties(SchemaTypeImpl.java:705)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:775)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)
at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)
at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)
at com.bea.plateng.patch.Patch.main(Patch.java:306)
Solution:
1. Go to /%FMW_Home%/utils/bsu/
2. Edit the bsu.sh
3. Here you will find the following: MEM_ARGS="-Xms256m -Xmx512m"
4. Increase these values to "-Xms1024m -Xmx1024m"
Reference:
Java.lang.OutOfMemoryError" Error When Applying Oracle Weblogic Server Patch (Doc ID 2007492.1)
Wednesday, May 11, 2016
Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit - Docs
Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Doc ID 471566.1)
Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)
Using Oracle EBS R12 with a Database Tier Only Platform on Oracle 11gR1 (Doc ID 762669.1)
Migrating OLAP From 32 Bits to 64 Bits or Across Platforms (Doc ID 352306.1)
Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)
Using Oracle EBS R12 with a Database Tier Only Platform on Oracle 11gR1 (Doc ID 762669.1)
Migrating OLAP From 32 Bits to 64 Bits or Across Platforms (Doc ID 352306.1)
Wednesday, May 4, 2016
Oracle EBS 12.2.5 Reference Docs
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
Oracle EBS Workflow Notification Mailer with Cloud E-Mail Servers
Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers (Doc ID 2077434.1)
How to set Workflow Mailer Override Address from Backend ? (Doc ID 1533596.1)
Query to get the workflow notification mailer logfile to troubleshoot issues.
select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','mailer container','WFALSNRSVC','listener container',fcq.concurrent_queue_name) "CONTAINER",
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;
Inbound Connection Setup
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap1.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap2.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap3.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap4.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap5.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap6.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap7.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap8.log 2>&1
Query to get the workflow notification mailer logfile to troubleshoot issues.
select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','mailer container','WFALSNRSVC','listener container',fcq.concurrent_queue_name) "CONTAINER",
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;
Inbound Connection Setup
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap1.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap2.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap3.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap4.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap5.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap6.log 2>&1
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap7.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap8.log 2>&1
Saturday, March 5, 2016
How to find Oracle EBS Weblogic Server Admin Port Number and URL
Web Logic Server Admin Port
Method 1:
Open the EBS domain config file in following location.
$EBS_DOMAIN_HOME/config/config.xml
Then check for Admin Server Port.
Method 2:
Open the application tier context file
$CONTEXT_FILE
Then check the value of variable "s_wls_adminport" in the for the correct Web Logic Server Admin port number
Web Logic Server Console URL
http://<server name>. <domain name> : < WLS Admin Port>/console
For example. http://oracle.test.com:7003/console
Method 1:
Open the EBS domain config file in following location.
$EBS_DOMAIN_HOME/config/config.xml
Then check for Admin Server Port.
Method 2:
Open the application tier context file
$CONTEXT_FILE
Then check the value of variable "s_wls_adminport" in the for the correct Web Logic Server Admin port number
Web Logic Server Console URL
http://<server name>. <domain name> : < WLS Admin Port>/console
For example. http://oracle.test.com:7003/console
Steps to Change Oracle Weblogic Server Node Manager & Administration User Password
The option to set the Oracle WebLogic Server Administration User password to a
non-default value is available during Oracle E-Business Suite installation. This section
describes the procedure to use (on the run file system) if you need to change the
password at a later time.
The EBS WebLogic Domain uses Node Manager to control the Administration Server
and the managed servers. For the EBS WebLogic Domain, the Node Manager and
WebLogic Server Administration User passwords must be same, otherwise the AD
control scripts will not work properly.
Important:
non-default value is available during Oracle E-Business Suite installation. This section
describes the procedure to use (on the run file system) if you need to change the
password at a later time.
The EBS WebLogic Domain uses Node Manager to control the Administration Server
and the managed servers. For the EBS WebLogic Domain, the Node Manager and
WebLogic Server Administration User passwords must be same, otherwise the AD
control scripts will not work properly.
Important:
If you need to change the
Administration User password, you must change the Node Manager password first,
If you do not do this, the WebLogic Server configuration change will not be
detected and the next online patching cycle may fail.
The instructions that follow should be
performed on the run file system. The password
change will be automatically propagated
to the patch file system during the next adop
prepare phase or fs_clone operation.
1.Shut down all application tier
services except the Admin Server.
On the primary node, run the command:
$
<ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdmin
2. Change the Oracle WebLogic Server Node
Manager and Administration User passwords by performing the following steps on weblogic
console
Changing
the Oracle WebLogic Server Node Manager Password
-Login to weblogic to server console:
- Login using the current weblogic admin username and password.
- Login using the current weblogic admin username and password.
- Click on the lock and edit button
- Click on Domain link
- Click on Security TAB
- Click on Security TAB
- Click on "Advanced" Tab
- Provide the new node manager password which you want to configure for
weblogic admin user
- Click on "save"
- Verify settings updated successfully and then click on "Activate changes"
- Verify
all changes has been activated successfully.
Changing
the Oracle WebLogic Server Administration User Password
- Click on "Security Realms"
- Click on "myrealm"
- select "users and groups" and select weblogic User:
- Provide same password as we have provided above for node manager.
- Make sure the settings has been updated successfully.
- take
backup of the following files:
$FMW_HOME/user_projects/domains/EBS_domain_PROD/servers/AdminServer/security/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_PROD/servers/oafm_server1/security/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_PROD/servers/forms-c4ws_server1/security/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_PROD/servers/forms_server1/security/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_PROD/servers/oacore_server1/security/boot.properties
After this we need to edit the following
configuration file "boot.properties" for all managed and admin server
using text editor and update the password field with the above configured
password ( new password).
password={AES}ATsg8vMdZRg1pDofFsrAiPUfqtDqyNarOKaBkqDtbqs\=
username={AES}ni/ohZITMmwRT8ft1wdc5dGr2sO+qlA5S0JwZVQrzEc\=
After
editing all the above mentioned files we need to restart the application
services using adstpall.sh and adstrtal.sh scripts. Above files password
will be automatically encrypted during the start of the application services.
After restarting of services make sure all application services are started successfully. Verify that you are able to access weblogic server console and access ERP application.
3. Start all services, using the
command:
$
<ADMIN_SCRIPTS_HOME>/adstrtal.sh
Subscribe to:
Posts (Atom)