ORA-00600: Internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s] An internal error happened.
This is an exceptional condition which might indicate a bug.
The parameters that come with this error give more information about the location where this exception occured.
You should contact Oracle support or browse metalink for more information regarding your specific error condition.
Also check the alert.log and other trace files in the background_dump_dest or user_dump_dest for additional information.
Should you want to find a solution yourself and have access to Oracle Metalink, Oracle support provides the ORA-600 Lookup Tool with which you can troubleshoot the ORA-600.
 Forum Messages
| This eroor is showing in my trace file and also showing when I'm trying to export my full database. Can some one hlep me why it occure and how to resolve it. |
Hi,
In TOAD, when i dropped an index and tried to create a bit map index with the same name, i have got the error ORA-00600 internal erro code, arguments: [kxfqupp_bad_cvl], [4233], [6],[],[],[],[],[]
The query which I used is,
CREATE BITMAP INDEX
ON table name(column name)
NOLOGGING
TABLESPACE
PARALLEL 10 COMPUTE STATISTICS;
Can you please suggest me a solution to rectify this error.
|
Hi,
I am getting the following error while executing a function.
v_Return = Oracle Error: Please Contact Support : ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
The function goes like this.
CREATE OR REPLACE
FUNCTION get_org_full_path(p_org_id IN NUMBER) RETURN VARCHAR2 IS l_sqlerrm VARCHAR2(300);
l_err_message error_log.err_message%TYPE;
return_string VARCHAR2(4000) := '';
CURSOR c1 IS
SELECT TRIM(LTRIM(max(SYS_CONNECT_BY_PATH(orgname,': ')), ':')) orgfullpath
from
(
select org.orgname, org.ORGId ,
ROW_NUMBER() OVER (PARTITION BY part ORDER BY ORG.ORGID) AS curr,
ROW_NUMBER() OVER (PARTITION BY part ORDER BY ORG.ORGID) -1 AS prev from
(
select orgid, PARENTORGANIZATION, orgname,
ROW_NUMBER() OVER (PARTITION BY ORGID ORDER BY ORGID) part
from orgunit where orgname in (
SELECT CONNECT_BY_ROOT ORG.orgname orgname
FROM ORGUNIT ORG
WHERE orgid = p_org_id
CONNECT BY PRIOR orgid = PARENTORGANIZATION
)
)org
)org1
CONNECT BY prev = prior curr
START WITH prev = 0;
BEGIN
FOR i IN c1
LOOP
return_string := i.orgfullpath;
END LOOP;
RETURN TRIM(return_string);
EXCEPTION
WHEN others THEN
l_sqlerrm := sqlerrm;
log_error_prc('get_org_full_path', l_sqlerrm, l_err_message);
RETURN l_err_message;
END;
Can you please help me in resolving this issue.
-- Vikas Kumar
|
Hi,
I tried to compile this statement, but have an error,
PROCEDURE Send_Word_Email(file_spec in varchar2,
po_no in number) IS
email_addr inv_supplier.email%TYPE;
supp_code inv_supplier.code%TYPE;
cursor supp_cur(pPO in inv_pohead.po%TYPE) is
select code,email from inv_supplier
where code in (select supplier from inv_pohead where po=pPO);
cursor cpro_cur is
select name from inv_cprofile
where rownum = 1;
subject varchar2(80):='Purchase Order';
error_string varchar2(80):='';
BEGIN
-- checking if the word file has been generated by reports
-- if the file does not exist, it might be difficult to catch
-- the error
if File_Exist(file_spec) then
-- get email address from supplier table
for supp_rec in supp_cur(po_no) loop
email_addr := supp_rec.email;
supp_code := supp_rec.code;
end loop;
if email_addr is null or Length(email_addr) = 0 then
-- write to log file about email_addr not filled in
if Length(:msg_block.message) > 0 then
:msg_block.message := :msg_block.message||chr(13);
end if;
:msg_block.message := :msg_block.message||'PO#'||to_char(po_no)||': E-mail address for supplier '||supp_code||' is empty!';
else
-- get company name from main profile table
for cpro_rec in cpro_cur loop
subject := subject||' from '||cpro_rec.name;
end loop;
-- dialog=0 means no user interaction
-- attachment_file_spec=null means no attachment file
begin
error_string := mailx.send(email_addr,
subject,
'Enclosed please find purchase order in Word document being attached!',
0,
file_spec);
if Length(error_string) > 0 then
if Length(:msg_block.message) > 0 then
:msg_block.message := :msg_block.message||chr(13);
end if;
:msg_block.message := :msg_block.message||'PO#'||to_char(po_no)||': '||error_string;
end if;
exception
when others then
if Length(:msg_block.message) > 0 then
:msg_block.message := :msg_block.message||chr(13);
end if;
:msg_block.message := :msg_block.message||'PO#'||to_char(po_no)||': Encounter error sending to '||email_addr||'!';
end;
end if;
else
-- have to write to a log file regarding report file not
-- generated
if Length(:msg_block.message) > 0 then
:msg_block.message := :msg_block.message||chr(13);
end if;
:msg_block.message := :msg_block.message||'PO#'||to_char(po_no)||': Report file is not generated!';
end if;
END;
Error
------
Compiling procedure SEND_WORD_EMAIL...
Compilation error on procedure SEND_WORD_EMAIL:
PL/SQL ERROR 0 at line 0, column 0
ORA-00600: internal error code, arguments: [17069], [68476056], [], [], [], [], [], []
Compilation errors have occurred.
Can someone help me to fix this? |
| when button preesed triger raised unhandiled exception ora-00600 |
Hi I found below error in alert log file.
let me know the reason of this please.
Thank you in advance..
Regards
Prasant
----------------------------------------------------------------------------
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1619.trc:
ORA-00600: internal error code, arguments: [729], [800], [space leak], [], [], [], [], []
Sat Apr 5 17:24:38 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1619.trc:
ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [800], [space leak], [], [], [], [], []
Sat Apr 5 17:34:24 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1527.trc:
ORA-00600: internal error code, arguments: [729], [180800], [space leak], [], [], [], [], []
Sat Apr 5 17:34:27 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1527.trc:
ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [180800], [space leak], [], [], [], [], []
Sat Apr 5 17:39:50 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1831.trc:
ORA-00600: internal error code, arguments: [729], [800], [space leak], [], [], [], [], []
Sat Apr 5 17:39:54 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1831.trc:
ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [800], [space leak], [], [], [], [], []
Sat Apr 5 17:44:55 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_25871.trc:
ORA-00600: internal error code, arguments: [729], [198400], [space leak], [], [], [], [], []
Sat Apr 5 17:44:59 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_25871.trc:
ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [198400], [space leak], [], [], [], [], []
Sat Apr 5 20:34:53 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1603.trc:
ORA-00600: internal error code, arguments: [729], [17600], [space leak], [], [], [], [], []
Sat Apr 5 20:34:57 2008
Errors in file /oracle/admin/smswwil1/udump/smswwil1_ora_1603.trc:
ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [17600], [space leak], [], [], [], [], []
|
| : -> 07-APR-2008 17:35:08 | Internal error | DbMotive | Reply |
ORA-00600 are internal errors and are probably a bug.
You will have to work with Oracle support in order to resolve this.
If you are not on the latest release, upgrading might resolve your problem
|
Add your message for ORA-00600
|
Home