$ export ORACLE_SID=orcl $ chmod +x orawatch.sh $ ./orawatch.sh system/yourpassword

 $ vi orawatch.sh sqlstr="system/system" $ chmod +x orawatch.sh $ ./orawatch.sh

 SQL> alter user system account unlock; alter user system identified by yourpassword;

 #!/bin/bash # script_name: orawatch.sh # Author: Danrtsey.Shun # Email:mydefiniteaim@126.com # usage: # chmod +x orawatch.sh # export ORACLE_SID=orcl # ./orawatch.sh system/yourpassword ipaddress=`ip a|grep "global"|awk '{print $2}' |awk -F/ '{print $1}'` file_output=${ipaddress}'os_oracle_summary.html' td_str='' th_str='' sqlstr=$1 test $1 if [ $? = 1 ]; then echo echo "Info...You did not enter a value for sqlstr." echo "Info...Using default value = system/system" sqlstr="system/system" fi export NLS_LANG='american_america.AL32UTF8' #yum -y install bc sysstat net-tools create_html_css(){ echo -e "" } create_html_head(){ echo -e "
$1
" } create_table_head1(){ echo -e "" } create_table_head2(){ echo -e "" } create_td(){ td_str=`echo $1 | awk 'BEGIN{FS="|"}''{i=1; while(i<=NF) {print "";i++}}'` } create_th(){ th_str=`echo $1|awk 'BEGIN{FS="|"}''{i=1; while(i<=NF) {print "";i++}}'` } create_tr1(){ create_td "$1" echo -e " $td_str " >> $file_output } create_tr2(){ create_th "$1" echo -e " $th_str " >> $file_output } create_tr3(){ echo -e "" >> $file_output } create_table_end(){ echo -e "
"$i"
"$i"
 `cat $1` 
" } create_html_end(){ echo -e "" } NAME_VAL_LEN=12 name_val () { printf "%+*s | %s\n" "${NAME_VAL_LEN}" "$1" "$2" } get_netinfo(){ echo "interface | status | ipadds | mtu | Speed | Duplex" >>/tmp/tmpnet_h1_`date +%y%m%d`.txt for ipstr in `ifconfig -a|grep ": flags"|awk '{print $1}'|sed 's/.$//'` do ipadds=`ifconfig ${ipstr}|grep -w inet|awk '{print $2}'` mtu=`ifconfig ${ipstr}|grep mtu|awk '{print $NF}'` speed=`ethtool ${ipstr}|grep Speed|awk -F: '{print $2}'` duplex=`ethtool ${ipstr}|grep Duplex|awk -F: '{print $2}'` echo "${ipstr}" "up" "${ipadds}" "${mtu}" "${speed}" "${duplex}"\ |awk '{print $1,"|", $2,"|", $3,"|", $4,"|", $5,"|", $6}' >>/tmp/tmpnet1_`date +%y%m%d`.txt done } ora_base_info(){ echo "######################## 1.数据库版本" echo "select ' ' as \"--1.Database Version\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_base_`date +%y%m%d`.txt echo "Select version FROM Product_component_version Where SUBSTR(PRODUCT,1,6)='Oracle';" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_base_`date +%y%m%d`.txt } ora_archive_info(){ echo "######################## 2.归档状态" echo "select ' ' as \"--2.DB Archive Mode\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_archive_`date +%y%m%d`.txt echo "select archiver from v\$instance;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_archive_`date +%y%m%d`.txt sed -i '33!d' /tmp/tmpora_archive_`date +%y%m%d`.txt archive_string=`cat /tmp/tmpora_archive_\`date +%y%m%d\`.txt` if [ $archive_string = STARTED ];then echo "set linesize 333; col FILE_TYPE for a13; select FILE_TYPE,PERCENT_SPACE_USED as \"占用率(%)\",PERCENT_SPACE_RECLAIMABLE,NUMBER_OF_FILES,CON_ID from v\$flash_recovery_area_usage where FILE_TYPE = 'ARCHIVED LOG'; show parameter log_archive; col NAME for a40; col 已使用空间 for a13; select NAME,SPACE_LIMIT/1024/1024 as \"最大空间(M)\",SPACE_USED/1024/1024 as \"已使用空间(M)\",SPACE_RECLAIMABLE,NUMBER_OF_FILES,CON_ID from v\$recovery_file_dest;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_archive_`date +%y%m%d`.txt for i in `seq 2`; do sed -i '$d' /tmp/tmpora_archive_`date +%y%m%d`.txt ; done fi } ora_mem_info(){ echo "######################## 3.1 内存参数memory" echo "select ' ' as \"--3.1.DB memory\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_mem_`date +%y%m%d`.txt echo "set line 2500; show parameter memory;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_mem_`date +%y%m%d`.txt } ora_sga_info(){ echo "######################## 3.2 内存参数sga" echo "select ' ' as \"--3.2.DB sga\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_sga_`date +%y%m%d`.txt echo "set line 2500; show parameter sga;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_sga_`date +%y%m%d`.txt } ora_pga_info(){ echo "######################## 3.3 内存参数pga" echo "select ' ' as \"--3.3.DB pga\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_pga_`date +%y%m%d`.txt echo "set line 2500; show parameter pga;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_pga_`date +%y%m%d`.txt } ora_dbfile_info(){ echo "######################## 4.表空间是否自动扩展" echo "select ' ' as \"--4.DB dbfile\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_dbfile_`date +%y%m%d`.txt echo "set lines 2500; col TABLESPACE_NAME for a15; col FILE_NAME for a60; select FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE, maxbytes/1024/1024 as max_m,increment_by/1024/1024 as incre_m from dba_data_files;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_dbfile_`date +%y%m%d`.txt } ora_dbfile_useage_info(){ echo "######################## 5.表空间使用率" echo "select ' ' as \"--5.DB dbfile useage\" from dual;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_dbfile_useage_`date +%y%m%d`.txt echo "set line 2500; col 表空间名 for a14; SELECT UPPER(F.TABLESPACE_NAME) \"表空间名\",D.TOT_GROOTTE_MB \"表空间大小(G)\",D.TOT_GROOTTE_MB - F.TOTAL_BYTES \"已使用空间(G)\",TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,2),'990.99') || '%' \"使用比\",F.TOTAL_BYTES \"空闲空间(G)\",F.MAX_BYTES \"最大块(G)\" FROM (SELECT TABLESPACE_NAME,ROUND(SUM(BYTES) / (1024 * 1024*1024), 2) TOTAL_BYTES,ROUND(MAX(BYTES) / (1024 * 1024*1024), 2) MAX_BYTES FROM SYS.DBA_FREE_SPACE where tablespace_name<> 'USERS' GROUP BY TABLESPACE_NAME) F,(SELECT DD.TABLESPACE_NAME,ROUND(SUM(DD.BYTES) / (1024 * 1024*1024), 2) TOT_GROOTTE_MB FROM SYS.DBA_DATA_FILES DD where dd.tablespace_name<> 'USERS' GROUP BY DD.TABLESPACE_NAME) D WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME ORDER BY 1;" >ora_sql.sql sqlplus $sqlstr >/tmp/tmpora_dbfile_useage_`date +%y%m%d`.txt } create_html(){ rm -rf $file_output touch $file_output create_html_css >> $file_output create_html_head "0 Network Info Summary" >> $file_output create_table_head1 >> $file_output get_netinfo while read line do create_tr2 "$line" done < /tmp/tmpnet_h1_`date +%y%m%d`.txt while read line do create_tr1 "$line" done < /tmp/tmpnet1_`date +%y%m%d`.txt create_table_end >> $file_output create_html_head "1 Version of Database" >> $file_output create_table_head1 >> $file_output ora_base_info sed -i '27,33!d' /tmp/tmpora_base_`date +%y%m%d`.txt sed -i '2,3d' /tmp/tmpora_base_`date +%y%m%d`.txt create_tr3 "/tmp/tmpora_base_`date +%y%m%d`.txt" create_table_end >> $file_output create_html_head "2 Status of archive_log" >> $file_output create_table_head1 >> $file_output ora_archive_info sed -i '2,11d' /tmp/tmpora_archive_`date +%y%m%d`.txt create_tr3 "/tmp/tmpora_archive_`date +%y%m%d`.txt" create_table_end >> $file_output create_html_head "3.1 memory Config of Database" >> $file_output create_table_head1 >> $file_output ora_mem_info sed -i '1,30d' /tmp/tmpora_mem_`date +%y%m%d`.txt for i in `seq 2`; do sed -i '$d' /tmp/tmpora_mem_`date +%y%m%d`.txt ; done create_tr3 "/tmp/tmpora_mem_`date +%y%m%d`.txt" create_table_end >> $file_output create_html_head "3.2 sga Config of Database" >> $file_output create_table_head1 >> $file_output ora_sga_info sed -i '1,30d' /tmp/tmpora_sga_`date +%y%m%d`.txt for i in `seq 2`; 
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：Oracle 错误日志表及异常处理包详解 附源码_oracle_
                                                                
下一篇：云服务器centos8安装oracle19c的详细教程_oracle_