OraFAQ Forum: Server Administration » ORA-060

Home » RDBMS Server » Server Administration » ORA-060 - User Trace file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-060 - User Trace file [message #60349]

Mon, 02 February 2004 23:35

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

Each time I'm using or executing a stored procedure my Oracle instance crashes. When I check my user trace file I have this ORA-00600 error (ksedmp: internal or fatal error):

/opt/oracle/admin/sms/udump/sms_ora_17698.trc

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production ORACLE_HOME = /opt/oracle/product/9.2.0.1.0

System name: Linux

Node name: prodplatform.my-caller.com

Release: 2.4.9-e.27smp

Version: #1 SMP Tue Aug 5 15:11:41 EDT 2003

Machine: i686

Instance name: sms

Redo thread mounted by this instance: 1

Oracle process number: 19

Unix process pid: 17698, image: oracle@prodplatform.my-caller.com (TNS

V1-V3)

*** SESSION ID:(19.16668) 2004-01-30 13:01:37.889

*** 2004-01-30 13:01:37.889

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [[kohdtf048]], [[]], [[]], [[]], [[]], [[]], [[]], [[]] Current SQL statement for this session: DECLARE

P_NEW_SERVICE_NAME VARCHAR2(200);

P_NEW_SHORT_NUMBER NUMBER;

P_COUNTRY_CODE NUMBER;

P_OLD_SERVICE_NAME VARCHAR2(200);

P_OLD_SHORT_NUMBER NUMBER;

P_NEW_CUSTOMER_ID NUMBER;

P_IS_VOP NUMBER;

BEGIN

P_NEW_SERVICE_NAME := 'vopcolor';

P_NEW_SHORT_NUMBER := 1100;

P_COUNTRY_CODE := 1;

P_OLD_SERVICE_NAME := 'color';

P_OLD_SHORT_NUMBER := 8998;

P_NEW_CUSTOMER_ID := 0;

P_IS_VOP := 1;

SMS_USER.BUILD_SRVC ( P_NEW_SERVICE_NAME, P_NEW_SHORT_NUMBER, P_COUNTRY_CODE, P_OLD_SERVICE_NAME, P_OLD_SHORT_NUMBER, P_NEW_CUSTOMER_ID, P_IS_VOP );

COMMIT;

END;

----- PL/SQL Call Stack -----

object line object

handle number name

0x532b03b0 17 procedure SMS_USER.BUILD_SRVC

0x532b03b0 17 procedure SMS_USER.BUILD_SRVC

0x532b03b0 17 procedure SMS_USER.BUILD_SRVC

..... etc ....

Can someone help me please? Why If my procedure and packages is compiled succefully, should I get back such problems? Do I have a problem with my server configuration?

Regards,

Patrick Tahiri.

Report message to a moderator

Previous Topic:	Oracle 9i replication problem
Next Topic:	PFILE or SPFILE (Oracle 9i)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:40:37 CDT 2024