With the sample input you provided, the following script seems to do what you want:
although I am assuming that you had a typo in the output you said you wanted....
The above script produces the output:
while the output you said you wanted was:
If you can't see how the index() and substr() functions are working to extract the data you want, you can uncomment the commented out print and printf() statements to see values being used.
If someone wants to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk.
Dear Don Cragun
Thank you for your reply, although some difficulties,
I'll go check some command usage, and study your answer,
Thank you for your help.
---------- Post updated at 08:36 PM ---------- Previous update was at 08:25 PM ----------
Dear RudiC
Thank you for your reply,
I understand you provide answers.
I will try this code and study awk command usage.
Thank you.
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)
I want to check for "errors" or "ORA-" in Y.if there is an error then exit
Y=`sqlplus -s user/passwd<< EOF
exec test_Proc;
exit;
EOF`
if ; then
exit 1
fi
but this doesnt work (6 Replies)
Hi,
I would like to modify, in script schell, the line right above (DESCRIPTION and check three cases :
if line contain ".world" then line=line-".world" concat "," concat line
if line dont contain ".world" then line=line concat "," concat line concat".world"
else line=line
Keep in... (10 Replies)
Hi all- i am having some hiccups while writing a korn shell to edit init.ora file for automating latest PSU patchset.(Oracle)
I am trying to edit(add) the ._fix_control and .event with certain parameters.
if anyone has any idea that will be helpful.
thanks. (1 Reply)
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)
hi
i would like to know the path of init.ora in AIX Server
i tried with find command but i could not find it.
can somebody help me with that. (8 Replies)