Wednesday, June 29, 2011

use WebAdi to upload Journals :the connection to the server is unavailable, Please contact your support representative

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
On 11.5.10.2 When attempting to use WebAdi to upload Journals,
the following error occurs:

ERROR
-----------------------
"The connection to the server is unavailable, Please contact your support representative"


Due to this issue, Unable to upload the data for one month

Solution:

1.Follow up the instructions for applying patch 5711361 in a Test instance first.

This patch inluded in
Applications Technology 11i.ATG_PF.H.delta.6 (patch 5903765)
Applications Technology 11i.ATG_PF.H.delta.5 (patch 5473858)

2.Assign responsibility Desktop Integration Responsibility for users work on WebADi
You can refer to note 287080.1


3.Retest your issue

4.Migrate solution as appropriate
Get Oracle Certifications for all Exams
Free Online Exams.com

Edit existing TCA

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 Description: Log into TCA using Oracle Trading Community Manager and  Edit existing TCA Relationship 11.5.10 CU3

The relationship of "Manager of" was created as a non-cyclic relationship through Trading Comm Manager Responsibility.
We need to edit this and make this a Reciprocal relationship with " Employee of" as the reciprocal relation.

Solution:
This functionality is not available.

There is an Enhancement Request raised on this -
================================================
Bug 4435563 (15) NEED ABILITY TO UPDATE RELATIONSHIP PHRASES, RELATIONSHIP TYPES -

Currently, if Relationship Types is created with appropriate phrases &
roles, the phrases, roles and the Relationship Type names cannot be updated
from the RM UI. This causes problems since our UI doesn't support
inactivating the relationship types too.

Super Users or users with RM access ought to be able to update phrases, roles
and the relationship types. Users currently have to go to AR lookups to
update the phrases which is not a clean way of managing relationships in case
they need to make updates to relationship types.

================================================
Get Oracle Certifications for all Exams
Free Online Exams.com

Common questions about merge apps patches

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


Question:

Can we merge patches in Oracle apps?

Answer:


You can merge multiple patches into a single patch by using AD Merge Patch. This AD
command line utility merges multiple AutoPatch-compatible patches into a single,
integrated patch. Once the merged patch is created, you use AutoPatch to apply it in a
single operation. Applying a merged patch reduces the time it takes to complete the
patching process.

In general, you can safely merge any Oracle Applications patch with any other Oracle
Applications patch. Older split driver patches can be merged with newer unified
driver patches. Patches can and should be merged with their listed prerequisite
patches to make patch application easier.

Additional Information: See AD Merge Patch in Oracle Applications
Maintenance Utilities.

Question:

Can we merge the NLS patches along with US patch and apply the same

Answer:

You can merge .However the recommended method is:
If an Oracle Applications system contains multiple languages other than American
English (US) and you are applying multiple patches for each language, the
recommended method is to merge all US patches into a single patch and all patches for
every non-US language into a single patch. Then, apply the merged US patch followed
by the merged language patch.

You can also merge US patches with the additional language patches or merge each
language in separate language-specific patches. Depending on your downtime
window and your system topology, it may be necessary to keep the US and non-US
patches separate. (See Applying an Emergency NLS Patch in this chapter). This
procedure assumes that you will apply US and language patches separately.

 Basically you can try 2-3 times on a test system which is cloned from production to apply the merged patch US and ARABIC .
If no errors then you can apply on production.

Question:


What are the cases merging will not work out?

Answer:

AD Merge Patch cannot merge patches of 
different releases,
different parallel modes, 
different platforms. 

However, it can merge patches for a specific platform with a generic patch, or
patches with different source character sets. 

AD Merge Patch
notifies you if you try to merge incompatible patches.

However, patches that affect the Applications DBA (AD) product must be handled
separately. AD patches can be merged with other AD patches, but AD patches and
non-AD patches cannot be merged because AD patches may change the AutoPatch
utility itself. Merged AD patches must be created separately and applied before you
apply non-AD patches.
Get Oracle Certifications for all Exams
Free Online Exams.com

Can we merge the NLS patches along with US patch and apply the same

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 Description:
Problem Description: Can we merge the NLS patches along with US patch and apply the same
Solution:

You can merge .However the recommended method is:
If an Oracle Applications system contains multiple languages other than American
English (US) and you are applying multiple patches for each language, the
recommended method is to merge all US patches into a single patch and all patches for
every non-US language into a single patch. Then, apply the merged US patch followed
by the merged language patch.
You can also merge US patches with the additional language patches or merge each
language in separate language-specific patches. Depending on your downtime
window and your system topology, it may be necessary to keep the US and non-US
patches separate. (See Applying an Emergency NLS Patch in this chapter). This
procedure assumes that you will apply US and language patches separately.


Basically you can try 2-3 times on a test system which is cloned from production to apply the merged patch US and ARABIC .
If no errors then you can apply on production.
Get Oracle Certifications for all Exams
Free Online Exams.com

How to expose Oracle Sourcing home page to external vendors?

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 Description: How to expose Oracle Sourcing home page to external vendors?

Solution:
Note 308271.1 Enable Web Access By External Supplier Users to Oracle iSupplier Portal and Oracle Sourcing
Note 395530.1 How To Diagnose An Issue Where External Supplier Users Cannot Access Sourcing Pages
Note.344749.1 How To Setup Oracle Sourcing Access Through Reverse Proxy / URL Firewall
Note 215097.1 Pricing in Negotiations - Auction, Offer, RFQ in Oracle Sourcing and Oracle Exchange
Note 731079.1 Sourcing Notifications - Please Click Here To Respond - Incorrect URL (Using Reverse Proxy)
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-01578: ORACLE data block corrupted (file # 1, block # 26894)

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:

Errors in file /admin/bdump/sid_smon_14277.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 26894)
ORA-01110: data file 1: '/u02/oradata/prd10/data/system01.dbf'
Sat Jan 24 20:50:12 2009

CAUSE JUSTIFICATION
===================
Corruption in system datafile
One of the Cluster C_TOID_VERSION# in SYS schema is got corrupt,

PROPOSED SOLUTION(S)
====================
Need to skip the corrupt and take a full database export

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
This object cant be recreated

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Unfortunately, it cannot be Dropped and Recreated because they are an number
underlying tables associated with it and they cannot be Dropped as it is not supported.

SQL> select table_name from dba_tables where cluster_name='C_TOID_VERSION#';

TABLE_NAME
------------------------------
TYPE$
COLLECTION$
ATTRIBUTE$
METHOD$
PARAMETER$
RESULT$

However, perform an Analyze on the cluster and each of the tables to verify the
corruption. But you said you did this and showed error right

object=C_TOID_VERSION# which is a segment cluster. This is a boot
strap object for Oracle, so it cannot be dropped or truncated to remove the
corruption.


You must be aware that your option may be limited here dur to the corruption in
the system datafile. You may have to either restore from a backup and roll forward,
or you are able, you may have to export the database, then rebuild it.

If restore and recovery is not possible due to no backups then
Try settting the Event 10231 and perform a complete full database export.
once the full database export is completed recreate the database using the
export dump.

Usage:

Event="10231 trace name context forever, level 10".

After setting this event in the init.ora restart the database.
then you can do a full database export . This event will allow to skip
corrupted blocks.

This should be removed from the instance parameters immediately after it has
been used.
Get Oracle Certifications for all Exams
Free Online Exams.com

FRM-92102: A network error has occured after upgrade to JRE

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 Statement:

Done the upgrade to JRE on the environment,but after every 5-10 minutes the forms are getting disconnected with the below error.

Error:

FRM-92102: A network error has occured.
The Forms Client has attempted to restablish its
connection to the server 1 times(s) without success.
Please check the network connection and try again later.

JRE plug-in : JRE 6 Update 13
OS : Windows XP profession 2002 SP2
browser : IE 6

from server

JDK : JRE 6 Update 13
Oracle Forms : Dev 6i Patchset 19

java console
------------------

Filename = <a href="http://sew.oraclecorp.com/SEW/fileDownload?forceDownload=0&fileURL=https%3A%2F%2Fgtcr.oracle.com%2Fgtcr-dir%2Fgtcr_322189299%2F21119062.6%2Fjavaconsole.log"target="_blank">https://gtcr.oracle.com/gtcr-dir/gtcr_322189299/21119062.6/javaconsole.log</a>

shows:
connectMode=HTTP, native.
Forms Applet version is : 60828
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afnav.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/aflleft.gif
Loaded image: jar:http://jaoradu1.dpa.co.ae:8012/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/aflright.gif

Reconnecting (try 1 of 5)...
Reconnecting (try 2 of 5)...
Reconnecting (try 3 of 5)...
Reconnecting (try 4 of 5)...
Reconnecting (try 5 of 5)...
oracle.forms.net.ConnectionException: 500
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.StreamMessageWriter.run(Unknown Source)
java.io.EOFException
at java.io.DataInputStream.readUnsignedByte(Unknown Source)
at oracle.forms.engine.Message.readDetails(Unknown Source)
at oracle.forms.engine.Message.readDetails(Unknown Source)
at oracle.forms.net.StreamMessageReader.run(Unknown Source)

Solution:

increase your NetworkRetries parameter to 30.So please do the following :


1.Edit context file.XML

2.Look for <forms_network_retries oa_var="s_frmNetworkRetries">0</forms_network_retries>

3.Change to <forms_network_retries oa_var="s_frmNetworkRetries">30</forms_network_retries>

4. change log=false to log=true in $IAS_ORACLE_HOME/Apache/Jserv/etc/forms.properties
5. change FORMS60_CATCHTERM=1 to FORMS60_CATCHTERM=0 and FORMS60_TIMEOUT=5 to FORMS60_TIMEOUT=15 in formsevlet.ini

6. Bounce the apache

7.Run AutoConfig

8. Reprodcue the issue


References:

Note.313703.1 Ext/Pub FRM-92100 Your Connection To The Server Was Interrupted in Asset Workbench (FAXASSET)
Note.150705.1 Ext/Pub Logging into Oracle Applications Errors "java.io.EOFException Unexpected end of ZLIB input stream"
Note.253927.1 Ext/Mod Failed To Connect To Server Frm-92050
Note.549735.1 Ext/Pub Description List For Parameters Affect Timeout In Webforms
Note.356693.1 Ext/Pub FNDFFMSV - Application Closes or Throws FRM-92100 when Trying to Add, Delete or Modify a Flexfield Segment V

    

Get Oracle Certifications for all Exams
Free Online Exams.com

Period Closed however transaction not transferred to GL

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 Description: Period Closed however transaction not transferred to GL 11i.AR.O

Run 'Transfer to GL' program. And verify Unposted transaction report. Nothing appears in output. However if we verify some transactions they are not transferred to GL.

Explanation:
The issue is caused by not entering a post through date when submitting the AR to GL transfer program. This is causing inconsistent behavior.

Solution:
Therefore, I recommend 2 things to prevent this from re-occuring:

1)
Apply Patch 7419363: "UNPOSTED ITEMS REPORT NOT SPAWNED FROM ARGLTP"

Note: It is not necessary to apply patch 6939913 as well. It is included in above patch.

2)
Always enter a start date AND post through date when you submit the AR to GL transfer.
For example enter the dates of the period to be closed:

Start date: 01-APRIL-2009
Post through date: 30-APRIL-2009

This is the recommended way to submit the program and will prevent you from running into further issues.
Get Oracle Certifications for all Exams
Free Online Exams.com

upload journals using WEBADI:he connection to the server is unavailable, Please contact your support representative

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


On 11.5.10.2 When attempting to use WebAdi to upload Journals,
the following error occurs:

ERROR
-----------------------
"The connection to the server is unavailable, Please contact your support representative"

CAUSE JUSTIFICATION
====================
When users are trying to upload journals using WEBADI, they get the following error same as mentioned in the above bug
The connection to the server is unavailable - Please contact your support representative.
The strange thing in this case that the bne.log file is not showing any errors which is the same thing reported in the above bug.

Due to this issue, Unable to upload the data for one month

Solution:

1.Follow up the instructions for applying patch 5711361 in a Test instance first.

This patch inluded in
Applications Technology 11i.ATG_PF.H.delta.6 (patch 5903765)
Applications Technology 11i.ATG_PF.H.delta.5 (patch 5473858)

2.Assign responsibility Desktop Integration Responsibility for users work on WebADi
You can refer to note 287080.1


3.Retest your issue

4.Migrate solution as appropriate
Get Oracle Certifications for all Exams
Free Online Exams.com

Integrate OSB 10.3 with Weblogic Server 10.0

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 Description: Integrate OSB 10.3 with Weblogic Server 10.0

### Detailed Problem Statement ###

How we can  Integrate OSB10.3  with Weblogic Server 10.0


Solution:
OSB 10.3 supports WLS 10.3.
Please see http://edocs.bea.com/platform/suppconfigs/configs_al10gr3/osb10gr3/overview.html#1132096
Previous releases like WLS 10.0 are not supported with OSB 10gR3.

References:
more documentation on the upgrade of OSB into the following documentations:

http://download.oracle.com/docs/cd/E13159_01/osb/docs10gr3/index.html

Upgrade Guide:
http://download.oracle.com/docs/cd/E13159_01/osb/docs10gr3/upgrade/index.html

Product Components:
http://download.oracle.com/docs/cd/E13159_01/osb/docs10gr3/install/prepare.html#wp1074264

For information about upgrade to WLS 10.3 please see http://e-docs.bea.com/wls/docs103/upgrade/

Get Oracle Certifications for all Exams
Free Online Exams.com

Jinit is de-supported JRE Replaces it

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 Description: Jinit is de-supported JRE Replaces it

As a part of CPU patches for Ebusiness suite Applicaiton 11.5.10.2 applied CPU patches from OCT05 to OCT- 08,in this process we upgraded the Jinitiator to 1.3.1.30. In this regard need the below clarification.


1. Does the support for Jinitiator is going to expire!

2. If yes do we need to move to JRE window native or J2SE!

3. Is it mandatory to move JRE window native or J2SE!

Explanation:
JInitiator 1.3 To Be Desupported for Apps 11i in July 2009 as per Oracle Metalink Note 552692.1 Oracle JInitiator 1.3 for E-Business Suite 11i - Forms version 6.0.8.x

Solution:
As per Oracle Metalink Note 290807.1 - Oracle has certified the Oracle E-Business Suite with the minimum Sun JRE releases noted above on the JRE 1.6 and JRE 1.5 families. Oracle E-Business Suite end-users may use or upgrade to later production releases of the Sun JRE plug-in on either family at their discretion.

Please review Note 290807.1 - Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i

Note 760250.1 Diagnosing Forms Mouse Focus Problems Using JRE in Release 11i for further information
Get Oracle Certifications for all Exams
Free Online Exams.com

Tuesday, June 28, 2011

Unapplied Receipts Journal report is erroring out

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 Statement:
Unapplied Receipts Journal report is erroring out

Post-processing of request 5480230 failed at 09-APR-2009 08:44:50 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details

-- Steps To Reproduce:
1. Run Unapplied Receipts Journal program and it completes with warning.

-- Business Impact:
Users are not able to find unapplied receipts for a period and because of it they are facing lot of difficulty in their day to day activities.


Log File
-----------

Filename = <a href="http://sew.oraclecorp.com/SEW/fileDownload?forceDownload=0&fileURL=https%3A%2F%2Fgtcr.oracle.com%2Fgtcr-dir%2Fgtcr_322189299%2F7523545.992%2FWO-12562.log"target="_blank">https://gtcr.oracle.com/gtcr-dir/gtcr_322189299/7523545.992/WO-12562.log</a>

FND CONC-CP EXCEPTION N EXCEPTION java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:473)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:188)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:160)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1015)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:968)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:209)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1561)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:951)
at oracle.apps.xdo.oa.schema.serv

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper
...
Caused by: oracle.xdo.parser.v2.XMLParseException: Start of root element



Note.471209.1 Ext/Pub Unapplied Receipt Register Report Failing With One Or More Post-Processing Actions Failed.:
Note.788084.1 Int/Pub Unapplied Receipts Journal And Applied Receipts Journal Ending In Warning One or more post-processing actions failed:
Note.740529.1 Ext/Pub Output Post Processor Fails Due To java.sql.SQLException Exhausted Resultset:
Note.456742.1 Lim/Pub ARXUNAJR Unapplied Receipts Journal errored out ORA-31011 XML parsing failed:

Solution:
1) Please download and review the readme for Patch.Standalone Patch 6394101 XML PUBLISHER POST-PROCESSING FAILING FOR CUMULATIVE ACTIVITY REPORT

Applicable Family Pack/Release
11i.AR.O

Branched versions of files included in this patch
ar patch/115/sql ARXCUABB.pls 115.4.15104.5
ge fr� 7 l e � � =1 wait_time=53405
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=302
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=626
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=10639
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 19, pgadep: 0
Open cursors(pls, sys, hwm, max): 19(13, 2, 64, 2500)
NULL 3 SYNTAX 0 PARSE 0 BOUND 16 FETCH 0 ROW 0
----------------------------------------
Cursor#19(800003ffbfdc1f78) state=NULL curiob=800003ffbfc2da80
curflg=44 fl2=0 par=0000000000000000 ses=c0000001fedbeee8
sqltxt(c0000001e752ad38)=SELECT SERVER_ID,TYPE_ID,MEMBER_SVR_GROUP_ID, DNS_NAME,IP_ADDRESS,LOCATION FROM IEO_SVR_SERVERS WHERE SERVER_NAME = :1
hash=befdfc91dcf1de63a98a59741d85d682
parent=c0000001e951d278 maxchild=02 plk=c0000001d8af18e0 ppn=n
cursor instantiation=800003ffbfc2da80 used=1238445218
child#0(c0000001e74fd758) pcs=c0000001e74fda88
clk=c0000001bfed4500 ci=c0000001b859aa38 pn=c0000001c96dc160 ctx=c0000001e949fd38
kgsccflg=0 llk[800003ffbfc2da88,800003ffbfc2da88] idx=0
xscflg=20028 fl2=0 fl3=2022000 fl4=0
Bind bytecodes
Frames pfr 0000000000000000 siz=0 efr 0000000000000000 siz=0
Cursor frame dump
enxt: 1.0x00000000
pnxt: 1.0x00000000
Session cached cursors
-----------------------------------------------------------
Solution:
If you see the call stack information in the trace file : -

Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor

Please refer the Note below : -

Article-ID: Note 73835.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Server.DBA.Admin
Topic: Archives
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace .

This patch is very, very old. Release date was: 1998/11/30
This patch is not appropriate for 11.23. 11.23 was released September 2003!

Please go back to Oracle and ask for more details and a fix for 11.23.

---------------------------------

This patch as per HP is for 11.00 Platform and we are having 11.23 release

Article-ID: Note 43507.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Platform.Unix.HPUX
Topic: Configuration
Title: HP-UX: Patch Levels Advised

Check with HP for details and do the needful.

Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded]

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

### Detailed Problem Statement ###
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded],
PMON: terminating instance due to error 474
Tue Mar 31 00:33:51 2009
Errors in file sid_lms0_21814.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_lmon_21782.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_dbw0_21820.trc:
ORA-00474: SMON process terminated with error


ALERT LOG
-------------------

Tue Mar 31 00:33:41 2009
Errors in file /u01/ptyp/ptypdb/10.2.0/admin/PTYP2_pebpdb02/udump/ptyp2_ora_21976.trc:
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []


TRACE FILE
------------
sid_ora_21976.trc


Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME =
System name: HP-UX
Node name:
Release: B.11.23
Version: U
Machine: 9000/800
Instance name:
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 21976, image: oracle@
*** SERVICE NAME:(PTYP) 2009-03-31 00:33:41.008
*** SESSION ID:(1423.10903) 2009-03-31 00:33:41.008
*** 2009-03-31 00:33:41.008
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []



STACK TRACE
------------
kglobf0 <- kglhpd_internal

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor
sdsnm: dlmodinfo failed for address : 0x40000000
ksedst()+40 ? ksedst1() 090072FFF ?
80000001000164D8 ?
80000001000164D8 ?
800000010012D388 ?
ksedmp()+168 ? ksedst() 80000001000164D8 ?
800000010012D388 ?
C0000001F0B55478 ?
4000000001B5446F ?
ksfdmp()+32 ? ksedmp() 80000001000164D8 ?
800000010013F6D8 ?
80000001000164D8 ?
00000000C ?
kgerinv()+152 ? ksfdmp() 80000001000164D8 ?
00000000C ?
4000000004E70BE7 ?
1700016098 ?
kgeasnmierr()+88 ? kgerinv() C0000001B8503080 ?
000000000 ?
C0000001FF92E798 ?
800000010012D388 ?
kglobf0()+992 ? kgeasnmierr() A9A00000000 ?
80000001000165B0 ?
4000000001AB89EB ?
000000000 ?
kglhpd_internal()+2 ? kglobf0() C000000100E0BB60 ?
92 4000000004E7368B ?
000000000 ?
800000010012D388 ?
0x0000000040000000 ? kglhpd_internal() 80000001000165B0 ?
C0000001B1D5DC98 ?
000000000 ?
4000000001B374F3 ?

--------------------- Binary Stack Dump ---------------------


SQL
-----
No current SQL statement being executed.


PROCESS STATE
---------------
user: 44/APPS
O/S info: user: applptyp, term: unknown, ospid: , machine: pebpap05.dubaiworld.ae
program: JDBC Thin Client
client info: 104 0
application name: JDBC Thin Client, hash value=0
last wait for 'SQL*Net message from client' blocking sess=0x0000000000000000 seq=46 wait_time=326 seconds since wait started=3
driver id=28444553, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=326
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=53405
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=302
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=626
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=10639
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 19, pgadep: 0
Open cursors(pls, sys, hwm, max): 19(13, 2, 64, 2500)
NULL 3 SYNTAX 0 PARSE 0 BOUND 16 FETCH 0 ROW 0
----------------------------------------
Cursor#19(800003ffbfdc1f78) state=NULL curiob=800003ffbfc2da80
curflg=44 fl2=0 par=0000000000000000 ses=c0000001fedbeee8
sqltxt(c0000001e752ad38)=SELECT SERVER_ID,TYPE_ID,MEMBER_SVR_GROUP_ID, DNS_NAME,IP_ADDRESS,LOCATION FROM IEO_SVR_SERVERS WHERE SERVER_NAME = :1
hash=befdfc91dcf1de63a98a59741d85d682
parent=c0000001e951d278 maxchild=02 plk=c0000001d8af18e0 ppn=n
cursor instantiation=800003ffbfc2da80 used=1238445218
child#0(c0000001e74fd758) pcs=c0000001e74fda88
clk=c0000001bfed4500 ci=c0000001b859aa38 pn=c0000001c96dc160 ctx=c0000001e949fd38
kgsccflg=0 llk[800003ffbfc2da88,800003ffbfc2da88] idx=0
xscflg=20028 fl2=0 fl3=2022000 fl4=0
Bind bytecodes
Frames pfr 0000000000000000 siz=0 efr 0000000000000000 siz=0
Cursor frame dump
enxt: 1.0x00000000
pnxt: 1.0x00000000
Session cached cursors
-----------------------------------------------------------
Solution:
If you see the call stack information in the trace file : -

Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor

Please refer the Note below : -

Article-ID: Note 73835.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Server.DBA.Admin
Topic: Archives
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace .

This patch is very, very old. Release date was: 1998/11/30
This patch is not appropriate for 11.23. 11.23 was released September 2003!

Please go back to Oracle and ask for more details and a fix for 11.23.

---------------------------------

This patch as per HP is for 11.00 Platform and we are having 11.23 release

Article-ID: Note 43507.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Platform.Unix.HPUX
Topic: Configuration
Title: HP-UX: Patch Levels Advised

Check with HP for details and do the needful.

Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.
Get Oracle Certifications for all Exams
Free Online Exams.com

Applying arabic syncronization patch [8466814] for EBS using adpatch fails

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

### Detailed Problem Statement ###
Applying  arabic syncronization patch [8466814] for EBS using adpatch fails ( @ the end after workers have finished thier jobs) with :

The following Oracle Forms objects did not generate successfully:


on forms/AR PNXVAREN.fmx

Trouble shooing

LOG FILE
-----------------------
Filename =adadmin.log
See the following error:

The following Oracle Forms objects did not generate successfully:
pn forms/AR PNXVAREN.fmx
The US version of the form has been regenerated successfully.

Solution:
This is explained in the following bug:
Bug.6436010 - FORM PNXVAREN FAILED TO REGENERATE DURING NLS TRANSLATION
After applied the patch run adadmin generate the forms and update the status

Get Oracle Certifications for all Exams
Free Online Exams.com

Use DBMS_RANDOM to generate text number date and time stamp values

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


SELECT DBMS_RANDOM.VALUE FROM DUAL;
For integers in a given range, add the arguments low_value and high_value,  andtruncate the decimals from the result (the high value is not included  as a possible value). So, for integers from 0 to 99,you would use this code:

SELECT TRUNC(DBMS_RANDOM.VALUE(0, 100)) FROM DUAL;
To generate random text strings, use the STRING function andsupply a code  indicating the type of string and the desired length:

SELECT DBMS_RANDOM.STRING('A', 20) FROM DUAL;
The type codes are documented in the Oracle Database 10g PL/SQL Packages  and Types Reference. Here are a few type codes: 'U' generates uppercase, 'L'  generateslowercase, and 'A' generates mixed case.
Oracle stores dates as integer offsets from a key date inthe past (January 1, 4712 B.C., in case you were curious). This means that youcan generate random dates in a given range by finding the integer thatcorresponds to your desired start date, and then adding a random integer to it.

You can generate the internal date number for today's dateby using the TO_CHAR function with the 'J' format code:

SELECT TO_CHAR(SYSDATE, 'J') FROM DUAL;
For example, to generate random dates during the year 2003,you would first  determine the date integer for January 1, 2003:

SELECT TO_CHAR(TO_DATE('01/01/03','mm/dd/yy'),'J')
FROM DUAL;
The system responds with 2452641. So, to generate a randomdate within the  year, we use DBMS_RANDOM.VALUE with a low_valueof 2452641 and a high_value of  2452641+364, andconvert it to a date:

SELECT TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2452641,2452641+364)),'J')
FROM DUAL;



This is how to generate Random Time Stamp between two dates:

alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS';

SELECT   TO_DATE ('01/07/2011', 'DD/MM/YYYY  HH24:MI:SS')
       +   DBMS_RANDOM.VALUE (0,
                                  86400
                                * (  TO_DATE ('30-07-2011', 'DD/MM/YYYY  HH24:MI:SS')
                                   - TO_DATE ('02-07-2011', 'DD/MM/YYYY  HH24:MI:SS')
                                  )
                              + 1
                             )
         / 86400
  FROM DUAL;

Get Oracle Certifications for all Exams
Free Online Exams.com

Monday, June 27, 2011

How to implement a role for the BPEL console, which restricts the user's functionality

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 implement a role for the BPEL console, which restricts the user's functionality to the following:
1. the ability to view the BPEL Processes page
2. the ability to view the Instances page
3. the ability to view the Activities page
4. the ability to initiate a process, but not retire or undeploy it? Due to separation of duties on customer's site, they have a need for a way to allow developers to view process execution, but not change settings
Above can be done for for SOA Suite 11g but not for SOA 10g.
Currently for 10g, this functionality is not available but it is possible that users to build a separate BPEL console that would allow read only access to BPEL processes, instances and activities information. The following documents provide additional details:

http://forums.oracle.com/forums/thread.jspa?messageID=1849093
http://chintanblog.blogspot.com/2007/12/i-saw-numerous-people-asking-about-bpel_290.html
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-10388: parallel query server interrupt (failure) in Oracle Streams

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 Statement:
Streams has got the following error :

Errors in file /u01/app/oracle/admin/DPBIU/bdump/dpbiu_ora_6324.trc:
ORA-10388: parallel query server interrupt (failure)

Getting aborted with ORA-01280: Fatal LogMiner Error. in DBA_CAPTURE

It seems that the streams database got shutdown while a parallel query was 
running.

Starting the streams capture process again sounds solve the issue

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps:


It seems that the streams database got shutdown while a parallel query was running.
I just started the streams capture process again and everything went fine.
Get Oracle Certifications for all Exams
Free Online Exams.com

Agent restarts frequently. draws alot of memory/VM on version 10.2.0.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 Description
Agent restarts frequently. draws alot of memory/VM
on version 10.2.0.4

Check AGENT_HOME/sysman/log

emagent.trc

2009-06-02 14:02:47,116 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,344 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,441 Thread-3020 ERROR engine: [oc4j,psoa.jdpuap02.dubaiworld.ae_home,oc4j_jms_raw] : nmeegd_GetMetricData failed : Result has repeating key value : jdpuap02.dubaiworld.ae/oc4j_soa:OC4J:12505//JMS
2009-06-02 14:02:47,441 Thread-3020 WARN collector: <nmecmc.c> Error exit. Error message: Result has repeating key value : jdpuap02.dubaiworld.ae/oc4j_soa:OC4J:12505//JMS
2009-06-02 14:02:47,562 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,685 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body

emagent.nohup

(pid=13735): emagent started successfully
URLTiming: Using SunX509
(pid=13735): signal handler called due to abnormal condition; dumping core due to signal SIGSEGV
----- Tue Jun 2 14:03:55 2009::Checking status of EMAgent : 13735 -----
----- Tue Jun 2 14:03:58 2009::Checking status of EMAgent : 13735 -----
----- Tue Jun 2 14:03:58 2009::EMAgent exited at Tue Jun 2 14:03:58 2009 with signal 6 -----
----- Tue Jun 2 14:03:58 2009::EMAgent has exited due to an internal error -----
----- Tue Jun 2 14:03:58 2009:: - checking for corefile at /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd -----
----- Tue Jun 2 14:03:58 2009::EMAgent coredump found at /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd/core
----- Tue Jun 2 14:03:58 2009::Core file moved to /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd/core_EMAgent_1243937038
----- Tue Jun 2 14:04:00 2009::EMAgent will be restarted due to core dump(via signal 6). -----
----- Tue Jun 2 14:04:00 2009::Restarting EMAgent. -----
----- Tue Jun 2 14:04:00 2009::Agent Launched with PID 18989 at time Tue Jun 2 14:04:00 2009 -----
(pid=18989): starting emagent version 10.2.0.4.0
(pid=18989): emagent started successfully
URLTiming: Using SunX509

 Agent is leaking some memory, hence triggering an unstable state and restarting
The only workaround id to upgrade the agent to 10.2.0.5
Get Oracle Certifications for all Exams
Free Online Exams.com

RAC Troubleshooting: SERVICES ARE GETTING TERMINATED UNEXPECTEDLY

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

RAC Troubleshooting:  SERVICES ARE GETTING TERMINATED UNEXPECTEDLY on RAC Database

Here what you have to do to troubleshoot RAC services termination unexpectedly

- Check all logs under $ORACLE_HOME/log/<hostname>/racg/*

- /var/log/syslog.log

- Check  /tmp/node1status.txt ,/tmp/node2status.txt after running the following commands :

Node-1
-------
$script /tmp/node1status.txt
$hostname
$crsctl check crs
$crs_stat
$crs_stat -t
$crs_stat -ls
$crs_stat -p
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$olsnodes -n
$olsnodes -v
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$srvctl config nodeapps -n <nodename1> -a -g -s -l
$srvctl config nodeapps -n <nodename2> -a -g -s -l
$srvctl config database -d <db_name> -a
$srvctl config service -d <db_name> -a
$srvctl config asm -n <node name>
$ocrcheck
$crsctl query css votedisk
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$olsnodes -p 
$ocrdump run this as root user
$ifconfig -a 
$/etc/hosts 
$exit;

Node-2
--------
$hostname
$script /tmp/node2status.txt
$crsctl check crs
$ocrcheck
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$exit;
Get Oracle Certifications for all Exams
Free Online Exams.com

Sunday, June 26, 2011

R12: How to change the hostname/IP address of an Database Tier using AutoConfig

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 Description: R12: How to change the hostname/IP address of Apps  Database Tier using AutoConfig

Solution:

Sometimes we have a need of changing the hostname/domainname/port on database tier. Oracle recommends the following set of action rather than simply changing the context-file and running autoconfig.

1. Deregister the current database server
perl /appsutil/bin/adgentns.pl appspass=APPSpwd \
contextfile=$CONTEXT -removeserver
2. Update the AutoConfig Context files
DB Tier: Create a new context file using the following syntax : 
cd $ORACLE_HOME/appsutil/bin
perl adclonectx.pl contextfile=$CONTEXT_FILE.
3. Shutdown the Applications Tier Services
4. Reseed the Net Services Topology Model
Run AutoConfig on the Database Tier
./adconfig.sh contextfile=$ORACLE_HOME/appsutil/$SID_new_hostname>.xml
Run AutoConfig on the Applications Tier(s)
./adautocfg.sh appspass=appspasswd
5. Shutdown the Database Listener
6. Shutdown the Database 
7. Change the machine hostname 
edit the /etc/hosts file to update the new hostname/domainname.

8. Start the Database
9. Start the DB TNS Listener
10. Start the Applications Tier Services



References:

Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'
Get Oracle Certifications for all Exams
Free Online Exams.com

Can't locate strict.pm in @INC (@INC while running adpreclone.pl dbTier

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

Running adpreclone.pl on the Database tier gave the below error:

oratest@erptest-db $ perl adpreclone.pl dbTier
Can't locate strict.pm in @INC (@INC contains: /oracle/11.2.0/perl/lib/5.8.3 /oracle/11.2.0/perl/lib/site_perl/5.8.3 /oracle/11.2.0/appsutil/perl ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/5.10.0 ../lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl/5.10.0 ../lib/5.10.0 ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl .) at adpreclone.pl line 34.
BEGIN failed--compilation aborted at adpreclone.pl line 34.

After upgrading you database from 10g to 11g , perl utility has been upgraded from 5.8.3 to 5.10.0

So in order to resolve this issue, you need to update the database main environment file :
cd $ORACLE_HOME
vi <SID>_hostname.env
and update the
PERL5LIB with the right location of your perl libraries.
from
$ORACLE_HOME/perl/lib/5.8.3 to $ORACLE_HOME/perl/lib/5.10.0

However


If you are using autoconfig, you have to
Login to the Application Manager then click on site map
From the Administration tap , click on AutoConfig from the system configuration area
Click on Edit Parameters for the Database section
From the search , search for title:PERL5LIB and click save
Then run autoconfig for the database.


Get Oracle Certifications for all Exams
Free Online Exams.com

AutoPatch error:ATTENTION: All workers either have failed or are waiting:FAILED: file xxxx on worker x.

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

AutoPatch error:ATTENTION: All workers either have failed or are waiting:FAILED: file xxxx on worker x.

Whatever listed below is from my own experience for cases and issues I faced while I am working as an Apps DBA .
It does not nessassary to apply on all cases just it will give you a hint or clu to where you should focus.


Here what you are going to do if you face the below error while applying patches using adpatch

ATTENTION: All workers either have failed or are waiting:
FAILED: file xxxx on worker x.
ATTENTION: Please fix the above failed worker(s) so the manager can continue


Check the worker ID log file ( adworkerxx.log ) from $APPL_TOP/admin/$SID/log , the exact issue should be mentioned in it, take an action and resolve the issue then do the following to proceed with the adpatch:


Run adctrl
Choose option 1 "Show Worker Status" which should show the status failed.
Then choose option "2. Tell worker to restart a failed job". Enter the number of worker which you want to restart.
The status will change to "fixed,restart" and the patch will progress.

Get Oracle Certifications for all Exams
Free Online Exams.com

AutoPatch error:adfrjp(): Error running jobs in workers" After your adpatch session disconnects inproperly

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

Whatever listed below is from my own experience for cases and issues I faced while I am working as an Apps DBA .

It does not nessassary to apply on all cases just it will give you a hint or clu to where you should focus.


While I was trying to reapply a patch using adpatch after my old session got disconnected inproperly ( This includes you close your session by mistake, your PC reboots , network issues),

I ran the adpatch again and select "YES" for continue from previous run so it will resume from the last point befire it got terminated by using the *.rf9 files in $APPL_TOP/admin/$sid/restart


Thats would be in an ideal situation,however sometimes it fails  throwing the following error:

"AutoPatch error:
The worker should not have status 'Running' or 'Restarted' at this point.


Telling workers to quit...


All workers have quit.


AutoPatch error:
adfrjp(): Error running jobs in workers"


What is caused it is an "inconsistency between fnd_install_processes, ad_deferred_jobs and .rf9 files".

What to do next is to use adctrl utility  and select option "1. Show worker status" ==> Show Running
it you try  to quit the worker by hitting option "3. Tell worker to quit" , you will get "Control code already set to 'Quit' for worker xxx".


Here what you going to do to get on the top of this issue:
Hit on option "4. Tell manager that a worker failed its job" from the adctrl utility and type the worker id you saw above to change his status from "Running" to "Failed"
Then tell this gentelman worker to restart his failed job by hitting "2. Tell worker to restart a failed job"


and hopefully will get your issue resolved and it will proceed with your adpatch

Get Oracle Certifications for all Exams
Free Online Exams.com

Friday, June 24, 2011

adrelink is not running

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:

Running adrelink gave the below without actually run:

adrelink.sh force=y "ad adpatch"

Usage: adrelink force={y|n} [<optional args>] <targets>
or: adrelink force={y|n} [<optional args>] filelist=<file>

where <targets> = { <product module> [<product module>] ... }
and <product module> = "<product> <module name>"
- <product> should be in lower case
- <module name> should exactly match the executable name

Valid <optional args> are:

envfile=adsetenv.sh
Used only by the 'adsetup' script
link_debug={y|n}
Will we link executables with debug or not? Default is 'n'
backup_mode={none|all|file}
Which executables will we back up when linking with force=y?
Default is 'file'. Meanings are:
- none: do not back up any executables
- all : back up all executables
- file: do what $APPL_TOP/admin/adlinkbk.txt says to do

Type 'adrelink examples' to see some examples of running adrelink.


Solution:


You should use tr utility from  /usr/bin not from this /usr/xpg4/bin/tr as you are running version < 12.1.1
Get Oracle Certifications for all Exams
Free Online Exams.com

adlibout: error: Can't write to lib directory for product ad While applying patches using adpatch

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:

While applying patch Patch 7461070 the below error generated:

---ad----------------------------------------
Extracting object modules for product ad...

adlibout: error: Can't write to lib directory for product ad
Directory name is /lib
Directory permissions are drwxr-xr-x

Done extracting requested object modules for product ad.

End of adlibout session
Date/time is Monday 20 June 2011 11:54:22 AM GST
**********************************************************

An error occurred while extracting files from library.
Continue as if it were successful [No] :


Solution:

You should use tr utility from  /usr/bin not from this /usr/xpg4/bin/tr as you are running version < 12.1.1
Get Oracle Certifications for all Exams
Free Online Exams.com

Thursday, June 23, 2011

RACGMAIN PROCESS SPAWNS 1000+ PROCESSES THAT ARE NOT GETTING CLEANED

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 Description: CC : RACGMAIN PROCESS SPAWNS 1000+ PROCESSES THAT ARE NOT GETTING CLEANED


racgmain process spawns 1000+ processes that are not getting cleaned causing memory / swap issues. this issue is happening only on one node (second) of a 2 node RAC cluster

Alert Log file shows
2009-07-18 13:10:24.914: [ CRSEVT][139127] CAAMonitorHandler :: 0:Action Script /u01/app/oracle/product/10.2.0/bin/racgwrap(check) timed out for ora.PDPP.PDPP2.inst! (timeout=600)
2009-07-18 13:10:24.914: [ CRSAPP][139127] CheckResource error for ora.PDPP.PDPP2.inst error code = -2
2009-07-18 13:28:42.448: [ CRSEVT][139188] CAAMonitorHandler :: 0:Could not join /u01/app/crs/product/10.2.0/bin/racgwrap(check)
category: 1234, operation: scls_process_join, loc: childcrash, OS error: 0, other: Abnormal termination of the child


- crs_stop <resource name > -f
- start the resource again using srvctl start , then monitor for the same behavior

- If the previous steps not release this status , we will need to check the following logs

* $ORA_CRS_HOME/log/<hostname>/crsd/crsd.log
* Please also check if you can find any core file under CRS home specially under $ORA_CRS_HOME/log/<hostname>/racg/racgmain
* $ORACLE_HOME/log/<hostname>/racg/*
* as root run ocrdump and upload the generated output
- Please also upload the result of the following command list :

$crs_stat
$crs_stat -p
$crs_stat -ls
$srvctl config nodeapps -n <nodename1> -a -g -s -l
$srvctl config nodeapps -n <nodename2> -a -g -s -l
$srvctl config database -d <db_name> -a
$srvctl config service -d <db_name> -a
$srvctl config asm -n <node name>
$ocrcheck
$crsctl query css votedisk
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist

Solution:

As the CRS is 10.2.0.4 , so as we agree on phone that you will need to apply either 10.2.0.4 Bundle Patch #2 ( bug 7493592 ) or 10.2.0.4 CRS Bundle Patch #4 (bug 8436582) and the both will fix bug:6196746 ,as the bundle patches are cumulative 
Get Oracle Certifications for all Exams
Free Online Exams.com

WARNING [AJPRequestHandler-RMICallHandler-15] ldap.LDAPAuthenticatorStep - Could not get DN for the userid: deg-syncdispatch-user

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:


OWSM integration with OID is not working while trying to configure Oracle Web Services Manager ( OWSM ) 10.1.3 to use the LDAP Authenticate Policy Step for a registered service to allow for authentication of a user using Oracle Internet Directory ( OID )

WARNING [AJPRequestHandler-RMICallHandler-15] ldap.LDAPAuthenticatorStep - Could not get DN for the userid: deg-syncdispatch-user

The gateway.log file:
--------------------------------
2009-09-02 09:39:18,103 WARNING [Thread-15] configuration.PolicySetWatchdog - Failed to retrieve policy set from policy manager with url http://mirsal2.dubaitrade.ae:80/policymanager/services/RegistrationService: com.cfluent.policymanager.sdk.base.exception.ServerException: org.xml.sax.SAXException: Bad envelope tag: HTML
2009-09-02 09:39:18,106 FINEST [Thread-15] configuration.PolicySetWatchdog - Failed to retrieve policy set from policy manager with url http://mirsal2.dubaitrade.ae:80/policymanager/services/RegistrationService
com.cfluent.policymanager.sdk.base.exception.ServerException: org.xml.sax.SAXException: Bad envelope tag: HTML
at com.cfluent.policymanager.sdk.client.soap.SoapComponentConfigurator.getUpdatedPolicies(SoapComponentConfigurator.java:229)
at com.cfluent.agent.configuration.PolicySetWatchdog.getPolicySetFromPolicyManager(PolicySetWatchdog.java:168)
at com.cfluent.agent.configuration.PolicySetWatchdog.pollFromPolicyManager(PolicySetWatchdog.java:205)
at com.cfluent.agent.configuration.PolicySetWatchdog.run(PolicySetWatchdog.java:91)
2009-09-02 09:41:18,123 FINEST [Thread-15] configuration.PolicySetWatchdog - Checking Policy Manager
2009-09-02 09:41:18,133 WARNING [Thread-15] configuration.PolicySetWatchdog - Failed to retrieve policy set from policy manager with url http://mirsal2.dubaitrade.ae:80/policymanager/services/RegistrationService: com.cfluent.policymanager.sdk.base.exception.ServerException: org.xml.sax.SAXException: Bad envelope tag: HTML
2009-09-02 09:41:18,133 FINEST [Thread-15] configuration.PolicySetWatchdog - Failed to retrieve policy set from policy manager with url http://mirsal2.dubaitrade.ae:80/policymanager/services/RegistrationService
com.cfluent.policymanager.sdk.base.exception.ServerException: org.xml.sax.SAXException: Bad envelope tag: HTML
at com.cfluent.policymanager.sdk.client.soap.SoapComponentConfigurator.getUpdatedPolicies(SoapComponentConfigurator.java:229)
at com.cfluent.agent.configuration.PolicySetWatchdog.getPolicySetFromPolicyManager(PolicySetWatchdog.java:168)
at com.cfluent.agent.configuration.PolicySetWatchdog.pollFromPolicyManager(PolicySetWatchdog.java:205)
at com.cfluent.agent.configuration.PolicySetWatchdog.run(PolicySetWatchdog.java:91)

In the policymanager.log file of N2:
---------------------------------------------
com.cfluent.utils.db.DBException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=pdppdb03-vip.dubaiworld.ae)(PORT=1750))(ADDRESS=(PROTOCOL=TCP)(HOST=pdppdb04-vip.dubaiworld.ae)(PORT=1750))(CONNECT_DATA=(SERVICE_NAME=PSOA.dubaiworld.ae)))

at com.cfluent.utils.db.DBContext.getConnection(DBContext.java:95)
at com.cfluent.db.registry.ComponentsTable.isActiveComponent(ComponentsTable.java:323)
at com.cfluent.policymanager.da.ComponentAccessor.isValidComponent(ComponentAccessor.java:267)
at com.cfluent.policymanager.service.policy.PolicyQuery.getComponentPolicySet(PolicyQuery.java:52)
at com.cfluent.policymanager.service.soap.RegistrationService.getUpdatedPolicies(RegistrationService.java:192)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
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 oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=pdppdb03-vip.dubaiworld.ae)(PORT=1750))(ADDRESS=(PROTOCOL=TCP)(HOST=pdppdb04-vip.dubaiworld.ae)(PORT=1750))(CONNECT_DATA=(SERVICE_NAME=PSOA.dubaiworld.ae)))

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:361)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.cfluent.utils.db.DBContext.getConnection(DBContext.java:86)
... 31 more

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


In the gateway.log of N1:
--------------------------------------
2009-09-02 09:23:23,010 FINEST [AJPRequestHandler-RMICallHandler-5] security.WSBasicCredsExtractor - Found the UsernameToken Header
2009-09-02 09:23:23,010 FINEST [AJPRequestHandler-RMICallHandler-5] security.WSBasicCredsExtractor - Element Value:deg-syncdispatch-user
2009-09-02 09:23:23,011 FINEST [AJPRequestHandler-RMICallHandler-5] security.WSBasicCredsExtractor - Element Value:plvSdpOQ1
2009-09-02 09:23:23,011 FINEST [AJPRequestHandler-RMICallHandler-5] security.WSBasicCredsExtractor - Successfully retrieved username and password
2009-09-02 09:23:23,011 FINEST [AJPRequestHandler-RMICallHandler-5] security.WSBasicCredsExtractor - Removing the UsernameToken Header
2009-09-02 09:23:23,011 FINE [AJPRequestHandler-RMICallHandler-5] CSWComponent - Executing policy step. Policy='SID0003009', Step Name='LDAP Authenticate', Step Class='com.cfluent.policysteps.security.ldap.LDAPAuthenticatorStep'
2009-09-02 09:23:23,011 FINE [AJPRequestHandler-RMICallHandler-5] common.AbstractAuthenticatorStep - Step LDAP Authenticate called
2009-09-02 09:23:23,011 FINEST [AJPRequestHandler-RMICallHandler-5] ldap.LDAPAuthenticatorStep - Inside LDAP authenticate
2009-09-02 09:23:23,011 FINE [AJPRequestHandler-RMICallHandler-5] ldap.LDAPAuthenticatorStep - Getting DN for user deg-syncdispatch-user
2009-09-02 09:23:23,011 FINE [AJPRequestHandler-RMICallHandler-5] ldap.LDAPAuthenticatorStep - BaseDN=cn=Users,dc=DT,dc=tco,dc=co,dc=ae
2009-09-02 09:23:23,011 FINE [AJPRequestHandler-RMICallHandler-5] ldap.LDAPAuthenticatorStep - Filter=(&(uid=deg-syncdispatch-user)(objectclass=inetOrgPerson))
2009-09-02 09:23:23,012 INFO [AJPRequestHandler-RMICallHandler-5] ldap.DirContextHolder - Attempt 1 to connect
2009-09-02 09:23:23,018 WARNING [AJPRequestHandler-RMICallHandler-5] ldap.LDAPAuthenticatorStep - Could not get DN for the userid: deg-syncdispatch-user
2009-09-02 09:23:23,028 FINEST [MessageLogWriterDaemon] util.BoundedTaskQueue - Removing from bounded queue AsyncMessageLog
2009-09-02 09:23:23,053 FINE [AJPRequestHandler-RMICallHandler-5] CSWComponent - Step execution failed: Fault Code=[http://schemas.oblix.com/ws/2003/08/Faults/AuthenticationFault] Fault String=[Unable to authenticate user deg-syncdispatch-user against LDAP Server.] Policy=[SID0003009] Pipeline=[Request] Step Name=[LDAP Authenticate] Step Class=[com.cfluent.policysteps.security.ldap.LDAPAuthenticatorStep]
2009-09-02 09:23:23,053 FINER [AJPRequestHandler-RMICallHandler-5] common.PrepareForServiceStep - Step PrepareForServiceStep called
2009-09-02 09:23:23,053 FINEST [AJPRequestHandler-RMICallHandler-5] wssecurity.WSSecurityUtils - Found the Security Header
2009-09-02 09:23:23,053 FINEST [AJPRequestHandler-RMICallHandler-5] wssecurity.WSSecurityUtils - Removing the Security Header
2009-09-02 09:23:23,053 FINE [AJPRequestHandler-RMICallHandler-5] gateway.Invoker - Result of Request Pipeline is 1
2009-09-02 09:23:23,053 FINEST [AJPRequestHandler-RMICallHandler-5] agent.AgentRuntime - Released read lock
2009-09-02 09:23:23,054 FINEST [AJPRequestHandler-RMICallHandler-5] listener.ProtocolListener - Request message size: 1,100
2009-09-02 09:23:23,054 FINEST [AJPRequestHandler-RMICallHandler-5] listener.ProtocolListener - Response message size: 380
2009-09-02 09:23:23,055 FINEST [AJPRequestHandler-RMICallHandler-5] policysteps.CoremanClient - creating invocation measurement with serviceStatus=-1, invocationstatus=1, componentId=C0003001
2009-09-02 09:23:23,055 FINEST [AJPRequestHandler-RMICallHandler-5] util.BoundedTaskQueue - adding to bounded queue
2009-09-02 09:23:23,055 FINEST [AJPRequestHandler-RMICallHandler-5] agent.AgentRuntime - Released read lock
2009-09-02 09:23:23,301 FINEST [Thread-18] util.BoundedTaskQueue - Removing from bounded queue
2009-09-02 09:23:23,301 FINEST [Thread-18] policysteps.CoremanClient - initInternal called
2009-09-02 09:23:23,303 WARNING [Thread-18] policysteps.CoremanClient - Fail to connect to coreman, Could not get RMI ICoremanAdaptor
2009-09-02 09:23:23,303 FINEST [Thread-18] policysteps.CoremanClient - Fail to connect to coreman
com.cfluent.coreman.sdk.CoremanException: Could not get RMI ICoremanAdaptor
at com.cfluent.coreman.sdk.client.CoremanAdaptorFactory.getRMIClient(CoremanAdaptorFactory.java:70)
at com.cfluent.coreman.sdk.client.CoremanAdaptorFactory.getCoremanAdaptor(CoremanAdaptorFactory.java:86)
at com.cfluent.policysteps.CoremanClient.initInternal(CoremanClient.java:87)
at com.cfluent.policysteps.CoremanClient.sendMeasurementsInternal(CoremanClient.java:251)
at com.cfluent.policysteps.CoremanClientDaemon.sendMeasurements(CoremanClient.java:356)
at com.cfluent.policysteps.CoremanClientDaemon.run(CoremanClient.java:307)

target exception:

java.rmi.ConnectException: Connection refused to host: localhost; nested exception is:
java.net.ConnectException: Connection refused (errno:239)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:574)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:306)
at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
at java.rmi.Naming.lookup(Naming.java:84)
at com.cfluent.coreman.sdk.client.CoremanAdaptorFactory.getRMIClient(CoremanAdaptorFactory.java:67)
at com.cfluent.coreman.sdk.client.CoremanAdaptorFactory.getCoremanAdaptor(CoremanAdaptorFactory.java:86)
at com.cfluent.policysteps.CoremanClient.initInternal(CoremanClient.java:87)
at com.cfluent.policysteps.CoremanClient.sendMeasurementsInternal(CoremanClient.java:251)
at com.cfluent.policysteps.CoremanClientDaemon.sendMeasurements(CoremanClient.java:356)
at com.cfluent.policysteps.CoremanClientDaemon.run(CoremanClient.java:307)
Caused by: java.net.ConnectException: Connection refused (errno:239)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:530)
at java.net.Socket.connect(Socket.java:480)
at java.net.Socket.<init>(Socket.java:366)
at java.net.Socket.<init>(Socket.java:180)
at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:22)
at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:128)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:569)

Troubleshooting:


If you get an error saying ldap.LDAPAuthenticatorStep - Could not get DN for the <user>, verify password using the ldapbind command on your OID instance.
Also, ensure the DN entry is correctly given in OWSM's LDAP configuration page.

Would you please refer to the section "Troubleshooting" in the provided Note 782989.1?


check that the user has already bound and the password is correct by the following command:
ldapbind -h <HOST> -p <PORT> -D "cn=<username>,cn=users,dc=<domain>" -w <PASSWORD>

You should receive the message "Bind Successful" .

Enable OWSM logs with increased debugging by the following Note:

Note.726219.1 <How To Change Log Level for Oracle Web Services Manager (OWSM)>.


Solution:


The cause is creating the OID user using the oidadmin tool and did not set the proper values for the attributes which can be associated with a user to be created.

In order to solve this issue, you have to drop the OID user and recreate it using oiddas





Reference:


WebIV SEARCH
------------------------
Note 782989.1 : <An Example Of Using LDAP Authenticate Step in OWSM to Authenticate a Registered Web Service to OID>

The above note is used to configure Oracle Web Services Manager ( OWSM ) 10.1.3 to use the LDAP Authenticate Policy Step for a registered service
to allow for authentication of a user using Oracle Internet Directory ( OID ).
Get Oracle Certifications for all Exams
Free Online Exams.com

DATABASE ACTING DEAD SLOW DEAILY

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 Description: ENG: DATABASE ACTING DEAD SLOW DEAILY @ THE SAME SAME TIME WINDOW

Database running very slow between around 2300 and 0200 Hours Everyday.

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~~
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 13,783 31.8
log file sync 737,638 11,829 16 27.3 Commit
log file parallel write 749,259 8,533 11 19.7 System I/O
db file scattered read 305,077 6,418 21 14.8 User I/O
enq: TX - row lock contention 2,234 4,506 2,017 10.4 Application

SQL ordered by Elapsed Time
~~~~~~~~~~~~~~~~~~~~~~~~~~~

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
11,006 4,407 0 25.42 30jv4ktjqj3xz DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
6,350 2,790 0 14.67 10828gd6bbnwt DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...


1,811 55 1 1810.78 4.18 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
1,715 48 50 34.29 3.96 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
1,568 187 1 1567.97 3.62 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...

OBSERVATION
===========
30jv4ktjqj3xz
~~~~~~~~~~~~~~~
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN BEGIN OPCTF044.MAIN_PROC('J', 'T1'); COMMIT; END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;


OBSERVATION
==========
+ AWR Report is for 300mins instead of request multiple 60mins reports.
+ We can see high waits for "Log file Sync" waits.
+ dbms_stats auto job is running in the night.
+ Besides there are other maintainenance jobs runnning in the night runnign space advisory.

SQL ordered by Reads
~~~~~~~~~~~~~~~~~~~~
Total Disk Reads: 10,792,730
Captured SQL account for 57.5% of Total
Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
462,457 1 462,457.00 4.28 211.52 1874.71 0vj94pmqvwdux sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
424,535 1 424,535.00 3.93 87.93 838.76 74f7trkxksdzq sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
407,046 1 407,046.00 3.77 79.50 811.24 69qkjfnh3tvtf sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
380,101 1 380,101.00 3.52 1882.00 10834.46 amw3yd0j2ak61 sqlplus@jctpdb01 (TNS V1-V3) select /*+ parallel(t, 16) par...
378,133 1 378,133.00 3.50 49.44 448.18 3vuybk2a7828w sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
355,344 1 355,344.00 3.29 113.11 938.17 cx3nf783fppg4 sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
351,481 1 351,481.00 3.26 27.67 320.92 40kpkjgbfb3dm sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
351,309 1 351,309.00 3.26 31.46 400.39 2cdckjfy4cxhb sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
347,193 1 347,193.00 3.22 23.47 296.92 3w7fvrrccruqp sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
346,058 1 346,058.00 3.21 11.76 285.14 b602h54cr0bp4 sqlplus@jctpdb01 (TNS V1-V3) select substrb(dump(val, 16, 0...
346,058 1 346,058.00 3.21 11.61 295.87 c9586mbmqfknm sqlplus@jctpdb01 (TNS V1-V3) select substrb(dump(val, 16, 0...
346,058 1 346,058.00 3.21 16.47 271.41 f5zz84nsrp5bm sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
344,657 1 344,657.00 3.19 11.97 273.83 0dkxnkp0rnhp7 sqlplus@jctpdb01 (TNS V1-V3) select substrb(dump(val, 16, 0...
284,128 1 284,128.00 2.63 500.83 3903.04 g58ma37a1fkpa sqlplus@jctpdb01 (TNS V1-V3) select /*+ parallel(t, 16) par...
269,680 1 269,680.00 2.50 157.69 1354.73 f7kf4x9bskr9w sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
245,799 1 245,799.00 2.28 127.12 704.66 8wq3bawn5n2p7 sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su...
128,275 1 128,275.00 1.19 98.31 632.91 9h2gcqz93mcay sqlplus@jctpdb01 (TNS V1-V3) select min(minbkt), maxbkt, su


OBSERVATION
============
+ The db time increases over a period of time when the automatic job kick in.
+ We can huge waits for Parallelism. The Queries are mainly all related to statistics gathering.



disable the automatic statistics job for a couple of days and see if the performance is still bad. ?

NOTE.311836.1 How to Disable Automatic Statistics Collection in 10G
NOTE.377143.1 How to check what automatic statistics collection is

Even though observing the "Cluster" waits considering this a non-rac database.
and performance did not enhanced

#########
Bad Time
########


WORKLOAD REPOSITORY report for
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Name DB Id Instance Inst num Release RAC Host
PRD10 1688280630 prd10 1 10.2.0.2.0 NO jctpdb01


Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 25384 05-Sep-09 23:00:40 386 32.1
End Snap: 25385 05-Sep-09 23:30:40 384 32.9
Elapsed: 30.00 (mins)
DB Time: 312.41 (mins)


Top 5 Timed Events
~~~~~~~~~~~~~~~~~~~
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 2,601 13.9
log file sync 101,472 2,091 21 11.2 Commit
PX Deq Credit: send blkd 121,035 1,607 13 8.6 Other
log file parallel write 98,120 1,346 14 7.2 System I/O
db file scattered read 48,401 763 16 4.1 User I/O





WORKLOAD REPOSITORY report for
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Name DB Id Instance Inst num Release RAC Host
PRD10 1688280630 prd10 1 10.2.0.2.0 NO jctpdb01


Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 25385 05-Sep-09 23:30:40 384 32.9
End Snap: 25386 06-Sep-09 00:00:42 439 34.8
Elapsed: 30.04 (mins)
DB Time: 383.26 (mins)


Top 5 Timed Events
~~~~~~~~~~~~~~~~~~~
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
PX Deq Credit: send blkd 1,285,081 5,336 4 23.2 Other
CPU time 4,516 19.6
log file sync 53,710 894 17 3.9 Commit
log file parallel write 57,896 697 12 3.0 System I/O
PX qref latch 48,494,766 487 0 2.1 Other



##########
Good Time
##########


WORKLOAD REPOSITORY report for
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Name DB Id Instance Inst num Release RAC Host
PRD10 1688280630 prd10 1 10.2.0.2.0 NO jctpdb01


Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 25122 29-Aug-09 21:00:05 470 35.8
End Snap: 25123 29-Aug-09 22:00:19 489 37.4
Elapsed: 60.23 (mins)
DB Time: 853.29 (mins)


Top 5 Timed Events
~~~~~~~~~~~~~~~~~~~

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
PX Deq Credit: send blkd 6,082,722 12,816 2 25.0 Other
CPU time 7,820 15.3
PX qref latch 73,108,081 1,449 0 2.8 Other
log file sync 76,710 978 13 1.9 Commit
log file parallel write 84,027 856 10 1.7 System I/O




OBSERVATION
===========
+ In Bad Time, We see on 05-Sep-09, the DB Time was 383.26 (mins).
+ During Good Time, We see on 29-Aug-09 21:00:05, the DB Time was 853.29 (mins)
+ The waits are maing on PX.
+ There are not major critical waits during the bad time.
+ The I/O on the box get a little slower at times.

1. Can you check with the Unix Folks , if they are observing the high Network usage particularly @ night during problem time Daily ?
2.. Considering there 4 databases on this box. have you looked at other databases . I am just wondering if the culprit is someone else and database is merely a victim.


NOTE.301137.1 OS Watcher User Guide

1. Complete OSWatcher output.
2. Exact time when you observed the slowness. , i believe we still have problem from 21:00 -
3. Upload complete alert log.
4. Upload multiple 30mins / 1 hours report covering

i) 1 hour prior to problem time start.
ii) Problem time.
iii) 1 after after the performance was back to normal.
Get Oracle Certifications for all Exams
Free Online Exams.com