Sitemap

Amicuk Programming Answers

ORA-600 [17280]

-0001-11-30   Views:10

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
Hi While installing solaris 10 x86 I skipped the installation of solaris 2 of 3 CD . After than I installed solaris 3 of 3 CD. When the installation is completed I cannot find some important commands like vold & volume management commands. Now how ca [More]
Hi,        I want to default a field nationality in infotype 0002 as a great britan, using dynamic actions but unable to go ahead. Any help regarding this really appreciate. Regards NiranjanHi, I need some guidance around creating dynamic action with [More]
When I forward an e-mail from within the e-mail app, the e-mail does not get forwarded completely. For some reason the original text gets truncated. I first noticed this on IOS 6 on both the iPhone 5 and iPad 3rd gen. Please advice me what to do, bec [More]
Hi, I am using oracle sql developer for this. I have created Store procedure which run after every 30mins of interval. the problem is Ii need to insert data for first time of day then later that same record should update for particular field(here its [More]
We have a requirement to assign multiple FI customer accounts to the same Business Partner in ECC 5.0. When we try to do this, we get the error message: Business partner &&& is already assigned to FI customer &&& Message no. FLBP12 [More]
Hi, Say loop tdate='12-JAN-2005' loop cursor....... if '10-JAN-2005'<=tdate then fetch end loop tdate=tdate+1 month end loop; in the above query i want my cursor to run the loop only once at the first true of my condition....in the second run the tda [More]
My iPod is connected to my powerbook g4 via USB - into the back of the laptop. The iPod is recharging - however it does not appear on either my desktop or iTunes. does anyone know how to rectify this - and what causes it?Does the iPod show the Do Not [More]
Hi ALL, I wish to create blocks on a production rsource as follows, class- chemistry characteristics- chem1, chem2, chem3,chem4 when PPDS plans for products with chemistry chem1, the planned orders should be created in the block chem1 and so on, so t [More]
How to delete marketing attribute when it is assigned to marketing attribute set  and some accounts  are already created with  use of these marketing attribute. Kindly helpthnx man i am able to delet it using this BTW For marketing attribute if  you [More]
I used to be able to burn a CD a few pictures at a time till it was full. I have tried CD-R AND CD-RW and now it says "This Disc Does Not allow any more burns, please put in a blank CD" what happened? I used a CD-RW disc, and it still doesn't al [More]