10 More Discussions You Might Find Interesting
1. Red Hat
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)
Discussion started by: Maddy123
2 Replies
2. HP-UX
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)
Discussion started by: Perlbaby
4 Replies
3. Programming
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,... (2 Replies)
Discussion started by: rshivarkar
2 Replies
4. UNIX for Advanced & Expert Users
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)
Discussion started by: Mansoor8810
7 Replies
5. Solaris
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)
Discussion started by: newbie_01
1 Replies
6. Shell Programming and Scripting
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)
Discussion started by: shivanete
3 Replies
7. Linux
Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is... (2 Replies)
Discussion started by: yajneshilu
2 Replies
8. Linux
It is related to Linux, Oracle 9.2.0. I am new to Oracle.
I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is
“ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor”
I have successfully started lsnrctl. Here... (3 Replies)
Discussion started by: yajneshilu
3 Replies
9. HP-UX
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)
Discussion started by: techbravo
6 Replies
10. UNIX for Dummies Questions & Answers
Hi All,
I have to make the following changes in shell script:
When the data file is being created, an “ORA” error occurs in it. I have to remove this ORA error from data file and put it in log file.
I am “ -n grip command” to find the ORA error and get the line number,
How do I delete it... (1 Reply)
Discussion started by: sk005
1 Replies