Monday, July 4, 2011

UNABLE TO CREDIT TRANSACTION ORA-01476 divisor is equal zero ORA-06512 APPS.ARP_PROCESS_CREDIT_INS_COVER

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:
On 11.5.10 in Production:UNABLE TO CREDIT TRANSACTION  ORA-01476 divisor is equal zero ORA-06512 APPS.ARP_PROCESS_CREDIT_INS_COVER
1.       Open credit transaction window.
2. Enter all details.
3. Save record.
4. Got error
Not able to credit transaction through credit transaction window.
ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.ARP_PROCESS_CREDIT_INS_COVER", line 261

Symptoms:


Log files:

Debug LOG FILE
--------------------------
*** This Transaction Is Not Being Monitored ***
EXCEPTION: Error executing insert dist stmt
EXCEPTION: arp_credit_memo_module.write_cm_sched_to_table()
EXCEPTION: Error fetching select cm lines
EXCEPTION: arp_credit_memo_module.credit_rule_transactions()
EXCEPTION: arp_credit_memo_module.credit_transactions_ins_mode(654996, , 436099, , )
EXCEPTION: derive_credit_information
EXCEPTION: arp_process_credit.insert_header
EXCEPTION : arp_process_credit_cover.insert_header_cover

Solution:
It is a bug 8489702
References:
Navigate to Oracle Diagnostics and run the Transaction Data Collection test
( Note 223834.1 ) for the affected transaction and check the output

Check the output of the Applications Collection Tool (ACT) for product AR
See Note 183274.1.

Note 398834.1 - Script Catalogue for Receivables Support Transaction and Reconciliation Issues

    
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-01403: no data found Error in Oracle Downstreams.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ORA-01403: no data found Error in Oracle Downstreams.


Log files:
++ ERROR QUEUE ++

Apply
Name Source
Database Source
Commit
Scn Message in
Txn causing
Error Total
Messages
in Txn Local
Transaction
ID Apply
Error
Message Error
Creation
Timestamp Source
Transaction
ID
APPLY_DEC_PROC UDPP.DUBAIWORLD .AE 1158911000920 3 7 5.22.50689 ORA-01403: no data found 04:15:34 05/21/09 4.20.47663
UDPP.DUBAIWORLD .AE 1158911001108 4 6 4.18.46373 ORA-01403: no data found 13:16:09 05/21/09 265.35.11029


APPLY_DEC_PROC STRMADMIN.APP_DEC_QUEUE Captured ABORTED STRMADMIN 00 STRMADMIN.RULESET$_1215

APPLY_DEC_PROC ABORTED 13:16:11 05/21/09 26714 ORA-26714: User error encountered while applying

DISABLE_ON_ERROR Y (for all apply processes)

Solution:

1403 error normally refers to inconsistency in the data between source and target, so you need to compare the data between the two sites to find the differences and manually fix them before starting the apply again.

It is recommended to set the apply parameter "disable_on_error" to false instead of its current value of true, so in the future any such errors doesn't stop the apply process, and then manually you can fix the errors without stopping the replication.

The following article used to find the steps needed to identify the transaction that caused the 1403 error :
Note.405541.1 Procedure to Print LCRs

References:

Run the Streams Health Check SQL scripts on the instances where
Streams is configured.
 
Note.273674.1 Streams Configuration Report and Health Check Script
Note.405541.1 Procedure to Print LCRs
More in depth information on how to diagnose the 1403 errors :
Note.265201.1 Troubleshooting Streams Apply Error ORA-1403, ORA-26787 or ORA-26786
How to manually resync the data :
Note.749036.1 How to Re-Synchronize Streams Replicated Objects Online

    
Get Oracle Certifications for all Exams
Free Online Exams.com

How to Gather HTTP Header Information From a Client PC

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
how to capture HTTP Header information from the client browser



Internet Explorer - ieHTTPHeaders


Please download ieHTTPHeaders from http://www.blunck.se/iehttpheaders.html



a:- Install the downloaded executable
b:- Open a new Internet Explorer session

c:- Activate the IEHTTPHeader window by selecting
"View/Explorer Bar/ieHTTPHeaders"
From your Internet Explorer menu bar. This will bring up a Window of HTTP header data that will accumulate as you navigate from place to place.

d:- Replicate the problem as directed in the SR.
e:- Click the "HEADERS VIEW" tab in the ieHTTPHeaders window
f:- Right click the "HEADERS VIEW" page and choose save
e:- Upload the file created.

Firefox - Live HTTP Headers

LiveHTTP headers is available as an xpi, under the installation tab:  http://livehttpheaders.mozdev.org 



a:- Install the downloaded executable
b:- Open a new Mozilla Firefox session

c:- Enable LiveHTTPheaders by choosing  "Tools / LiveHTTPHeaders".
This will bring up a Window of HTTP header data that will accumulate as you navigate from place to place.

d:- Replicate the problem as directed in the SR.

e:- Click the "Save All" button and upload the file created.





    

Get Oracle Certifications for all Exams
Free Online Exams.com

Clearing the _pages in R12 creates a blank login page issue

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
FYI : Clearing the _pages in R12 creates a blank login page issue, as in Release 12 the jsp files do not get compiled automatically.

If you made it be accident, use the ojspcompile.pl perl script to perform a manual pre-compilation of the JSP pages. The following command will compile all the JSP pages and build up the JSP cache again.

Unix: # $FND_TOP/patch/115/bin/perl ojspCompile.pl --compile --flush -p 2
Windows: C:> <FND_TOP>\patch\115\bin\perl -x ojspCompile.pl --compile --flush 



instead this is what you have to do to clear jsp cache in R12


clearing middle tier cache:

(R) Functional Administrator responsibility
(N) Core Services > Caching Framework > Global Configuration > Clear cache



    
Get Oracle Certifications for all Exams
Free Online Exams.com

How to clear Apps middle tier cache

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
For clearing middle tier cache:

(R) Functional Administrator responsibility
(N) Core Services > Caching Framework > Global Configuration > Clear cache



FYI : Clearing the _pages in R12 creates a blank login page issue, as in Release 12 the jsp files do not get compiled automatically.
If you made it be accident, use the ojspcompile.pl perl script to perform a manual pre-compilation of the JSP pages. The following command will compile all the JSP pages and build up the JSP cache again.
Unix: # $FND_TOP/patch/115/bin/perl ojspCompile.pl --compile --flush -p 2
Windows: C:> <FND_TOP>\patch\115\bin\perl -x ojspCompile.pl --compile --flush

This utility is also used by the AD utilities to perform this action, for example after patches are applied which replaced 1 or more JSP pages. Since this a manual action which also requires understanding of parameters to be passed to have the right (set of) JSP compiled this option may be error-prone.



    
Get Oracle Certifications for all Exams
Free Online Exams.com

Special characters like '&', '<' '>', '"' throw java exceptions in XDO document merge API

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Special characters like '&', '<' '>', '"' throw java exceptions in XDO document merge API.
On 11.5.10.2 in Production

Sending a test mail in PROD instance, the following error message appears.
The error seems to occur when an html link is attached. Normal content is sent successfully

Oracle Marketing Resp-->Administration-->Fulfillment-->CoverLetter
Give the cover letter name and paste it in the content and tryed to send a test
mail.

Symptoms:

Attaching an html link that is when the error occurs - it is the special characters in the link that is causing the error

This is explained in the following bug:
Bug 5865343: & CHARACTER IN RTF MERGED DOC CAUSES FULFILLMENT REQUEST TO FAIL

Log files:
error message screen showing the following error.

oracle.apps.fnd.framework.OAException: oracle.apps.jtf.base.resources.FrameworkException: oracle.xml.parser.v2.XMLParseException: Expected name instead of . at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:205) at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1001) at oracle.xml.parser.v2.XMLReader.scanQName(XMLReader.java:1677) at oracle.xml.parser.v2.XMLReader.getEntity(XMLReader.java:1928) at oracle.xml.parser.v2.NonValidatingParser.parseAttrEntityRef(NonValidatingParser.java:1535) at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1520) at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1408) at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1350) at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1180) at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301) at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268) at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:253) at oracle.apps.ibc.util.XmlUtil.parseContentItemXml(XmlUtil.java:63) at oracle.apps.ibc.admin.PreviewManager.previewContentItemDeepXmlDom(PreviewManager.java:401) at oracle.apps.ibc.coverletter.server.CoverLetterApprovalManager.setRenditions(CoverLetterApprovalManager.java:271) at oracle.apps.ams.oa.campaign.webui.AdminSendTestCO.processFormRequest(AdminSendTestCO.java:204) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:804) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.OAWebBeanHideShowHelper.processFormRequest(OAWebBeanHideShowHelper.java:138) at oracle.apps.fnd.framework.webui.OAHideShowHeaderHelper.processFormRequest(OAHideShowHeaderHelper.java:134) at oracle.apps.fnd.framework.webui.beans.layout.OAHideShowHeaderBean.processFormRequest(OAHideShowHeaderBean.java:484) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:821) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:821) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java

oracle.apps.fnd.framework.OAException: oracle.apps.jtf.base.resources.FrameworkException: oracle.xml.parser.v2.XMLParseException: Expected name instead of . at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:205) at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1001) at oracle.xml.parser.v2.XMLReader.scanQName(XMLReader.java:1677) at oracle.xml.parser.v2.XMLReader.getEntity(XMLReader.java:1928) at oracle.xml.parser.v2.NonValidatingParser.parseAttrEntityRef(NonValidatingParser.java:1535) at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1520) at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1408) at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1350) at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1180) at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301) at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268) at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:253) at oracle.apps.ibc.util.XmlUtil.parseContentItemXml(XmlUtil.java:63) at oracle.apps.ibc.admin.PreviewManager.previewContentItemDeepXmlDom(PreviewManager.java:401) at


Solution:

Note 468683.1 One-to-One Fulfillment Requests Fail when Special Characters & < > " are found in Document


Special characters like '&', '<' '>', '"' throw java exceptions in XDO document merge API.

This issue has been fixed in the file NLSConfig.java in version 115.6.

You have file NLSConfig.java and version 11.5.5 which is lower than this fixed version.

This is explained in the following bug:
Bug 5865343: & CHARACTER IN RTF MERGED DOC CAUSES FULFILLMENT REQUEST TO FAIL
Patch 5931302.

References:
Review Note 468683.1

    

Get Oracle Certifications for all Exams
Free Online Exams.com

How to change the VIP for RAC apps database tier and VIP for the Apps tier

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

How to change the VIP for RAC apps database tier and VIP for the Apps tier

Symptoms:

Database -- RAC instance (Two Instances).
Application -- Two node with shared APPL_TOP.


Solution:

- on the Database tier update the Auto Config Context variable s_virtual_hostname with the new vip hostname
- deregister the host or purge the Net Services Topology Data Model as per Note 218089.1 so the new virtual host to get reflected in tnsnames.ora in 8.0.6 ORACLE_HOME
backup FND_Nodes table.
deregister the current database tier from the Net Services Topology Data Model using

            perl <RDBMS ORACLE_HOME>/appsutil/bin/adgentns.pl appspass=<APPSpwd> \
contextfile=<CONTEXT> -removeserver

- run Auto Config on the Database tier
- run Auto Config on the Applications tier

References:

You might have to deregister the host or purge the Net Services Topology Data Model? as per Note 218089.1: "Autoconfig FAQ"


    

Get Oracle Certifications for all Exams
Free Online Exams.com

Configuration Assistant “Repository Upgrade" Failed while Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Configuration Assistant “Repository Upgrade" Failed while Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5
Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5

while Patching the OMS home, and on the configuration menu, the following error occured

Configuration Assistant " Repository Upgrade" Failed

Symptoms:
Sysman password has been changed from the sql plus.


Log files:

CfmLogger_2009-06-05_12-37-19-AM.log

Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50

emrepmgr.log.10.2.0.5.0.*
-------------------------------
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))

[05-06-2009 00:40:55] Validating for Repos User ...

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jun 5 00:40:56 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[05-06-2009 00:40:56] Return code = 1.
[05-06-2009 00:40:56] Failed
[05-06-2009 00:40:56] Repos User does not exist..

SQL>
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[05-06-2009 00:40:57] Checking repository version..
[05-06-2009 00:40:57] Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

[05-06-2009 00:40:57] Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)



emoms.trc

2009-06-04 21:40:53,962 [AJPRequestHandler-ApplicationServerThread-11] ERROR conn.ConnectionService verifyRepositoryEx.878 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))



CfmLogger_2009-06-05_12-37-19-AM.log

Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
SEVERE: oracle.sysman.top.oms:Schema Upgrade Failed. Installation Terminated! Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
WARNING: oracle.sysman.top.oms:EmcpPlug:startProcessing:Exception in runner=Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
INFO: oracle.sysman.top.oms:EmcpPlug:invoke:Completed EmcpPlug invoke method on an aggregate=oracle.sysman.top.oms for Action=patchsetConfiguration in step=1:microstep=0
INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:1:patchsetConfiguration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.5.0:common:family=CFM:oh=/u01/app/oracle/product/emgrid/oms10g:label=3} failed with an unhandled exception:
java.lang.Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
at oracle.sysman.emcp.util.EmcpPlug.startProcessing(EmcpPlug.java:389)
at oracle.sysman.emcp.util.EmcpPlug.invoke(EmcpPlug.java:360)
at oracle.sysman.emCfg.core.PerformMicroStep.runJavaClass(PerformMicroStep.java:540)
at oracle.sysman.emCfg.core.PerformMicroStep.executeMicroStep(PerformMicroStep.java:120)

Solution:
Use the right procedure to change the sysman password
References:

Note 803063.1
book E14646-01 

    
Get Oracle Certifications for all Exams
Free Online Exams.com

How To Change the Password of the Database User Sysman (DB Control Repository Schema)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com




How to change the password of the Database User SYSMAN when the database is hosting a DB Control Repository.



Database Release prior 10.2.0.4

1. Stop the DB Control 
    emctl stop dbconsole


2. Connect to the database as a user with DBA privilege with SQL*Plus and execute:
    alter user sysman identified by <password> ;


3.  Edit the file emoms.properties
    1. Search for the line beginning with:
      oracle.sysman.eml.mntr.emdRepPwd=
      Replace the encrypted value by the new password value
    2. Search for the line:
      oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
      Replace TRUE by FALSE 
4. Restart the DB Control
    emctl start dbconsole

Database Release beginning 10.2.0.4

1. Stop the DB Control 
    emctl stop dbconsole

2. Connect to the database as a user with DBA privilege with SQL*Plus and execute:
    alter user sysman identified by <password> ;

3. From the database directory $ORACLE_HOME/bin, execute:

    $ emctl setpasswd dbconsole

4. Restart the DB Control
    emctl start dbconsole

    
Get Oracle Certifications for all Exams
Free Online Exams.com

How To Change The SYSMAN Password Used For Grid Control

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

1. Stop the Agent monitoring the 'OMS and Repository' target


cd <AGENT_HOME>/bin
     emctl stop agent



2. Stop all the OMS instances that are associated with the repository


cd <OMS_HOME>/opmn/bin
opmnctl stopall



3. Change the SYSMAN password in the file emoms.properties:


- Edit the file emoms.properties and change the following lines

oracle.sysman.eml.mntr.emdRepPwd=new_password
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE



4. Change the SYSMAN password in the Database hosting the repository: 


SQL> alter user sysman identified by <newpassword>;


5. Start the OMS and the Agent



New in 10.2.0.5 and 11.1 Grid Control 

When using 10.2.0.5 / 11.1 OMS, all the above steps can be performed by executing a single command:

cd <OMS_HOME>/bin
emctl config oms -change_repos_pwd -change_in_db



References:


Note 270516.1: How To Change The SYSMAN Password Used For Grid Control


    
Get Oracle Certifications for all Exams
Free Online Exams.com

Steps to Upgrade OMS to 10.2.0.4 or 10.2.0.5

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Steps to Upgrade OMS to 10.2.0.4/5 

1. Apply Patch shutdown db And apply patch 4329444 on 10.1.0.4 repository db
2. Rollback Patch 5191377 from OMS_HOME, if applied
3. Check there are NO invalid SYSMAN objects

4. Stop all EM DBMS jobs

SQL> execute emd_maintenance.remove_em_dbms_jobs;
SQL> commit;
SQL> ALTER SYSTEM SET job_queue_processes=0 SID='*';

5. Stop all OMS components (Leave repository DB and listener running)

$PROMPT> $ORACLE_HOME/bin/emctl stop oms
$PROMPT> $ORACLE_HOME/bin/emctl stop iasconsole
$PROMPT> $ORACLE_HOME/opmn/bin/opmnctl stopall

6. Apply the 10.2.0.4/5.0 Patch Set (3731593) to OMS10 home

7. Re-submit the EM DBMS jobs after successful upgrade

SQL> ALTER SYSTEM SET job_queue_processes=10 SID='*';
SQL> EXEC emd_maintenance.submit_em_dbms_jobs;
SQL> commit;
******************
References:


(Please also see Note 464674.1)

    
Get Oracle Certifications for all Exams
Free Online Exams.com

HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:

HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4

Symptoms:
opmn.log shows  SOA components are continuously restarting.

Log files:
Opmn.log
opmn.log:8526:09/04/11 14:23:45 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8528:09/04/12 08:26:34 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8530:09/04/12 08:27:24 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8532:09/04/12 08:28:14 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8534:09/04/12 08:29:04 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8536:09/04/12 08:29:54 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8538:09/04/12 08:30:44 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8546:09/04/22 10:06:11 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8548:09/04/22 10:07:01 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8550:09/04/22 10:07:51 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8552:09/04/22 10:08:41 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8554:09/04/22 10:09:31 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8556:09/04/22 10:10:21 [libopmnoc4j] OC4J ping attempt timed out

BPEL~oc4j_soa~default_group~1.log


Group is not found.
Group "group" is not found in realm "jazn.com"
Please, verify that given group name "group" exists in realm "jazn.com". Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

at oracle.tip.pc.services.identity.jazn.BPMAuthorizationServiceImpl.lookupGroup(BPMAuthorizationServiceImpl.java:235)
at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.lookupGroup(XMLIdentityService.java:175)
at oracle.bpel.services.workflow.task.impl.TaskUtil.getUsersinAsssignment(TaskUtil.java:185)
at oracle.bpel.services.workflow.task.impl.TaskUtil.randomPickCurrentAssignee(TaskUtil.java:156)
at oracle.bpel.services.workflow.task.impl.TaskUtil.randomPickCurrentAssignee(TaskUtil.java:143)
at oracle.bpel.services.workflow.task.impl.TaskUtil.getCurrentAssignee(TaskUtil.java:131)
at oracle.bpel.services.workflow.verification.impl.VerificationService.isTopmostUser(VerificationService.java:2915)
at oracle.bpel.services.workflow.verification.impl.VerificationService.getRoleBasedGroupActions(VerificationService.java:2649)
at oracle.bpel.services.workflow.verification.impl.VerificationService.getTaskSystemActions(VerificationService.java:1257)
...
<2009-04-20 14:53:33,485> <WARN> <default.collaxa.cube.services> <::> The value parameter passed in Predicate.addClause contains Strings, and will be deprecated. Please pass List of ITaskAssingee.
09/04/20 14:53:41 Remote User is: null------------------------------------------
09/04/20 14:53:41 Normal login with username: User------------------------------------------
09/04/20 14:54:45 Remote User is: null------------------------------------------
09/04/20 14:54:48 Remote User is: null------------------------------------------
09/04/20 14:54:48 Normal login with username: User------------------------------------------
09/04/20 14:54:48 Remote User is: null------------------------------------------
09/04/20 14:55:13 Remote User is: null------------------------------------------
09/04/20 14:55:13 Normal login with username: User------------------------------------------
<2009-04-20 14:55:13,258> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Identity Service Authentication failure.
<2009-04-20 14:55:13,258> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> WorkflowService:: VerificationService.authenticateUser: error: Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> ORABPEL-30501
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Error in authenticating user.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Error in authenticating and creating a workflow context for user jazn.com/User
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Check the underlying exception and correct the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:375)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.query.impl.TaskQueryService.authenticate(TaskQueryService.java:159)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at worklistapp.servlets.Login.handleRequest(Login.java:137)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at worklistapp.servlets.BaseServlet.doPost(BaseServlet.java:157)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
...
...
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at java.lang.Thread.run(Thread.java:595)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Caused by: ORABPEL-10528
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> ... 14 more
<2009-04-20 14:55:13,260> <ERROR> <oracle.bpel.services.workflow> <::> Identity Service Authentication failure.
Identity Service Authentication failure.
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

ORABPEL-10528

Identity Service Authentication failure.
Identity Service Authentication failure.

Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150)
at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426)
at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341)
at oracle.bpel.services.workflow.query.impl.TaskQueryService.authenticate(TaskQueryService.java:159)
at worklistapp.servlets.Login.handleRequest(Login.java:137)
at worklistapp.servlets.BaseServlet.doPost(BaseServlet.java:157)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
09/04/20 14:55:15 Remote User is: null------------------------------------------
09/04/20 14:55:15 Normal login with username: User------------------------------------------
...


~SOA_~default_group~1.log

...
09/04/20 14:49:09 Caused by: org.hibernate.TransactionException: JDBC rollback failed
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
09/04/20 14:49:09 at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:589)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:792)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:679)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:621)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:311)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
09/04/20 14:49:09 at $Proxy135.saveUploadedDocument(Unknown Source)
09/04/20 14:49:09 at sun.reflect.GeneratedMethodAccessor15030.invoke(Unknown Source)
09/04/20 14:49:09 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
09/04/20 14:49:09 at java.lang.reflect.Method.invoke(Method.java:585)
09/04/20 14:49:09 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at com.ksevindik.auditing.interceptor.ServiceAuditLogInterceptor.invoke(ServiceAuditLogInterceptor.java:43)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
09/04/20 14:49:09 at $Proxy136.saveUploadedDocument(Unknown Source)
09/04/20 14:49:09 at com.pcfc.customs.customer.common.web.action.UploadDocumentAction.executeInvokeMethod(UploadDocumentAction.java:410)
09/04/20 14:49:09 ... 41 more
09/04/20 14:49:09 Caused by: java.sql.SQLException: Attempt to use an invalid handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@278340'.
09/04/20 14:49:09 at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:286)
09/04/20 14:49:09 at oracle.oc4j.sql.spi.ConnectionHandle.rollback(ConnectionHandle.java:148)
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
09/04/20 14:49:09 ... 63 more

 BPEL~oc4j_soa~default_group~2.log

....
<2009-04-01 19:05:15,163> <ERROR> <declaration.collaxa.cube.engine.dispatch> <BaseScheduledWorker::process> Failed to handle dispatch message ... exception ORABPEL-05002

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.instance.ExpirationMessage"; the exception is: Instance not found in datasource.
The process domain was unable to fetch the instance with key "11701441" from the datasource.
Please check that the instance key "11701441" refers to a valid instance that has been started and not removed from the process domain.


ORABPEL-05002

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.instance.ExpirationMessage"; the exception is: Instance not found in datasource.
The process domain was unable to fetch the instance with key "11701441" from the datasource.
Please check that the instance key "11701441" refers to a valid instance that has been started and not removed from the process domain.


at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:171)
at com.collaxa.cube.engine.dispatch.BaseScheduledWorker.process(BaseScheduledWorker.java:70)
at com.collaxa.cube.engine.ejb.impl.WorkerBean.onMessage(WorkerBean.java:86)
at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.SetContextActionInterceptor.invoke(SetContextActionInterceptor.java:44)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at oracle.j2ee.connector.messageinflow.MessageEndpointImpl.OC4J_invokeMethod(MessageEndpointImpl.java:297)
at WorkerBean_EndPointProxy_4bin6i8.onMessage(Unknown Source)
at oracle.j2ee.ra.jms.generic.WorkConsumer.run(WorkConsumer.java:266)
at oracle.j2ee.connector.work.WorkWrapper.runTargetWork(WorkWrapper.java:242)
at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:814)
at java.lang.Thread.run(Thread.java:595)
09/04/01 22:32:22 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1bf36ff name:DPPException
09/04/01 22:32:22 QName string is DPPException
09/04/01 22:32:22 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1bcca5d name:DPPException
09/04/01 22:32:22 QName string is DPPException
09/04/01 22:32:40 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1de9d38 name:DPPException
09/04/01 22:32:40 QName string is DPPException

--------
09/04/01 23:14:20 Stop process
--------
09/04/01 23:14:41 Shutting down...

<2009-04-01 23:14:44,618> <INFO> <collaxa> <ServerManager::uninit> Shutting down all domains
<2009-04-01 23:14:45,810> <INFO> <default.collaxa.cube.engine> <AdapterStats::uninit:Done uninitializing Adapter statistics holder for engine > default
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <AdaptorManager::unload> Uninitialized adaptors for platform 'ias_10g', datasource 'oracle'
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <CubeEngine::uninit> Uninitialized BPEL domain "default"
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <CubeEngine::unload> Unloaded BPEL domain "default"
<2009-04-01 23:14:46,652> <INFO> <collaxa> <ServerManager::uninit> Done shutting down all domains
Apr 1, 2009 11:14:47 PM org.collaxa.thirdparty.jgroups.blocks.PullPushAdapter run
WARNING: [<null>] channel closed, exception is ChannelClosedException
09/04/01 23:16:19 WARNING: MessageDrivenHome.waitForListeners Timeout waiting for listener threads to finish

Solution:
Patch 7670088: HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4 MLR# 6 installation
References:

Note. 761675.1 " OracleAS 10g OPMN Restarts OC4J Instance After "OC4J Ping Attempt Timed Out" Error "

    
Get Oracle Certifications for all Exams
Free Online Exams.com