if [ ! -d "$year_name" ];
then
mkdir "$year_name"
cd "$year_name"
mkdir "$Directory_Name"
echo "This directory already exists"
#df -k > "$year_name/$Directory_Name/$File_Name".log
exit 0
fi
df -k > "$year_name/$Directory_Name/$File_Name".log
su - oracle -c "export ORACLE_SID=ORACLE;sqlplus /nolog <<!
connect /as sysdba
select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;
select a.tablespace_name,total,free,total-free used from (select tablespace_name,sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name)a,(select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space group by tablespace_name)b where a.tablespace_name=b.tablespace_name;
select * from v$resource_limit; quit
!" >> "$year_name/$Directory_Name/$File_Name".log
sleep 5
ftp -in 192.168.0.44 << !
user root root123
bin
lcd "$year_name/$Directory_Name/"
cd /var/www/html/checkdisk/"$year_name/$Directory_Name"
put $File_Name.log
bye
!