Oracle World: Oct 23, 2011

Sunday, October 23, 2011

ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],

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: Runnng data pump on ERP instance gave ORA-600 error

While running expdp on ERP instance, I am getting ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened
ORA-00600 internal error code , arguments [xschkmk:!dict]

Explanation:

set serverout on
call dbms_aw.execute('aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('shw statlen(name)');

SQL> set serverout on
SQL> call dbms_aw.execute('aw list');
EXPRESS R/O UNCHANGED SYS.EXPRESS

Call completed.

SQL> call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list')
*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened.
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122

SQL> call dbms_aw.execute('shw statlen(name)');
call dbms_aw.execute('shw statlen(name)')
*
ERROR at line 1:
ORA-34496: The NAME dimension is available only when you have an active
analytic workspace.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
SQL>

The object affected is a so-called 'Analytical Workspace' (AW for short)
where the Oracle OLAP option is storing its data.
During the exp (either via exp or expdp) an OLAP routine is internally
triggered in order to perform the export for the AW's that are part of the objects
to be exported. When the system tries to open one of them, it is failing.
In order to see how bad the damage is, can you please perform the following steps
for me as SYS:

The AW affected is used by Enterprise Planning and Budgetting
which is in turn part of Oracle Financials.

Solution:

The Analytical Workspace (AW) ZPBANNOT owned by the user ZPB is
no longer accessible and therefor damaged beyond repair.

The AW is physicall stored in a table call AW$ZPBANNOT. So what I would suggest to do is
go for a backup and restore this table to another schema to see (using the commands
given blow) whether the AW can be opened. If this is the case, then restore to production
and then make sure that the users are made aware of that as there may be a discrepancy in the data
between what is lost and what is in the restored AW.
The other alternative is (to be discussed with the users) whether there is a possibility
to re-generate this AW by reloading the data . But I am no EPB specialist,
so this is not something that I am in a position to comment.

Get Oracle Certifications for all Exams
Free Online Exams.com

Arabic Characters shows unreadable in concurrent request outputs

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: Arabic Characters shows unreadable

Active user concurrent request output shows Arabic characters as:

+---------------------------------------------------------------------------+
ãßÊÈÉ æÍÏÇÊ ÇáÊØÈíÞÇÊ: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDSCURS module: ÇáãÓÊÎÏãæä ÇáäÔØæä
+---------------------------------------------------------------------------+

æÞÊ ÇáäÙÇã ÇáÍÇáí åæ 04-07-2010 13:33:24

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

+-----------------------------
| ÈÏÇíÉ ÊäÝíÐ ÈÑäÇãÌ ÇáÊÒÇãä...
+-----------------------------

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6

FileName
----------------

URL
------
https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-1902837891&FileName=Active_Users_040710_view_log.mht

****

select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
AR8ISO8859P6
select * from nls_database_parameters where parameter = 'NLS_LANGUAGE';
AMERICAN
select * from nls_database_parameters where parameter = 'NLS_TERRITORY';
AMERICA

the value of profile option 'FND: NATIVE CLIENT ENCODING' ?
AR8MSWIN1256

Solution:

follow steps detailed in note 555686.1

Details from note: 555686.1

Please check that the TK_LOCALE and IX_PRINTING are set properly in the environment ,

You can run the request
"Generate concurrent processing environment information"
to check how the TK_LOCALE and IX_PRINTING is set.
Solution

1- Shutdown the managers.

2- take a backup from the files :
adcmctl.sh , gsmstart.sh Under the $COMMON_TOP/admin/scripts

3- In the 2 files >> edit >> under the display section

the section that is like
"
#
# Set the DISPLAY variable regardless of how it is set in the
# current environment.
#
DISPLAY="fasmwi:0.0"
export DISPLAY
"

i want to add the following :

IX_PRINTING="/p01/oramwip/mwipappl/fnd/11.5.0/resource/ixlib.cfg"
export IX_PRINTING

TK_LOCALE="bidi"
export TK_LOCALE

Please do not forget to adjust the above path as in your instance.

4- Restart the managers and retest the issue.

Besides try the below

From the System Administrator responsibility
>Install >Viewer Options
ADD new record
File Format: 'Text'
Mime Type: 'apps/bidi'
Description: 'Pasta Viewer for bi-di'

Change profile 'Viewer: Application for Text' to be 'Pasta viewer for bi-di' instead of 'Browser'

FND: NATIVE CLIENT ENCODING This profile option needs to match the database characterset to ensure a proper output. If this profile option is different from DB characterset, then it's common to find issues when printing, exporting, generating reports. Therefore, the recommendation for this profile option is that it should match the database characterset.

Also Try:

1- please add teh following lines to the .prt files in $FND_TOP/reports

nls locale "arabic"
nls datastorageorder "logical"
nls contextuallayout "no"
nls contextualshaping "yes"
code "4" esc "[4m"
code "5" esc "[5m"

2- In the enviroment file that you source before starting the concurrent manager :

set both the IX_Printing and
IX_Rendering to the full path of Pasta.cfg file used .

3- add teh following lines to the environment file ( .env file)
REPORTS60_PRINTER_CODE_BEFORE=&5
export REPORTS60_PRINTER_CODE_BEFORE
REPORTS60_PRINTER_CODE_AFTER=&4
export REPORTS60_PRINTER_CODE_AFTER

4- Stop Concurrent Managers and make sure that all FNDLIBR processes are gone
5- restart and re-test the arabic report

Also Try:

A- in the pasta_bidi.cfg file please change the
bidi_algorithm=unicode
to
bidi_algorithm=oracle

B)-
1- login to sysadmin
2- Install -> viewer options
3- search on file format =text and Mime type= text/plain
4- toggle the value for 'Allow native encoding' ( ensure that the checkbox is not checked)

c) rebounce teh concurrent manager so that changes take effect

Get Oracle Certifications for all Exams
Free Online Exams.com

How to recreate the ZPBANNOT AW?

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:

We have damaged ZPBANNOZ beyond repair .
According to Note 795247.1 it may not be necessary to create it at all and simply drop it

Explanation:

The ZPB.ZPBANNOT AW is a shared AW used to store the annotations created in EPB. If you cannot attach it, the only way is recreating it. I think you have not used EPB or, at least, a new ZPB.ZPBANNOT AW has not been created.
For each Business Area (BA) created, you should have the following AWs associated to a BA with id 240.

ZPBDATA240 (data)
ZPBANNOT240 (annotations)
ZPB1008068A240 (personal)
ZPBCODE (code) is the same for all business areas

If you had already created annotations, they will be lost

Below you can see the full Note 795247.1.

DETAILS
=========
Note 795247.1: EPB AW's Cannot Be Attached Or Do Not Exist
--------------------------------------

Applies to:
------------
Oracle Enterprise Planning and Budgeting - Version: 12.0.6
This problem can occur on any platform.
Symptoms
After installing R12, three EPB AW's:

1. ZPBCODE
2. ZPBDATA
3. ZPBANNOT

cannot be opened.

Attempts to attach the AW's in SQLPlus returns the following error:

SQL> exec dbms_aw.execute('aw attach ZPB.ZPBCODE');

BEGIN dbms_aw.execute('aw attach ZPB.ZPBCODE'); END;
*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBCODE cannot be opened.
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at line 1

Cause
------
Exact cause is unknown
.
Solution
---------

Delete and recreate the AW's.

1. Delete the existing, unusable, aw's by executing the following commands in SQL Plus:
set serveroutput on
exec dbms_aw.execute('aw delete zpb.zpbcode')
exec dbms_aw.execute('aw delete zpb.zpbdata')
exec dbms_aw.execute('aw delete zpb.zpbannot')

2. Run the SQL script, zpbmakeaws.sql, to create the aw's.

This script is located in appl_top/zpb/11.5.0/patch/115/sql directory.

Please note that only the ZPBCODE AW will be created as both ZPBDATA or ZPBANNOT are obsolete objects.

Also if the error message is:

BEGIN dbms_aw.execute('aw attach xx'); END;

*
ERROR at line 1:
ORA-33262: (DBERR01) Analytic workspace ZPB.ZPBCODE does not exist.
ORA-06512: at "SYS.DBMS_AW", line 18
ORA-06512: at "SYS.DBMS_AW", line 138
ORA-06512: at line 1

Run only the zpbmakeaws.sql can to create the missing AW.

Solution:

The ZPB.ZPBANNOT is one Analytic Workspace (AW) used by Oracle Enterprise Budgeting and Planning (EPB) tool, that it is integrated in Oracle Applications. If you are not using EPB, you just need to run the step 1 in the Note 795247.1:

1. Delete the existing, unusable, aw's by executing the following commands in SQL Plus:
set serveroutput on
exec dbms_aw.execute('aw delete zpb.zpbcode')
exec dbms_aw.execute('aw delete zpb.zpbdata')
exec dbms_aw.execute('aw delete zpb.zpbannot')

If you are using EPB, you should run the other point 2. to recreate the ZPB.ZPBANNOT AW

Get Oracle Certifications for all Exams
Free Online Exams.com

Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics

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:

Problem Description: Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics

Errors in file /orasys/admin/udump/addev_ora_730.trc:
ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] [Address not mapped to object]
[0x000000040] [] []

Stack Trace: drurnew draccbi drexumcx drexostatscoll spefcpfa spefmccallstd peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main start

Explanation:

Bug 5587976

Solution:

the core dump while gathering statistics is caused by one of your interim patches (see also the ORA-60 errors) applied and is fixed by patch 5160122, available as one-off on top of 10.2.0.4.
To resolve the problem execute below action plan:

1. upgrade to 10.2.0.5, apply patch 8202632, since 10.2.0.5 includes the fix for bug 5160122
or
2. upgrade to 10.2.0.4, apply patch 6810189 and on top of 10.2.0.4 apply one-off patch 5160122

3.
Patch is available for solaris on 10.2.0.3.
Download and apply the patch for bug 5587976

please relink the oracle executable and check whether this
fixes the problem.

-- Be sure to shutdown all databases and listeners in this $ORACLE_HOME
-- Then as software owner relink:

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle

For more information on this please see:

Note 131321.1 : How to Relink Oracle Database Software on UNIX

Get Oracle Certifications for all Exams
Free Online Exams.com

Failed to start HTTP listener

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:

While trying to start agent installation on Active/passive environment ( using VIP), I am getting:
Starting agent failed ....... failed
Failed to start HTTP listener

+ emagent.trc

2010-12-13 13:43:49,532 Thread-1 ERROR http: snmehl_allocateListenerPort: failed to get host info. Could not resolve name

+ emagent.nohup
----- Mon Dec 13 13:43:52 2010::Checking status of EMAgent : 25414 -----
----- Mon Dec 13 13:43:52 2010::EMAgent exited at Mon Dec 13 13:43:52 2010 with return value 55. -----
----- Mon Dec 13 13:43:52 2010::EMAgent has exited due to initialization failure. -----

Solution:

  1) set the ORACLE_HOSTNAME parameter to vip Hostname
   2) Put an entry of vip Hostname in /etc/hosts file on both the active/passive host in pattern
   <IP Address> <Hostname>.<DomainName> <Hostname>
   3) Start the Agent
   emctl start agent

Further more :

1) Confirm the Hostname and port to which Agent is configured.
   1.1) Search for EMD_URL in $AGENT_HOME/sysman/config/emd.properties file
   grep 'EMD_URL' $AGENT_HOME/sysman/config/emd.properties
   1.2) From the EMD_URL parameter value, we will get Hostname and port details
   2) nslookup <hostname in EMD_URL in emd.properties file>
   3) nslookup <IP Address> ,where <IP Address> we will get as a result of step - 2)
   4) export ORACLE_HOSTNAME=<hostname in EMD_URL in emd.properties file>
   5) export EMCTL_DEBUG=true
   6) $AGENT_HOME/bin/emctl start agent
   7) Please provide the output of each step as well as $AGENT_HOME/sysman/log/*
   As we debugging the emctl command, so will have more information in log/trc file and so we are requesting to send the "$AGENT_HOME/sysman/log/*" again.

Try Also:

The parameter EMD_URL in emd.properties file should have the Host using which the Agent has been configured.
Below are the steps to verify and correct the issue.

1. Understand Agent is installed with Physical hostname or Virtual Hostname
2. Run ifconfig to check whether there are multiple NICs
3. Check emd.properties file for parameter ListenOnAllNICs. Set it to False (as you have already done)
4. If Agent is installed with Physical hostname,
   Run the command "hostname" and check if it returns the same value
   If yes, then start the Agent.
   $AGENT_HOME/bin/emctl start agent
5. If Agent is installed with virtual hostname,
   set ORACLE_HOSTNAME=<emd_url host>
   start Agent
   $AGENT_HOME/bin/emctl start agent

Confirm the below:

Please confirm the few point regarding your setup/installation.

1. Is this location "/oradg2/orasys/Grid10g/agent10g" is shared location among both adsun4 and adsun5 nodes of active/passive setup ?
   (as per doc its prereqs)
2. Have yo installed agent on physical node to monitor the local services of physical node ?
3. What is the command used to install agent with virtual name ?
   Have you used the following command to install agent with virtual name ?
   $./runInstaller -invPtrLoc <shared location>/oraInst.loc ORACLE_HOSTNAME=adp2-lh.auh.police –debug
   if not , please could you paste the exact command used during agent installation ?
4. Exepcetd /etc/hosts entries should be as below:

****
127.0.0.1 localhost.localdomain localhost
z.z.z.z. adp2-lh.auh.police adp2-lh
x.x.x.x adsun4.auh.police adsun4
y.y.y.y adsun5.auh.police adsun5

&

on another node also entry shld be

127.0.0.1 localhost.localdomain localhost
z.z.z.z. adp2-lh.auh.police adp2-lh
x.x.x.x adsun4.auh.police adsun4
y.y.y.y adsun5.auh.police adsun5

*****

5. Are you able to resolve the virtual hostname from each node with properr entry in /etc/hosts file ?
   Verify the following From active node :

$hostname
$more /etc/hosts | grep adp2-lh
$ping adp2-lh.auh.police
$nslookup adp2-lh.auh.police

6. Oracle recommend to follow the steps mentioned in the doc 406014.1
   Upload the following details from both the nodes ( zip files as node1 and node2)

$AGENT_HOME/config/emd.properties
$AGENT_HOME/emd/targets.xml
$AGENT_HOME/cfgtoolllogs/*
/etc/hosts

Get Oracle Certifications for all Exams
Free Online Exams.com

How to Setup EBS, VPasta, And Pasta for BIDI Languages for viewing Arabic Reports.

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

setup step required for viewing Arabic Reports.

See note : 839520.1 => How to Setup EBS, VPasta, And Pasta for BIDI Languages

This are the required steps :

02. Setup VPASTA, the Pasta viewer, to view BIDI reports.

a) Responsibility = System Administrator

b) Navigate --> Install: Viewer Options

c) Add a new record:

File Format: 'Text'
Mime Type: 'apps/bidi'
Description: 'Pasta Viewer for bi-di'

d) Navigate --> Profile: System
e) Set / verify the following profile options:

Viewer: Application for Text = 'Pasta viewer for bi-di'
Viewer: Text = 'browser'

FND: NATIVE CLIENT ENCODING = UTF8
ICX: Client IANA Encoding = UTF-8

Note 2: If a profile is changed, one needs to exit Oracle Applications and sign on again in order for the profile change to take effect. As per <<Bug 8685356>> “English Report Displays Hebrew Text LTR Instead Of RTL”, ATG Development supports viewing BiDi reports only via the browser (VPASTA).

Also try the following

02. Setup VPASTA, the Pasta viewer, to view BIDI reports.

a) Responsibility = System Administrator

b) Navigate --> Install: Viewer Options

c) Add a new record:

File Format: 'Text'
Mime Type: 'apps/bidi'
Description: 'Pasta Viewer for bi-di'

d) Navigate --> Profile: System
e) Set / verify the following profile options:

Viewer: Application for Text = 'Pasta viewer for bi-di'
Viewer: Text = 'browser'

FND: NATIVE CLIENT ENCODING = UTF8
ICX: Client IANA Encoding = UTF-8

Also

make sure TK_LOCALE is set as
TK_LOCALE="bidi"
export TK_LOCALE

See also note :209293.1

Also try the following

IX_PRINTING=/apptest/adtst/apps/apps_st/appl/fnd/12.0.0/resource/ixlib.cfg
IX_RENDERING=/apptest/adtst/apps/apps_st/appl/fnd/12.0.0/resource/pasta_bidi.cfg

Now in R12 this is not used anymore.

See note :
On EBS Release 12, the IX_RENDERING variable is not utilized and can be left unset.

So unset IX_RENDERING and upload the file /apptest/adtst/apps/apps_st/appl/fnd/12.0.0/resource/ixlib.cfg that you use for IX_PRINTING

Get Oracle Certifications for all Exams
Free Online Exams.com

Database hang due to "Read By Other Session" Wait Event

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: Process m000 died, see its trace file
ksvcreate: Process(m001) creation failed

After migrating database from 10.2.0.3 to 10.2.0.5 on a new server the database hang due to "Read By Other Session" Wait Event.
Shutting down instance: further logons disabled
Sun Oct 24 10:57:40 GST 2010
kkjcre1p: unable to spawn jobq slave process, error 1089
Sun Oct 24 10:57:45 GST 2010
kkjcre1p: unable to spawn jobq slave process, error 1089

AWR Report shows

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
ADP2 2590586986 adp 1 10.2.0.3.0 NO adsun4

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 32881 21-Oct-10 08:00:01 589 24.9
End Snap: 32882 21-Oct-10 09:00:38 1114 28.0
Elapsed: 60.63 (mins)
DB Time: 2,811.04 (mins)

Load Profile

Per Second Per Transaction
Redo size: 136,602.58 4,704.12
Logical reads: 379,351.64 13,063.54
Block changes: 2,353.50 81.05
Physical reads: 3,602.48 124.06
Physical writes: 170.68 5.88
User calls: 1,040.09 35.82
Parses: 1,179.47 40.62
Hard parses: 81.71 2.81
Sorts: 6,499.61 223.82
Logons: 7.25 0.25
Executes: 5,728.18 197.26
Transactions: 29.04

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 7,213,522 64,295 9 38.1 User I/O
enq: TM - contention 13,134 38,495 2,931 22.8 Application
CPU time 32,364 19.2
enq: TX - row lock contention 2,249 5,588 2,485 3.3 Application
read by other session 742,678 4,061 5 2.4 User I/O

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
22,100 10,526 26,874 0.82 13.10 5vbrgk6bwp0c7 Apache.exe declare rc__ number; simple_...
9,343 2,131 859 10.88 5.54 ay2vxw27bf5c8 Apache.exe declare rc__ number; simple_...
9,189 1,740 4,279 2.15 5.45 bfpduwnsaw4h8 Apache.exe declare rc__ number; simple_...
7,508 330 1,223 6.14 4.45 cbycbjq2zs8cf Apache.exe declare rc__ number; simple_...
6,340 368 583 10.88 3.76 7sw991yq7a7km Apache.exe declare rc__ number; simple_...
6,065 170 434 13.98 3.60 2dgpnj1mgd736 Apache.exe declare rc__ number; simple_...
4,288 934 2,403 1.78 2.54 525frh6ufz9ax Apache.exe declare rc__ number; simple_...
3,986 340 956 4.17 2.36 189b4k6uj3vx6 Apache.exe declare rc__ number; simple_...

SQL ordered by Gets
Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
182,094,373 4,518 40,304.20 13.20 1521.15 2724.38 bbjw2jhdps5un Apache.exe declare rc__ number; simple_...
179,664,227 7,952 22,593.59 13.02 1390.57 2493.95 62ad3m07n545d Apache.exe SELECT * FROM CS_WFL_PROPERTY ...
167,175,797 0 12.12 1223.43 3421.54 cu8c0144khjb3 javaw.exe SELECT COUNT (EMP_ID) FROM (SE...
156,952,712 322,266 487.03 11.37 2479.81 3784.42 6f6rhrrwp2vv7 Apache.exe SELECT DECODE(:B2 , 'A', USERN...
130,770,628 26,874 4,866.06 9.48 10525.67 22099.85 5vbrgk6bwp0c7 Apache.exe declare rc__ number; simple_...
115,109,914 4,279 26,901.13 8.34 1740.12 9188.74 bfpduwnsaw4h8 Apache.exe declare rc__ number; simple_...
95,604,273 859 111,297.17 6.93 2130.59 9342.75 ay2vxw27bf5c8 Apache.exe declare rc__ number; simple_...
67,010,609 2,403 27,886.23 4.86 933.60 4288.38 525frh6ufz9ax Apache.exe declare rc__ number; simple_...

Tablespace IO Stats
Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
UNDOTBS1 4,296 1 10.11 1.00 141,772 39 95 2.95

Explanation:

When information is requested from the database, Oracle will first read the data from disk into the database buffer cache. If two or more sessions request the same information, the first session will read the data into the buffer cache while other sessions wait. In previous versions, this wait was classified under the "buffer busy waits" event. However, in Oracle 10.1 and higher, this wait time is now broken out into the "read by other session" wait event. Excessive waits for this event are typically due to several processes repeatedly reading the same blocks, e.g. many sessions scanning the same index or performing full table scans on the same table. Tuning this issue is a matter of finding and eliminating this contention.

Solution:

The reason why the performance is improved is because you increased the buffer cache and also because some processes now are not waiting for the same blocks any more ( a slight shift in the load can have caused this).

You'll need to increase the shared_pool to 2.5Gb

The pga_aggregate_target_parameter is set to high lower it to 3G and use a part of the memory that became available to increase the shared_pool.

Get Oracle Certifications for all Exams
Free Online Exams.com

OPMN is not start while applying patch 10.1.3.5 stops at 83%

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:OPMN is not start while applying patch 10.1.3.5 stops at 83%

While Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 [ID 454811.1]

Installer gave an error as show below exactly when reaching 83%

#########
OPMN is failing to start. OPMN must be started in order to correctly install and configure the patchset. Please start OPMN manually in order to continue with the patchset installation.
#########

$IAS_ORACLE_HOME/opmn/bin/opmnctl is trying to read opmn.xml from path pointed by $ORACLE_CONFIG_HOME which points to 10.1.2 home instead opmnctl should need 10.1.3 home

Do below:
Point ORACLE_CONFIG_HOME to 10.1.3 home and test by running the below command before running the installer again.

$IAS_ORACLE_HOME/opmn/bin/opmnctl status (or) startall

Export the environment variable before invoking runinstaller and this should be able to bypass the issue.

Solution:
$ echo $ORACLE_CONFIG_HOME
/erpapp/aderp/inst/apps/adtmp_erptest-temp/ora/10.1.2
$ export ORACLE_CONFIG_HOME=/erpapp/aderp/inst/apps/adtmp_erptest-temp/ora/10.1.3
$ echo $ORACLE_CONFIG_HOME
/erpapp/aderp/inst/apps/adtmp_erptest-temp/ora/10.1.3

Run the installer again and you will pass the 83% error.

Get Oracle Certifications for all Exams
Free Online Exams.com

Failed to start HTTP listener

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

Get Oracle Certifications for all Exams
Free Online Exams.com

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

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:

rman target / catalog rman1/rman1@rman debug trace c:\debug.trace

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 10 11:02:57 2011

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

RMAN-06005: connected to target database: BMC1 (DBID=3542203146)
RMAN-06008: connected to recovery catalog database

RMAN> list backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

RMAN>

AND FROM THE DEBUG FILE

DBGMISC: Finished cleanup at 10-JAN-11 [11:03:08.767]
DBGMISC: EXITED krmice [11:03:08.767] elapsed time [00:00:00:01.454]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . translateArchivedLogSCNRange ( thread# => NULL , fromscn => 0 , toscn => 281474976710655 + 1 , pattern => NULL , statusMask => :statusMask , online => :online , duplicates => :duplicates , needstby => :getstby , onlyrdf => :onlyrdf ) ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 21779
DBGMISC: ENTERED krmkursr [11:03:08.782]

Solution:

After bouncing the RMAN cataqlog database, issue resolved

Get Oracle Certifications for all Exams
Free Online Exams.com

Exception 300 (): table or view does not exist

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:

Checking again the first files rwEng-0.trc from the zip Reports Upload1
======================================================
Error 1
=========
[2011/1/24 10:4:31:692] (rwfdt:rwfdtgcf_GenCachefile) Cache file is D:\oracle\FR_AS\reports\cache\FN_R7011597774.pdf
..
...
[2011/1/24 10:4:31:723] Error 50103 (C Engine): 10:04:31 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtprint): 10:04:31 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:31:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:31:754] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:31:754] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 2
===========
[2011/1/24 10:4:38:692] Error 50103 (rwfdt:rwfdtgcf_GenCachefile): Cache file is D:\oracle\FR_AS\reports\cache\FN_R7021055655.pdf
...

[2011/1/24 10:4:38:723] Error 50103 (C Engine): 10:04:38 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtprint): 10:04:38 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:38:739] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 3
==========
2011/1/24 10:5:15:5] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Solution
Confirmed that the problem was a database permission issue.

1. Open your RDF file and verify which table will be used.
2. Now verify if your application user has the permission to select the table.
(For instance use SQL * Plus session to login to the database and try to execute a select statement with the same application user that will be used when you start Forms or Reports)

Get Oracle Certifications for all Exams
Free Online Exams.com

CCP:oradism 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

Problem Description: oradism process is not running

oradism file permission is as below
-r-sr-s--- 1 oracle dba oradism

not -rwsr-xr-x root dba oradism

grep -i dism /etc/security/exec_attr
returns nothing.

Explanation:

The use of DISM requires that the ora_dism process starts. The process will not start unless SGA_MAX_SIZE is greater than sum total of all SGA components.
This means that in case you use SGA_TARGET. you specify size of SGA_MAX_SIZE greater than SGA_TARGET

Please refer Doc ID 778777.1(When Will DISM Start On Oracle Database)

Please check the below parameter is enabled

_use_ism= TRUE

select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value",
a.KSPPDESC "Describtion"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and a.ksppinm like '_use_ism';

Dynamic intimate shared memory (DISM) is a unique feature of Solaris. It achieves dynamic memory management. On other OSs, When you specify SGA_MAX_SIZE, then the complete size of SGA_MAX_SIZE is reserved from your memory (reserved from Swap not from physical RAM) at instance startup. Then you can dynamically increase SGA_TARGET size until you reach SGA_MAX_SIZE. On Solaris, however, and due to DISM feature, SGA_MAX_SIZE is not reserved from the memory at instance startup but it is allocated when needed. This presents a great value since you do not reserve memory you are not using.

If DISM is not used then SGA_MAX_SIZE is reserved from your memory (reserved from Swap not from physical RAM).

By default, SGA_MAX_SIZE is not set during database installation and hence it takes the same value as SGA_TARGET. The use of SGA_TARGET is not a necessity to use DISM. Oracle will use DISM instead of ISM if SGA_MAX_SIZE is set larger than the total of the database buffers (in particular, db_cache_size dynamic SGA resizing is not supported with the older db_block_buffers parameter), the shared pool, the redo buffers, the large pool, the Java pool, the fixed size. In this case you will need to check the total of following parameters:

* db_cache_size
* java_pool_size
* large_pool_size
* log_buffer
* shared_pool_size
* streams_pool_size
* db_keep_cache_size
* db_recycle_cache_size

The difference between the total and the SGA_MAX_SIZE is so small that it can be approximated in calculations related to Granule size, so DISM should not be started, otherwise the ora_dism process will be started. .

Use of DISM does not depend on whether you use pfile or spfile.You can use DISM with pfile.

References:
notes 1205673.1 and 1018855.1

Get Oracle Certifications for all Exams
Free Online Exams.com

multiple frmweb.exe processes are consunming all cpu and memory resources

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: 100% CPU utilization of Application Server Forms & Reports

application.log

=== ODM Data Collection ===
11/01/17 11:34:38 formsweb: Forms session <2094> exception stack trace:
java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

Solution:

You are using webcache to run forms. It normally cause the performance problem when the number of users go high.

1) So you can disable webcache and run with HTTP Listen port (7778) in the URL.
2) Set "KeepAlive" directive in httpd.conf file to "Off" as below and restart the services and test. This will improve the performance.

KeepAlive Off

Note: You can set this parameter if you use forms application only. If you use any other applications like Portal then do not set this, try the first option.

Get Oracle Certifications for all Exams
Free Online Exams.com

oracle.apps.fnd.common.PoolException: Exception creating new Poolable object

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: Exception creating new Poolable object

Login to application gives :

500 Internal Server Error
oracle.apps.fnd.cache.CacheException
at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1485)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:354)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1259)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1114)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1083)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1050)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1037)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1081)
at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:120)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2232)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) .server.http.HttpApplication.findServlet(HttpApplication.java:4622)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4546) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2822) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230) at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object. at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833) at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216) ... 33 moreCaused by: oracle.apps.jtf.base.resources.FrameworkException: An exception occurred in the method CacheAccess.getnullThe base exception is:Exception creating new Poolable object. at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607) at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:66) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:88) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:202) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:218) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:249) ... 37 more

access_log.1306800000
10.1.25.56 - - [31/May/2011:10:27:09 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 229 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"
10.1.25.56 - - [31/May/2011:10:47:04 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 152 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"

debug.log
[May 31, 2011 10:25:19 AM GST]:1306823119991:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.2:412373572:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:58850:1306823010799:4:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.instantiateProfileStore(): s_constructorExtendedProfileStore=public oracle.apps.fnd.profiles.ExtendedProfileStore(oracle.apps.fnd.common.AppsContext)
[May 31, 2011 10:44:34 AM GST]:1306824274840:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.1:412373571:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:11086:1306824274840:4:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.makeConnectionManager(class oracle.apps.fnd.security.AppsConnectionManager): : BEGIN

javacache.log
[2011-05-31T09:23:28.435+04:00] [ias] [ERROR] [] [cache] [host: erptest-temp.auh.police] [nwaddr: 130.130.100.135] [tid: 10] [userId: appltest] [ecid: 130.130.100.135:38039:1306819169749:0,7] [[
oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1286)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:583)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:297)
...
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1215)
...
... 62 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
..
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1410)
... 72 more

Explanation:

Failed to change apps password by providing wrong apps password using FNDCPASS

log file shows

FNDCPASS was not able to decrypt password for user 'GCC' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPS' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPLSYS' during applsys password change.
. . .

Solution:

RUn FNDCPASS using the right apps password

Get Oracle Certifications for all Exams
Free Online Exams.com