Search Results

Search: Posts Made By: a1_win
3,188
Posted By a1_win
Script to automate add/resize datafile in Oracle ASM Storage
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...
Forum: Red Hat 01-23-2017
10,706
Posted By a1_win
Unable to extract .gz file using gunzip
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...
6,494
Posted By a1_win
Extract Oracle sql queries from .fmb and .rdf files
Hi all,



Thanks for your time!

Regards,
7,630
Posted By a1_win
How to pass Oracle sql script as argument to UNIX shell script?
Yes. You are right Junior-Helper.

I changed the line @users.sql to @$1 and it works!!
7,630
Posted By a1_win
---------- Post updated at 02:40 PM ----------...
---------- 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...
7,630
Posted By a1_win
How to pass Oracle sql script as argument to UNIX shell script?
Thanks Don.

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

Regards,
7,630
Posted By a1_win
How to pass Oracle sql script as argument to UNIX shell script?
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...
1,057
Posted By a1_win
Hi Scott, Tried the below and verified ...
Hi Scott,

Tried the below and verified

echo $WINPORT
22

echo ${WINPORT:+:}
:

echo ${WINPORT:-}
22
1,057
Posted By a1_win
Meaning of WINPORT=22${WINPORT:+:}${WINPORT:-}
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:-}
...
4,431
Posted By a1_win
How to trap APPS/Password dynamically in FCP_LOGIN?
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
1,639
Posted By a1_win
Hi Hanson44, One issue I still face while...
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...
1,639
Posted By a1_win
Thanks hanson44 for pointing it out! After...
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 |...
1,639
Posted By a1_win
Compare two initoras shell script syntax error
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...
41,840
Posted By a1_win
Thanks to everyone who took out time to share the...
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...
41,840
Posted By a1_win
How to get sqlplus column header once in csv file?
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...
4,643
Posted By a1_win
Hi Alister/RudiC, Thanks a lot for your...
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...
4,643
Posted By a1_win
Hi Rudi C, Thanks but even sourcing the...
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...
4,643
Posted By a1_win
Hi Chubler_XL, The issue is not resolved...
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...
4,643
Posted By a1_win
Hi Chubler_XL, Will this help resolve in...
Hi Chubler_XL,

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

Thanks,
a1_win
4,643
Posted By a1_win
Running same script through cron gives different output
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...
12,324
Posted By a1_win
Yes Ahamed! I figured it out and wanted to update...
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
12,324
Posted By a1_win
Sar -u generates multiple column headers in csv file
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 ...
12,324
Posted By a1_win
Thanks Ahamed! This is working as per the...
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
12,324
Posted By a1_win
Sar -u generates multiple column headers in csv file
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
...
5,519
Posted By a1_win
Hi Spacebar, Thanks but this is not working!...
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...
Showing results 1 to 25 of 88

 
All times are GMT -4. The time now is 05:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy