Home » RDBMS Server » Server Utilities » ORA-00600 while data insertion through SQLLDR (ORACLE 9i -- SOLARIS)
icon8.gif  ORA-00600 while data insertion through SQLLDR [message #361352] Wed, 26 November 2008 01:06 Go to next message
pankajkmeena
Messages: 46
Registered: September 2007
Member
I am getting below error while data Upload using SQLLDR

Record 16: Rejected - Error on table GLIF.
ORA-00600: internal error code, arguments: [ktspgsb-1], [], [], [], [], [], [], []


However i am able to insert manually in that table.

Database is opened properly. No error in alert log file execept that comes during Upload of data through SQLLDR.

Is it a bug or something else (like Inter proccess communication).

Thankx in advance for your reply.
Re: ORA-00600 while data insertion through SQLLDR [message #361357 is a reply to message #361352] Wed, 26 November 2008 01:16 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug - the first argument is the internal error number


Show us what you are trying to do ?
Re: ORA-00600 while data insertion through SQLLDR [message #361359 is a reply to message #361357] Wed, 26 November 2008 01:22 Go to previous messageGo to next message
pankajkmeena
Messages: 46
Registered: September 2007
Member
Inserting Data from a Flat File to table using sqlldr.
same is working fine 2 days ago.
Due to some problem PC was rebooted (normally) 2 days ago.
After that this problem start comming.

Oracle is now Up

However there was some problem in bringing up oracle earlier as disk containg datafile showing some error during rebooting of Pc.
But now that is solved.
Re: ORA-00600 while data insertion through SQLLDR [message #361363 is a reply to message #361359] Wed, 26 November 2008 01:28 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
Show us what you are trying to do ?

Quote:
Inserting Data from a Flat File to table using sqlldr.

Well that is quite clear....
By the word show, I mean provide an example...

Quote:
same is working fine 2 days ago.

So "something" has happend to your environment
Re: ORA-00600 while data insertion through SQLLDR [message #361365 is a reply to message #361352] Wed, 26 November 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: ORA-00600 while data insertion through SQLLDR [message #361386 is a reply to message #361363] Wed, 26 November 2008 03:14 Go to previous messageGo to next message
pankajkmeena
Messages: 46
Registered: September 2007
Member
physical volume is remaped
Also when i am running long query it is giving below error

     *
ERROR at line 2:
ORA-08103: object no longer exists

[Updated on: Wed, 26 November 2008 03:16]

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361427 is a reply to message #361359] Wed, 26 November 2008 06:23 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

pankajkmeena wrote on Wed, 26 November 2008 08:22
However there was some problem in bringing up oracle earlier as disk containg datafile showing some error during rebooting of Pc.
But now that is solved.


Doesn't seem like that if you are getting ORA-08103

An incomplete recovery perhaps ?

[Updated on: Wed, 26 November 2008 06:23]

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #362214 is a reply to message #361427] Mon, 01 December 2008 05:52 Go to previous message
pankajkmeena
Messages: 46
Registered: September 2007
Member
Our database is running in noarchievelog mode

Also V$RECOVER_FILE view doesnot shows any file that requires recovery

Previous Topic: Import of a schema, without the its data
Next Topic: Exporting from Access to Oracle
Goto Forum:
  


Current Time: Mon Dec 05 15:14:38 CST 2016

Total time taken to generate the page: 0.17602 seconds