manually undeploy the application if you are not able to do so from dcm

At the time of undeploying an application in Oracle Application Server 10.1.2 it is fiving the following error


Error

An error occured while undeploying the application. Base Exception:

No ApplicationInfo is associated with application named: Sth

Resolution:





You have to manually undeploy the application if you are not able to do so from dcm.



1. Shut down the HTTP server of the OAS

2. Shut down all the OC4J instances in the OAS



-bash-3.2$ cd /u01/10G_AS/Midd/

-bash-3.2$ ./opmn/bin/opmnctl status



Processes in Instance: midd.tcs186246.tcskolkata.co.in

-------------------+--------------------+---------+---------

ias-component
process-type
pid
status

-------------------+--------------------+---------+---------

DSA
DSA
N/A
Down

LogLoader
logloaderd
N/A
Down

dcm-daemon
dcm-daemon
17680
Alive

OC4J
home
17521
Alive

OC4J
OC4J_Portal
N/A
Down

WebCache
WebCache
17488
Alive

WebCache
WebCacheAdmin
17477
Alive

HTTP_Server
HTTP_Server
17479
Alive



-bash-3.2$ ./opmn/bin/opmnctl stopall

opmnctl: stopping opmn and all managed processes...



3. Run dcmctl getState -v -d and check if you are in synch or not



-bash-3.2$ ./dcm/bin/dcmctl getState -v -d





Current State for Instance:midd.tcs186246.tcskolkata.co.in



Component Type Up Status In Sync Status

================================================================================

1 HTTP_Server HTTP_Server Down True

2 OC4J_Portal OC4J Down True

3 home OC4J Down True



4. Goto the following path

-bash-3.2$ cd ./j2ee/OC4J_Portal/config



5. Take the Backup of server.xml and default-web-site.xml file.



-bash-3.2$ cp server.xml server.xml_bkp

-bash-3.2$ cp default-web-site.xml default-web-site.xml_bkp



6. Edit both files to delete the entries respective to the application, which you want to delete.



-bash-3.2$ vi server.xml

-bash-3.2$ vi default-web-site.xml

-bash-3.2$ vi server.xml



7. Go to the following directory and remove the ear and the directories of the specified applications.



-bash-3.2$ cd ../applications

-bash-3.2$ ls -lrt

total 17864

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portalHelp2

-rw-rw---- 1 oracletrg dba 2687627 Feb 1 12:59 jpdk.ear

drwxrwx--- 5 oracletrg dba 4096 Feb 1 12:59 jpdk

drwxrwx--- 7 oracletrg dba 4096 Feb 1 12:59 UltrasearchQuery

drwxrwx--- 6 oracletrg dba 4096 Feb 1 12:59 UltrasearchAdmin

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 orauddi

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portalHelp

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 UltrasearchPortlet

drwxrwx--- 8 oracletrg dba 4096 Feb 1 12:59 portalTools

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portal

drwxrwx--- 5 oracletrg dba 4096 Feb 1 12:59 oraudrepl

-rw-r--r-- 1 oracletrg dba 5441117 Feb 11 18:15 SimpleStruts2.ear

drwxr-xr-x 4 oracletrg dba 4096 Feb 11 18:15 SimpleStruts2

-rw-r--r-- 1 oracletrg dba 10075940 Feb 14 10:58 Sth.ear

drwxr-xr-x 4 oracletrg dba 4096 Feb 14 10:58 Sth

-bash-3.2$ rm -rf SimpleStruts2.ear SimpleStruts2 Sth.ear Sth





8. Go to the following directory and remove the directories of the specified applications.



-bash-3.2$ cd ../application-deployments/

-bash-3.2$ ls -lrt

total 52

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:58 default

drwxrwx--- 6 oracletrg dba 4096 Feb 1 12:59 oraudrepl

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 orauddi

drwxrwx--- 5 oracletrg dba 4096 Feb 10 15:28 UltrasearchQuery

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 UltrasearchPortlet

drwxrwx--- 6 oracletrg dba 4096 Feb 10 15:28 UltrasearchAdmin

drwxrwx--- 8 oracletrg dba 4096 Feb 10 15:28 portalTools

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portalHelp2

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portalHelp

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portal

drwxrwx--- 5 oracletrg dba 4096 Feb 10 15:28 jpdk

drwxr-xr-x 4 oracletrg dba 4096 Feb 11 18:15 SimpleStruts2

drwxr-xr-x 4 oracletrg dba 4096 Feb 14 10:58 Sth

-bash-3.2$ rm -rf SimpleStruts2 Sth



9. Go to $ORACLE_HOME(MID)/Apache/Apache/conf/



-bash-3.2$ cd ../../../Apache/Apache/conf/



10. Take a backup of mod_oc4j.conf file.



-bash-3.2$ cp mod_oc4j.conf mod_oc4j.conf_bkp



11. Edit the mod_oc4j.conf file to remove the entries regarding the applications.



-bash-3.2$ vi mod_oc4j.conf



12. Goto $ORACLE_HOME(MID)/dcm/bin/ and update the configuration



-bash-3.2$ cd dcm/bin/

-bash-3.2$ ./dcmctl updateConfig -v -d



13. Start the opmnctl



-bash-3.2$ ./../../opmn/bin/opmnctl startall

opmnctl: starting opmn and all managed processes...



14. Check the status of the opmnctl



-bash-3.2$ ./../../opmn/bin/opmnctl status



Processes in Instance: midd.tcs186246.tcskolkata.co.in

-------------------+--------------------+---------+---------
ias-component process-type         pid          status
-------------------+--------------------+---------+---------
DSA              DSA                        N/A       Down
LogLoader     LogLoader              N/A       Down
dcm-daemon dcm-daemon            14784   Alive
OC4J            home                        15646   Alive
OC4J            OC4J_Portal            15645   Alive
WebCache    WebCache               15618   Alive
WebCache    WebCacheAdmin     15607   Alive
HTTP_Server HTTP_Server          15609  Alive

On Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 Domains, Time of Day (TOD) May Drift or Jump

Product
Sun Fire 3800 Server
Sun Fire 4800 Server
Sun Fire 4810 Server
Sun Fire 6800 Server
Sun Fire V1280 Server
Netra 1280 Server

Bug Id
SUNBUG: 4876369

Date of Workaround Release
10-SEP-2003

Date of Resolved Release
04-NOV-2003

Impact

On very rare occasions, the Time of Day (TOD) on Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 domains may be susceptible to a clock drift or jump. As a result, any functionality that relies upon the System Controller (SC) timer may be inaccurate.

Contributing Factors

This issue can occur in the following releases:

SPARC Platform

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0014 or earlier
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.12.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.13.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.14.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.0, 5.15.1 and 5.15.2

Note: Systems with firmware 5.11.x are not affected by this issue. Use the "showsc -v" command to display the firmware version of the SC.

Symptoms

This issue may occur after 528 days of SC continuous uptime, where the TOD within a domain in the system may become random and unstable. The intervals reported have varied, but the behavior is generally that the TOD jumps backwards approximately one hour up to as much as one month. The TOD as seen by the SC itself does not jump.

There are no specific messages that would indicate this issue has occurred. It can only be discovered by the domain exhibiting unexpected behavior due to the domain TOD changing unexpectedly.

Resolution

This issue is addressed in the following releases:

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0015 (as delivered in patch 113751-05 or later)
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.3 (as delivered in patch 112884-04 or later)

Note: The patch must be added to both system controllers to remedy this issue.

Discoverer Startup Fails on Solaris

Discoverer Startup Fails on Solaris

When running the addischtl.sh start script, you see the following message:

Registering Discoverer Preference Repository oadutil.reg:Failed to bind to OAD
Workaround

Set the TMPDIR environment variable to the Oracle home directory of the release 8.0.6 visibroker directory. The following is an example of commands required to make this change:

% TMPDIR=/mount_point/product/8.0.6/vbroker
% export TMPDIR

ADSSTATS.SQL fails while applying R12.1.1 NLS Upgrade Patch 6678700

When attempting to Apply Patch 6678700,
the following error occurs.
ERROR
-----------------------
sqlplus -s APPS/***** AD_TOP\12.0.0\patch\115\sql\adsstats.sql 


Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.declare
*
ERROR at line 1:
ORA-20000: ORA-20001: invalid column name or duplicate columns/column
groups/expressions in method_opt Error while executing
FND_STATS.GATHER_SCHEMA_STATISTICS package.
ORA-06512: at line 91

ERROR: While running adsstats.sql :
object_name=FII.FII_FIN_ITEM_HIERARCHIES***ORA-20001: invalid column name or duplicate columns/column
groups/expressions in method_opt Error while executing
FND_STATS.GATHER_SCHEMA_STATISTICS package.
ORA-06512: at line 9

Solution

Please apply the following solution:
1. Make sure to have a valid backup for FND_HISTOGRAM_COLS table.

2. Run the following to delete column 'PARENT_FLEX_VALUE' from FND_HISTOGRAM_COLS.

delete from FND_HISTOGRAM_COLS
where table_name = 'FII_FIN_ITEM_HIERARCHIES'
and column_name = 'PARENT_FLEX_VALUE'

3- Restart the failed worker.

FRM-92101: Forms Server Java Exception: oracle.forms.net.ConnectionException: Forms session failed during startup:

After installing E-Business Suite R12, try to access system by Forms and the following error is displayed:

FRM-92101: Forms Server

Java Exception:
oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown Source)
at oracle.forms.net.HTTPConnection.connect(Unknown Source)
at oracle.forms.engine.FormsDispatcher.initConnection(Unknown Source)
at oracle.forms.engine.FormsDispatcher.init(Unknown Source)
at oracle.forms.engine.Runform.initConnection(Unknown Source)
at oracle.forms.engine.Runform.startRunform(Unknown Source)
at oracle.forms.engine.Main.createRunform(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

In $LOG_HOME/ora/10.1.3/j2ee//_/application.log next error is displayed:

yy/dd/mm 10.1.3.0.0 Started
yy/dd/mm .773 formsweb: FormsServlet init():
configFileName: $ORACLE_HOME/forms/server/appsweb.cfg
testMode: false
yy/dd/mm .783 formsweb: 10.1.3.0.0 Started
yy/dd/mm .288 formsweb: ListenerServlet init()
yy/dd/mm .514 formsweb: Forms session <1> aborted: runtime process
failed during startup with errors $ORACLE_HOME/bin/frmweb
: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

yy/dd/mm .514 formsweb: Forms session <1> exception stack trace:
oracle.forms.engine.RunformException: Forms session <1> failed during startup:
no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:702)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:359)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.
AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.
run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.
ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.
java:303)
at java.lang.Thread.run(Thread.java:595)
yy/dd/mm .214 formsweb: Forms session <2> aborted: runtime process
failed during startup with errors $ORACLE_HOME/bin/frmweb:
error while loading shared libraries: libXm.so.2: cannot open shared object
file: No such file or directory

In formsstd.out next error is displayed:

$ORACLE_HOME/bin/frmweb: error while loading shared
libraries: libXm.so.2: cannot open shared object file: No such file or directory




Solution

To implement the solution, please execute the following steps:

1. Install package openmotif rpm.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:

openmotif21-2.1.30-11.EL5.i386.rpm.

2. Bounce the services.
3. Retest.

References

NOTE:402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)

IE 8 is Supported for the following cases in R12

The Cases are given bellow:
E-Business Suite Release 12.0 Prerequisites

• Oracle Applications Technology R12.ATG_PF.A.DELTA.6 (patch 7237006) or later
• Oracle Forms Version 10.1.2.3 or later
• Desktop client running Microsoft IE 8 on:

• Windows XP Service Pack 2 or 3
• Windows Vista Service Pack 1 or 2

E-Business Suite Release 12.1 Prerequisites

• Oracle E-Business Suite 12.1.1
• Desktop client running Microsoft IE 8 on:

• Windows XP Service Pack 2 or 3
• Windows Vista Service Pack 1 or 2

R12 Performance issue when clicking 'Monitor Request' after Submitting Concurrent Requests

In R12, when clicking on the 'Monitor requests' button after submitting a request, It is taking longer time for this screen to open. This performance issue can be reproduced when invoking the standard concurrent request submission (or) View request page  from Oracle Application Framework (OAF) from various modules like Quoting, Report Manager, etc.

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 9747291
2. Ensure that you have taken a backup and Apply the patch in a test environment. .
3. Confirm the following file versions

RequestSummarySearchVO.xml  120.14.12010000.3

You can use the commands like the following:

strings -a $JAVA_TOP/oracle/apps/fnd/cp/viewreq/server/RequestSummarySearchVO.xml | grep Header

4. Retest the issue.
5. Migrate the solution as appropriate to other environments.