RE: ora 3113 error

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Thu, 8 Apr 2004 17:15:33 -0400
Message-ID: <E1732F21A9B99440B2117A3BEC76B91D021158@ztangousexch.ad.ztango.com>

Also give it try with the ORA-7445 lookup.

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: Thursday, April 08, 2004 2:19 PM
To: oracle-l_at_freelists.org
Subject: RE: ora 3113 error

ORA-7445 is a core dump. You need to open a TAR w/ Oracle.

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

-----Original Message-----
From: Kommareddy, Srinivas (MED, Wissen Infotech) [mailto:Srinivas.Kommareddy_at_med.ge.com]=3D20 Sent: Thursday, April 08, 2004 2:13 PM
To: ORACLE-L_at_freelists.org
Subject: ora 3113 error

Hi All,
=3D20

Can somebody through somelight on this:
=3D20

When I tried to exeucte the flwng code, I am getting 3113 error......
=3D20

SQL> conn sys/********@xxx as sysdba
Connected.
=3D20

SQL> begin

  2     dbms_rule_adm.grant_system_privilege
  3     (
  4        privilege =3D3D> dbms_rule_adm.CREATE_RULE_SET_OBJ ,
  5        grantee =3D3D> 'STRMADMIN' ,
  6        grant_option =3D3D> TRUE
  7     ) ;

8 end;
9 /
begin
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
=3D20
=3D20

The trace file is like this:
=3D20

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [FFFFFFFF7DF009C8] [SIGSEGV] [Address not mapped to object] [0x000000009] [] [] Current SQL statement for this session:
begin

dbms_rule_adm.grant_system_privilege
(

      privilege =3D3D> dbms_rule_adm.CREATE_RULE_SET_OBJ ,
      grantee =3D3D> 'STRMADMIN' ,
      grant_option =3D3D> TRUE

) ;
end;
=3D20
=3D20

Anybody ever got such error.
=3D20

Regards,
Srinivas

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 08 2004 - 16:12:04 CDT