10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
getting ./query: 0403-057 Syntax error at line 1 : `|' is not expected.
here is the top portion of the script below.
#!/bin/ksh
DATE=`date +%b-%d`
TIME=`date +%H%M`
TIMEA=`date +%H:%M`
STAT=stat.csv
USERID=user
PASSWD=user_password
COMD="dsmadmc -id=$USERID -password=$PASSWD... (1 Reply)
Discussion started by: rvstovall
1 Replies
2. Shell Programming and Scripting
Buddies, I am writing the below script 'tab.sh' to monitor the tablespaces in Database:-
-------------------------------
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
sqlplus system/oracle as sysdba <<EOF
spool... (5 Replies)
Discussion started by: sandip250382
5 Replies
3. Shell Programming and Scripting
Hi All,
I copied an existing script so that I could make updates to it and test those updates.
In both scripts I set the path which is the exact same in both scripts as I copied from the old to the new script.
setting path is this command:
# Add the path required for EMC commands to... (3 Replies)
Discussion started by: colinwilson1303
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: dehetoxic
5 Replies
5. Shell Programming and Scripting
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)
Discussion started by: svajhala
4 Replies
6. Shell Programming and Scripting
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:
> cat ts_size.sh
#!/bin/ksh
xwhere=" "
xwild=" "... (8 Replies)
Discussion started by: desibabu
8 Replies
7. Shell Programming and Scripting
I have a script in which i want to print absolute path of the same script irrespective of path from where i run script.
I am using
test.sh:
echo "pwd : `pwd`"
echo "script name: $0"
echo "dirname: `dirname $0`"
when i run script from /my/test/dir/struct as ../test.sh the output i... (10 Replies)
Discussion started by: rss67
10 Replies
8. Shell Programming and Scripting
Hi,
CREATE TABLESPACE aps_blob_large01
DATAFILE '/c2r6u13/u03/oradata/qnoldv01/aps_blob_large0101.dbf' SIZE X 270532608
REUSE
DEFAULT STORAGE (INITIAL 134217728 NEXT... (2 Replies)
Discussion started by: rparavastu
2 Replies
9. HP-UX
how can I find cpu usage memory usage swap usage and
I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times
my final destination is monitor process
logical volume usage above X % and number of Logical voluage above
can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies
10. Shell Programming and Scripting
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)
Discussion started by: vighna
4 Replies