Archive for the ‘Issues’ Category

R12.2.5 single node cloning   1 comment

Hello all,

After long time I am updating my blog with R12.2.5 cloning.

There is a slight difference between R12.2.4 and R12.2.5.

With the introduction of dualfs in R12.2.5 we can even configure patch filesystem with single run of adcfgclone on the target node.

r1225_clone

Here in the above picture, if run filesystem is on fs2 on the source then on the target also we should configure fs2 as run filesystem and automatically fs1 will become patch filesystem

we copy only EBSApps folder from source fs2 filesystem which is RUN filesystem, to target fs2 filesystem

NOTE: DO NOT COPY EBSApps folder from source fs2 run filesystem to target fs1 folder, this resulted in error.

IF FS2 FILESYSTEM IS RUN THEN WE SHOULD COPY SOURCE EBSApps FOLDER FROM FS2 of source TO TARGET FS2. THIS SHOULD BE DONE AFTER RUNNING adpreclone.pl ON SOURCE RUN FILESYSTEM.

[applcrp4@crp4app1 fs2]$ cd /d01/oracle/CRP1/fs1
[applcrp4@crp4app1 fs1]$ ls -l
drwxr-xr-x 5 applcrp4 dba 4096 Nov 6 04:49 EBSapps
[applcrp4@crp4app1 fs1]$

[applcrp4@crp4app1 bin]$ perl adcfgclone.pl appsTier dualfs

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContext_1116040449.log

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

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

Target System Database SID : CRP1

Target System Database Server Node [crp4app1] : crp4db1

Target System Database Domain Name [ora.ad] :

Target System Base Directory : /d01/oracle/CRP1

Target System Base Directory set to /d01/oracle/CRP1

Target System Current File System Base set to /d01/oracle/CRP1/fs2

Target System Other File System Base set to /d01/oracle/CRP1/fs1

Target System Fusion Middleware Home set to /d01/oracle/CRP1/fs2/FMW_Home
Target System Other File System Fusion Middleware Home set to /d01/oracle/CRP1/fs1/FMW_Home

Target System Web Oracle Home set to /d01/oracle/CRP1/fs2/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /d01/oracle/CRP1/fs1/FMW_Home/webtier

Target System Appl TOP set to /d01/oracle/CRP1/fs2/EBSapps/appl
Target System Other File System Appl TOP set to /d01/oracle/CRP1/fs1/EBSapps/appl

Target System COMMON TOP set to /d01/oracle/CRP1/fs2/EBSapps/comn
Target System Other File System COMMON TOP set to /d01/oracle/CRP1/fs1/EBSapps/comn

Target System Instance Home Directory [/d01/oracle/CRP1] :

Target System Current File System Instance Top set to /d01/oracle/CRP1/fs2/inst/apps/d01_crp4app1

Do you want to preserve the Display [app-upg-app1:0.0] (y/n) : n

Target System Display [crp4app1:0.0] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] : enabled

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

Target System Port Pool [0-99] : 0

Checking the port pool 0
done: Port Pool 0 is free
Report file located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /tmp
3. /d01/oracle/d01/11204/appsutil/outbound/CRP1_crp4db1
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/appl/admin/CRP1_crp4app1.xml
Check Clone Context logfile /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContext_1116040449.log for details.

Creating Patch file system context file.....

Log file located at /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContextPatch_1116040654.log

Target System Other File System Instance Top set to /d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1/appl/admin/CRP1_crp4app1.xml
Check Clone Context logfile /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContextPatch_1116040654.log for details.

FMW Pre-requisite check log file location : /d01/oracle/CRP1/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...

Configuring: Run file system....
LogFile located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/log/clone/run/RCloneApplyAppstier_11160407.log

Configuring: Patch file system....
LogFile located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/log/clone/patch/RCloneApplyAppstier_11160433.log

Do you want to startup the Application Services for CRP1? (y/n) [n] : n

Services not started

Posted November 16, 2015 by balaoracledba.com in Cloning, R12.2

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory   2 comments

Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory

cd /d01/oracle/VIS/inst/apps/VIS_r12/logs/ora/10.1.3/opmn

vi HTTP_Server~1.log
--------
14/03/04 00:54:51 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 00:54:53 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 10:22:12 Start process

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Start up all Oracle Application Services.

Posted March 4, 2014 by balaoracledba.com in Issues

RC-50409: Topology information required for cloning not found in the database-adpreclone.pl dbTier errors out with   Leave a comment

On one of my 11i Instance DB when i executed adpreclone.pl dbTier i see below error

[oratest@testdb02 TSTINST_testdb02]$ perl adpreclone.pl dbTier
Running Rapid Clone with command...
 perl /TSTINST/oracle/product/112/appsutil/bin/adclone.pl java=/TSTINST/oracle/product/112/jdk mode=stage stage=/TSTINST/oracle/product/112/appsutil/clone component=dbTier method=CUSTOM dbctx=/TSTINST/oracle/product/112/appsutil/TSTINST_testdb02.xml showProgress
Beginning database tier Stage - Mon Nov 11 23:00:59 2013
APPS Password : apps
Log file located at /TSTINST/oracle/product/112/appsutil/log/TSTINST_testdb02/StageDBTier_11112301.log
 | 59% completed
RC-50409: Topology information required for cloning not found in the database. Make sure that AutoConfig was run successfully prior to starting Rapid Clone, and try again
Raised by oracle.apps.ad.tools.AdCreateCtlFile
RC-40001: Fatal: Failed to create sql script adcrdbclone.sql for recreating control files at target
ERROR while running Stage...
ERROR while running perl /TSTINST/oracle/product/112/appsutil/bin/adclone.pl java=/TSTINST/oracle/product/112/jdk mode=stage stage=/TSTINST/oracle/product/112/appsutil/clone component=dbTier method=CUSTOM dbctx=/TSTINST/oracle/product/112/appsutil/TSTINST_testdb02.xml showProgress ... Please check the log for more details..
[oratest@testdb02 TSTINST_testdb02]$ vi /TSTINST/oracle/product/112/appsutil/log/TSTINST_testdb02/StageDBTier_11112301.log

Cause:
The Contextfile on the Database Tier is missing the value for "s_domainname". 

Solution:
RUN AUTOCONFIG on the Database Tier

[oratest@testdb02 TSTINST_testdb02]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /TSTINST/oracle/product/112/appsutil/log/TSTINST_testdb02/11112301/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /TSTINST/oracle/product/112
Classpath : /TSTINST/oracle/product/112/jdk/jre/lib/rt.jar:/TSTINST/oracle/product/112/jdk/lib/dt.jar:/TSTINST/oracle/product/112/jdk/lib/tools.jar:/TSTINST/oracle/product/112/jdbc/lib/ojdbc5.jar:/TSTINST/oracle/product/112/appsutil/java/xmlparserv2.zip:/TSTINST/oracle/product/112/appsutil/java:/TSTINST/oracle/product/112/jlib/netcfg.jar:/TSTINST/oracle/product/112/jlib/ldapjclnt11.jar
Using Context file : /TSTINST/oracle/product/112/appsutil/TSTINST_testdb02.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.

Once after running autoconfig i again executed adpreclone.pl

[oratest@testdb02 TSTINST_testdb02]$ perl adpreclone.pl dbTier
Running Rapid Clone with command...
perl /TSTINST/oracle/product/112/appsutil/bin/adclone.pl java=/TSTINST/oracle/product/112/jdk mode=stage stage=/TSTINST/oracle/product/112/appsutil/clone component=dbTier method=CUSTOM dbctx=/TSTINST/oracle/product/112/appsutil/TSTINST_testdb02.xml showProgress
Beginning database tier Stage - Mon Nov 11 23:02:23 2013
APPS Password : apps
Log file located at /TSTINST/oracle/product/112/appsutil/log/TSTINST_testdb02/StageDBTier_11112302.log
Completed Stage...
Mon Nov 11 23:02:35 2013
Completed running perl /TSTINST/oracle/product/112/appsutil/bin/adclone.pl java=/TSTINST/oracle/product/112/jdk mode=stage stage=/TSTINST/oracle/product/112/appsutil/clone component=dbTier method=CUSTOM dbctx=/TSTINST/oracle/product/112/appsutil/TSTINST_testdb02.xml showProgress ...

 

Posted November 12, 2013 by balaoracledba.com in Issues, OracleAppsR12

12.1.1 rapidwiz – libmwat.so libXext.so.6 libXtst.so.6 not found on OEL6U3   4 comments

When i was trying to install R12.1.1 (64-bit) on OEL6.3. I hit below error:

4

this is due to missing RPM’s specific to libX*

I manually executed yum as seen below

sudo yum install glibc.i686 libXext.i686 libXtst-devel.i686

Once i finished installing again i executed ./rapidwiz

5

Posted November 11, 2013 by balaoracledba.com in Issues, OracleAppsR12

11i/R12 Apache Common Issues with Solutions   4 comments

I dont know where I got this document. But I am thankful to the person who collected all these issues in one single Document.

Credits to that Person

Apache Common Issues

General Information to Troubleshoot Apache Issues.

1)If you mistype any directive in Apache (httpd.conf or any conf file), Apache will not start & it will not write even in error_log. In these case it will report any error message to file
$COMMON_TOP/admin/log/$CONTEXT_NAME/adapcctl.txt

So first check in the above file

2)Found *.pid file in Apache_Top/Apache/logs/ even after bounce of an Apache web server (When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file). So if this file is already there then Apache will not start.
Fix: Simply move this file

3)Could not bind port (Port already in Use) or Sometimes apache and concurrent Manager will interchange their port no.’s while starting results error and both of them will not up
Fix: To overcome this up the services in this manner
1)Listener
2)Apache web server
3)Concurrent manager
4)adstrtal.sh

4)Error 500 – Internal server error
Fix: 1) Clear Cache (Application Server Cache)and start the services

5)If there are no error messages in error_log or error_log_pls
then there might be issues in starting Jserv component of web server (which caters Java requests by mod_jserv)

6)If you don’t know port number of your web server you can check it in file $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf with directive Listen & Port

7)Once you are able to access http://hostname.domainname:port and if you are getting any error message that means your web server (Core Apache) is working but there are various components called as modules and there may be issues with those modules which we will check these modules . few modules of our interest are
-mod_jserv
-mod_pls
-mod_oprocmgr
-mod_ossl (If you have ssl enabled on web server)
-mod_osso (If single sign on server is enabled on web server)

8)Once in a while adapcctl.sh start will not work then ultimate you have to go and invoke apachectl script file in Apache top/apache/bin to start Apache webserver.

09)Error : Your session is no longer valid while trying to loging to applications.
The issue is resolved by changing the profile option session_cookie_domain to null from domain.com

10)HTTP-403 forbidden message after entering the username and password in the “Apps Logon Links” page. [Not authorised to view this page]
Check for Apps password in $APACHE_TOP/modplsql/cfg/wdbsvr.app ,Comment out custom_auth entry in $APACHE_TOP/modplsql/cfg/wdbsvr.app and bounce apache.

11)Error message: You have insufficient privileges for the current operation.
Verify and update SESSION_COOKIE_DOMAIN in ICX_parameters if it is wrong.

Example :

update icx_parameters set SESSION_COOKIE_DOMAIN=’NEW_VALUE’ where SESSION_COOKIE_DOMAIN=’OLD_VALUE’

12)AppsLocalLogin?.jsp page error outs….

  • Edit the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties
  • Set wrapper.bin.parameters=-DLONG_RUNNING_JVM=false
  • add the line wrapper.bin.parameters=-DCACHEMODE=LOCAL
  • Restarted Apache for these changes to take effect and retested the issue

13) Login to the applications URL fails with
500 Internal server Error
java.lang.NoClassDefFoundError at
oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) at
oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.loadServlet(HttpApplication.java:2231) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.findServlet(HttpApplication.java:4617) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.findServlet(HttpApplication.java:4541) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)

Performed the below steps, but it did not resolved the issue
1) Bounced Apache server, cleared cache and validated ports
2) Bounced all Middle tier services and killed defunct processes
3) Bounced Unix Server

Solution
=======
Java object Caching Configuration parameter was Enabled in oc4j.properties
$INST_TOP/ora/10.1.3/j2ee/oacore/config
Disabled LONG_RUNNING_JVM=false from True
Bounced Apache server and could login to the applications URL without issues

                           ISSUES AND SOLUTIONS

ISSUE 1:

Description

When Apache script adapcctl.sh is issued.It shows that Apache is started.On checking the status Apache is stopped

Cause

The error log file in the folder
cd $APACHE_TOP/Apache/logs

Showed

fopen: No such file or directory httpd: could not log pid to file /var/opt/_/Apache/logs/httpd_pls.pid

SOLUTION 1

Created the missing directories /_/Apache/logs under /var/opt folder
Bounced Apache
**********************************************************************
ISSUE 2:

Description
oacore was not comming up in the configurator node.
opmnctl status

ias-component process-type pid status

OC4J oacore N/A Down
OC4J oacore N/A Down
OC4J oacore N/A Down
OC4J oacore N/A Down

Cause

Check the oacore error log.

Example:

Below Log file gives root cause. //mtlog/_/logs/ora/10.1.3/opmn/oacore_default_group_2/oacorestd.err

14:11:56 Error initializing server: //inst/apps/_/ora/10.1.3/j2ee/oacore/config/server.xml,
Fatal error at line 70 offset 1 in file://inst/apps/_/ora/10.1.3/j2ee/oacore/config/server.xml: .:
XML-20100: (Fatal Error) Expected ‘EOF’.
SOLUTION 2

Edit the /sid/inst/apps/SID_hostname/ora/10.1.3/j2ee/oacore/configserver.xml file and remove the extra line in the file. Restart and check oacore will be starting. This sudden change in server.xml seems to be because of a bug.
Bug – 6702510
************************************************************************
ISSUE 3

AppsLocalLogin?.jsp page was displaying errors

Cause

Extract from the Jserv log file =========================== [27/02/2008 16:57:14:447 CST] weboamLocal/oracle.apps.fnd.oam. servlet.ui.OAMServlet:
Sucessfully initialize oaosu.OAMServlet [27/02/2008 16:57:14:447 CST] Servlet Zone rootauohstrzt11 initia lization complete [27/02/2008 16:57:15:101 CST]
Creating noun for: oracle.jsp.JspServlet [27/02/2008 16:57:15:102 CST] Creating noun for: AppsLocalLogin?.jsp
[27/02/2008 16:57:15:120 CST] oracle.jsp.JspServlet: init [27/02/2008 16:57:28:066 CST] Creating noun for: oracle.jsp.JspServlet
[27/02/2008 16:57:28:067 CST] Creating noun for: AppsLocalLogin?.jsp [27/02/2008 16:57:28:078 CST] oracle.jsp.JspServlet: init
[27/02/2008 16:57:29:753 CST] JspServlet?: unable to dispatch to requested page: Exception:java.lang.NoClassDefFoundError

SOLUTION 3:

Edited the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties
a) Set wrapper.bin.parameters=-DLONG_RUNNING_JVM=false
b) Add the line wrapper.bin.parameters=-DCACHEMODE=LOCAL
c) Restarted Apache for these changes to take effect and retested the issue
********************************************************************
ISSUE 4

New Message when starting Apache using adapcctl.sh start

Cause

It takes 7/10 minutes to clear this cache directory if present
apache Web Server Listener is not running.

Starting Apache Web Server Listener (dedicated HTTP) …

Removing gantt cache directory
/ppomwi/applmgr/r12/apps/apps_st/comn/webapps/oacore/html/cabo/images/cache
Successfully removed the gantt cache directory:/tcge1i/applmgr/common/html/cabo/images/cache/gantt

Apache Web Server Listener (PLSQL) is not running.

Starting Apache Web Server Listener (dedicated PLSQL) …

SOLUTION 4

$COMMON_TOP/webapps/oacore/html/cabo/images/cache

Wait for atleast 7 to 10 minutes and this cache directory will be cleared and Apache will be started successfully
***********************************************************************
ISSUE 5

Apache server is up and running.
But adapcctl.sh status shows
adapcctl.sh version 115.54
Apache Web Server Listener is not running. Apache Web Server Listener (PLSQL) is not running.

adapcctl.sh: exiting with status 1

Cause

Incorrect Lock file path given in httpd.conf
LockFile? $APACHE_TOP/Apache/log/PPOMWI_httpd.lock
and Incorrect path given in adapcctl.sh script.

SOLUTION 5:
Modified the path of lock file in $APACHE_TOP/Apache/conf/httpd.conf file.
LockFile? /var/opt/SID_/httpd.lock
and Modified the path of adapcctl.sh file by commenting the wrong path
************************************************************************
ISSUE 6

After selecting the E-Business home page got internal server error Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Cause
Found that all the properties files as below
jserv.properties jserv_restrict.properties zone.properties zone_restrict.properties
were pointing to a dbc file name _.dbc
which was not physically present at the path
/sid/applmgr/11510/fnd/11.5.0/secure/_
$ cd //applmgr/11510/fnd/11.5.0/secure/_
$ ls .dbc

SOLUTION 6:

copied the file PROD.dbc
which was physically present at path
//applmgr/11510/fnd/11.5.0/secure/_
to the dbc file name which was being pointed by all the properties files
This resolved the issue.
**********************************************************************
ISSUE 7
Instance is very slow / inaccessible with a warning on login page:
Warning

Low-level logging is currently enabled. Your application will not perform as well while Low-level logging is on.

Cause
Logging was enabled through profile values:
FND: Debug Log Enabled — Yes
FND: Debug Log Level — Statement
FND: Debug Log Module — %
SLA: Enable Diagnostics — Yes
FND Validation Level — Error

SOLUTION 7
1. Change these values to:
FND: Debug Log Enabled — No
FND: Debug Log Level — ( Blank )
FND: Debug Log Module — ( Blank )
SLA: Enable Diagnostics — No
FND Validation Level — None

2. Bounce Apache on all the MTs and clear Apache cache.
*********************************************************************
ISSUE 8

Login to the applications URL fails with
500 Internal Server Error java.lang.NoClassDefFoundError at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect?.java:126) at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect?.java:170) at com.evermind[Oracle Containers for J2EE? 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication?.java:2231) at com.evermind

Performed the below steps, but it did not resolved the issue
1) Bounced Apache server, cleared cache and validated ports
2) Bounced all Middle tier services and killed defunct processes
3) Bounced Unix Server

Cause
No Cause Entered

SOLUTION 8

Java object Caching Configuration parameter was Enabled in oc4j.properties $INST_TOP/ora/10.1.3/j2ee/oacore/config
Disabled LONG_RUNNING_JVM=false from True

Bounced Apache server and could login to the applications URL without issues

Java Caching is a mechanism used to improve performance by storing data in the Middle Tier JVM memory, instead of retrieving the data from the database every time it is requested.
***********************************************************************
ISSUE 9
When trying to access the URL (Either Big IP or the node level), it hangs for a long time and getting redirected to a different URL and gives a blank page. For example, When try to access the ipayments URL which is hosted on node2, it hangs for a long time and its getting redirected towards the Sales URL which is hosted on node3, and displays a blank page.

Cause
All the host reference and the URL directives are pointing towards node3 and sales URL respectively, in the below files. Hence every attempt tries to launch the sales URL and get fails as the apache configuration files and parameters are pointing towards the correct one.
jserv.conf forms.properties zone.properties jserv.properties

SOLUTION 9

Stop Apache. Edit the files jserv.conf, forms.properties, zone.properties, jserv.properties, jserv.conf to replace the host reference and the URL directives to the correct one (In our case, its node3 . Clear the cache and restart the Apache.

ISSUE 10
Apache login issues occurs in multi MT environment. Unable to login to oracle applications.

Cause
Issue due to distributed cache.

SOLUTION 10
Set is_distributed to false in javacache.xml Bounce Apache.

ISSUE 11
Apache server is down. Apache logfile did not provide useful information.
Started the Apache server, but the Apache Web listener did not started.
1) Verified no log files (Apache,Jserv) crossed 2GB limit. error_log, access.log, mod_jserv
2) Veified that the port is listening (netstat -an |grep ) Apache port(httpd.conf), pls listener(httpd_pls.conf)
3) Verified that the Apache and Jserv configuration files are not changed recently httpd.conf & Jserv.conf
4) Shutdown all the Middle tier services and check for ipcs (semaphores) did not resolve the outage.
$ ipcs on application middle tier as Application user ap

Cause
No Cause Entered

SOLUTION 11

Rebooted the server and started the services. All services came back normal.
************************************************************************
ISSUE 12
Unable to login to the home page URL. Login fails with the error:
Error Page You have encountered an unexpected error. Please contact the system administrator for assistance.

Click here for exception details

Checks:

Upon clicking the link, can observe the error:
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PL SQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode=’null’,’2D8 FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412?’); REASON = java.s ql.SQLException: ORA-01422: exact fetch returns more than requested number of ro ws ORA-06512: at “APPS.FND_SESSION_MANAGEMENT”, line 295 ORA-06512: at “APPS.FND_SESSION_MANAGEMENT”, line 455 ORA-06512: at line 1 ; ERRNO = 1422;

Cause
FND_NODES table was updated with the same server_id for all Nodes.

SOLUTION 12

Update the table FND_NODES with correct server_ids for all nodes as in $FND_TOP/secure/sid_host/sid.dbf
Bounced apache on all apache nodes.

and Run select node_name, server_id from fnd_nodes;
to confirm the values.

Below is the example for the solution:

Found three hosts using same server_id:

SQL> select node_name, server_id from fnd_nodes; NODE_NAME SERVER_ID
AUOHSACPS06 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
AUOHSACPS03 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
AUOHSACPS02 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412

reset server_id with original server_id from each hosts .dbc file @ $FND_TOP/secure:

SQL> select node_name, server_id from fnd_nodes; NODE_NAME SERVER_ID
AUOHSACPS06 2D8FF21843830F82E040558CDBC6195C27690802237516122831445560236127
AUOHSACPS03 2D90005D5A13C774E040558CDBC61D9436546148971863330582284123371818
AUOHSACPS02 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
************************************************************************
ISSUE 13

Users getting ‘404 page not found errors’ when tyring to access the URL

(OR)

Getting Exception in thread “main” java.lang.ClassFormatError: Truncated class file

(OR)

adstrtal.sh or adstpall.sh is throwing below error message

You are running adstrtal.sh version 115.16

Exception in thread “main” java.lang.ClassFormatError: oracle/apps/ad/context/AppsContext (Truncated class file) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader?.java:539) at java.security.SecureClassLoader.defineClass(SecureClassLoader?.java:123) at java.net.URLClassLoader.defineClass(URLClassLoader?.java:251) at java.net.URLClassLoader.access$100(URLClassLoader?.java:55) at java.net.URLClassLoader$1.run(URLClassLoader?.java:194) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader?.java:187) at java.lang.ClassLoader.loadClass(ClassLoader?.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader?.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader?.java:302) at oracle.apps.ad.autoconfig.ServiceControl.(ServiceControl?.java:319) at oracle.apps.ad.autoconfig.ServiceControl.main(ServiceControl?.java:662) Check logfile //applmgr/common/admin/log/_/08061104.log for details

Exiting with status 1

(OR)

[06/08/2007 11:03:12:181] (ERROR) an error returned handling request via protocol “ajpv12” [06/08/2007 11:03:12:181] (EMERGENCY) ajp12: can not connect to host 140.85.188.36:20021 [06/08/2007 11:03:13:184] (EMERGENCY) ajp12: can not connect to host 140.85.188.36:20021 [06/08/2007 11:03:15:038] (EMERGENCY) ajp12: auth did not receive challenge size [06/08/2007 11:03:15:038] (EMERGENCY) ajp12: auth fail

Cause

Extract from the JVM log file: //product/iAS/Apache/Jserv/logs/jvm/OACoreGroup.0.stderr
Exception in thread “main” java.lang.ClassFormatError: Truncated class file at org.apache.jserv.JServServletManager.load_init(JServServletManager?.java:765) at org.apache.jserv.JServServletManager.loadServlet(JServServletManager?.java:659) at org.apache.jserv.JServServletManager.loadStartupServlets(JServServletManager?.java:789) at org.apache.jserv.JServServletManager.init(JServServletManager?.java:447) at org.apache.jserv.JServ.start(JServ.java:625)

Verified that there are no log files that exceed 2GB limit (OS limit).
Clearing the Apache and Jserv cache did not resolve the issue. Unmount / mount product specific file system did not resolve

SOLUTION 13:

Try each of these solutions until the problem is resolved, in order to have the least impact on the system.
1. If you can determine the specific class file from the log files, use the ‘touch’ command.

e.g. touch classfile

If necessary, restart Apache and clear server cache.

2. Shut down all MT services, exit the Apps owner and ask the System Admin to unmount and remount the /sid/applmgr file system (mount point above $JAVA_TOP). Ask the System Admin to kill any processes that may be holding the file system open. Then log in to the Apps owner and restart MT services.

3. Shutdown all the MT services and ask System Admin to reboot the server if the actions above don’t resolve the outage.
************************************************************************
ISSUE 14:

Got login error – Internal Server Error after bounced all services on . find following message from Jserv log file:

$ tail -8 mod_jserv.log
[07/05/2007 18:41:06:915] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
[07/05/2007 18:41:06:916] (ERROR) an error returned handling request via protocol “ajpv12”
[07/05/2007 18:41:06:916] (ERROR) balance: 11906 internal servlet error in server auohsnops03.oracleoutsourcing.com:20720
[07/05/2007 18:41:06:916] (ERROR) an error returned handling request via protocol “balance”
[07/05/2007 20:07:52:732] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
No runaway, no lock on port 20720.

SOLUTION 14:
Shutdown all services on MT. Removed all log file (standard error…) from Jserv/jvm. Started All services with successful login.
************************************************************************
ISSUE 15
Customer reported Not able to login with “Internal Server Error” on .
We could not start some of services during bounced All Services with following error message: adapcctl.sh version 115.47
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

Apache Web Server Listener is not running (dedicated HTTP) …
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

Apache Web Server Listener is already stopped.
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.
adapcctl.sh: exiting with status 2

Unable to login the application URL, facing the error while login:

Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, ap@domain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

Cause:

SQL> select END_DATE from fnd_user where user_name=’GUEST’;

END_DATE
———
05-OCT-10

SOLUTION 15

We found out the apps and applsys were not in sync.
Just manual change the apps password from sqlplus.
Restarted all services and login successfully.

or

Update the FND_USER table with END_DATE=null and bounced apache
SQL> update fnd_user set END_DATE=null where user_name=’GUEST’;

1 row updated.

SQL> commit;

Commit complete.

SQL> select END_DATE from fnd_user where user_name=’GUEST’;

END_DATE
———–
************************************************************************

 

 

 
ISSUE 16

Unable to login to oracle applications:
error message: You have insufficient privileges for the current operation.

Checks

Unable to login to oracle applications:
error message: You have insufficient privileges for the current operation.

SOLUTION 16

Verify and update SESSION_COOKIE_DOMAIN in ICX_parameters if it is wrong.

Example :

update icx_parameters set SESSION_COOKIE_DOMAIN=’NEW_VALUE’ where SESSION_COOKIE_DOMAIN=’OLD_VALUE’;
************************************************************************
ISSUE 17

Apache home page is not coming up even after bounced
Found in jvm log asking for java version

SOLUTION 17

//product/iAS/Apache/Apache/bin/java.sh: /usr/java/jdk1.3.1_15/bin/java: not found

Check the version in /usr/java and update that version in java.sh file and Bounced Apache.
************************************************************************
ISSUE 18

Unable to access applications

cause
All applications are up and running.
“Solaris Error: 12: Not enough space” errors are encounterd in database listener logfile.

SOLUTION 18:

Check if the OS is SUN Solaris.
Check if /tmp filesystem is 100% full.
Check Swap space utilization.
Check the application process that is hagging resources. (Check if any sql sessions are hagging resources)
Clear the process in issue after getting required approval.

NOTE:
The above is applicable only for environments on Solaris OS.
************************************************************************
ISSUE 19

Not able to login to APPS. JSP Error:
Unable to create an user session or ORA-01403 : no data found has been detected in FND.SIGNON.AUDIT_USER

Checks

Check number of rows in dual table.
Select * from dual;
DUAL table should always contain only one row.
The table named DUAL is a small table in the data dictionary that Oracle and user-written programs can reference to guarantee a known result.
This table has one column called DUMMY and one row containing the value X.

SOLUTION 19

DUAL table should always contain only one row and one column.
Insert a row with value X into dual table if the dual table contains 0 rows. If the dual table contains more than one row then delete the rows by keeping one row.

The rows in dual table not equal to zero.
************************************************************************
ISSUE 20

Signature for “https URL redirecting to http URL”
Issue:
https URL redirecting to http URL and the page cannot be displayed error occurs.

SOLUTION 20

Check the httpd.conf and url_fw.conf, in url_fw.conf the Rewrite rule was
RewriteRule ^/$/OA_HTML/AppsLocalLogin.jsp.
Changed into
RewriteRule https://: /OA_HTML/AppsLocalLogin.jsp.

 

Posted October 30, 2013 by balaoracledba.com in Issues, OracleAppsR12

R12.2. Cloning Step-by-Step   49 comments

Here we go………………….

My First R12.2. Clone

clone_ora

newclone

STEP1:Prepare Souce Node for Cloning

Run adpreclone.pl from RUN File System

cd /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/admin/scripts/

[applprod@idbaprod-appl scripts]$ adpreclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
 Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adpreclone Version 120.31.12020000.7
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /d01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /d01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/d01/oracle/R122/fs1/FMW_Home/jrockit64 mode=stage stage=/d01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method= appctx=/d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml showProgress

Setting the wls environment
Beginning application tier Stage - Wed Oct 23 04:32:22 2013
/d01/oracle/R122/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /d01/oracle/R122/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/d01/oracle/R122/fs1/EBSapps/comn/java/classes:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/share.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/d01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/d01/oracle/R122/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml -stage /d01/oracle/R122/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/admin/log/StageAppsTier_10230432.log
| 20% completed
Completed Stage...
Wed Oct 23 04:40:32 2013

Step2:WHAT NEEDS TO BE COPIED
----------------------------

Choose only RUN FILE SYSTEM for copying

what1

Prepare Target

mkdir -p /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs2/
mkdir -p /u01/oracle/R122/fs_ne/

STEP3:After finishing the copy CONFIGURE TARGET RUN FILE SYSTEM

Go to clone directory

cd /u01/oracle/R122/fs1/EBSapps/comn/clone/bin

RUN perl adcfgclone.pl appsTier

[appltest@rel-dem-test01 bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
 Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
Enter the APPS password :
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_17052.lst -stage /u01/oracle/R122/fs1/EBSapps/comn/clone 2> /tmp/adcfgclone_17052.err; echo $? > /tmp/adcfgclone_17052.res
Log file located at /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
Target System File Edition type [run] :run
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [rel-dem-test01] :
Target System Database SID : TEST
Target System Database Server Node [rel-dem-prodas01] : rel-dem-testdb01
Target System Database Domain Name [ora.ad] :
Target System Base Directory : /u01/oracle/R122
Target System Base Directory set to /u01/oracle/R122
Target System Current File System Base set to /u01/oracle/R122/fs1
Target System Other File System Base set to /u01/oracle/R122/fs2
Target System Fusion Middleware Home set to /u01/oracle/R122/fs1/FMW_Home
Target System Web Oracle Home set to /u01/oracle/R122/fs1/FMW_Home/webtier
Target System Appl TOP set to /u01/oracle/R122/fs1/EBSapps/appl
Target System COMMON TOP set to /u01/oracle/R122/fs1/EBSapps/comn
Target System Instance Home Directory [/u01/oracle/R122] :
Target System Instance Top set to /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01
Do you want to preserve the Display [rel-dem-prod01:0.0] (y/n) : n
Target System Display [rel-dem-test01:0.0] : rel-dem-test01:1.0
Target System Root Service [enabled] :
Target System Web Administration [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [enabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 0
Checking the port pool 0
done: Port Pool 0 is free
Report file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
Complete port information available at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/oracle/product/11.2.0/appsutil/outbound/TEST_rel-dem-proddb01
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Creating the new APPL_TOP Context file from :
 /u01/oracle/R122/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
 /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml
Log file located at /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
Check Clone Context logfile /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log for details.
Running Rapid Clone with command:
Running:
perl /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -log /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct 23 03:09:54 2013
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/log/ApplyAppsTier_10230309.log
 | 100% completed
Completed Apply...
Wed Oct 23 03:28:43 2013

 Executing command: /u01/oracle/R122/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for TEST? (y/n) [n] :
Services not started

STEP4:Once we are done with everything. Start the application Tier using adstral.sh
———————————————————————————–

RUN the ENV for the Applciation tier

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

Provide Weblogic Password:
Once application is up do a sample Health Check.
STEP4:RUN adpreclone on TARGET RUN FILESYSTEM

[appltest@rel-dem-test01 scripts]$ adpreclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adpreclone Version 120.31.12020000.7
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /u01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /u01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/oracle/R122/fs1/FMW_Home/jrockit64 mode=stage stage=/u01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress

Setting the wls environment
Beginning application tier Stage - Wed Oct 23 04:32:22 2013
/u01/oracle/R122/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/R122/fs1/EBSapps/comn/java/classes:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/log/StageAppsTier_10230432.log
| 20% completed
Completed Stage...
Wed Oct 23 04:40:32 2013

STEP5:SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM
------------------------------------------------------------------
cd $ADMIN_SCRIPTS_HOME
adstpal.sh apps/apps
provide Weblogic admin password:

STEP6:COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM
----------------------------------------------------------------
make sure you already created the directory structure like

mkdir -p /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs2/<-------------------Here We need to copy EBSapps from /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs_ne/
UNSET the application Enviroment.Previously we have executed env.
Before we run adcfgclone.pl dont run any env's, Directly go to /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/ and execute adcfgclone.pl
STEP7:Once Finished copying START CONFIGURING TARGET PATCH FILESYSTEM
---------------------------------------------------------------------
[appltest@rel-dem-test01 bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
 Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
Enter the APPS password :
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_4606.lst -stage /u01/oracle/R122/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_4606.err; echo $? > /tmp/adcfgclone_4606.res
Log file located at /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file : /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /u01/oracle/R122/fs2/FMW_Home
Target System Web Oracle Home set to /u01/oracle/R122/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/oracle/R122/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/oracle/R122/fs2/EBSapps/comn
Target System Instance Top set to /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01
Target System Port Pool [0-99] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
Complete port information available at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/oracle/product/11.2.0/appsutil/outbound/TEST_rel-dem-testdb1
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Creating the new APPL_TOP Context file from :
 /u01/oracle/R122/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
 /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml
Log file located at /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log
Check Clone Context logfile /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log for details.
Running Rapid Clone with command:
Running:
perl /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/R122/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs2/EBSapps/comn/clone -log /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct 23 05:43:35 2013
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/R122/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-prodas01.xml -stage /u01/oracle/R122/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/admin/log/ApplyAppsTier_10230543.log
 / 100% completed
Completed Apply...
Wed Oct 23 06:03:53 2013
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is no rows selected
Updating incomplete CLONE record to COMPLETED

STEP8:Once we are done with everything. Start the application Tier using adstral.sh

This time set the env to RUN File System

. /u01/oracle/R122/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

Hope so this Helps…………………

Posted October 23, 2013 by balaoracledba.com in Cloning, R12.2

Managers down – Status show “Target node/queue unavailable   5 comments

Concurrent Managers Status shows  ”Target node/queue unavailable”  in Concurrent–>Manager–>Administer Screen form.

target

 

Solution:

Ensure Database is Running and Middle Tier Services are down.

Connect SQLPLUS as APPS user and run the following :

EXEC FND_CONC_CLONE.SETUP_CLEAN;

COMMIT;

EXIT;

  • Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtier to repopulate the required systemtables
  • Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
  • Note.134007.1 – ‘CMCLEAN.SQL – Non Destructive Script to Clean Concurrent  Manager Tables‘
  • Start the middle tier services including your concurrent manager.
  • Retest the issue.