tag:blogger.com,1999:blog-63353432281905110092024-03-12T17:24:40.002-07:00Oracle Apps TechnologyBlog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to AppsVikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.comBlogger718125tag:blogger.com,1999:blog-6335343228190511009.post-62596851916054062452017-07-26T14:10:00.000-07:002017-07-26T14:10:00.359-07:00Unable to locally verify the issuer's authority<div dir="ltr" style="text-align: left;" trbidi="on">
Chuka pinged me when he got this error in Qualys logs after installation of qualys agent on a server<br />
<br />
<div class="MsoNormal">
2017-07-24 15:23:08.363
[qualys-cloud-agent][232147]:[Information]:Webservice uri: <a href="https://qagpublic.qg1.apps.qualys.com/CloudAgent/v1.1/customer/9c0e25de-0221-5af6-e040-10ac13043f6a/agent/e6ea9ca7-a662-4a4d-8412-2ec70077d7a9/CAPI">https://qagpublic.qg1.apps.qualys.com/CloudAgent/v1.1/customer/9c0e25de-0221-5af6-e040-10ac13043f6a/agent/e6ea9ca7-a662-4a4d-8412-2ec70077d7a9/CAPI</a><o:p></o:p></div>
<div class="MsoNormal">
2017-07-24 15:23:08.497
[qualys-cloud-agent][232147]:[Information]:Finished curl request<o:p></o:p></div>
<div class="MsoNormal">
2017-07-24 15:23:08.497
[qualys-cloud-agent][232147]:[Error]:Http request failed:Peer certificate
cannot be authenticated with given CA certificates: SSL certificate problem:
unable to get local issuer certificate<o:p></o:p></div>
<div class="MsoNormal">
2017-07-24 15:23:08.497
[qualys-cloud-agent][232147]:[Error]:Http request failed: error code: 0<o:p></o:p></div>
<div class="MsoNormal">
2017-07-24 15:23:08.497
[qualys-cloud-agent][232147]:[Error]:CAPI request failed:<o:p></o:p></div>
<div class="MsoNormal">
2017-07-24 15:23:08.497
[qualys-cloud-agent][232147]:[Error]:CAPI event failed<o:p></o:p></div>
<br />
<div class="MsoNormal">
2017-07-24 15:23:08.500
[qualys-cloud-agent][232147]:[Information]:Next event: INTERVAL_EVENT_CAPI,
time left: 100 seconds<o:p></o:p></div>
<br />
I suggested that we try setting http_proxy and https_proxy environment variables and check with wget and curl<br />
<br />
We did that and got the error:<br />
<br />
Unable to locally verify the issuer's authority<br />
<br />
On access.redhat.com, I found https://access.redhat.com/solutions/37323 that described a similar issue on RHEL5, we are on OEL6:<br />
<br />
<header class="header" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h1 class="title" style="box-sizing: border-box; color: inherit; font-size: 1.875rem; line-height: 1.25em; margin: 0px 0px 6px; text-rendering: auto;">
Getting "Unable to locally verify the issuer's authority" error from wget in RHEL 5</h1>
<div class="header-meta" style="box-sizing: border-box;">
<span class="status verified" data-content="This solution has been verified to work by Red Hat Customers and Support Engineers for the specified product version(s)." data-original-title="" data-placement="bottom" data-toggle="popover" data-trigger="hover" style="box-sizing: border-box; color: #3f9c35; font-weight: bold; text-transform: uppercase;" title=""><span aria-hidden="true" class="icon-solution" style="box-sizing: border-box;"></span> SOLUTION VERIFIED </span>- Updated <time class="moment_date" datetime="2013-02-06T11:52:21-05:00" style="box-sizing: border-box;" title="February 6 2013 at 11:52 AM">February 6 2013 at 11:52 AM</time> - <div class="dropdown inline" style="box-sizing: border-box; display: inline; position: relative;">
<a aria-expanded="false" aria-haspopup="true" data-target="#" data-toggle="dropdown" href="https://access.redhat.com/solutions/37323" id="dLabel" role="button" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;">English <span class="caret" style="border-left: 4px solid transparent; border-right: 4px solid transparent; border-top: 4px solid; box-sizing: border-box; display: inline-block; height: 0px; margin-left: 2px; vertical-align: middle; width: 0px;"></span></a></div>
</div>
</header><section class="field_kcs_environment_txt" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h2 style="box-sizing: border-box; color: inherit; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Environment</h2>
<ul style="box-sizing: border-box; margin-bottom: 1rem; margin-top: 0px;">
<li style="box-sizing: border-box;">Red Hat Enterprise Linux (RHEL) 5.5</li>
</ul>
</section><section class="field_kcs_issue_txt" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h2 style="box-sizing: border-box; color: inherit; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Issue</h2>
<ul style="box-sizing: border-box; margin-bottom: 1rem; margin-top: 0px;">
<li style="box-sizing: border-box;">When downloading from certain SSL URLs, wget throws the error "Unable to locally verify the issuer's authority".</li>
</ul>
</section><section class="field_kcs_resolution_txt" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h2 style="box-sizing: border-box; color: inherit; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Resolution</h2>
<ul style="box-sizing: border-box; margin-bottom: 1rem; margin-top: 0px;">
<li style="box-sizing: border-box;">This issue has been resolved as of RHEL 5.7 in <code style="background-color: #f7f7f7; border-radius: 0px; box-sizing: border-box; font-family: Consolas, Monaco, "Andale Mono", monospace; font-size: 14.4px; padding: 2px 4px; white-space: nowrap;">openssl-0.9.8e-20.el5</code>, for more information see the following errata: <a href="http://rhn.redhat.com/errata/RHBA-2011-1010.html" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;">http://rhn.redhat.com/errata/RHBA-2011-1010.html</a></li>
</ul>
</section><section class="field_kcs_rootcause_txt" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h2 style="box-sizing: border-box; color: inherit; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Root Cause</h2>
<ul style="box-sizing: border-box; margin-bottom: 1rem; margin-top: 0px;">
<li style="box-sizing: border-box;">The openssl <code style="background-color: #f7f7f7; border-radius: 0px; box-sizing: border-box; font-family: Consolas, Monaco, "Andale Mono", monospace; font-size: 14.4px; padding: 2px 4px; white-space: nowrap;">/etc/pki/tls/certs/ca-bundle.crt</code> file in RHEL 5.5 is outdated.</li>
</ul>
</section><section class="field_kcs_diagnostic_txt" style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 30px;"><h2 style="box-sizing: border-box; color: inherit; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Diagnostic Steps</h2>
<div style="box-sizing: border-box; line-height: 1.5em; margin-bottom: 1rem;">
Reproduction steps:</div>
<div class="code-raw" style="box-sizing: border-box; position: relative;">
<div class="code-raw-toolbar" style="background: rgb(236, 236, 236); border: 1px solid rgb(236, 236, 236); box-sizing: border-box; height: 40px; position: relative;">
<br /></div>
<pre style="background-color: whitesmoke; border-radius: 0px; border: 1px solid rgb(236, 236, 236); box-sizing: border-box; color: #333333; font-family: Consolas, Monaco, "Andale Mono", monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 0.9375rem; white-space: pre-wrap; word-break: normal; word-wrap: normal;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Consolas, Monaco, "Andale Mono", monospace; font-size: inherit; padding: 0px;">$ wget https://www.internetx.com/
--2010-07-24 15:30:14-- https://www.internetx.com/
Resolving www.internetx.com... 85.236.36.48, 2001:4178:2:10::54, 2001:4178:2:10::55, ...
Connecting to www.internetx.com|85.236.36.48|:443... connected.
ERROR: cannot verify www.internetx.com's certificate, issued by '/C=US/O=VeriSign, Inc./OU=VeriSign Trust Network/OU=Terms of use at https://www.verisign.com/rpa (c)06/CN=VeriSign Class 3 Extended Validation SSL SGC CA':
Unable to locally verify the issuer's authority.
To connect to www.internetx.com insecurely, use `--no-check-certificate'.
Unable to establish SSL connection.</code></pre>
</div>
</section>So we compared the size of the file /etc/ssl/certs/ca-certificates.crt on a working server and this server. Sure enough the file size was different. On further investigation we found that there was a backup called ca-bundle.crt.newrpm that had the correct size. So we took a backup of ca-bundle.crt and replaced it with the newer file. The error stopped coming. Even though the ca-certificates rpm version was same on both servers, someone had replaced the ca-bundle.crt file with the older version. We would have to investigate, why that was done, before this solution can be implemented, as it is possible that the new certificates.crt file broke something, because of which it was replaced by the older version. We should always have the latest ca-bundle.crt, so that we have the latest root certificates from the Certificate Authorities.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-15684291096853799322017-07-16T11:53:00.001-07:002017-07-16T12:00:50.183-07:00acroread on Linux 6<div dir="ltr" style="text-align: left;" trbidi="on">
As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader (acroread) allows users to view and print documents in Portable Document Format (PDF). Adobe Reader 9 reached the end of its support cycle on June 26, 2013, and will not receive any more security updates. Future versions of Adobe Acrobat Reader will not be available with Red Hat Enterprise Linux.<br />
<br />
Some of our ERPs still use acroread for pasta printing. When we did the upgrade of OS to OEL 6, we had to reinstall adobe by getting the rpm from adobe site ftp://ftp.adobe.com/pub/adobe/reader/unix/9.x/9.5.5/enu/ that I got from https://www.reddit.com/r/linux/comments/2hsgq6/linux_version_of_adobe_reader_no_longer/ Fortunately, adobe still hosts it. It is also available from Red Hat if you have a subscription:<br />
<br />
<h2 style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 1.625rem; font-weight: 200; line-height: 1.25em; margin-bottom: 0.625rem; margin-top: 0px; text-rendering: auto;">
Red Hat Enterprise Linux Server 6</h2>
<table class="files" style="background-color: white; border-collapse: collapse; border-spacing: 0px; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 24px; max-width: 100%; width: 1110px;"><tbody style="box-sizing: border-box;">
<tr style="border-radius: 0px; box-sizing: border-box;"><th colspan="2" style="background: transparent; border-top: 0px; box-sizing: border-box; color: #333333; padding: 12px; text-align: left;">SRPM</th></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><th colspan="2" style="background: transparent; border-top: 0px; box-sizing: border-box; color: #333333; padding: 12px; text-align: left;">x86_64</th></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><td class="name" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a href="https://access.redhat.com/downloads/content/rhel---6/x86_64/1673/acroread/9.5.5-1.el6_4.1/i686/fd431d51/package" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; font-family: Overpass, "Liberation Sans", "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", helvetica, verdana, arial, sans-serif; line-height: 18px; text-decoration-line: none; vertical-align: top;">acroread-9.5.5-1.el6_4.1.i686.rpm</a></td><td class="checksum" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: monospace; font-size: 14.4px; padding: 6px 12px; width: auto;">SHA-256: ac0934cfe887c6f49238ebff2c963adc33c1531019660bbfa4f8852d725136a2</td><td class="download" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a class="rpmLink" href="https://access.cdn.redhat.com//content/origin/rpms/acroread/9.5.5/1.el6_4.1/fd431d51/acroread-9.5.5-1.el6_4.1.i686.rpm" rel=" noopener noreferrer" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;" target="_blank">Download</a></td></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><td class="name" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a href="https://access.redhat.com/downloads/content/rhel---6/x86_64/1673/acroread-plugin/9.5.5-1.el6_4.1/i686/fd431d51/package" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; font-family: Overpass, "Liberation Sans", "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", helvetica, verdana, arial, sans-serif; line-height: 18px; text-decoration-line: none; vertical-align: top;">acroread-plugin-9.5.5-1.el6_4.1.i686.rpm</a></td><td class="checksum" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: monospace; font-size: 14.4px; padding: 6px 12px; width: auto;">SHA-256: 8116e41e4825f74478731a7e970482274db5c9d4b9489b9f70ca4e1a278e526b</td><td class="download" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a class="rpmLink" href="https://access.cdn.redhat.com//content/origin/rpms/acroread-plugin/9.5.5/1.el6_4.1/fd431d51/acroread-plugin-9.5.5-1.el6_4.1.i686.rpm" rel=" noopener noreferrer" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;" target="_blank">Download</a></td></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><th colspan="2" style="background: transparent; border-top: 0px; box-sizing: border-box; color: #333333; padding: 12px; text-align: left;">i386</th></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><td class="name" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a href="https://access.redhat.com/downloads/content/rhel---6/i386/1673/acroread/9.5.5-1.el6_4.1/i686/fd431d51/package" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; font-family: Overpass, "Liberation Sans", "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", helvetica, verdana, arial, sans-serif; line-height: 18px; text-decoration-line: none; vertical-align: top;">acroread-9.5.5-1.el6_4.1.i686.rpm</a></td><td class="checksum" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: monospace; font-size: 14.4px; padding: 6px 12px; width: auto;">SHA-256: ac0934cfe887c6f49238ebff2c963adc33c1531019660bbfa4f8852d725136a2</td><td class="download" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a class="rpmLink" href="https://access.cdn.redhat.com//content/origin/rpms/acroread/9.5.5/1.el6_4.1/fd431d51/acroread-9.5.5-1.el6_4.1.i686.rpm" rel=" noopener noreferrer" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;" target="_blank">Download</a></td></tr>
<tr style="border-radius: 0px; box-sizing: border-box;"><td class="name" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a href="https://access.redhat.com/downloads/content/rhel---6/i386/1673/acroread-plugin/9.5.5-1.el6_4.1/i686/fd431d51/package" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; font-family: Overpass, "Liberation Sans", "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", helvetica, verdana, arial, sans-serif; line-height: 18px; text-decoration-line: none; vertical-align: top;">acroread-plugin-9.5.5-1.el6_4.1.i686.rpm</a></td><td class="checksum" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: monospace; font-size: 14.4px; padding: 6px 12px; width: auto;">SHA-256: 8116e41e4825f74478731a7e970482274db5c9d4b9489b9f70ca4e1a278e526b</td><td class="download" style="background: none; border-top: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; padding: 6px 12px; width: auto;"><a class="rpmLink" href="https://access.cdn.redhat.com//content/origin/rpms/acroread-plugin/9.5.5/1.el6_4.1/fd431d51/acroread-plugin-9.5.5-1.el6_4.1.i686.rpm" rel=" noopener noreferrer" style="background: 0px 0px transparent; box-sizing: border-box; color: #0066cc; text-decoration-line: none;" target="_blank">Download</a><br /></td></tr>
</tbody></table>
<table class="files" style="background-color: white; border-collapse: collapse; border-spacing: 0px; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; margin-bottom: 24px; max-width: 100%; width: 1110px;"><tbody style="box-sizing: border-box;"></tbody></table>
<br />After installing the rpm with rpm -ivh AdbeRdr9.5.5-1_i486linux_enu.rpm command, we got dependency error for libxml2.so. On installing libxml2.so, we got error for other missing dependencies. So eventually we did yum install AdbeRdr9.5.5-1_i486linux_enu.rpm which installed about 80 rpms that acroread needs to function.<br />
<br />
After installation, we kept getting this error:<br />
<br />
dirname: missing operand<br />
<br />
The post on http://www.linuxquestions.org/questions/slackware-14/error-message-dirname-missing-operand-when-starting-acroread-827012/ recommended a fix:<br />
<br />
<div>
The issue was fixed by commenting line 529 in the bash script /opt/Adobe/Reader/bin/acrobat<br />
<br />
529 # [ -n "${MozPath}" ] || mozillaPath="`readlink "$MozPath" | xargs dirname`"</div>
<br />
The DBAs were getting this error when they used sudo to login as applmgr:<br />
<br />
Adobe Reader does not need to be run as a privileged user. Please remove 'sudo' from the beginning of the command<br />
<br />
The post on https://forums.freebsd.org/threads/17345/ recommended that we comment line 331,332,333 and 334:<br />
<br />
# Do not allow launch using 'sudo'.<br />
#if [ "${ACRO_ALLOW_SUDO+set}" != "set" -a \( "${SUDO_USER+set}" = "set" -o "${SUDO_UID+set}" = "set" -o "${SUDO_GID}" = "set" \) ]; then<br />
# printf "%s\n" "Adobe Reader does not need to be run as a privileged user. Please remove 'sudo' from the beginning of the command."<br />
# exit 1<br />
#fi<br />
<br />
That fixed the sudo issue.<br />
<br />
I have asked the DBA team to reach out to the Developers to stop using acroread and migrate to an alternative that is natively supported in Linux. Here's more from Red Hat on their security advisory https://access.redhat.com/errata/RHSA-2013:1402 :<br />
<br />
<div style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; line-height: 1.5em; margin-bottom: 1rem;">
Red Hat advises users to reconsider further use of Adobe Reader for Linux,<br />
as it may contain known, unpatched security issues. Alternative PDF<br />
rendering software, such as Evince and KPDF (part of the kdegraphics<br />
package) in Red Hat Enterprise Linux 5, or Evince and Okular (part of the<br />
kdegraphics package) in Red Hat Enterprise Linux 6, should be<br />
considered. These packages will continue to receive security fixes.</div>
<div style="background-color: white; box-sizing: border-box; color: #252525; font-family: Overpass, "Open Sans", Helvetica, sans-serif; font-size: 16px; line-height: 1.5em; margin-bottom: 1rem;">
Red Hat will no longer provide security updates to these packages and<br />
recommends that customers not use this application on Red Hat Enterprise<br />
Linux effective immediately.</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-6014067335459144862016-12-16T15:38:00.001-08:002016-12-16T15:38:18.007-08:00Demantra setup.exe does nothing on Windows 7<div dir="ltr" style="text-align: left;" trbidi="on">
Last evening, Mukhtiar called me to assist in Demantra installation on Windows. By the time we got on screen share, he had already downloaded patch 2195481 and installed JDK 1.8.0_77. However, when he clicked setup.exe, nothing happened. We tried these :<br />
<br />
1. Right click on setup.exe > Click Properties > Compatibility Tab > Run this program in compatibility mode for Windows XP<br />
2. Run the program as Administrator<br />
3. Tried changing registy settings as per some microsoft technotes<br />
<br />
However nothing worked.<br />
<br />
We located a file called setup.lax that was a configuration file for the installer and switched on stderr=console<br />
<br />
However it showed a command window that used to disappear in a flash.<br />
<br />
We tried uninstalling JDK 1.8.0_77 and installing JDK 1.7<br />
<br />
Setting environment variable JAVA_HOME as described Demantra installation guide on https://docs.oracle.com/cd/E26401_01/doc.122/e22516/T573380T574948.htm<br />
<br />
<h3 style="color: #222222; font-family: Tahoma, sans-serif; font-size: 18.07px; line-height: normal;">
<b>JAVA_HOME System Environment Variable</b></h3>
<a href="https://www.blogger.com/null" name="d0e8324" style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;"></a><span style="background-color: white; color: #222222; font-family: Tahoma, sans-serif; font-size: x-small;"></span><br />
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
If the client machine does not have JDK version 1.6 or 1.7 installed, the Installer prompts you to download and install it. After installation, set JAVA_HOME to the JDK installation directory (for example, C:\Program Files\Java\jdk1.6.0_16).</div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
Nothing worked.</div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
Mukhtiar located a blog that advised setting java heap size to 512m by setting this environment variable:</div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<span style="background-color: white;">_JAVA_OPTIONS = -Xmx512M</span></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<span style="background-color: white;"><br /></span></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<span style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;">The </span><b style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;">Java</b><span style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;"> Virtual Machine takes two command line arguments which set the initial and maximum </span><b style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;">heap</b><span style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;"> sizes: -Xms and -Xmx. You can add a system </span><b style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;">environment variable</b><span style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;"> named _JAVA_OPTIONS, and set the </span><b style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;">heap size</b><span style="background-color: white; font-family: Roboto, arial, sans-serif; font-size: 16px;"> values there</span></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
As soon as this environment variable was set, setup.exe finally launched. All this time it was erroring out as the default 256MB was insufficient for starting the installer.</div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
There was information about Out of Memory error on the installation guide too, but we had missed that:</div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<b style="font-size: 18.07px;"><br /></b></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<b style="font-size: 18.07px;">Out of Memory Error Message</b></div>
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
Verify memory settings:</div>
<ol style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
<li>From the Windows Start menu, choose Settings, Control Panel, and then Java. The Java Control Panel dialog box appears.</li>
<li>Click the Java Tab.</li>
<li>From the Java Applet Runtime Settings section, click View.</li>
<li>Verify that the value of the field Java Runtime Parameters is at least -Xmx256M and is based on the client machine hardware/RAM capacity. Oracle recommends value -Xmx512M for heavy-duty client side use.</li>
</ol>
<br />
<br />
<br />
<br /></div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-7427093712910700252016-03-15T14:00:00.001-07:002016-03-15T14:00:18.757-07:00Presenting in Collaborate 2016<div dir="ltr" style="text-align: left;" trbidi="on">
I am presenting in OAUG Collaborate 2016 about our experiences with running E-Business Suite on Engineered Systems - Exadata, Exalogic, ZFS and PCA. Session Details:<br />
<br />
https://collaborate.zerista.com/event/member/223628<br />
<br />
Please attend, if you are coming to OAUG Collaborate.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-36813657169236446092016-01-14T08:15:00.002-08:002016-01-14T08:16:52.881-08:00Extranet login redirects to intranet URL<div dir="ltr" style="text-align: left;" trbidi="on">
For an old 11.5.10.2 ERP, we are moving from the architecture of "EBS application server in DMZ" to the architecture of "Reverse Proxy in DMZ and EBS application server in intranet". After doing all configurations, we hit the classic issue where, you login through extranet url visible on public internet which redirects to intranet url.<br />
<div>
<br /></div>
<div>
So https://extranet.example.com asks for SSO details and after keying in SSO username and password goes to http://intranet.example.com.</div>
<div>
<br /></div>
<div>
The support.oracle.com article DMZ Configuration with Oracle E-Business Suite 11i (Doc ID 287176.1) has listed 4 checks which could be the reason for this issue:</div>
<div>
<br /></div>
<div>
<h3 class="km" style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 13.65px; padding-top: 0.5em; width: 1163px;">
<span class="OraFieldText">H6: </span>Redirection to an Incorrect Server During Login</h3>
<div style="background-color: white; font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
If you are getting redirected to an incorrect server during the login process, check the following:</div>
<ul style="background-color: white;">
<li style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">Whether the hirearchy type of the profile options mentioned in <span class="OraFieldText"><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_afrLoop=462809811361128&_afrWindowMode=0&_adf.ctrl-state=143c9uicci_65#Section5.1">Section 5.1</a> is set to </span>SERVRESP .</li>
<blockquote style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
<pre style="font-size: 13.3333px;">select PROFILE_OPTION_NAME,HIERARCHY_TYPE from fnd_profile_options where profile_option_name in
('APPS_WEB_AGENT','APPS_SERVLET_AGENT','APPS_JSP_AGENT','APPS_FRAMEWORK_AGENT' ,'ICX_FORMS_LAUNCHER','ICX_DISCOVERER_LAUNCHER','ICX_DISCOVERER_VIEWER_LAUNCHER','HELP_WEB_AGENT','APPS_PORTAL','CZ_UIMGR_URL','ASO_CONFIGURATOR_URL','QP_PRICING_ENGINE_URL','TCF:HOST');</pre>
</blockquote>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">PROFILE_OPTION_NAME HIERARCHY_TYPE</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">---------------------------------------- --------------------------------</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">APPS_FRAMEWORK_AGENT<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">APPS_JSP_AGENT<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">APPS_PORTAL<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">APPS_SERVLET_AGENT<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">APPS_WEB_AGENT<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">ASO_CONFIGURATOR_URL<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">CZ_UIMGR_URL<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">HELP_WEB_AGENT<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">ICX_DISCOVERER_LAUNCHER<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">ICX_DISCOVERER_VIEWER_LAUNCHER<span class="Apple-tab-span" style="white-space: pre;"> </span>SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">ICX_FORMS_LAUNCHER<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">QP_PRICING_ENGINE_URL<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;">TCF:HOST<span class="Apple-tab-span" style="white-space: pre;"> </span> SERVRESP</span></span><br />
<span style="font-family: Arial, Helvetica, Geneva, sans-serif;"><span style="font-size: 13.3333px;"><br /></span></span>
<div style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
All good on this point</div>
<div style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
<br /></div>
<li style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">Whether the profile option values for the fnd profile options (APPS_FRAMEWORK_AGENT, APPS_WEB_AGENT, APPS_JSP_AGENT, APPS_SERVLET_AGENT) are pointing to the correct node. Replace the node_id with the node_id of the external and internal web tier. For example:</li>
<blockquote style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
<pre style="font-size: 13.3333px;">select fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',null,null,null,null,<node_id>) from dual;</node_id></pre>
</blockquote>
This query returned https://extranet.example.com<br />
<br />
<li style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">Whether the dbc file pointed to by the JVM parameter (JTFDBCFILE) in jserv.properties exists.</li>
<blockquote style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">
<pre style="font-size: 13.3333px;">wrapper.bin.parameters=-DJTFDBCFILE=<location-of-your-dbc-file></location-of-your-dbc-file></pre>
</blockquote>
This was incorrect. It was pointing to the intranet jdbc file location.<br />
<br />
<li style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 10pt;">Whether the value of the parameter APPL_SERVER_ID set in the dbc file for the node is the same as the value of the server_id in the fnd_nodes table.<blockquote>
<pre style="font-size: 13.3333px;">select node_name,node_id,server_id from fnd_nodes;</pre>
</blockquote>
This was overwritten in the dbc file, with appl_server_id of intranet when autoconfig was done on intranet and overwritten with appl_server_id of extranet when autoconfig was done on extranet, as the DBC file location and name were same for both intranet and extranet.</li>
</ul>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;">I asked the DBA team to manually correct the dbc file name inside $IAS_CONFIG_HOME/Apache/Apache/Jserv/etc/jserv.properties</span></div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;">and create a file of that name in $FND_SECURE/$CONTEXT_NAME.dbc on the extranet node and bounce services. Once that was done, we tested and it worked. No more redirection to intranet URL.</span></div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;">Then I asked them to correct the s_dbc_file_name variable in the context file of extranet node. Run autoconfig on extranet, verify the value of dbcfile in jserv.properties DJTFDBCFILE parameter, verify that the DBC file had the server_id of the extranet node. Restart all services.</span></div>
</div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;">Checked again, and it worked again.</span></div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 13.3333px;">So apart from checking the values of context file variables like s_webentryhost, s_webentrydomain, s_active_port, you also need to check the value of s_dbc_file while verifying the setups for extranet configuration. This can happen in 11i , R12.1 and R12.2 also.</span></div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-22189721363776834162015-12-22T07:02:00.003-08:002015-12-22T07:02:40.245-08:00Calling all Apps DBAs doing 11i to R12.x upgrades<div dir="ltr" style="text-align: left;" trbidi="on">
At this time of the year during holidays, the Apps DBA community is busy doing upgrades as longer downtimes are possible. In case you are facing any issues, please feel free to write to me at my email: oracleappstechnology@gmail.com . I will be glad to hear from you and help you.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com1tag:blogger.com,1999:blog-6335343228190511009.post-22186977178904175542015-12-16T18:51:00.002-08:002015-12-16T18:51:33.618-08:0011i pre-upgrade data fix script ap_wrg_11i_chrg_alloc_fix.sql runs very slow<div dir="ltr" style="text-align: left;" trbidi="on">
We are currently upgrading one of our ERP instances from 11.5.10.2 to R12.2.5. One of the pre-upgrade steps is to execute the data fix script ap_wrg_11i_chrg_alloc_fix.sql. However, this script has been running very very slow. After 4 weeks of monitoring, logging SRs with Oracle, escalating etc., we started a group chat today with our internal experts. We had Ali, Germaine, Aditya, Mukhtiar, Martha Gomez and Zoltan. I also invited our top notch EBS Techstack expert John Felix. After doing explain plan on the sql, Based on the updates being done by the query I predicted that it will take 65 days to complete.<br />
<br />
John pointed out that the query was using the index AP_INVOICE_DISTRIBUTIONS_N4 that had a very high cost. We used an sql profile that replaced AP_INVOICE_DISTRIBUTIONS_N4 with AP_INVOICE_DISTRIBUTIONS_U1. The query started running faster and my new prediction was that it would complete in 5.45 days.<br />
<br />
John mentioned that now another select statement was using the same index AP_INVOICE_DISTRIBUTIONS_N4 that had a very high cost.<br />
<br />
After discussing among ourselves, we decided to drop the index, run the script and re-create the index. Aditya saved the definition of the index and dropped it.<br />
<br />
DBMS_METADATA.GET_DDL('INDEX','AP_INVOICE_DISTRIBUTIONS_N4','AP')<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
<br />
CREATE INDEX "AP"."AP_INVOICE_DISTRIBUTIONS_N4" ON "AP"."AP_INVOICE_DISTRIBUTIONS_ALL" ("ACCOUNTING_DATE")<br />
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS<br />
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645<br />
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1<br />
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)<br />
TABLESPACE "APPS_TS_TX_IDX"<br />
<br />
1 row selected.<br />
<br />
SQL> drop index AP.AP_INVOICE_DISTRIBUTIONS_N4;<br />
<br />
Index dropped.<br />
<br />
The updates started happening blazing fast. The whole thing got done in 39 minutes and we saw the much awaited:<br />
<br />
SQL> set time on<br />
16:34:16 SQL> @ap_wrg_11i_chrg_alloc_fix.sql<br />
Enter value for resp_name: Payables Manager<br />
Enter value for usr_name: 123456<br />
-------------------------------------------------------------------------------<br />
/erp11i/applcsf/temp/9570496-fix-16:34:40.html is the log file created<br />
-------------------------------------------------------------------------------<br />
<br />
PL/SQL procedure successfully completed.<br />
<br />
17:13:36 SQL><br />
<br /><div>
From 65 days to 5.45 days to 39 minutes. Remarkable. Thank you John for your correct diagnosis and solution.</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-52132718453219801322015-11-16T14:23:00.002-08:002015-11-19T05:47:36.765-08:00sqlplus core dumps with segmentation fault error in OEL 6.6 when you connect to DB<div dir="ltr" style="text-align: left;" trbidi="on">
We have used OEL 6.6 image in our latest build. When we cloned an EBS R12.2 instance that was on OEL 5.7 to this new server that has OEL 6.6, During the clone, adcfgclone.pl was failing. On further checks, we discovered that sqlplus is crashing with segmentation fault error whenever we tried to connect to database:<br />
<br />
sqlplus /nolog<br />
conn apps/apps<br />
Segmentation Fault<br />
<br />
So, I suggested the DBAs to do strace sqlplus apps/apps. The strace revealed many missing libraries:<br />
<br />
We had another working OEL 6.4 instance where we checked for these libraries, and all of them were present.<br />
<br />
The locate command was used to locate the full directory paths of the missing libraries<br />
<div>
<br /></div>
<div>
locate libnss_sss.so.2</div>
<div>
/lib/libnss_sss.so.2</div>
<div>
<br /></div>
<div>
/lib/libnss_sss.so.2<br />
/lib/libnss_files.so.2<br />
/lib/libociei.so<br />
/lib/libc.so.6<br />
/lib/libgcc_s.so.1<br />
/lib/libnsl.so.1<br />
/lib/libpthread.so.0</div>
<div>
<br /></div>
<div>
Then rpm -qf command was used to find out the rpm that would have the library:</div>
<div>
<br /></div>
<div>
<div>
$ rpm -qf /lib/libnss_sss.so.2</div>
<div>
sssd-client-1.11.6-30.el6_6.3.i686</div>
<div>
$ rpm -qf /lib/libnss_files.so.2</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
<div>
$ rpm -qf /lib/libociei.so</div>
<div>
error: file /lib/libociei.so: No such file or directory</div>
<div>
$ rpm -qf /lib/libc.so.6</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
<div>
$ rpm -qf /lib/libgcc_s.so.1</div>
<div>
libgcc-4.4.7-3.el6.i686</div>
<div>
$ rpm -qf /lib/libnsl.so.1</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
<div>
$ rpm -qf /lib/libpthread.so.0</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
<div>
$ rpm -qf /lib/libm.so.6</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
<div>
$ rpm -qf /lib/libdl.so.2</div>
<div>
glibc-2.12-1.149.el6_6.9.i686</div>
</div>
<div>
<br /></div>
<div>
Since 10.1.2 home is 32-bit in EBS R12.1 and 12.2, all the libraries needed to be 32-bit.</div>
<div>
<br /></div>
<div>
Except for sssd-client, the other rpms were present. 64-bit version of sssd-client was present and whenver we tried to install the 32-bit rpm it would give this error, as the operating system thinks that it is already installed:</div>
<div>
<br /></div>
<div>
<div>
# yum install sssd-client.i686</div>
<div>
Loaded plugins: security</div>
<div>
Setting up Install Process</div>
<div>
Resolving Dependencies</div>
<div>
--> Running transaction check</div>
<div>
---> Package sssd-client.i686 0:1.12.4-47.el6 will be installed</div>
<div>
--> Finished Dependency Resolution</div>
<div>
Error: Multilib version problems found. This often means that the root</div>
<div>
cause is something else and multilib version checking is just</div>
<div>
pointing out that there is a problem. Eg.:</div>
<div>
<br /></div>
<div>
1. You have an upgrade for sssd-client which is missing some</div>
<div>
dependency that another package requires. Yum is trying to</div>
<div>
solve this by installing an older version of sssd-client of the</div>
<div>
different architecture. If you exclude the bad architecture</div>
<div>
yum will tell you what the root cause is (which package</div>
<div>
requires what). You can try redoing the upgrade with</div>
<div>
--exclude sssd-client.otherarch ... this should give you an error</div>
<div>
message showing the root cause of the problem.</div>
<div>
<br /></div>
<div>
2. You have multiple architectures of sssd-client installed, but</div>
<div>
yum can only see an upgrade for one of those arcitectures.</div>
<div>
If you don't want/need both architectures anymore then you</div>
<div>
can remove the one with the missing update and everything</div>
<div>
will work.</div>
<div>
<br /></div>
<div>
3. You have duplicate versions of sssd-client installed already.</div>
<div>
You can use "yum check" to get yum show these errors.</div>
<div>
<br /></div>
<div>
...you can also use --setopt=protected_multilib=false to remove</div>
<div>
this checking, however this is almost never the correct thing to</div>
<div>
do as something else is very likely to go wrong (often causing</div>
<div>
much more problems).</div>
<div>
<br /></div>
<div>
Protected multilib versions: sssd-client-1.12.4-47.el6.i686 != sssd-client-1.11.6-30.el6_6.4.x86_64</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
# rpm -qa | grep sssd-client</div>
<div>
sssd-client-1.11.6-30.el6_6.4.x86_64</div>
</div>
<div>
<br /></div>
<div>
Eventually we installed it with force option</div>
<div>
<br /></div>
<div>
<div>
# rpm -Uvh --force /tmp/sssd-client-1.11.6-30.el6_6.3.i686.rpm</div>
<div>
<br /></div>
<div>
# rpm -qa | grep sssd-client</div>
<div>
sssd-client-1.11.6-30.el6_6.3.i686</div>
<div>
sssd-client-1.11.6-30.el6_6.4.x86_64</div>
</div>
<div>
<br /></div>
<div>
pam-ldap was one of the other rpms that was installed for other missing libraries. Surprisingly, sssd-client and pam-ldap rpms are not mentioned as pre-requisites in support.oracle.com article:</div>
<div>
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1) </div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com4tag:blogger.com,1999:blog-6335343228190511009.post-59933161862111737012015-11-16T13:59:00.002-08:002017-05-01T08:37:49.418-07:00vnc xterm window appears without header<div dir="ltr" style="text-align: left;" trbidi="on">
The program twm is "the window manager" that is responsible for the window header that appears on top of terminal windows of xterm. In newer OEL 6 builds, when xterm is launched, the header doesn't appear as twm fails to launch. If you try launching twm, it gives this error and exits to unix prompt:<br />
<br />
twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"<br />
<br />
I found a solution on http://ubuntuforums.org/archive/index.php/t-1596636.html :<br />
<br />
It was reported here for fedora: https://bugzilla.redhat.com/show_bug.cgi?id=509639. The workaround is to execute it with a specific shell variable:<br />
<br />
$ DISPLAY=:vnc port number<vnc port=""></vnc><br />
$ export DISPLAY<br />
$ xhost +<br />
$ LANG=C<br />
$ export LANG<br />
twm &<br />
<br />
twm launches fine after this.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-8783464416119407912015-11-14T12:57:00.001-08:002015-11-14T12:57:12.803-08:00Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured<div dir="ltr" style="text-align: left;" trbidi="on">
Today, during a cutover when we were moving one of our ERP instance on Cisco UCS VMware VMs to Exalogic and Exadata, I got a call from Bimal. The extranet iSupplier URL had been configured, but whenever any user logged in, they were seeing the following error instead of the iSupplier OAF Home page:<br />
<br />
Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured<br />
<br />
A search on support.oracle.com showed many hits. I went through a few of them and ruled out the solutions given. This article sounded promising: Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured (Doc ID 1474474.1).<br />
<br />
The solution suggested:<br />
<br />
There is a hardware load-balancer for a multi-tier environment on place, as well as an SSL accelerator.<br />
<br />
For R12, there is a context variable, s_enable_sslterminator, that was set to "#".<br />
<br />
This should be null for e-Business R12 using specific hardwarementioned before. <br />
<br />
<br />
1. Set context variable, s_enable_sslterminator to null,<br />
<br />
2. Re-ran autoconfig,<br />
<br />
3. Re-test Single sign-ons via IE and Firefox now works as expected.<br />
<br />
I asked the DBAs to check the value of s_enable_sslterminator:<br />
<br />
grep s_enable_sslterminator<br />
<br />
and sure enough the value was #<br />
<br />
As per article Enabling SSL or TLS in Oracle E-Business Suite Release 12 (Doc ID 376700.1), the value of s_enable_sslterminator should be made null if you are using an SSL accelerator. In our case we use SSL certificate on the Load Balancer and never on Web servers.<br />
<br />
The DBAs removed the #<br />
Ran autoconfig<br />
Deregistered SSO<br />
Registered SSO<br />
<br />
The user was able to login after that.<br />
<br />
<br />
<br /></div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-62345378766151145292015-10-21T14:48:00.001-07:002015-10-21T14:53:12.941-07:00How To Install Latest Verisign G5 Root Certificates<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif;">Dhananjay pinged me today and told me that for their Paypal integration, they had to upgrade to Verisign G5 root certificate. This was the message from Paypal:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div style="background-color: white; font-size: 13px; margin-bottom: 10px; margin-top: 10px; padding: 0px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Global security threats are constantly changing, and the security of our merchants continues to be our highest priority. To guard against current and future threats, we are encouraging our merchants to make the following upgrades to their integrations:</span></div>
<ol style="background-color: white; font-size: 13px;">
<li style="padding-bottom: 6px;"><span style="font-family: Arial, Helvetica, sans-serif;"><strong>Update your integration to support certificates using the SHA-256 algorithm.</strong> PayPal is upgrading SSL certificates on all Live and Sandbox endpoints from SHA-1 to the stronger and more robust SHA-256 algorithm.</span></li>
<li style="padding-bottom: 6px;"><span style="font-family: Arial, Helvetica, sans-serif;"><strong>Discontinue use of the VeriSign G2 Root Certificate.</strong> In accordance with industry standards, PayPal will no longer honor secure connections that require the VeriSign G2 Root Certificate for trust validation. Only secure connection requests that are expecting our certificate/trust chain to be signed by the <a href="https://knowledge.symantec.com/support/mpki-for-ssl-support/index?page=content&actp=CROSSLINK&id=SO5624" style="color: #0079c1; text-decoration: none;" target="_blank">G5 Root Certificate</a> will result in successful secure connections.</span></li>
</ol>
<div style="background-color: white; font-size: 13px; margin-bottom: 10px; margin-top: 10px; padding: 0px;">
<span style="font-family: Arial, Helvetica, sans-serif;">For detailed information on these changes, please reference the <a href="https://www.paypal-knowledge.com/resources/sites/PAYPAL/content/live/FAQ/1000/FAQ1766/en_US/2015%20Merchant%20Security%20System%20Upgrade%20Guide%20(U.S.%20English).pdf" style="color: #0079c1; text-decoration: none;" target="_blank">Merchant Security System Upgrade Guide</a>. For a basic introduction to internet security, we also recommend these short videos on <a href="https://www.youtube.com/watch?v=SJJmoDZ3il8" style="color: #0079c1;" target="_blank">SSL Certificates</a> and <a href="https://www.youtube.com/watch?v=3QnD2c4Xovk" style="color: #0079c1;" target="_blank">Public Key Cryptography</a>.</span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">There is a support.oracle.com article published on October 16, 2015 which has detailed steps for 11i and R12.1: </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">How To Install Latest Verisign Root Certificates For Use With Paypal SDK 4.3.X (Doc ID 874433.1)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">The Verisign G5 root certificate can be downloaded from:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Paypal Microsite about this change: https://www.paypal-knowledge.com/infocenter/index?page=content&id=FAQ1766&expand=true&locale=en_US</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<h3 style="background-color: white; font-size: 14.3px; line-height: 24px; margin: 10px 0px 0px; padding: 0px;">
<span style="font-family: Arial, Helvetica, sans-serif;">
Useful Links</span></h3>
<ul style="background-color: white; font-size: 13px; margin: 10px 0px 0px 15px; padding: 0px;">
<li><span style="font-family: Arial, Helvetica, sans-serif;">Download <a href="https://knowledge.verisign.com/support/mpki-for-ssl-support/index?page=content&actp=CROSSLINK&id=SO5624" style="color: #0079c1;" target="_blank">Symantec’s VeriSign G5 Root Certificate</a></span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Download <a href="https://www.paypal-knowledge.com/infocenter/index?page=content&widgetview=true&id=FAQ1510&viewlocale=en_EN" style="color: #0079c1;">specific server SSL certificates</a>, if required by your server</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Contact <a href="https://www.paypal-techsupport.com/app/ask" style="color: #0079c1;" target="_blank">PayPal Technical Support</a></span></li>
</ul>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-784226159880226512015-10-09T19:36:00.001-07:002015-10-09T19:36:15.460-07:00sftp failure due to newline character difference between windows and unix.<div dir="ltr" style="text-align: left;" trbidi="on">
Recently I spent almost a full day struggling to make out, why an sftp connection would not work without password, after setting up ssh equivalence. The keys were correct, the permissions on the directories were correct. The authorized_keys file looked ok. I copied the authorized_keys file of another account that was working fine. When I replaced the authorized_keys after taking backup of original authorized_keys, it started working. So then I proceeded to check the contents in a hex editor<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaBE9J5tjWFh46HAE4RXGYnUM0yTU437zo2eDyftdwIMi63pB7H0KSrlFihfn42mwk6bVEnWDc8Lhok_IoJDTdmCZHTKLM_T-9MYoBMTUPAICIRXb57pZ9GgWyohNZ965fEiW6kULiwF4i/s1600/authorized_keys_difference_in_windows_and_unix.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaBE9J5tjWFh46HAE4RXGYnUM0yTU437zo2eDyftdwIMi63pB7H0KSrlFihfn42mwk6bVEnWDc8Lhok_IoJDTdmCZHTKLM_T-9MYoBMTUPAICIRXb57pZ9GgWyohNZ965fEiW6kULiwF4i/s320/authorized_keys_difference_in_windows_and_unix.JPG" width="273" /></a></div>
<br />
On the left side you have the authorized_keys file created in Windows.<br />
On the right side you have the same authorized_keys file created in Unix.<br />
<br />
If you notice the ends of the lines in the Windows file it shows CR LF, where as unix shows LF.<br />
<br />
This difference is well described in the <a href="https://en.wikipedia.org/wiki/Newline">wikipedia article</a> on newline character.<br />
<br />
The one mistake I had done this time was create the authorized_keys file in Windows notepad, as I was teaching a Developer how to create authorized_keys file. Once I used vi on unix to create the authorized_keys file and pasted the same ssh key, sftp started working without prompting for password. I know that Windows/DOS and Unix have different newline characters. However, I was not able to apply that knowledge, till I compared the files in hex editor.<br />
<br />
Whenever, a techie is able to get to the root cause of a problem, a deep sense of satisfaction is experienced. I am glad I got the opportunity to troubleshoot and fix the issue by getting to the root cause of the issue.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-52854861536354945262015-09-15T01:50:00.002-07:002015-10-09T19:26:01.544-07:00Copycat blog<div dir="ltr" style="text-align: left;" trbidi="on">
While doing a google search today I noticed that there is another blog that has copied all content from my blog and posted it as their own content and even kept a similar sounding name: http://oracleapps-technology.blogspot.com . I have made a DMCA complaint to google about this. The google team asked me to provide a list of URLs. I had to go through the copycat's whole blog and create a spreadsheet with two columns. One column with URL of my original post and second column with the URL of the copycat's blog. There were 498 entries. I patiently did it and sent the spreadsheet to google team and got a reply within 2 hours:<br />
<br />
<br />
<div dir="ltr" id="yiv9923064440" style="background-color: white; font-family: 'Helvetica Neue', 'Segoe UI', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">
Hello,<br clear="none" /></div>
<div dir="ltr" id="yui_3_16_0_1_1444443645857_2248" style="background-color: white; font-family: 'Helvetica Neue', 'Segoe UI', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">
<div dir="ltr" id="yiv9923064440">
In accordance with the Digital Millennium Copyright Act, we have completed processing your infringement notice. We are in the process of disabling access to the content in question at the following URL(s):<br clear="none" /><br clear="none" />http://oracleapps-technology.blogspot.com/<br clear="none" /><br clear="none" />The content will be removed shortly.</div>
<div dir="ltr" id="yiv9923064440">
<br clear="none" />Regards,<br clear="none" />The Google Team </div>
</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com1tag:blogger.com,1999:blog-6335343228190511009.post-53915208210639106162015-06-22T10:23:00.000-07:002015-06-22T10:23:03.795-07:00Server refused public-key signature despite accepting key!<div dir="ltr" style="text-align: left;" trbidi="on">
A new SFTP connection was not working, even though everything looked fine:<br />
<br />
1. Permissions were correct on directories:<br />
chmod go-w $HOME/<br />
chmod 700 $HOME/.ssh<br />
chmod 600 $HOME/.ssh/authorized_keys<br />
chmod 600 $HOME/.ssh/id_rsa<br />
chmod 644 $HOME/.ssh/id_rsa.pub<br />
chmod 644 $HOME/.ssh/known_hosts<br />
<div>
<br /></div>
<div>
2. Keys were correctly placed</div>
<div>
<br /></div>
<div>
However, it still asked for password, whenever SFTP connection was done:</div>
<div>
<br /></div>
<div>
<div>
Using username "sftpuser".</div>
<div>
Authenticating with public key "rsa-key-20150214"</div>
<div>
Server refused public-key signature despite accepting key!</div>
<div>
Using keyboard-interactive authentication.</div>
<div>
Password:</div>
</div>
<div>
<br /></div>
<div>
I tried various things, none worked and I eventually went back to my notes for SFTP troubleshooting:</div>
<div>
<br /></div>
<div>
1. Correct Permissions</div>
<div>
<div>
chmod go-w $HOME/</div>
<div>
chmod 700 $HOME/.ssh</div>
<div>
chmod 600 $HOME/.ssh/authorized_keys</div>
<div>
chmod 600 $HOME/.ssh/id_rsa</div>
<div>
chmod 644 $HOME/.ssh/id_rsa.pub</div>
<div>
chmod 644 $HOME/.ssh/known_hosts</div>
<div>
<br /></div>
<div>
2. Make sure the owner:group on the directories and files is correct:</div>
<div>
<br /></div>
<div>
ls -ld $HOME/</div>
<div>
ls -ld $HOME/.ssh</div>
<div>
ls -ltr $HOME/.ssh</div>
<div>
<br /></div>
<div>
3. Login as root</div>
<div>
<br /></div>
<div>
chown user:group $HOME </div>
<div>
chown user:group $HOME/.ssh</div>
<div>
chown user:group $HOME/.ssh/authorized_keys</div>
<div>
chown user:group $HOME/.ssh/id_rsa</div>
<div>
chown user:group $HOME/.ssh/id_rsa.pub</div>
<div>
chown user:group $HOME/.ssh/known_hosts</div>
<div>
<br /></div>
<div>
4. Check for user entries in /etc/passwd and /etc/shadow</div>
<div>
<br /></div>
<div>
5. grep user /etc/shadow</div>
</div>
<div>
<br /></div>
<div>
When I did the 5th step, I found that /etc/shadow entry for the user didn't exist. So I did these steps:</div>
<div>
<br /></div>
<div>
chmod 600 /etc/shadow</div>
<div>
vi /etc/shadow</div>
<div>
Insert this new line at the end</div>
<div>
<div>
sftpuser:UP:::::::</div>
</div>
<div>
Save File</div>
<div>
chmod 400 /etc/shadow</div>
<div>
<br /></div>
<div>
It started working after that.</div>
<div>
<br /></div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-16960932326149690662015-05-13T16:11:00.002-07:002015-05-28T11:20:31.525-07:00java.sql.SQLException: Invalid number format for port number<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Jim pinged me with this error today:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">on
./adgendbc.sh i get<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Creating
the DBC file...<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">java.sql.SQLRecoverableException:
No more data to read from socket raised validating GUEST_USER_PWD<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">java.sql.SQLRecoverableException:
No more data to read from socket<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Updating
Server Security Authentication<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">java.sql.SQLException:
Invalid number format for port number<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Database
connection to jdbc:oracle:thin:@host_name:port_number:database failed<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">to this
point, this is what i've tried.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">clean,
autoconfid on db tier, autoconfig on cm same results<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">bounced
db and listener.. same thing.. nothing i've done has made a difference<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">I
noticed that when this error was coming the DB alert log was showing:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Wed May
13 18:50:51 2015<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Exception
[type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x10A2FFB<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">C8,
joet_create_root_thread_group()+136] [flags: 0x0, count: 1]<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Errors
in file /r12.1/admin/diag/rdbms/erp/erp/trace/erp_ora_1</span><span style="font-family: 'GE Inspira', sans-serif;">4528.trc (incident=1002115):</span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">ORA-07445:
exception encountered: core dump [joet_create_root_thread_group()+136<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">]
[SIGSEGV] [ADDR:0x8] [PC:0x10A2FFBC8] [Address not mapped to object] []<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Incident
details in: /r12.1/admin/diag/rdbms/erp/erp/incident/incdi</span><span style="font-family: 'GE Inspira', sans-serif;">r_1002115/erp_ora_14528_i1002115.trc</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Metalink
search revealed this article:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span style="background: white; font-family: Tahoma, sans-serif; font-size: 10.5pt;">Java Stored Procedure Fails With ORA-03113 And
ORA-07445[JOET_CREATE_ROOT_THREAD_GROUP()+145] (Doc ID 1995261.1)</span></b><span style="font-family: "GE Inspira","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">It seems
that the post patch steps for a PSU OJVM patch were not done. We followed the steps given in above note
were note completed. We completed these and adgendbc.sh completed successfully after
that.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: 'Courier New'; font-size: 9pt;">1.set the following init parameters so that JIT and job process do
not start.<br />
<br />
If spfile is used:<br />
<br />
SQL> alter system set java_jit_enabled = FALSE;<br />
SQL> alter system set "_system_trig_enabled"=FALSE;<br />
SQL> alter system set JOB_QUEUE_PROCESSES=0;<br />
<br />
2. Startup instance in restricted mode and run postinstallation step.<br />
<br />
SQL> startup restrict<br />
<br />
3.Run the postinstallation steps of OJVM PSU(Step 3.3.2 from readme)<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;">
<b><span style="color: #336699; font-family: "Arial","sans-serif"; font-size: 15.5pt; mso-fareast-font-family: "Times New Roman";">Postinstallation<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Arial, sans-serif; font-size: 12pt;">The
following steps load modified SQL files into the database. For an Oracle RAC
environment, perform these steps on only one node.<o:p></o:p></span></div>
<ol start="1" type="1">
<li class="MsoNormal" style="background: white;"><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Install the SQL portion of the patch by running the
following command. For an Oracle RAC environment, reload the packages on
one of the nodes.<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">2.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">cd $ORACLE_HOME/sqlpatch/19282015<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">3.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">sqlplus /nolog<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">4.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">SQL> CONNECT / AS SYSDBA<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">5.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">SQL> @postinstall.sql<o:p></o:p></span></div>
<ol start="6" type="1">
<li class="MsoNormal" style="background: white;"><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">After installing the SQL portion of the patch, some
packages could become INVALID. This will get recompiled upon access or you
can run </span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #336699; font-family: 'Courier New'; font-size: 12pt;">utlrp.sql</span><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> to get them back into a VALID state.<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">7.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">cd $ORACLE_HOME/rdbms/admin<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">8.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">sqlplus /nolog<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; mso-list: l0 level1 lfo1; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: 'Courier New'; font-size: 12pt;">9.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: 'Courier New'; font-size: 12pt;">SQL> CONNECT / AS SYSDBA<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 12.2pt; margin-left: .5in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="font-family: 'Courier New'; font-size: 12pt;">SQL> @utlrp.sql<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: 'Courier New'; font-size: 9pt;"><br />
<br />
4. Reset modified init parameters<br />
<br />
SQL> alter system set java_jit_enabled = true;<br />
SQL> alter system set "_system_trig_enabled"=TRUE;<br />
SQL> alter system set JOB_QUEUE_PROCESSES=10;<br />
-- or original JOB_QUEUE_PROCESSES
value<br />
<br />
5.Restart instance as normal<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: 'Courier New'; font-size: 9pt;">6.Now execute the Java stored procedure. <o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<span style="font-family: "GE Inspira","sans-serif";">Ran
adgendbc.sh and it worked fine.<o:p></o:p></span></div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-74013638039650916442015-04-29T22:21:00.002-07:002015-04-29T22:21:39.856-07:00R12.2 Single file system<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif;">With the release of AD and TXK Delta 6, Oracle has provided the feature of single file system on development instances for R12.2. Here's what they have mentioned in support.oracle.com article: <b><span style="background: white; font-size: 10.5pt;">Oracle
E-Business Suite Applications DBA and Technology Stack Release Notes for
R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)</span></b></span><br />
<div class="MsoNormal">
<b><span style="font-family: Arial, Helvetica, sans-serif;">Enhancements
in AD and TXK Delta 6<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<h3 style="background: white;">
<span style="color: #333333; font-size: 10pt;"><span style="font-family: Arial, Helvetica, sans-serif;">4. New and Changed
Features<o:p></o:p></span></span></h3>
<div style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">Oracle
E-Business Suite Technology Stack and Oracle E-Business Suite Applications DBA
contain the following new or changed features in<span class="apple-converted-space"> </span>R12.AD.C.Delta.6 and
R12.TXK.C.Delta.6.<o:p></o:p></span></div>
<h4 style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.blogger.com/null" name="4.1"></a><span style="color: #666666; font-size: 10pt;">4.1
Support for single file system development environments<o:p></o:p></span></span></h4>
<ul type="disc">
<li class="MsoNormal" style="background: white;"><span style="font-family: Arial, Helvetica, sans-serif;">A
normal Release 12.2 online patching environment requires one application
tier file system for the run edition, and another for the patch edition.
This dual file system architecture is fundamental to the patching of
Oracle E-Business Suite Release 12.2 and is necessary for production
environments and test environments that are meant to be representative of
production. This enhancement makes it possible to have a development
environment with a single file system, where custom code can be built and
tested. A limited set of adop phases and modes are available to support
downtime patching of such a development environment. Code should then be
tested in standard dual file system test environments before being applied
to production.<span style="font-size: 12pt;"><o:p></o:p></span></span></li>
</ul>
<span style="font-family: Arial, Helvetica, sans-serif;">More details are provided in </span><strong style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 9.5pt;">Oracle E-Business Suite Maintenance Guide, Chapter: Patching Procedures):</span></strong><br />
<a href="http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm#6169002" style="font-family: Arial, Helvetica, sans-serif;">http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm#6169002</a><span style="font-family: Arial, Helvetica, sans-serif;"> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #222222;"><br /></span></b></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #222222;">Support for
Single File System Development Environments</span></b><span style="color: #222222;"><o:p></o:p></span></span><br />
<span style="color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">A
normal Release 12.2 online patching environment requires two application tier
file systems, one for the run edition and another for the patch edition. This
dual file system architecture is fundamental to patching of Oracle E-Business
Suite Release 12.2, and is necessary both for production environments and test
environments that are intended to be representative of production. This feature
makes it possible to create a development environment with a single file
system, where custom code can be built and tested. The code should then always
be tested in a standard dual file system test environment before being applied
to production.<o:p></o:p></span></span><br />
<span style="color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">You
can set up a single file system development environment by installing Oracle
E-Business Suite Release 12.2 in the normal way, and then deleting the
$PATCH_BASE directory with the command:<o:p></o:p></span></span><br />
<pre><span style="font-family: Arial, Helvetica, sans-serif;"><code><span style="color: #222222; font-size: 9.5pt;">$ rm -rf $PATCH_BASE</span></code><span style="color: #222222; font-size: 8.5pt;"><o:p></o:p></span></span></pre>
<span style="color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">A
limited set of adop phases and modes are available to support patching of a
single file system development environment. These are:<o:p></o:p></span></span><br />
<div style="margin-left: .5in; mso-list: l1 level1 lfo1; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #222222;">apply phase in downtime mode<o:p></o:p></span></span></div>
<div style="margin-left: .5in; mso-list: l1 level1 lfo1; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #222222;">cleanup phase<o:p></o:p></span></span></div>
<span style="color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">Specification
of any other phase or mode will cause adop to exit with an error.<o:p></o:p></span></span><br />
<span style="color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">The
following restrictions apply to using a single file system environment:<o:p></o:p></span></span><br />
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: yellow; color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="background: yellow; color: #222222;">You can only use a single
file system environment for development purposes.<o:p></o:p></span></span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #222222;">You cannot use online patching on a single file system
environment.<o:p></o:p></span></span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #222222;">You can only convert an existing dual file system environment to
a single file system: you cannot directly create a single file system
environment via Rapid Install or cloning.<o:p></o:p></span></span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: yellow; color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="background: yellow; color: #222222;">There is no way to
convert a single file system environment back into a dual file system.<o:p></o:p></span></span></div>
<br />
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: yellow; color: #222222; font-size: 10pt;">·<span style="font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--></span><span style="background: yellow; color: #222222;"><span style="font-family: Arial, Helvetica, sans-serif;">You cannot clone from a
single file system environment.</span><span style="font-family: Tahoma, sans-serif;"><o:p></o:p></span></span></div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-26963798760628003662015-04-15T15:06:00.003-07:002015-04-15T15:06:53.337-07:00You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed<div dir="ltr" style="text-align: left;" trbidi="on">
Shahed pinged me about this error. It was coming after logging in. This R12.1.3 instance had just migrated from an old server to a new one. Once you logged in this error would be displayed:<br />
<br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14.3000001907349px; font-weight: bold; text-align: right;">You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14.3000001907349px; font-weight: bold; text-align: right;"><br /></span>
The hits on support.oracle.com were not helpful, but a gave a clue that it may have something to do with session cookie. So I used Firefox to check http headers. If you press Ctrl+Shift+K, you will get a panel at the bottom of the browser. Click on Network tab, click on the AppsLocalLogin.jsp and on the right side of the pane, you'll see a cookie tab.<br />
<br />
The domain appearing in the cookie tab was from the old server. So I checked:<br />
<br />
select session_cookie_domain from icx_parameters;<br />
olddomain.justanexample.com<br />
<br />
So I nullified it:<br />
<br />
update icx_parameters set session_cookie_domain=null;<br />
<br />
commit;<br />
<br />
Restarted Apache<br />
<br />
cd $ADMIN_SCRIPTS_HOME<br />
adapcctl.sh stop<br />
adapcctl.sh start<br />
<br />
No more error. I was able to log in and so was Shahed.</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com1tag:blogger.com,1999:blog-6335343228190511009.post-53241231330540364262015-04-15T11:23:00.000-07:002015-04-15T11:23:01.590-07:00Chrome and E-Business Suite<div dir="ltr" style="text-align: left;" trbidi="on">
Dhananjay came to me today. He said that his users were complaining about forms not launching after upgrading to the latest version of Chrome. On launching forms they got this error:<br />
<br />
/dev60cgi/oracle forms engine Main was not found on this server<br />
<br />
I recalled that Google Chrome team had announced that they would not support java going forward. Googling with keywords chrome java brought this page:<br />
<br />
https://java.com/en/download/faq/chrome.xml#npapichrome<br />
<br />
It states that:<br />
<br />
<h4 class="sub" style="background-color: white; border: 0px; color: #111111; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 1.18em; line-height: 1; margin-bottom: 0.25em !important; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding: 0px; vertical-align: baseline;">
NPAPI support by Chrome</h4>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 1.5em; padding: 0px; vertical-align: baseline;">
The Java plug-in for web browsers relies on the cross platform plugin architecture <a href="http://en.wikipedia.org/wiki/NPAPI" style="border: 0px; color: #333333; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;" title="NPAPI description">NPAPI</a>, which has long been, and currently is, supported by all major web browsers. Google announced in September 2013 plans to remove NPAPI support from Chrome by "the end of 2014", thus effectively dropping support for Silverlight, Java, Facebook Video and other similar NPAPI based plugins. Recently, <a href="http://blog.chromium.org/2014/11/the-final-countdown-for-npapi.html" style="border: 0px; color: #333333; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Google</a> has revised their plans and now state that they plan to completely remove NPAPI by late 2015. As it is unclear if these dates will be further extended or not, we strongly recommend Java users consider alternatives to Chrome as soon as possible. Instead, we recommend Firefox, Internet Explorer and Safari as longer-term options. As of April 2015, starting with Chrome Version 42, Google has added an additional step to configuring NPAPI based plugins like Java to run — see the section <a href="https://java.com/en/download/faq/chrome.xml#npapichrome" style="border: 0px; color: #333333; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Enabling NPAPI in Chrome Version 42 and later</a> below.</div>
<h4 class="sub" style="background-color: white; border: 0px; color: #111111; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 1.18em; line-height: 1; margin-bottom: 0.25em !important; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding: 0px; vertical-align: baseline;">
<a href="https://www.blogger.com/null" name="npapichrome" style="border: 0px; font-family: inherit; font-size: 14.1599998474121px; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Enabling NPAPI in Chrome Version 42 and later</a></h4>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 1.5em; padding: 0px; vertical-align: baseline;">
As of Chrome Version 42, an additional configuration step is required to continue using NPAPI plugins.</div>
<ol style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin: 0px 1.5em 1.5em; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">In your URL bar, enter:<br /><code style="border: 0px; font-family: 'andale mono', 'lucida console', monospace; font-size: 1em; font-stretch: normal; line-height: 1.5; margin: 1.5em 0px; padding: 0px; vertical-align: baseline;">chrome://flags/#enable-npapi</code> </li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Click the <b>Enable</b> link for the <b>Enable NPAPI</b> configuration option.</li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Click the <b>Relaunch</b> button that now appears at the bottom of the configuration page.</li>
</ol>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 1.5em; padding: 0px; vertical-align: baseline;">
Developers and System administrators looking for alternative ways to support users of Chrome should see this <a href="https://blogs.oracle.com/java-platform-group/entry/java_web_start_in_or" style="border: 0px; color: #333333; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">blog</a>, in particular "Running Web Start applications outside of a browser" and "Additional Deployment Options" section.</div>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 1.5em; padding: 0px; vertical-align: baseline;">
Once Dhananjay did the above steps, Chrome started launching forms again. He quickly gave these steps to all his users who had upgraded to the latest version of Chrome (version 42) and it started working form them too.</div>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 1.5em; padding: 0px; vertical-align: baseline;">
Oracle doesn't certify E-Business Suite forms on Chrome. Only self service pages of E-Business Suite are certified on Google Chrome.</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com2tag:blogger.com,1999:blog-6335343228190511009.post-67431282986286755622015-04-11T17:30:00.002-07:002015-04-11T17:30:42.638-07:00opatch hangs on /sbin/fuser oracle<div dir="ltr" style="text-align: left;" trbidi="on">
Pipu pinged me today about opatch hanging. The opatch log showed this:<br />
<br />
[Apr 11, 2015 5:24:13 PM] Start fuser command /sbin/fuser
$ORACLE_HOME/bin/oracle at Sat Apr 11 17:24:13 EDT 2015<br />
<br />
I had faced this issue once before, but was not able to recall what was the solution. So I started fresh.<br />
<br />
As oracle user:<br />
<br />
/sbin/fuser $ORACLE_HOME/bin/oracle hung<br />
<br />
As root user<br />
<br />
/sbin/fuser $ORACLE_HOME/bin/oracle hung<br />
<br />
As root user<br />
<br />
lsof hung.<br />
<br />
Google searches about it brought up a lot of hits about NFS issues. So I did df -h.<br />
<br />
df -h also hung.<br />
<br />
So I checked /var/log/messages and found many messages like these:<br />
<br />
Apr 11 19:44:42 erpserver kernel: nfs: server share.justanexample.com not responding, still trying<br />
<div>
<br /></div>
<div>
That server has a mount called /R12.2stage that has the installation files for R12.2.</div>
<div>
<br /></div>
<div>
So I tried unmounting it:</div>
<div>
<br /></div>
<div>
umount /R12.2stage</div>
<div>
Device Busy</div>
<div>
<br /></div>
<div>
umount -f /R12.2stage</div>
<div>
Device Busy</div>
<div>
<br /></div>
<div>
umount -l /R12.2stage</div>
<div>
<br /></div>
<div>
df -h didn't hang any more.</div>
<div>
<br /></div>
<div>
Next I did strace /sbin/fuser $ORACLE_HOME/bin/oracle and it stopped here:</div>
<div>
<br /></div>
<div>
<div>
<div>
open("/proc/12854/fdinfo/3", O_RDONLY) = 7</div>
<div>
fstat(7, {st_mode=S_IFREG|0400, st_size=0, ...}) = 0</div>
<div>
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b99de014000</div>
<div>
read(7, "pos:\t0\nflags:\t04002\n", 1024) = 20</div>
<div>
close(7) = 0</div>
<div>
munmap(0x2b99de014000, 4096) = 0</div>
<div>
getdents(4, /* 0 entries */, 32768) = 0</div>
<div>
close(4) = 0</div>
<div>
stat("/proc/12857/", {st_mode=S_IFDIR|0555, st_size=0, ...}) = 0</div>
<div>
open("/proc/12857/stat", O_RDONLY) = 4</div>
<div>
read(4, "12857 (bash) S 12853 12857 12857"..., 4096) = 243</div>
<div>
close(4) = 0</div>
<div>
readlink("/proc/12857/cwd", "11.2.0.4/examples (deleted)"..., 4096) = 27</div>
<div>
rt_sigaction(SIGALRM, {0x411020, [ALRM], SA_RESTORER|SA_RESTART, 0x327bc30030}, {SIG_DFL, [ALRM], SA_RESTORER|SA_RESTART, 0x327bc30030}, 8) = 0</div>
<div>
alarm(15) = 0</div>
<div>
write(5, "@\20A\0\0\0\0\0", 8) = 8</div>
<div>
write(5, "\20\0\0\0", 4) = 4</div>
<div>
write(5, "/proc/12857/cwd\0", 16) = 16</div>
<div>
write(5, "\220\0\0\0", 4) = 4</div>
<div>
read(6, <unfinished ...=""></unfinished></div>
</div>
<div>
<br /></div>
<div>
It stopped here. So I did Ctrl+C</div>
<div>
# </div>
<div>
# ps -ef |grep 12857</div>
<div>
oracle 12857 12853 0 Apr10 pts/2 00:00:00 -bash</div>
<div>
root 21688 2797 0 19:42 pts/8 00:00:00 grep 12857</div>
<div>
<br /></div>
<div>
Killed this process</div>
<div>
<br /></div>
<div>
# kill -9 12857</div>
</div>
<div>
<br /></div>
<div>
Again I did strace /sbin/fuser $ORACLE_HOME/bin/oracle and it stopped at a different process this time that was another bash process. I killed that process also.</div>
<div>
<br /></div>
<div>
I executed it for 3rd time: strace /sbin/fuser $ORACLE_HOME/bin/oracle</div>
<div>
<br /></div>
<div>
This time it completed.</div>
<div>
<br /></div>
<div>
Ran it without strace</div>
<div>
<br /></div>
<div>
/sbin/fuser $ORACLE_HOME/bin/oracle</div>
<div>
<br /></div>
<div>
It came out in 1 second.</div>
<div>
<br /></div>
<div>
Then I did the same process for lsof</div>
<div>
<br /></div>
<div>
strace lsof</div>
<div>
<br /></div>
<div>
and killed those processes were it was getting stuck. Eventually lsof also worked.</div>
<div>
<br /></div>
<div>
Pipu retried opatch and it worked fine.</div>
<div>
<br /></div>
<div>
Stale NFS mount was the root cause of this issue. It was stale because the source server was down for Unix security patching during weekend.</div>
<div>
</div>
<div>
<br /></div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-61847264231235086432015-04-03T18:26:00.000-07:002015-04-03T18:26:20.277-07:00adoafmctl.sh hangs<div dir="ltr" style="text-align: left;" trbidi="on">
Rajesh and Shahed called me about this error where after a reboot of the servers, adoafmctl.sh wouldn't start. It gave errors like these:<br />
<br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;">You are running adoafmctl.sh version 120.6.12000000.3 </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;">Starting OPMN managed OAFM OC4J instance ... </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;">adoafmctl.sh: exiting with status 152 </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;">adoafmctl.sh: check the logfile </span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;">$INST_TOP/logs/appl/admin/log/adoafmctl.txt for more information</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: x-small;"><br /></span>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
adoafmctl.txt showing:</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
ias-component/process-type/process-set:<br />default_group/oafm/default_group/<br />Error<br />--> Process (index=1,uid=349189076,pid=15039)<br />time out while waiting for a managed process to start<br />Log:<br />$INST_TOP/logs/ora/10.1.3/opmn/default_group~oafm~default_group~1<br />07/31/09-09:14:28 :: adoafmctl.sh: exiting with status 152<br />================================================================================<br />07/31/09-09:14:40 :: adoafmctl.sh version 120.6.12000000.3<br />07/31/09-09:14:40 :: adoafmctl.sh: Checking the status of OPMN managed OAFM OC4J instance<br />Processes in Instance: SID_machine.machine.domain<br />-------------------+--------------------+---------+---------<br />ias-component | process-type | pid | status<br />-------------------+--------------------+---------+---------<br />default_group | oafm | N/A | Down</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
Solution:</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
1. Shutdown all Middle tier services and ensure no defunct processes exist running the following from the operating system:</div>
<blockquote style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; font-size: 11.6999998092651px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;">
<code class="km" style="font-family: 'Courier New', Courier, monospace; font-size: 10.5299997329712px; white-space: pre-wrap; word-wrap: break-word;"># ps -ef | grep <applmgr></applmgr></code></div>
<br />If one finds any, kill these processes.</blockquote>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
2. Navigate to $INST_TOP/ora/10.1.3/opmn/logs/states directory. It contains hidden file .opmndat:</div>
<blockquote style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; font-size: 11.6999998092651px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;">
<code class="km" style="font-family: 'Courier New', Courier, monospace; font-size: 10.5299997329712px; white-space: pre-wrap; word-wrap: break-word;"># ls -lrt .opmndat</code></div>
</blockquote>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
3. Delete this file .opmndat after making a backup of it:</div>
<blockquote style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; font-size: 11.6999998092651px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;">
<code class="km" style="font-family: 'Courier New', Courier, monospace; font-size: 10.5299997329712px; white-space: pre-wrap; word-wrap: break-word;"># rm .opmndat</code></div>
</blockquote>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
4. Restart the services.<br /><br />5. Re-test the issue.</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
This resolved the issue.</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0tag:blogger.com,1999:blog-6335343228190511009.post-16258712283459892212015-03-23T18:35:00.003-07:002015-03-23T18:36:55.923-07:00R12.2 Documentation link in html format<div dir="ltr" style="text-align: left;" trbidi="on">
This link has the R12.2 documentation in HTML format:<br />
<br />
<a href="https://docs.oracle.com/cd/E26401_01/index.htm">https://docs.oracle.com/cd/E26401_01/index.htm</a> </div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com1tag:blogger.com,1999:blog-6335343228190511009.post-80175653894117576132015-03-01T12:53:00.001-08:002015-03-01T13:05:41.819-08:00The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes<div dir="ltr" style="text-align: left;" trbidi="on">
I got this error while upgrading an R12.1.3 instance to R12.2.4, when I completed AD.C.Delta 5 patches with November 2014 bundle patches for AD.C and was in the process of applying TXK.C.Delta5 with November 2014 bundle patches for TXK.C :<br />
<br />
Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.<br />
[START 2015/03/01 04:53:16] Check if services are down<br />
[INFO] Run admin server is not down<br />
[WARNING] Hotpatch mode should only be used when directed by the patch readme.<br />
[EVENT] [START 2015/03/01 04:53:17] Performing database sanity checks<br />
[ERROR] The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes: <racnode1>.</racnode1><br />
Log file: /erppgzb1/erpapp/fs_ne/EBSapps/log/adop/adop_20150301_045249.log<br />
<br />
<br />
[STATEMENT] Please run adopscanlog utility, using the command<br />
<br />
"adopscanlog -latest=yes"<br />
<br />
to get the list of the log files along with snippet of the error message corresponding to each log file.<br />
<br />
<br />
adop exiting with status = 1 (Fail)<br />
<div>
<br /></div>
<div>
I was really surprised as I had already run EBS technology codelevel checker (patch 17537119) script checkDBpatch.sh on racnode1.</div>
<div>
<br /></div>
<div>
To investigate I checked inside checkDBpatch.sh and found that it create a table called TXK_TCC_RESULTS. </div>
<div>
<br /></div>
<div>
<div>
SQL> desc txk_tcc_results</div>
<div>
Name Null? Type</div>
<div>
----------------------------------------- -------- ----------------------------</div>
<div>
TCC_VERSION NOT NULL VARCHAR2(20)</div>
<div>
BUGFIX_XML_VERSION NOT NULL VARCHAR2(20)</div>
<div>
NODE_NAME NOT NULL VARCHAR2(100)</div>
<div>
DATABASE_NAME NOT NULL VARCHAR2(64)</div>
<div>
COMPONENT_NAME NOT NULL VARCHAR2(10)</div>
<div>
COMPONENT_VERSION NOT NULL VARCHAR2(20)</div>
<div>
COMPONENT_HOME VARCHAR2(600)</div>
<div>
CHECK_DATE DATE</div>
<div>
CHECK_RESULT NOT NULL VARCHAR2(10)</div>
<div>
CHECK_MESSAGE VARCHAR2(4000)</div>
<div>
<br /></div>
<div>
SQL> select node_name from txk_tcc_results;</div>
<div>
<br /></div>
<div>
NODE_NAME</div>
<div>
--------------------------------------------------------------------------------</div>
<div>
RACNODE1</div>
</div>
<div>
<br /></div>
<div>
I ran checkDBpatch.sh again, but the patch failed again with previous error:</div>
<div>
<br /></div>
<div>
[ERROR] The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes: <racnode1>.</racnode1></div>
<div>
<br /></div>
<div>
It was Saturday 5 AM already working through the night. So I thought, it is better to sleep now and tackle this on Sunday. On Sunday morning after a late breakfast, I looked at the problem again. This time, I realized that the error was complaining about racnode1 (in lower case) and the txk_tcc_results table had RACNODE1(in upper case). To test my hunch, I immediately updated the value:</div>
<div>
<br /></div>
<div>
update txk_tcc_results</div>
<div>
set node_name='racnode1' where node_name='RACNODE1';</div>
<div>
<br /></div>
<div>
commit;</div>
<div>
<br /></div>
<div>
I restarted the patch, and it went through. Patch was indeed failing because it was trying to look for a lower case value. I will probably log an SR with Oracle, so that they change their code to make the node_name check case insensitive.<br />
<br />
Further, I was curious, why node_name was stored in all caps in fnd_nodes and txk_tcc_results. The file /etc/hosts had it in lowercase. I tried the hostname command on linux prompt:<br />
<br />
$ hostname<br />
RACNODE1<br />
<br />
That was something unusual, as in our environment, hostname always returns the value in lowercase. So I further investigated.<br />
[root@RACNODE1 ~]# sysctl kernel.hostname<br />
kernel.hostname = RACNODE1<br />
<br />
So I changed it<br />
<br />
[root@RACNODE1 ~]# sysctl kernel.hostname=RACNODE1<br />
kernel.hostname = racnode1<br />
[root@RACNODE1 ~]# sysctl kernel.hostname<br />
kernel.hostname = racnode1<br />
[root@RACNODE1 ~]#<br />
[root@RACNODE1 ~]# hostname<br />
racnode1</div>
<div>
<br />
Logged in again to see if root prompt changed:</div>
<div>
<br /></div>
<div>
<div>
[root@racnode1 ~]#<br />
<br />
I also checked<br />
[root@tsgld5811 ~]# cat /etc/sysconfig/network<br />
NETWORKING=yes<br />
NETWORKING_IPV6=no<br />
NOZEROCONF=yes<br />
HOSTNAME=RACNODE1<br />
<br />
Changed it here also:<br />
[root@tsgld5811 ~]# cat /etc/sysconfig/network<br />
NETWORKING=yes<br />
NETWORKING_IPV6=no<br />
NOZEROCONF=yes<br />
HOSTNAME=racnode1<br />
<div>
<br /></div>
</div>
</div>
<div>
I also changed it on racnode2.</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com3tag:blogger.com,1999:blog-6335343228190511009.post-58102549288873337522015-02-24T08:01:00.000-08:002015-02-24T08:01:44.598-08:00cannot set user id: Resource temporarily unavailable or Fork: Retry: Resource Temporarily Unavailable<div dir="ltr" style="text-align: left;" trbidi="on">
Amjad reported this error while trying to login to the server:<br />
<br />
cannot set user id: Resource temporarily unavailable<br />
<br />
In the past he had reported this error:<br />
<br />
Fork: Retry: Resource Temporarily Unavailable<br />
<br />
This is due to the fact that the user has run out of free stacks. In OEL 6.x , the stack setting is not done in /etc/security/limits.conf but in the file:<br />
<br />
/etc/security/limits.d/90-nproc.conf<br />
<br />
The default content in the file is:<br />
<br />
cat /etc/security/limits.d/90-nproc.conf<br />
# Default limit for number of user's processes to prevent<br />
# accidental fork bombs.<br />
# See rhbz #432903 for reasoning.<br />
<br />
* soft nproc <b>1024</b><br />
root soft nproc unlimited<br />
<div>
<br /></div>
<div>
I changed this to:</div>
<div>
<br /></div>
<div>
<div>
After</div>
<div>
$ cat /etc/security/limits.d/90-nproc.conf</div>
<div>
# Default limit for number of user's processes to prevent</div>
<div>
# accidental fork bombs.</div>
<div>
# See rhbz #432903 for reasoning.</div>
<div>
<br /></div>
<div>
* soft nproc <b>16384</b></div>
<div>
root soft nproc unlimited</div>
<div>
$</div>
</div>
<div>
<br /></div>
As soon as this change was made, Amjad was able to login.<br />
<br /></div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com2tag:blogger.com,1999:blog-6335343228190511009.post-91232191988114303052015-01-28T13:19:00.001-08:002015-01-28T13:19:53.915-08:00ERROR - CLONE-20372 Server port validation failed<div dir="ltr" style="text-align: left;" trbidi="on">
Alok and Shoaib pinged me about this error. This error is reported in logs when adcfgclone.pl is run for a R12.2.4 appsTier where the source and target instances are on same physical server.<br />
<br />
SEVERE : Jan 27, 2015 3:40:09 PM - ERROR - CLONE-20372 Server port validation failed.<br />
SEVERE : Jan 27, 2015 3:40:09 PM - CAUSE - CLONE-20372 Ports of following servers - oacore_server2(7256),forms_server2(7456),oafm_server2(7656),forms-c4ws_server2(7856),oaea_server1(6856) - are not available.<br />
4:00 PM<br />
SEVERE : Jan 27, 2015 3:40:09 PM - ERROR - CLONE-20372 Server port validation failed.<br />
SEVERE : Jan 27, 2015 3:40:09 PM - CAUSE - CLONE-20372 Ports of following servers - oacore_server2(7256),forms_server2(7456),oafm_server2(7656),forms-c4ws_server2(7856),oaea_server1(6856) - are not available.<br />
SEVERE : Jan 27, 2015 3:40:09 PM - ACTION - CLONE-20372 Provide valid free ports.<br />
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct<br />
<div>
<br /></div>
The ports reported are those in the source instance. Searching on support.oracle.com bug database I found three articles:<br />
<br />
EBS 12.2.2.4 RAPID CLONE FAILS WITH ERROR - CLONE-20372 SERVER PORT VALIDATION(Bug ID 20147454)<br />
<br />
12.2: N->1 CLONING TO SAME APPS TIER FAILING DUE TO PORT CONFLICT(Bug ID 20389864)<br />
<br />
FS_CLONE IS NOT ABLE TO COMPLETE FOR MULTI-NODE SETUP(Bug ID 18460148)<br />
<br />
The situation described in the first two bugs is same. The articles reference each other but don't provide any solution.<br />
<br />
Logically thinking, adcfgclone.pl is picking this up from source configuration that is in $COMMON_TOP/clone directory. So we did grep on subdirectories of $COMMON_TOP/clone:<br />
<br />
cd $COMMON_TOP/clone<br />
find . -type f -print | xargs grep 7256<br />
<br />
7256 is one of the ports that failed validation.<br />
<br />
It is present in<br />
<br />
CTXORIG.xml and<br />
FMW/ohs/moveplan.xml<br />
FMW/wls/moveplan.xml<br />
<br />
We tried changing the port numbers in CTXORIG.xml and re-tried adcfgclone.pl and it failed again.<br />
<br />
So we changed the port numbers of the ports that failed validation in<br />
<br />
$COMMON_TOP/clone/FMW/ohs/moveplan.xml and<br />
$COMMON_TOP/clone/FMW/wls/moveplan.xml<br />
<br />
cd $FMW_HOME<br />
find . -name detachHome.sh |grep -v Template<br />
<br />
The above command returns the detachHome.sh scripts for all the ORACLE_HOMEs inside FMW_HOME. Executed this to detach all of them.<br />
<br />
Removed the FMW_HOME directory<br />
<br />
Re-executed<br />
adcfgclone.pl appsTier<br />
<br />
It succeeded this time. Till we get a patch for this bug, we will continue to use this workaround to complete clones.<br />
<br />
<br /></div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com2tag:blogger.com,1999:blog-6335343228190511009.post-27016548878448959652015-01-16T11:55:00.000-08:002015-01-16T11:55:14.337-08:00ERROR: The following required ports are in use: 6801 : WLS OAEA Application Port<div dir="ltr" style="text-align: left;" trbidi="on">
Anil pinged me today when his adop phase=fs_clone failed with this error message:<br />
<br />
-----------------------------<br />
ERROR: The following required ports are in use:<br />
-----------------------------<br />
6801 : WLS OAEA Application Port<br />
Corrective Action: Free the listed ports and retry the adop operation.<br />
<br />
Completed execution : ADOPValidations.java<br />
<br />
====================================<br />
Inside _validateETCHosts()...<br />
====================================<br />
<div>
<br /></div>
<div>
This is a bug mentioned in the appendix of article: </div>
<table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:r1:0:tl5" style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 10.9090909957886px; width: 100%px;" summary=""><tbody>
<tr id="kmPgTpl:r1:0:rl12"><td align="left" id="kmPgTpl:r1:0:cf49"><span class="p_AFHoverTarget xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate (Doc ID 1576425.1)<br /></label></span></td></tr>
</tbody></table>
<div>
<div style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Bug <a href="https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1576425.1&id=19817016">19817016</a></div>
<div style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: small;">
The following errors are encountered when running fs_clone after completing AccessGate and OAM integration and after completing a patch cycle:<br /><br />Checking WLS OAEA Application Port on aolesc11: Port Value = 6801<br />RC-50204: Error: - WLS OAEA Application Port in use: Port Value = 6801<br /><br />-----------------------------<br />ERROR: The following required ports are in use:<br />-----------------------------<br />6801 : WLS OAEA Application Port<br />Corrective Action: Free the listed ports and retry the adop operation.<br /><br /><strong>Workaround:</strong><br />Stop the oaea managed server on the run file system before performing the fs_clone operation, immediately after the accessgate deployment.<br /><br /><strong>Solution:</strong><br />This issue will be addressed through Bug <a href="https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1576425.1&id=19817016">19817016</a>.</div>
<div style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: small;">
If you read the bug:</div>
<div style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div id="kmPgTpl:r1:0:psl1::t" style="color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 10.9090909957886px; height: 60px; overflow: hidden; position: relative; width: 1719.0908203125px;">
<div class="x1a" id="kmPgTpl:r1:0:pgl11" style="bottom: 0px; height: auto; left: 0px; position: absolute; right: 0px; top: 0px; width: auto;">
<span class="x1a" id="kmPgTpl:r1:0:pg19"><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:r1:0:btb1" style="width: 100%px;" summary=""><tbody>
<tr id="kmPgTpl:r1:0:btbr2"><td align="left" id="kmPgTpl:r1:0:cf2"><span class="xq" id="kmPgTpl:r1:0:ol913" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Bug 19817016 : RUNNING ADOP FS_CLONE FAILS DUE TO PORT CONFLICT BETWEEN RUN AND PATCH EDITION</label></span></td><td align="right" id="kmPgTpl:r1:0:cf3"><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:r1:0:btb2" summary=""><tbody>
<tr id="kmPgTpl:r1:0:btbr3"><td id="kmPgTpl:r1:0:cf21"><a class="xfd" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:cil4" style="font-size: 11px; text-decoration: none; white-space: nowrap;" title="Click to add to Favorites"><img alt="Click to add to Favorites" class="x137" id="kmPgTpl:r1:0:cil4::icon" src="https://support.oracle.com/epmos/ui/images/favorites_qualifier_notsel.png" style="border: none; display: inline; vertical-align: middle;" title="Click to add to Favorites" /></a><span class="x1a" id="kmPgTpl:r1:0:sug1:pglcl"></span><img alt="" height="10" id="kmPgTpl:r1:0:s13" src="https://support.oracle.com/epmos/adf/images/t.gif" width="20" /></td><td id="kmPgTpl:r1:0:cf25"><a class="x132" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:gil3" style="font-size: 11px; text-decoration: none; white-space: nowrap;" title="Email link to this document"><img alt="Email link to this document" class="x13a" id="kmPgTpl:r1:0:gil3::icon" src="https://support.oracle.com/epmos/ui/images/email_16.png" style="border: none; display: inline; vertical-align: middle;" title="Email link to this document" /></a><img alt="" height="10" id="kmPgTpl:r1:0:s15" src="https://support.oracle.com/epmos/adf/images/t.gif" width="20" /></td><td id="kmPgTpl:r1:0:cf26"><a class="xfe" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:cil2" style="color: #0851b3; font-size: 11px; text-decoration: none;" title="Printable Page"><img alt="Printable Page" class="xjd" id="kmPgTpl:r1:0:i1" src="https://support.oracle.com/epmos/ui/images/print_ena.png" style="border: 0px;" title="Printable Page" /></a><img alt="" height="10" id="kmPgTpl:r1:0:s24" src="https://support.oracle.com/epmos/adf/images/t.gif" width="20" /></td><td id="kmPgTpl:r1:0:cf29"><a class="xfd" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:cil1" style="font-size: 11px; text-decoration: none; white-space: nowrap;" title="To Bottom"><img alt="To Bottom" class="x137" id="kmPgTpl:r1:0:cil1::icon" src="https://support.oracle.com/epmos/ui/images/quicklink_smlarrowdown_enabled.gif" style="border: none; display: inline; vertical-align: middle;" title="To Bottom" /><span class="x133" style="color: #003286; margin-left: 3px;">To Bottom</span></a><img alt="" height="10" id="kmPgTpl:r1:0:s6" src="https://support.oracle.com/epmos/adf/images/t.gif" width="10" /></td></tr>
</tbody></table>
</td></tr>
<tr id="kmPgTpl:r1:0:btbr5"><td colspan="2" id="kmPgTpl:r1:0:cf267"><div id="kmPgTpl:r1:0:kbb_s3" style="margin-top: 5px;">
</div>
</td></tr>
<tr id="kmPgTpl:r1:0:btbr6"><td colspan="2" id="kmPgTpl:r1:0:cf261"><img alt="" height="1" id="kmPgTpl:r1:0:kbb_s9" src="https://support.oracle.com/epmos/adf/images/t.gif" style="background-color: silver;" width="100%" /></td></tr>
</tbody></table>
</span></div>
</div>
<div style="color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 10.9090909957886px; overflow: hidden;">
<div id="kmPgTpl:r1:0:psl1::c" style="overflow: hidden;">
<div class="x1a" id="kmPgTpl:r1:0:pgl2" style="height: 1834.14770507813px; overflow: auto; width: 1719.0908203125px;">
<div>
<img alt="" height="6" id="kmPgTpl:r1:0:s17" src="https://support.oracle.com/epmos/adf/images/t.gif" width="0" /></div>
<div>
<img alt="" height="0" id="kmPgTpl:r1:0:s7" src="https://support.oracle.com/epmos/adf/images/t.gif" width="0" /></div>
<div>
<div class="x1a" id="kmPgTpl:r1:0:pgl21" style="height: 1828.69311523438px; overflow: auto; width: 1719.0908203125px;">
<div>
<div class="x6w" id="kmPgTpl:r1:0:sdh1">
<table border="0" cellpadding="0" cellspacing="0" class="p_AFDisclosed xty" style="padding: 0px; width: 0px;" summary=""><tbody>
<tr><td class="xuj" style="font-size: 0px; min-width: 1px; padding: 0px; width: 1px;"> </td><td class="xvf" style="display: block; font-size: 14px; font-weight: bold; overflow: hidden; padding: 0px; vertical-align: middle; white-space: nowrap;"><table border="0" cellpadding="0" cellspacing="0" style="width: 100%px;" summary=""><tbody>
<tr><td class="xtm" style="padding-left: 0px; padding-right: 2px; vertical-align: middle; width: 10px;"><a class="xtu x1aw" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:sdh1::_afrDscl" style="background-image: url(https://support.oracle.com/epmos/afr/fusion/disclexp.png); background-position: 50% 50%; background-repeat: no-repeat; cursor: default; display: block; height: 20px; width: 13px;" title="Collapse Bug Attributes"></a></td><td class="x1yx" style="height: 21px;"></td><td id="kmPgTpl:r1:0:sdh1::_afrTtxt"><div class="xu3" style="max-width: 104px; overflow: hidden; white-space: nowrap; width: 104px;" title="Bug Attributes">
<h1 class="xdm " style="color: #003d5b; display: inline; font-size: 14px; margin: 0px;">
Bug Attributes</h1>
</div>
</td><td id="kmPgTpl:r1:0:sdh1::_afrEps"></td><td id="kmPgTpl:r1:0:sdh1::_afrStr" style="width: 1595.45446777344px;"></td></tr>
</tbody></table>
</td><td class="xv1" style="font-size: 0px; min-width: 1px; padding: 0px; width: 1px;"> </td></tr>
</tbody></table>
<div class="xwg" style="padding: 0px 1px 0px 10px; vertical-align: top;">
<hr class="x1j" id="kmPgTpl:r1:0:s5" style="border-bottom-color: rgb(255, 255, 255); border-bottom-style: solid; border-left-width: 0px; border-right-width: 0px; border-top-color: rgb(173, 182, 199); border-top-style: solid; margin-bottom: 3px; margin-top: 3px;" />
<table border="0" cellpadding="2" cellspacing="2" id="kmPgTpl:r1:0:tl2" style="width: 60%px;" summary=""><tbody>
<tr id="kmPgTpl:r1:0:rl2"><td align="left" id="kmPgTpl:r1:0:cf1"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol6" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Type</label></span></td><td align="left" id="kmPgTpl:r1:0:cf4"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">B - Defect</span></td><td align="left" id="kmPgTpl:r1:0:cf5"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol7" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Fixed in Product Version</label></span></td><td align="left" id="kmPgTpl:r1:0:cf6"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;"></span></td></tr>
<tr id="kmPgTpl:r1:0:rl3"><td align="left" id="kmPgTpl:r1:0:cf7"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol8" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Severity</label></span></td><td align="left" id="kmPgTpl:r1:0:cf8"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">2 - Severe Loss of Service</span></td><td align="left" id="kmPgTpl:r1:0:cf9"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol9" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Product Version</label></span></td><td align="left" id="kmPgTpl:r1:0:cf10"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">12.2.4</span></td></tr>
<tr id="kmPgTpl:r1:0:rl4"><td align="left" id="kmPgTpl:r1:0:cf11"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol10" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Status</label></span></td><td align="left" id="kmPgTpl:r1:0:cf12"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">11 - Code/Hardware Bug (Response/Resolution)</span></td><td align="left" id="kmPgTpl:r1:0:cf13"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol11" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Platform</label></span></td><td align="left" id="kmPgTpl:r1:0:cf14"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">226 - Linux x86-64</span></td></tr>
<tr id="kmPgTpl:r1:0:rl5"><td align="left" id="kmPgTpl:r1:0:cf15"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol12" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Created</label></span></td><td align="left" id="kmPgTpl:r1:0:cf16"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; white-space: nowrap;">14-Oct-2014</span></td><td align="left" id="kmPgTpl:r1:0:cf17"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol13" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Platform Version</label></span></td><td align="left" id="kmPgTpl:r1:0:cf18"><span class="bugOutputText xq" id="kmPgTpl:r1:0:ot351" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; padding: 0px 6px 0px 0px; text-align: right;"><label>ORACLE LINUX 5</label></span></td></tr>
<tr id="kmPgTpl:r1:0:rl6"><td align="left" id="kmPgTpl:r1:0:cf19"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol14" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Updated</label></span></td><td align="left" id="kmPgTpl:r1:0:cf20"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; white-space: nowrap;">02-Dec-2014</span></td><td align="left" id="kmPgTpl:r1:0:cf91"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol15" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Base Bug</label></span></td><td align="left" id="kmPgTpl:r1:0:cf22">N/A</td></tr>
<tr id="kmPgTpl:r1:0:rl7"><td align="left" id="kmPgTpl:r1:0:cf23"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol16" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Database Version</label></span></td><td align="left" id="kmPgTpl:r1:0:cf24"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">11.2.0.3</span></td><td align="left" id="kmPgTpl:r1:0:cf27"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol18" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Affects Platforms</label></span></td><td align="left" id="kmPgTpl:r1:0:cf28"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">Generic</span></td></tr>
<tr id="kmPgTpl:r1:0:rl9"><td align="left" id="kmPgTpl:r1:0:cf31"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:ol20" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Product Source</label></span></td><td align="left" id="kmPgTpl:r1:0:cf32"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">Oracle</span></td><td align="left" id="kmPgTpl:r1:0:cf30"><a class="xfu" href="https://support.oracle.com/epmos/faces/BugMatrix?id=19817016" id="kmPgTpl:r1:0:ol1" style="color: #0071c2; cursor: text; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; padding-top: 5px;" target="_blank">Knowledge, Patches and Bugs related to this bug</a></td></tr>
</tbody></table>
</div>
</div>
</div>
<div>
<img alt="" height="15" id="kmPgTpl:r1:0:sp171" src="https://support.oracle.com/epmos/adf/images/t.gif" width="15" /></div>
<div>
<div class="x6w" id="kmPgTpl:r1:0:sdh2">
<table border="0" cellpadding="0" cellspacing="0" class="p_AFDisclosed xty" style="padding: 0px; width: 0px;" summary=""><tbody>
<tr><td class="xuj" style="font-size: 0px; min-width: 1px; padding: 0px; width: 1px;"> </td><td class="xvf" style="display: block; font-size: 14px; font-weight: bold; overflow: hidden; padding: 0px; vertical-align: middle; white-space: nowrap;"><table border="0" cellpadding="0" cellspacing="0" style="width: 100%px;" summary=""><tbody>
<tr><td class="xtm" style="padding-left: 0px; padding-right: 2px; vertical-align: middle; width: 10px;"><a class="xtu x1aw" href="https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=475124615028568&id=19817016&_afrWindowMode=0&_adf.ctrl-state=rexlgef8n_373#" id="kmPgTpl:r1:0:sdh2::_afrDscl" style="background-image: url(https://support.oracle.com/epmos/afr/fusion/disclexp.png); background-position: 50% 50%; background-repeat: no-repeat; cursor: default; display: block; height: 20px; width: 13px;" title="Collapse Related Products"></a></td><td class="x1yx" style="height: 21px;"></td><td id="kmPgTpl:r1:0:sdh2::_afrTtxt"><div class="xu3" style="max-width: 121px; overflow: hidden; white-space: nowrap; width: 121px;" title="Related Products">
<h1 class="xdm " style="color: #003d5b; display: inline; font-size: 14px; margin: 0px;">
Related Products</h1>
</div>
</td><td id="kmPgTpl:r1:0:sdh2::_afrEps"></td><td id="kmPgTpl:r1:0:sdh2::_afrStr" style="width: 1578.18176269531px;"></td></tr>
</tbody></table>
</td><td class="xv1" style="font-size: 0px; min-width: 1px; padding: 0px; width: 1px;"> </td></tr>
</tbody></table>
<div class="xwg" style="padding: 0px 1px 0px 10px; vertical-align: top;">
<hr class="x1j" id="kmPgTpl:r1:0:s16" style="border-bottom-color: rgb(255, 255, 255); border-bottom-style: solid; border-left-width: 0px; border-right-width: 0px; border-top-color: rgb(173, 182, 199); border-top-style: solid; margin-bottom: 3px; margin-top: 3px;" />
<table border="0" cellpadding="2" cellspacing="2" id="kmPgTpl:r1:0:tl3" style="width: 60%px;" summary=""><tbody>
<tr id="kmPgTpl:r1:0:i26:0:r21"><td align="left" id="kmPgTpl:r1:0:i26:0:cf51"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:i26:0:ol61" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Line</label></span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf54"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">Oracle E-Business Suite</span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf55"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:i26:0:ol71" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Family</label></span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf56"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">Applications Technology</span></td></tr>
<tr id="kmPgTpl:r1:0:i26:0:r23"><td align="left" id="kmPgTpl:r1:0:i26:0:cf57"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:i26:0:ol81" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Area</label></span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf58"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">Technology Components</span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf59"><span class="bugOutputLabel xq" id="kmPgTpl:r1:0:i26:0:ol91" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Product</label></span></td><td align="left" id="kmPgTpl:r1:0:i26:0:cf60"><span class="bugOutputText" style="color: #333333; font-family: Helvetica, sans-serif; font-size: 14.5454540252686px;">1745 - Oracle Applications Technology Stack</span></td></tr>
<tr id="kmPgTpl:r1:0:i26:0:r24"></tr>
</tbody></table>
</div>
</div>
</div>
<div>
<img alt="" height="10" id="kmPgTpl:r1:0:s25" src="https://support.oracle.com/epmos/adf/images/t.gif" width="10" /></div>
<div>
<span style="font-size: 12px;"><pre>Hdr: 19817016 11.2.0.3 FSOP 12.2.4 PRODID-1745 PORTID-226
Abstract: RUNNING ADOP FS_CLONE FAILS DUE TO PORT CONFLICT BETWEEN RUN AND PATCH EDITION
<b>*** 10/14/14 11:58 am ***</b>
Service Request (SR) Number:
----------------------------
Problem Statement:
------------------
Running fs_clone after completing EBS and OAM integration and after
completing a patch cycle results in fs_clone failing with the following
errors:
Checking WLS OAEA Application Port on aolesc11: Port Value = 6801
RC-50204: Error: - WLS OAEA Application Port in use: Port Value = 6801
-----------------------------
ERROR: The following required ports are in use:
-----------------------------
6801 : WLS OAEA Application Port
Corrective Action: Free the listed ports and retry the adop operation.
Detailed Results of Problem Analysis:
-------------------------------------
The problem is due to the newly added managed server port being the same for
both the run and patch edition. Going back to the sequence of steps and
tracking the port assignment, it showed the following:
- deploy accessgate on patch
Creates managed server - oaea_server1:6801
This is the default port and doing this to the patch edition...
fs2 - run -> 6801 port
fs1 - patch -> 6801 port
- complete OAM registration
- close patching cycle
- cutover
- after cutover, SSO is working
fs1 - run -> 6801 port
fs2 - patch -> 6801 port
- fs_clone -> fails due to both run(fs1) and patch(fs2) referencing the same
port 6801
Configuration and Version Details:
----------------------------------
OAM - 11.1.2.2.0
WG - 11.1.2.2.0
EAG - 1.2.3
WT - 11.1.1.6.0
EBS 12.2.4 w/ AD/TXK delta 5
Steps To Reproduce:
-------------------
As part of the EBS integration w/ OAM, we add a managed server for use as the
EBS AccessGate (EAG) to the existing WLS in EBS. There is an option to do
this to both run edition, as well as the patch edition during an active patch
cycle. In this case the latter was done. Here is a summary of the steps
used:
1. Start patch cycle
2. Integrated OID and EBS
3. Cutover
4. Confirmed OID provisioning is working
5. Start patch cycle
6. Apply pre-req EBS patches for OAM
7. Proceed w/ OAM integration on patch file system
8. Cutover
9. Confirmed SSO/OAM is working
10. Run fs_clone -> this is where the issue appears
Additional Information:
-----------------------
The workaround here is to stop the oaea_server1 managed server operating in
the run edition on port 6801, and then re-running fs_clone. Once this is
done, fs_clone completes and the patch edition now operates on port 6802 for
the same managed server.
For A Severity 1 Bug: Justification and 24x7 Contact Details:
-------------------------------------------------------------
<b>*** 10/14/14 01:19 pm ***</b>
<b>*** 10/16/14 07:05 am ***</b>
<b>*** 10/16/14 07:05 am ***</b>
<b>*** 10/17/14 01:47 am ***</b>
<b>*** 10/17/14 01:49 am *** </b>
<b>*** 10/17/14 01:57 am ***</b>
<b>*** 10/17/14 08:47 am ***</b>
<b>*** 10/23/14 12:16 am ***</b>
<b>*** 10/23/14 12:17 am ***</b>
<b>*** 10/26/14 10:07 pm ***</b>
<b>*** 10/27/14 10:06 pm ***</b>
<b>*** 10/27/14 10:09 pm ***</b>
<b>*** 10/30/14 10:40 pm ***</b>
<b>*** 10/30/14 10:49 pm ***</b>
<b>*** 10/30/14 10:49 pm ***</b>
<b>*** 11/05/14 04:30 pm *** </b>
<b>*** 11/05/14 04:30 pm ***</b>
<b>*** 11/06/14 10:59 am *** </b>
<b>*** 11/17/14 09:20 pm ***</b>
<b>*** 12/02/14 12:36 am ***</b>
<b>*** 12/02/14 07:26 pm ***</b></pre>
<pre><b>
</b></pre>
<pre><b>Till a patch is made available, you need to shutdown the oaea managed server and restart fs_clone. So much for keeping all services online and the promise of no outage during fs_clone.</b></pre>
<div>
<b><br /></b></div>
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Vikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.com0