Search Results

Hi Team,


I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:

#!/bin/bash
export...

Hi folks,

I have a list of variables as follows:

CDBTEST1
messdba1
sat11cru1
s12tgts1
sa12ss1

I need to remove the last '1' so I can use the remaining variables in a for loop:

CDBTEST...

bingo!
fixed.
Thank you so much all, very much appreciate your valued feedback.

there are $ signs:

lit-dbracm01-p002:/home/oracle>cat -vet /tmp/longrunmon.out
testinst2,10,1525186184$
testinst,10,1525186184$


is that normal?

>
server:/home/oracle>while read line
> do
> printf "I have read \"${line}\" from the file.\n\n"
> done < /tmp/longrunmon.out


output

I have read "testinst2,10,1525186184" from the...

is there an exit i should be using somewhere?

It seems to be trying to use another empty line but I cant see one anywhere

Im not sure what you mean by correct tagging.

My files seems good enough. no empty line anywhere.


$:/home/oracle>cat /tmp/longrunmon.out
testinst,10,1525186184
testinst-2,10,1525186184...

oh yes, you're right!
thank you so much :-)

---------- Post updated at 04:08 PM ---------- Previous update was at 01:21 PM ----------

Actually I have one more bug:


Any idea why we see the...

lit-dbracm01-p002:/home/oracle>cat /tmp/longrunmon.out

testinst,10,1525186184
Seriously: Please use CODE tags - for code AND data - as required by forum rules!

For some reason the INSERT_TIME value is not being picked up before the rest of the script.



while IFS=, read -r INSTANCE SESS_COUNT INSERT_TIME

do

DATE_DIFF=`expr ${CHECK_DATE_1} -...

Thanks all for the help,

I tried re-arranging the expression:

#!/bin/bash

export CHECK_DATE_1=`date +%s`
export FILE1=/tmp/longrunmon.out

#export DATE_DIFF=`expr ${CHECK_DATE_1} -...

Thank you!

any idea why the expr is causing an issue?

lit-dbracm01-p002:/home/oracle>./testdiff.sh
expr: syntax error
Major Alert:
Major Alert:
lit-dbracm01-p002:/home/oracle>cat...

Hi folks,

I have a script where i am trying to calc the difference between two epoch dates and then have a condition based on the resultant value.

When I run the script it keeps complaining;
...

hi Folks,

Can anyone help with changing the color of the words in a linux shell script?

I get how to change default background etc in putty, but for some reason the text in the script has...

thank guys that works.

echo "${ORACLE_SID%?}"
blt10cr

nice and simple :-)

Hi all,

Can anyone suggest a way to get a portion of string from the end?

So:

$ORACLE_SID=blt10cr1

We can drop the final '1' and end up with:

$ORACLE_SID=blt10cr

So far I have the...

perfect!
thank you so much :-)

Thanks very much.

That is much better, the size is working now.

However, Im finding that the conetnts of $outputFile is appearing all on one line, ie not with new lines. the content of...

Hi All,

Can anyone help with an email formatting question:

Im using the following example to try and send a formatted email:


outputFile="file.txt"
(
echo "From: oracle@inovis.com"...

Hi team,

Anyone help me cut a process name from ps -ef output?

lit-dbrac01-b004: $ ps -ef|grep pmon|cut -f5 ...
oracle 448 1 0 2014 ? 00:04:15 ora_pmon_blms50db2

Like I...

anyone any ideas?

Hi all,

I did post this in another forum but I try as well.

Does anyone know how to change PROC_MEM_RES?
We have a DB server with quite a few oracle instances (RAC) and we are getting critical...

Hi all,

Does anyone know how to change PROC_MEM_RES?
We have a DB server with quite a few oracle instances (RAC) and we are getting critical alerts for PROC_MEM_RES.

Anyone know how to...

hmm. appending a parameter to a function name is not proving easy.

Ideally I just need 1 script rather than several.

I am getting a little confused.

i would call the script in the following...

I need to dynamically name a fnction so a watchdog script can identify a process.

so I need to append a parameter to a function name.

If you have any idea on how to do this I would be grateful.