I have code to update some records in MyTable1 in sql which I am calling from ksh file (unix script).
I am getting below error -
MyTable1 TABLE UPDATE FAILED : UPDATE MyTable1 SET ph_nr = '+44 (0)20 8960
1233' , update_dts = sysdate WHERE ID = 499037
ORA-00600: internal error code, arguments: [17059], [0xC000000F1E4DAEF0],
[0xC000000F1B7D78D0], [0xC000000FDF038F90], [], [], [], [], [], [], [], []
Lo
When I execute in Toad I am not getting any error- UPDATE MyTable1 SET ph_nr = '+44 (0)20 8960
1233' , update_dts = sysdate WHERE ID = 499037
ORA 00600 error is unclasifed error.
So any error that Oracle doesn't know what it is it's 600.
You can find additional info on metalink, here is what i've got from my DBA folks.
In this case, 17059, while building a table to hold the list of child cursor dependancies relating to a given parent cursor, we exceed the maximum possible size of the table.
Solution should be (please take backup of table to reinsert the data later)
Truncating data will not be good idea as it has dependency on many tables.
But if there is not solution then have to go deep level to truncate data in all dependent tables which is not good solution.
I am also investigating issue and will post solution if I find.
Till then let me know any other solution.
Hi,
User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
HI All ,
I am using oracle 10g and HP AIX . I am getting the below error while running the package.
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595
ORA-06512: at line 2
... (4 Replies)
Dear All,
i am not able to start the 9i oracle database because of the following problems.
I log in into unix
and then into sqlplus
export oracle_sid=SATEST
startup nomount
i am getting the following errors
ORA-27300: OS system dependent operation:semget failed with... (3 Replies)
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
1 #!/bin/ksh
2 ################################################################
3 # Written by Johnson 12/03/2008
4 # Version 1.0
5 # This script executes some SQL to provide Spike Check Report to TNS team.
6 ... (3 Replies)
Hi,
I need to redirect internal internet requests to a auth client site siting on the gateway. Currently users that are authenticated to access the internet have there mac address listed in the FORWARD chain. All other users need to be redirected to a internal site for authentication.
Can... (1 Reply)
I am getting a :; then
echo "Enter zero or one file"
echo "You must use a valid directory"
echo "Current directory is:" pwd
exit 0
fi
#Flag Variable
flag=1
#Code for no arguments
if ; then
for filename in *
do
if ; then
... (2 Replies)
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
Hey guys, need some help. Running AIX Version 5.2 and one of our cron jobs is writing errors to a log file. Any ideas on the following error message.
Error: Internal system error: Unable to initialize standard output file
I'm guessing more info might be needed, so let me know.
Thanks (2 Replies)
