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. AIX
Where can I find
dsn and TNSNAMES.ora
on UNIX AIX
Thanks for contribution (3 Replies)
Discussion started by: digioleg54
3 Replies
3. Shell Programming and Scripting
Hi there,
I'm encountering problems on an AIX system when using following in my script.
find . -name *.edi -type f -exec sh -c 'scp {} $user@$server:$path || exit 5; mv {} $sent || exit 7' \;
the error i get is following
find: 0652-018 An expression term lacks a required... (4 Replies)
Discussion started by: Kerberos
4 Replies
4. HP-UX
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)
Discussion started by: alokpattar
3 Replies
5. 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
6. 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
7. Shell Programming and Scripting
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)
Discussion started by: rajeshorpu
0 Replies
8. UNIX for Dummies Questions & Answers
Can we find out what is the location of tnsnames.ora file used by the hp unix. (3 Replies)
Discussion started by: Sudipshib
3 Replies
9. Shell Programming and Scripting
Hi ,
i need to extract only time for a file and i am using following code for this..
while read record1
do
SQLQuery=`echo $Record1 | awk '{printf $0 }'`
InputfileName=`echo $Record1 | awk '{printf $8 }'`
ColumnNamesSPcomma=`echo $Record1 | awk '{printf $4 }'`
filetime =`echo... (6 Replies)
Discussion started by: manmeet
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