# releve de la volumetrie de la base PMGRT1P1 sur su1423 (pour l'usage de l'ADM)
# Auteur BL

# 1) Initialiation des variables d'environnement

_=/bin/env
MANPATH=/usr/share/man:/usr/man:/usr/dt/man:/usr/openwin/man:/usr/5bin/man:/usr/local/man:/usr/sfw/man:/opt/sfw/man:/opt/SUNWldm/man
LANG=C
DBALOG=/product/oracle/admin/utl/log
HZ=
DBATOOL=/product/oracle/admin/tool
ORA_COMENV=/product/oracle/admin/etc/03ComEnv.ksh
DBAAUD=/product/oracle/admin/utl/script/audit
PATH=/var/opt/oracle/bin:/var/opt/oracle/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/ccs/bin:/usr/xpg4/bin:/usr/dt/bin:/usr/openwin/bin:/usr/ucb:/usr/local/bin:/usr/sfw/bin:/usr/sfw/sbin:/opt/sfw/bin:/opt/sfw/sbin:/opt/SUNWldm/bin:/usr/bin:/usr/ccs/bin:/product/oracle/moteur/10.2.0.4-64b/bin
DBAUTL=/product/oracle/admin/utl
ORACLE_BASE=/product/oracle
ORA_TOOL=/product/oracle/admin/scripts/tools
DBAHIS=/product/oracle/admin/utl/his
LD_LIBRARY_PATH64=/product/oracle/moteur/10.2.0.4-64b/lib
ORACLE_PATH=/product/oracle/moteur/10.2.0.4-64b/bin
EDITOR=vi
DBAORA=/product/oracle/admin
HISTFILE=/users/oracle/.sh_history
LOGNAME=oracle
LIBPATH=/product/oracle/moteur/10.2.0.4-64b/lib
MAIL=/usr/mail/oracle
DBASCR=/product/oracle/admin/utl/script
#PS1=[$LOGNAME@su1423 $ORACLE_SID $PWD]
DBASQL=/product/oracle/admin/utl/script/sql
ORA_VERSION=10.2.0.4-64b
DBACONF=/product/oracle/admin/config
LOCAL=/product/oracle/local
TNS_ADMIN=/var/opt/oracle
TAR=/product/oracle/TAR
ORA_ETC=/product/oracle/admin/etc
SHELL=/bin/ksh
MOTEUR=/product/oracle/moteur
ORA_CEG_OEM_IA_PATH=/product/oracle/moteur/9.2.0.6-64b
ORA_ADMIN=/product/oracle/admin
ORA_CONF=/product/oracle/admin/config
ORATAB=/var/opt/oracle/oratab
BASEORA=/product/oracle/admin/etc/base.ksh
ORA_CRS_HOME=/product/oracle/moteur/CRS10.2.0.3-64b
ORA_SRVBIN=/product/oracle/admin/scripts/server
HOME=/users/oracle
DBASTAT=/product/oracle/admin/utl/script/stat
LD_LIBRARY_PATH=/product/oracle/moteur/10.2.0.4-64b/lib
TERM=xterm
ORACLE_HOME=/product/oracle/moteur/10.2.0.4-64b
DBAPRG=/product/oracle/admin/utl/script/prg
PWD=/users/oracle/tmp
ORA_LOCAL_BIN=/var/opt/oracle/bin
DBATRC=/product/oracle/admin/utl/trc
TZ=MET
DBALST=/product/oracle/admin/utl/script/lst
DB=/database/oracle
DBATEST=/product/oracle/admin/test
ORA_LOCAL_DIR=/var/opt/oracle
ORAENV=/var/opt/oracle/bin/oraenv
DBAEXE=/product/oracle/admin/utl/script/exe
ORA_SCR=/product/oracle/admin/scripts
DBASPOOL=/product/oracle/admin/lst

#. /users/oracle/.profile

ORACLE_SID=PMGRT1P1
export ORACLE_SID
ORACLE_HOME=/product/oracle/moteur/10.2.0.4-64b
export ORACLE_HOME
echo "PATH=$PATH"
echo "ORACLE_SID=$ORACLE_SID"

# 2) execution du script SQL 

/product/oracle/moteur/10.2.0.4-64b/bin/sqlplus "/ as sysdba" @/users/oracle/tmp/releve_volumetrie_PMGRT1P1.sql #>/dev/null 2>&1