Search Results

Hi all,

Could anyone please share ideas or logic on how to automate add/resize datafile in Oracle ASM Storage for Oracle RAC/Single Node databases when any tablespace space alert is trigerred by...

Linux 3.8.13-16.2.1.el6uek.x86_64 #1 SMP Thu Nov 7 17:01:44 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

Hi all,

I am unable to extract .gz file using gunzip

Used the following command to create...

Hi all,



Thanks for your time!

Regards,

Yes. You are right Junior-Helper.

I changed the line @users.sql to @$1 and it works!!

---------- Post updated at 02:40 PM ---------- Previous update was at 02:38 PM ----------

Hi,

I think I got it

./output.sh users.sql


$(cat $1)


Thank You Don for your help. This...

Thanks Don.

But is there a way to pass the file users.sql as an argument to the shell script for execution.

Regards,

Hi all,

$ echo $SHELL
/bin/bash


Requirement - How to pass oracle sql script as argument to unix shell script?

$ ./output.sh users.sql

Below are the shell scripts and the oracle sql...

Hi Scott,

Tried the below and verified

echo $WINPORT
22

echo ${WINPORT:+:}
:

echo ${WINPORT:-}
22

Hi all,

O/S: Sun Solaris SPARC 64 bits

Could anyone please explain what does the below mean after WINPORT=22 in the below line?

WINPORT=22${WINPORT:+:}${WINPORT:-}
...

Hi All,

Bash shell is being used

Could anyone please let me know - How to trap APPS/Password dynamically in FCP_LOGIN variable in bash shell script?

Thanks for your time

Regards,
a1_win

Hi Hanson44,

One issue I still face while executing the script is:

initqa.ora file shows the prod sid name instead of the qa name which is incorrect


-bash-3.2$ ./compare_two_initoras.sh...

Thanks hanson44 for pointing it out!

After correcting the code, it's working fine!


-bash-3.2$ cat compare_two_initoras.sh

#!/bin/bash

file1=$1
file2=$2
for parameter in `cat $file1 |...

Hi All,

I am executing the below shell script to compare two initoras files which is ending up in syntax error as below:


-bash-3.2$ cat compare_two_initoras.sh

#!/bin/bash

file1=$1...

Thanks to everyone who took out time to share the resolution.
I will try with the suggestions provided and update with the results shortly.

Thanks to all for your time and attention!

A great...

Hi All,

Could anyoone please let me know how do I get sqlplus column header once in csv file

Scripts are below:

cat concreq.sh

#!/bin/bash

. $HOME/.profile

while [ 1 -eq 1 ]; do...

Hi Alister/RudiC,

Thanks a lot for your time! Appreciate your help!

I was able to get the expected output after modifying the script and running through cron as below:

shell script:

cat...

Hi Rudi C,

Thanks but even sourcing the .profile from absolute path didn't help resolve the issue when running the script through cron

I think there is something else that is missing when the...

Hi Chubler_XL,

The issue is not resolved after setting the code as below:

LC_TIME="POSIX" sar -tu 5 1 | awk ...

It still gives the incorrect output while running the script through cron as...

Hi Chubler_XL,

Will this help resolve in getting the expected output by running the sript through cron?

Thanks,
a1_win

Hi All,

I am running the below shell script through cron and surprisingly it gives different output

$uname -a
Linux 2.6.18-194.3.1.7.3.el5xen #1 SMP Fri Jul 30 00:08:45 EDT 2010 x86_64 x86_64...

Yes Ahamed! I figured it out and wanted to update the post!!

Thanks again Ahamed! This worked for me and I get the desrired output!!

Regards,
a1_win

Hi Ahamed,

Thanks but when I try using the same logic in the shell script to find out the page statistics, the headers are being repeated


-bash-3.2$ sar -B 5 1
Linux 2.6.32-300.41.1.el5uek ...

Thanks Ahamed! This is working as per the expected output!

Please let me know what is meant by "OFS=," in the shell script you updated as above

Thanks for your time!

Regards,
a1_win

Hi All,

The below sar -u command generates multiple column headers in csv file

Expected output should print column headers only once in the csv file


shell script:

$cat sar_cpu_EBS.sh
...

Hi Spacebar,

Thanks but this is not working!

Tried executing with the below command but it exited without running anything..


hr=$(date +"%H")
while [ $hr -ge 22 -a $hr -lt 01 ] # For...