I have developed the following shell script. The idea was to create an alias to execute it and return the tablespaces and their sizes from an oracle database. When I execute is via the alias, I have issues.
So, here is the script first:
Code:
> cat ts_size.sh
#!/bin/ksh
xwhere=" "
xwild=" "
wild=" "
if [$# -eq 1]
then
wild=$(`echo ${1} | awk '{print index($1,"%") }'`)
# echo $wild
if [${wild} != 0]
then
xwild="like"
else
xwild="="
fi
xwhere="where tablespace_name "${xwild}" upper('"${1}"')"
fi
echo $xwhere
sqlplus -s / <<eof &2>/dev/null
set linesize 120;
set pagesize 1000;
set feedback off;
set echo off;
col tablespace_name forma a30;
select round(sum(bytes/1024/1024/1024),2) as "Gb", tablespace_name from dba_data_files ${xwhere} group by rollup (tablespace_name) order by 1 asc;
<<eof
The alias defined is:
Code:
ts_size='. ~/util/sql/ts_size.sh'
When I execute the shell script via the alias: notice I get some ksh not found and a 14873 and my command prompt etc.. AND when the shell finishes, I don't get my prompt back...
Code:
> ts_size
ksh: [1: not found
[2] 14873
>
Gb TABLESPACE_NAME
---------- ------------------------------
.38 SYSTEM
.5 SI
.5 SD
.68 TOOLS
.98 USERS
1.17 RCTI
7.13 SYSAUX
17.58 RDL
19.53 RDS
28.32 RDLS
43.95 UNDOTBS
73.24 RCT
86.32 RDRT
314.73 RIN
348.13 RD
625.34 RDLL
When I press enter then I get the following:
Code:
[2] + Done ts_size
>
and I get my prompt.
When I execute it directly as a shell script. I get the following:
Code:
> ts_size.sh
ts_size.sh[5]: [0: not found
>
Gb TABLESPACE_NAME
---------- ------------------------------
.38 SYSTEM
.5 SI
.5 SD
.68 TOOLS
.98 USERS
1.17 RCTI
7.13 SYSAUX
17.58 RDL
19.53 RDS
28.32 RDLS
43.95 UNDOTBS
73.24 RCT
86.32 RDRT
314.73 RIN
348.13 RD
625.34 RDLL
1568.48
>
Here too, I don't get the prompt back. I have to press the enter key to get my prompt back.
Any idea what I need to do to fix all these?
Thanks
Moderator's Comments:
Please use code tags, and indent your code / output, etc.
Last edited by Scott; 01-13-2011 at 02:12 PM..
Reason: Code tags; spacing.
Wow..such obvious mistakes...well most of my problems have been resolved. One issue remains...for some reason, one of the variables remains defined between runs. i.e. The first time I run it with a parameter (wild card for tablespace names) it seems to carry that over into the next execution.
Code:
> ts_size s%
where tablespace_name like upper('s%')
Gb TABLESPACE_NAME
---------- ------------------------------
.38 SYSTEM
.5 SD
.5 SI
7.13 SYSAUX
8.5
> ts_size
where tablespace_name like upper('s%')
Gb TABLESPACE_NAME
---------- ------------------------------
.38 SYSTEM
.5 SPD
.5 SI
7.13 SYSAUX
8.5
>
Last edited by Scott; 01-13-2011 at 01:33 PM..
Reason: Code tags; spacing.
... but as it errors on my system it is hard to work out what it is meant do do. It is very unusual to use backticks inside parentheses. If we take the backticks away then it calculates where the "%" character is in the parameter $1 or returns zero if there is no "%" character.
Code:
Back on topic.
I wonder if your alias for "ts_size" is
ts_size='. ~/util/sql/ts_size.sh %s'
Any ideas/suggestions where I can look to resolve this last remaining puzzle?
I have no clue what could be causing this. I checked the env variables, there is nothing there defined that is being used in the shell script. I am not doing an export of any variables.
Hi
can some one please help me how i can get the output i require:
My text file "sample.txt" contains the text like below
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_fedora-lv_root
15G 2.6G 12G 19% /hari
Filesystem Size ... (3 Replies)
I'm new to unix script, and I need to check the tablespaces daily, here is the script(quite simple), but it does not work. Did I missed something ?
Please guide me, Many thanks !
#!/bin/sh
echo "ORA TABLEASPACE:"
sqlplus system/oracle as sysdba;
set pagesize 9999;
set linesize 132;
... (5 Replies)
I have prepared the below script to monitor the tablespace and alert the users whenever it reaches a threshold limit.
#!/bin/sh
. /home/.profile
sqlplus -s $LOGON << .eof > $scripts/check_tablespace.temp
set pages 0
select tablespace_name, free_percent
from (
SELECT... (4 Replies)
Hi
Linux
Set up - alias ls='ls -l'
Then run script
#! /bin/ksh
sub()
{
ls
}
sub
Is there any way to get it working. I don't want to define alias inside of the program
Thank you (2 Replies)
Hi ,
I am trying to run this script in crontab but I get errors. When I run it explicitly like ./monitor_tblsp from another location then it runs fine . I am messing somewhere with paths but I don't know where and how . Please help .
Here is the error part
./monitor_tblsp: touch: not... (2 Replies)
Hi,
I need to execute a script to find the tablespace size in oracle.But i get an error.:confused:
Script Executed:-
#!/bin/ksh
ORACLE_SID= oracelinstance
ORACLE_HOME= oracle path
PATH=$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH
sqlplus... (4 Replies)
Bourne: How to invoke an alias from within a shell script
If I type in the alias in the command line, it runs
If I insert that same alias into my shell script and run the shell script, the alias is not invoked.
Help please. (2 Replies)
Hi,
I want to use an 'if statement' that will check if a certian file is greater in size than a certain value given by the user, but cannot get it to work. Do you have any ideas how this can be done?
Your help is appreciated! (6 Replies)
01-13-2011
