Oracle World

Tuesday, June 28, 2011

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