Amicuk Programming Answers

ORA-600 [17280]

-0001-11-30   Views:9


Hello, I have a problem on a 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

I have a problem on a 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:
Oracle Database 10g Enterprise Edition Release - 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 ,
sqlOK_Ind , :sqlIccId:sqlIccIdIndNew , :sqlImei:sqlImeiIndNew ,
Ind , :sqlSessionId:sqlSessionIdIndNew , :sqlActorId:sqlActorIdIndNew ,
:sqlProfileId , :sqlLanga
ge:sqlLangageIndNew , :sqlStkMenuId:sqlStkMenuIdIndNew ,
:sqlCoordinateId:sqlCoordinateIdIndNew ,
:sqlErrorState:sqlErrorStateIndNew , :sqlOperError:sqlOperErrorIndNew ,
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
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]

Go to See the other 4 answers

ORA-600 [17280]

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

Hello, I have a problem on a 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 database to 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 - 64bit Production PL/SQL Release - Production "CORE Production" TNS for Linux: Version - 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 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]

Hi, I am getting the below error while executing the sales tax report S_ALR_87012394. Infomration: I have maintained the tax jurisdiction code 9 digits initially.after that i have maintained with 10 digits Tax jurisdiction LA0000000 has defective str [More]
Hi, I am having a problem with the Crystal Report comes with Visual Studio 2005. I am trying to develop a customized report for SAP Business One. When I try to add two tables using the Database Expert, there are certain fields missing in the LINK pag [More]
hi,          i created one rfc enabled function module to update the database table agr_define. but, is it possible to create custom function module in updating the any database table by using one function module only by giving the table name and fil [More]
Hi there. I am a novice when it comes to Web Intelligence reports. I have been tasked with producing a final report that I can export to Excel which shows a project number and a project name. Very simple. Ultimately I need to import my final Excel fi [More]
could i do this online or at a local apple store(one is near where i live), or do i have to still pay money bc i know apple has a history of trading in old ipods for new onesApple don't offer this kind of trade in. They have a recycling program in pl [More]
Mountain Lion Recovery DVD - How can I make one, ML was installed on my iMac and MBP when I purchased them. When I look at the App Store, it dose not show ML as purchased (to download again) - do I have to purchase it again to make a Recovery DVD? Th [More]
I have tried several times to set up my apple tv, but I cant't get passed the Apple ID, maybe I'm using a wrong gmail address but thats my Apple ID, any help would be AppleID is a Yahoo! email address and works fine... I'd log in and o [More]
My friend was told by an on-line apple support person that he should contact tech care live for help in fixing a hacked computer.  Is this a legitimate company?I wonder if your friend was actually talking to Apple. Apple computers are seldom hacked. [More]
In setting up my wife's User account on our jointly owned iMac (Mountain Lion), I chose the cat from the optional images. I'd like to replace this with an image of our own choice, but can't see a way to do that. Suggestions welcome!Does Profile Pictu [More]
AA. i have a problem in oracle data miner when i tried to start it with my connection ,the following error msg appeared : Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocki [More]