Sitemap

Amicuk Programming Answers

ORA-600 [17280]

-0001-11-30   Views:8

Advertisement

Hello, I have a problem on a 10.2.0.4 enterprise edition database. The database crashes several times a day with the error ORA-600 [17280]. Form the metalink I learned that this is due to a bug which is fixed in 11.1 version. Here is the error from t

Hello,
I have a problem on a 10.2.0.4 enterprise edition database. The database crashes several times a day with the error ORA-600 [17280].
Form the metalink I learned that this is due to a bug which is fixed in 11.1 version.
Here is the error from the trace file:
/ldata/oracle/pmb/udump/pmb_ora_6900.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/ORACLE/app/oracle/product/10.2.0/db_1
System name:    SunOS
Node name:      paymob10
Release:        5.10
Version:        Generic_142909-17
Machine:        sun4u
Instance name: pmb
Redo thread mounted by this instance: 1
Oracle process number: 84
Unix process pid: 6900, image: [email protected]
*** ACTION NAME:() 2011-10-10 16:56:44.152
*** MODULE NAME:() 2011-10-10 16:56:44.152
*** SERVICE NAME:(SYS$USERS) 2011-10-10 16:56:44.152
*** SESSION ID:(125.26) 2011-10-10 16:56:44.152
*** 2011-10-10 16:56:44.152
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17280], [1], [0x429EFDD28], [], [],
Current SQL statement for this session:
begin actor_pkg . actorLogin ( :sqlAliasCategoryName:sqlAliasCategoryNameIndNew
, :sqlAliasCatego
ry:sqlAliasCategoryIndNew , :sqlService:sqlServiceIndNew ,
:sqlMedium:sqlMediumIndNew , :sqlMediu
mName:sqlMediumNameIndNew , :sqlPasswd:sqlPasswdIndNew ,
:sqlNbMaxEssais:sqlNbMaxEssaisIndNew , :
sqlNbMaxSessions:sqlNbMaxSessionsIndNew , :sqlSystemNumber:sqlSystemNumberIndNew
, :sqlTransacId:
sqlTransacIdIndNew , :sqlSession_q:sqlOK_Ind , :sqlSessionControl_q:sqlOK_Ind ,
:sqlMsisdnInfo_q:
sqlOK_Ind , :sqlIccId:sqlIccIdIndNew , :sqlImei:sqlImeiIndNew ,
:sqlPwdExpiryDateControl_q:sqlOK_
Ind , :sqlSessionId:sqlSessionIdIndNew , :sqlActorId:sqlActorIdIndNew ,
:sqlProfileId , :sqlLanga
ge:sqlLangageIndNew , :sqlStkMenuId:sqlStkMenuIdIndNew ,
:sqlCoordinateId:sqlCoordinateIdIndNew ,
:sqlErrorState:sqlErrorStateIndNew , :sqlOperError:sqlOperErrorIndNew ,
:sqlReturnCode:sqlReturn
CodeIndNew ) ; END ;
----- Call Stack Trace -----The document describing the bug says:
+<mod. action : metalink note content removed>+
The workaround says that the error can be ignored, but I cannot due that because the database stops after this error is encountered. My question is: is there a configuration so that the database will not stop after this error?
I have asked the developers to correct the PL/SQL code accordingly, but this will take a while.
Thanks in advance,
Adrian Benga

The replay answer
Advertisement
ORA-00600: internal error code, You are getting oracle internal error(ORA 600) which mean you could need to work wiht oracle support team. Please see below note, if its not help than i suggest log a sr:
Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]
Regard
Helios

Go to See the other 4 answers

ORA-600 [17280]

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have a problem on a 10.2.0.4 enterprise edition database. The database crashes several times a day with the error ORA-600 [17280]. Form the metalink I learned that this is due to a bug which is fixed in 11.1 version. Here is the error from t[More]

ORA-600 [17069] error while running catrelod.sql to downgrade 11g database

Category:DefaultRelease time:2015-10-11Views:130

Hi, We are downgrading our 11.2.0.2 database to 10.2.0.4. We have successfullly run catdwgrd.sql without any errors in 11g env. While running catrelod.sql in 10g env we are facing the following error: SQL> @?/rdbms/admin/catrelod.sql TIMESTAMP COMP_T[More]

Problem with generating xml and nested cursor (ora-600)

Category:DefaultRelease time:2015-10-11Views:130

I have a problem with generating xml (with dbms_xmlquery or xmlgen) and nested cursors. When I execute the following command, I get a ORA-600 error: select dbms_xmlquery.getxml('select mst_id , mst_source , cursor(select per.* , cursor(select ftm_fdf[More]

Ora-600 publishing translation

Category:DefaultRelease time:2015-10-11Views:130

Getting following error when publishing translation: ORA-20001: Sync error: WWV_FLOW_ICON_BAR.ICON_IMAGE_ALT ORA-00600: internal error code, arguments: [kkxlsb csid mismatch], [871], [871], [1], [2], [], [], [] Problem happened in 1.6 and after upgra[More]

Ora 600 error  Arguments [25012] [11]

Category:DefaultRelease time:2015-10-11Views:130

hi, i've an ORA-00600: error Arguments [25012], [2], [11], [], [], [], [], [] by DELETE FROM table WHERE filed = :b1 ther are only 8 file in database. (not 11) Can anybody help, or give me an information about Bug number: 742709 OS NT 4 / SP6 ORACLE[More]

ORA 600 [kkqvmRmViewFromLst1] error

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am using Binary XML DB . Here is the DB banner info. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for Linux: Version 11.2.0.1.0 - Produ[More]

Database give ORA-600 error after cold backup

Category:DefaultRelease time:2015-10-11Views:130

HI, I have oracle 10g install on linux system. i take cold backup of my database using sql> shutdown immediate and then copy all files to any other location. but when i start my database it gives me error like Errors in file /opt/oracle/fina/bdump/fi[More]

ORA-600 while database restore

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have Oracle 10.2.0.3 on RHEL4. When i try to restore my standby database from daily full backup from live database i get this error: RMAN> restore database; Starting restore at 17-MAR-09 using target database control file instead of recovery[More]

ORA - 600  error while granting privs

Category:DefaultRelease time:2015-10-11Views:130

Whenever I fire the below query it returns me a ORA-600 error. Query select grantee UserName, granted_role Role from dba_role_privs where grantee in (select grantee from dba_role_privs where granted_role = 'DBA') and grantee in (select username from[More]

OAF Update of Custom Table causing ORA-600 with database block corruption?

Category:DefaultRelease time:2015-10-11Views:130

Using OA Framework 12.1.3, running under EBusiness Suite 12.1.3 Created Custom Web page operating against Custom Tables ISSUE On about 2% of new records, when OAF is UPDATING a record in a certain table, it  is failing with java.sql.SQLException: ORA[More]

Oracle DR Setup Problems / ORA - 600 /

Category:DefaultRelease time:2015-10-11Views:130

Dear All, Recently we have implemented DR(Disaster Recovery setup Using Oracle data guard in 10g, GUI configurations ) in our Production server. The DR setups are based on the Maximum performance with Realtime apply mode. The configuration went fine[More]

Hot
Is there a way to default attachments to "View As Icon" instead of previewing them in Mail? Specifically MP3s, since there's no way to drag the preview player directly into iTunes. I know I can just right click to change, but I get a lot of emai [More]
I have a 1st generation ipod touch (software version 3.13). When I attempt to update the software, it says that the software is up to date.  Can I manually force an update or is there something else I can do?Nope. 3.1.3 is the highest possible for a [More]
how to print line item description in next line... suppose i have line item description as "this is description of line item" then i need to print as "this is" "description of line item" in two lines......             so that [More]
I am developing a jsp page which has requirement something link this. User enters parameter name and parameter value and clicks on add button the details should get displayed in the table in the jsp.user should be able to select the row which he/she [More]
Whenever I print a mailing envelope in Lion's Address Book, it prints fine but then prints a blank page following. How can I stop this?HP printers for years have had a problem printing an extra envelope from the Apple Addressbook Application with the [More]
Just in case anyone else encountered this ... I downloaded and installed the Dynamic Action Plug-in, Notification, from http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-plug-ins-182042.html. I imported into Shared Objec [More]
Hi eperts, I am recreating issue in RAQ (quality system), but my ROC (order conformation)s are not flowing back, the output in R3 is generated, but in snc in sxmb_moni I donu2019t see any messages. Could you please  tell me . regards babuHi, Check th [More]
Hi everybody...somebody knows how to find an especific word that is located in file txt from java somebody has the code??? Thanks in advanceHere is the code for finding a word in txt file from Java. import java.io.*; public class FindTextFromFile     [More]
I keep getting the error message 1004 please try again later when i try to down load any apps. either updates or new apps. Can someone please help me correct this problem?apple_master New Delhi, India This solved my questionRe: Unable to Purchase  Ap [More]
I am writing a Login form to allow user to access MySQL but the Authentication is taking place in another form that actually does the work how do I pass the username and password form the Login form to the worker form.1. don't do these stuffs on the [More]