Search Results

Make sure the environment is correct, that either oracle_sid , only if this user is on the same box, or TWO_TASK is set, as well as ORACLE_HOME and the path statement is correct.

What error are...

This will output all the files that are type text, not using ls, but it gets the results you want I think.

file * | grep text | awk '{print $1 }' | cut -d':' -f1

Output is files that are some...

How are you identifying an exception? Seems if it's key word or some string grep would do it.

Giving us a definition of exception would be very useful to solving this.:confused:

Thanks Gneen for the correction, hadn't thought about that.

Believe

let hline=$((1+($tline/2)))

is what you meant to type. Since adding one to the tline causes the issue to move from odd...

The Shared memory realm error usually means the database is already mounted and/or open.

File already exists? That is really odd, sounds like you're trying to create a database file or control...

Greetings and salutation,
market research is it? I've been an Oracle DBA on unix for a long time, like it just fine, can handle the small workload you're talking about without issues, can run on...

Here's a stab at it.

==========Script follows ===========
#!/bin/ksh
filename=$1
tline=$(wc -l $filename | awk '{print $1}')
let hline=$tline/2
split -l $hline $filename
=========== End of...

They are used to assist in the automation of processes. Same purpose for which any script is used. Very big question, if you want detailed answers get any Oracle RDBMS DBA book, all have examples of...

wc -l [filename] | awk '{print $1}'

replacing [filename] with the name of the file the output will give you the line count.

Hope that helps