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
How can we import a Flash Professional .fla file format into Flash Catalyst? It would appear that we can't...at least not yet! I have added this as a feature request within the adobe labs site for Catalyst. Someone at Adobe suggested that I also expl [More]
Dear Friends We are working with SRM based scenario with given details <b>Software Component:  SAP SRM SERVER 5.5 Namespace : http://sap.com/xi/SRM/SupplierEnablement/Global Message Mapping name: MM2SUSGoodsReceipt</b> When we post the idoc fr [More]
I have the new Mac Pro Late 2013, 8-core, with D300 graphics cards. 64GB RAM. I've been having lots of UI lag using Logic Pro (Logic always has issues though..), but I've also had crazy graphics glitching. It very much looks like a failing graphics c [More]
my problem is that AIM for mac doesnt have webcam/video support yet...so I'm wondering does iChat have AIM syncing?? And one of my friends has a webcam and I would like her to able to use it but with the purchase of my new mac I cant use the AIM Vide [More]
Okay, I am just your basic Stay-at-home mom who manages a personal website and hobby website. The personal website is our family stuff the other one is NOT. Both are in the key to the left on iWeb as separate websites and I have registered the each d [More]
Hi, I have already set-up a VI to acquire data using traditional NI-DAQ. I am using DAQ board PCI-6033E, which has an SCB-100 to which are connected my sensors. I can acquire data in LabView using this set-up. I am looking for a simple VI which will [More]
Hey all - I searched and searched. How do I bend an image? I want to give it a 3d feel. If you take a piece of paper and make it do a U shape on a table (Touching the left and right edge only). And look down on it I want that effect. That's the best [More]
After starting Logic(pro 7.2)When I try to open a file by using the file>open>choose method the window shows a list of modification dates in the left column. If I try to browse in this window the only thing that changes is the modifcation dates.I am [More]
Hi all, Well I am relatively new to PowerBuilder and we are trying to establish a PoC on migrating a large Powerbuilder Application with a Sybase database to an Oracle Database. Specifically, I am looking for more info on the migration of the embedde [More]
I am importing imovie into fcpx, once imported into library I double click on the icon in the viewer to load movie onto the time line. The movie loads onto the time line and then crashes. I am running OSX 10.9.1, FCPX 10.1.1, and imovie 10.0.2. I am [More]