AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

数据库运维相关脚本(持续交作业)

2022-03-08 138
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 数据库运维相关脚本(持续交作业)

数据库运维相关脚本

1、采用shell脚本调用SQLPLUS执行SQL语句

#!/bin/bash

TAB=emp

sqlplus -s scott/tiger <<EOF | awk 'NR != 1 && $2 ~ /S.*T/{print $2,$6}'

set head off

set feed off

select * from $TAB;

select * from dept;

exit;

EOF


2、批量禁用/启用触发器

SELECT 'alter trigger ' || TRIGGER_NAME || ' enable;' FROM USER_TRIGGERS;

SELECT 'alter trigger ' || TRIGGER_NAME || ' disable;' FROM USER_TRIGGERS;


3、查询索引占碎片比例

selectname,del_lf_rows,lf_rows,

round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)||'%' frag_pct

from index_stats

where round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)>30


4、根据 sid 查 spid 或根据 spid 查 sid

selects.sid,s.serial#,s.LOGON_TIME,s.machine,p.spid,p.terminal

from v$session s,v$process p

where  s.paddr=p.addr and s.sid=SS or p.spid=BB

根据 sid 查sql 语句

selectusername,sql_text,machine,osuser from v$session a,v$sqltext_with_newlinesb  

where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value

and a.sid=&sid order by piece


5、查询会话和进程消耗的平均内存大小

selectround(sum(pga_used_mem)/1024/1024,0) total_used_M,

round(sum(pga_used_mem)/count(1)/1024/1024,0) avg_used_M,

round(sum(pga_alloc_mem)/1024/1024,0) total_alloc_M,

round(sum(pga_alloc_mem)/count(1)/1024/1024,0) avg_alloc_M

from v$process


6、高CPU占用查询


select*from (select CPU_TIME/1000000,username,PARSING_USER_ID,sql_id,ELAPSED_TIME/1000000,sql_text    

from v$sql,dba_users

where user_id=PARSING_USER_ID

order by CPU_TIME/1000000 desc)where rownum <=3


7、一个巡检脚本

#!/bin/bashmkdir-p /home/oracle/script 
read -p"Enter Instance Name: " Name
logfile=/home/oracle/script/db_log.log
echo" ###### 2.1 Section #######" > $logfileexportORACLE_SID=$Name$ORACLE_HOME/bin/sqlplus -S / as sysdba >>$logfile <<END
set heading off
set feedback off;
set pagesize 0;
set linesize 120;
set trimout on;
set trimspool on;
set verify off;
select 'database_name: '||value from v\$parameter where name='db_name';
select 'instance_name: '||value from gv\$parameter where name='instance_name';
select 'RDBMS Relase: '||version  from product_component_version where product like 'Oracle Database%';
select 'All Datafiles Total Size: '||round(sum(total_size)/1024/1024/1024,2)||'GB' from (
select sum(bytes) total_size from dba_data_files
union all
select sum(bytes) total_size from dba_temp_files
);
select  'SGA_MAX_SIZE: '||value from v\$parameter where name='sga_max_size';
select 'SGA_TARGET: '||value from v\$parameter where name='sga_target';
select 'BLOCK_SIZE: '||value from v\$parameter where name='db_block_size';
select 'TABLESPACE TOTAL: '||count(*) from dba_tablespaces;
select 'DataFiles: '||count(*) from dba_data_files;
select 'Controlfiles: '||count(*) from v\$controlfile;
select 'Every RedoLog Size: '||bytes/1024/1024||'MB' from v\$log where rownum=1;
select 'Every RedoLog Group has Members: '||members from v\$log where rownum=1;
select 'Archive Mode: '||log_mode from v\$database;
select 'Max Process(History): '||max_utilization from v\$resource_limit where resource_name='processes';
exit;
END
echo"######## 5 Section ########" >>$logfile#echo -n "Enter All HostNames In RAC: "#read HostNamegridpath=`ps -ef|grep crsd.bin|grep -v grep|awk '{print $8}'`for i in`${gridpath%/*}/olsnodes`doecho$i >>$logfilessh$i df -h >>$logfileecho"" >>$logfileecho$i >>$logfilessh$icat /etc/sysctl.conf|grep -v ^#|grep -v grep|sort|uniq>>$logfileecho$i >>$logfileecho"HugePage Set " >>$logfilessh$igrep-i hugepage /proc/meminfo >>$logfileecho"#### 3.1 ######" >>$logfileecho$i >>$logfileecho"Local Disk Size" >>$logfilessh$i df -h|sed '1d'|awk 'sub("G","",$2){total+=$2}END{print total"G"}' >>$logfileecho$i >>$logfileecho"Network Card " >>$logfilessh$i ethtool eth0|grep Speed >>$logfileecho$i >>$logfileecho"Phyical Memory Total" >>$logfilessh$igrep MemTotal /proc/meminfo >>$logfileecho"" >>$logfileecho" Physical CPUS" >>$logfilessh$icat /proc/cpuinfo |grep "physical id"|uniq|wc -l >>$logfileecho"#### 3.1 over #####" >>$logfileecho$i >>$logfileecho"Vmstat stat " >>$logfilessh$i vmstat 210 >>$logfileecho"" >>$logfileecho$i >>$logfileecho"ifconfig stat" >>$logfilessh$i /sbin/ifconfig >>$logfiledoneecho"" >>$logfileecho"######### 6.2 Section #########" >>$logfileecho"Oracle user vairal" >>$logfilecat /home/oracle/.bash_profile >>$logfileecho"" >>$logfileecho"######### 6.3 Section #########" >>$logfileecho"Oracle Patch " >>$logfile$ORACLE_HOME/OPatch/opatch lspatches >>$logfileecho"######### 6.4 Section #########" >>$logfileecho${gridpath%/*} >>$logfilecd${gridpath%/*} >>$logfileecho"olsnodes stats" >>$logfile./olsnodes >>$logfileecho"ocrcheck stats" >>$logfile./ocrcheck >>$logfileecho"ocrconfig -showbackup stats" >>$logfile./ocrconfig -showbackup >>$logfileecho"crsctl check crs stats" >>$logfile./crsctl check crs >>$logfileecho"crsctl stat res -t " >>$logfile./crsctl stat res -t >>$logfileecho"crsctl stat res -t -init ">>$logfile./crsctl stat res -t-init >>$logfileecho"crsctl query css votedisk " >>$logfile./crsctl query css votedisk >>$logfileecho"oifcfg getif ">>$logfile./oifcfg getif >>$logfileecho"######## 6.7 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120set pagesize 0col parameter for a40
col value for a10
prompt "Oracle install Options"select * from v\$option;
exit;
EOF
echo"######### 6.8 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col name for a40
col value for a80
select inst_id,name,value from gv\$parameter where isdefault='FALSE';
prompt "######## 6.9 Section #######"select value$ from props\$ where name='NLS_CHARACTERSET';
exit;
EOF
echo"######### 6.13 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a60
select name,status from v\$controlfile;
exit;
EOF
echo"########## 6.14 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120select group#,thread#,sequence#,bytes/1024/1024,members,archived,status from v\$log;prompt "####### 6.15 #### redo switch frequency"set linesize 200col Day for a5
col H00 FOR '999'COL H01 FOR '999'COL H02 FOR '999'col H03 FOR '999'COL H04 FOR '999'COL H05 FOR '999'col H06 FOR '999'COL H07 FOR '999'COL H08 FOR '999'COL H09 FOR '999'COL H10 FOR '999'col H11 FOR '999'COL H12 FOR '999'COL H13 FOR '999'col H14 FOR '999'COL H15 FOR '999'COL H16 FOR '999'COL H17 FOR '999'COL H18 FOR '999'col H19 FOR '999'COL H20 FOR '999'COL H21 FOR '999'col H22 FOR '999'COL H23 FOR '999'SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'01',1,0)) H01, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'02',1,0)) H02,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'03',1,0)) H03,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'04',1,0)) H04,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'05',1,0)) H05,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'06',1,0)) H06,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'07',1,0)) H07,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'08',1,0)) H08,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'09',1,0)) H09,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'10',1,0)) H10,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'11',1,0)) H11, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'12',1,0)) H12,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'13',1,0)) H13, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'14',1,0)) H14,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'15',1,0)) H15, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'16',1,0)) H16, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'17',1,0)) H17, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'18',1,0)) H18, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'19',1,0)) H19, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'20',1,0)) H20, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'21',1,0)) H21,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'22',1,0)) H22 , 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'23',1,0)) H23, 
      COUNT(*) TOTAL 
FROM v\$log_history  a
  where first_time>=to_char(sysdate-11)
GROUP BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) 
ORDER BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) DESC;
exit;
EOF
echo"########### 6.16 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a40
col value for a40
show parameter db_recovery;
select inst_id,name,value from gv\$parameter where name like '%archive%' order by 1;
exit;
EOF
echo"########### 6.17 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 150col tablespace_name for a20
col file_name for a60
set pagesize 0select tablespace_name,file_name,bytes/1024/1024,status,autoextensible from dba_data_files;
exit;
EOF
echo"########## 6.18 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200col tablespace_name for a20
set pagesize 0select tablespace_name,block_size,initial_extent,next_extent,status,contents,force_logging,extent_management,allocation_type,SEGMENT_SPACE_MANAGEMENT,BIGFILE,COMPRESS_FOR from dba_tablespaces;
prompt "####### tablespace_used % #######"SELECT total.tablespace_name,
      Round(total.MB, 2)          AS Total_MB,
      Round(total.MB - free.MB, 2) AS Used_MB,
      Round(( 1- free.MB / total.MB ) * 100, 2)
      || '%'                      AS Used_Pct
FROM  (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_free_space
        GROUP  BY tablespace_name) free,
      (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_data_files
        GROUP  BY tablespace_name) total
WHERE  free.tablespace_name = total.tablespace_name;
prompt "######6.19 Temporary Tablespace Usage % ######"SET PAGESIZE 60SET LINESIZE 100col tablespace_name for a20 
SELECT 
  A.tablespace_name tablespace, 
  D.mb_total,
  SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,
  D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free
FROM 
  v\$sort_segment A,
(
SELECT 
  B.name, 
  C.block_size, 
  SUM (C.bytes) / 1024 / 1024 mb_total
FROM 
  v\$tablespace B, 
  v\$tempfile C
WHERE 
  B.ts#= C.ts#GROUP BY 
  B.name, 
  C.block_size
) D
WHERE 
  A.tablespace_name = D.name
GROUP by 
  A.tablespace_name, 
  D.mb_total
/
prompt "######### 6.20 Section ###########"col segment_name for a30
set linesize 100set pagesize 0set heading on
select status,sum(bytes)/1024/1024 from dba_undo_extents group by status;
exit;
EOF
echo"######### 7 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileprompt "Use default password "col username for a20
set linesize 100select username from dba_users_with_defpwd where username in ('SYS','SYSTEM');
prompt "granted sysdba role "select username,sysdba from v\$pwfile_users;
PROMPT "GRANTED DBA ROLE "col grantee for a20
col granted_role for a20
select grantee,granted_role from dba_role_privs where granted_role='DBA';
prompt "password management "set linesize 200col profile for a20
col RESOURCE_NAME for a30
col limit for a15
select profile,resource_name,limit from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';
exit;
EOF
echo"######### 9.6 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col resource_name for a30
col INITIAL_ALLOCATION for a20
col LIMIT_VALUE for a20
select * from v\$resource_limit;
exit;
EOF
echo"######## 10.1 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfilecol segment_name for a30
set linesize 150col owner for a20
set pagesize 0select owner,segment_name,sum(bytes)/1024 from dba_segments 
where (segment_name like '%TMP%'  or segment_name like '%HIS%'  or segment_name like '%BAK%'  or segment_name like '%TEST%'  or segment_name like '%201%'  or segment_name like 'BIN%')
  and owner not in ('SYS','SYSTEM','SYSMAN','APEX_030200','MGMT_VIEW','DBSNMP')
  and segment_type like 'TABLE%'group by owner,segment_name;
prompt "######## 10.2 ###### Redundant index"column redundant_index format a45
column sufficient_index format a45
select
  o1.name||'.'||n1.name  redundant_index,
  o2.name||'.'||n2.name  sufficient_index
from
  sys.icol\$  ic1,
  sys.icol\$  ic2,
  sys.ind\$  i1,
  sys.obj\$  n1,
  sys.obj\$  n2,
  sys.user\$  o1,
  sys.user\$  o2
where
  ic1.pos# = 1 and  ic2.bo# = ic1.bo# and  ic2.obj# != ic1.obj# and  ic2.pos# = 1 and  ic2.intcol# = ic1.intcol# and  i1.obj# = ic1.obj# and  bitand(i1.property, 1) =0 and
  ( select
      max(pos#) * (max(pos#) + 1) / 2    from
      sys.icol\$
    where
      obj# = ic1.obj#  ) =  ( select
      sum(xc1.pos#)    from
      sys.icol\$ xc1,
      sys.icol\$ xc2
    where
      xc1.obj# = ic1.obj# and      xc2.obj# = ic2.obj# and      xc1.pos# = xc2.pos# and      xc1.intcol# = xc2.intcol#  ) and
  n1.obj# = ic1.obj# and  n2.obj# = ic2.obj# and  o1.user# = n1.owner# and  o2.user# = n2.owner#  and o1.name not in ('SYS','SYSTEM','APEX_030200','SYSMAN','MDSYS','ORDDATA','XDB')
/
PROMPT "####### 10.3 ####### Invalid object "col object_name for a30
set linesize 120col owner for a15
col object_type for a30
set pagesize 0select owner,object_name ,object_type from dba_objects where status='INVALID';
prompt "######### 10.4 ########UNUSABLE INDEX"select owner,index_name from dba_indexes where status='UNUSABLE';
prompt "######### 10.5 ###########Order by sql "set pagesize 0select sql_id from v\$sqlarea where sql_text like '%order by %';
prompt "######### 10.6 ###########No bound variables are used for SQL"set numw 20select FORCE_MATCHING_SIGNATURE, count(1)
  from v\$sql
where FORCE_MATCHING_SIGNATURE > 0  and FORCE_MATCHING_SIGNATURE != EXACT_MATCHING_SIGNATURE
group by FORCE_MATCHING_SIGNATURE
having count(1) > 100order by 2;
prompt "####### 10.7 ####### In SYSTEM/SYSAUX tablespace "col segment_name for a30
set linesize 200col owner for a20
select owner,segment_name,segment_type,tablespace_name from dba_segments
where tablespace_name in ('SYSTEM','SYSAUX')
and owner not in ('SYS','SYSTEM','OUTLN','APEX_030200','SYSMAN','MDSYS','OLAPSYS','ORDDATA','ORDSYS','EXFSYS','XDB','CTXSYS','EXFSYS','WMSYS','DBSNMP');
prompt "######## 10.7 #####Table Fragment"col table_name for a30
select table_name,round(BLOCKS*8192/1024/1024,2) total_size_MB,
round(num_rows*AVG_ROW_LEN/1024/1024,2) used_size_MB,
round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)  wasted_size_MB,
round(round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)/
round(BLOCKS*8192/1024/1024,2),2)*100||'%' wasted_percent
from dba_tables where owner not in ('SYS','SYSTEM','OUTLN')
and round(BLOCKS*8192/1024/1024,2) <>0
and round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)>100
order by 2;
PROMPT "##### 10.9 ###### TABLESPACE FRAGMENT "set linesize 150        column tablespace_name format a20 heading 'Tablespace'    column sumb format 999,999,999
    column extents format 9999    column bytes format 999,999,999,999
    column largest format 999,999,999,999
    column Tot_Size format 999,999 Heading 'Total| Size(Mb)'    column Tot_Free format 999,999,999 heading 'Total Free(MB)'    column Pct_Free format 999.99 heading '% Free'    column Chunks_Free format 9999 heading 'No Of Ext.'    column Max_Free format 999,999,999 heading 'Max Free(Kb)'setecho off
    PROMPT  FREE SPACE AVAILABLE IN TABLESPACES
    select a.tablespace_name,sum(a.tots/1048576) Tot_Size,
    sum(a.sumb/1048576) Tot_Free,
    sum(a.sumb)*100/sum(a.tots) Pct_Free,
    sum(a.largest/1024) Max_Free,sum(a.chunks) Chunks_Free
    from
    (
    select tablespace_name,0 tots,sum(bytes) sumb,
    max(bytes) largest,count(*) chunks
    from dba_free_space a
    group by tablespace_name
    union
    select tablespace_name,sum(bytes) tots,0,0,0 from
      dba_data_files
    group by tablespace_name) a
    group by a.tablespace_name
order by pct_free;
prompt "######### 10.10 parallel object #######"set pagesize 0col owner for a15
col index_name for a30
col table_name for a30
prompt "parallel tables"select owner,table_name,degree  from dba_indexes where ltrim(degree)>'1' order by 1;
prompt "parallel index"select owner,index_name,degree from dba_indexes where ltrim(degree)>'1' order by 1;
exit;
EOF
文章标签：
Perl
Shell
SQL
索引
运维
数据库
关键词：
运维脚本
运维数据库
数据库脚本
数据库运维
运维作业
1285620146464872
目录
相关文章
技能实验室
|
11天前
|
关系型数据库 MySQL 数据库连接
python脚本：连接数据库，检查直播流是否可用
【10月更文挑战第13天】本脚本使用 `mysql-connector-python` 连接MySQL数据库，检查 `live_streams` 表中每个直播流URL的可用性。通过 `requests` 库发送HTTP请求，输出每个URL的检查结果。需安装 `mysql-connector-python` 和 `requests` 库，并配置数据库连接参数。
技能实验室
111 68
你都不懂
|
2天前
|
缓存 运维 NoSQL
python常见运维脚本_Python运维常用脚本
python常见运维脚本_Python运维常用脚本
你都不懂
9 3
肥猪肥猪-17824
|
3天前
|
运维 监控 应用服务中间件
自动化运维：如何利用Python脚本提升工作效率
【10月更文挑战第30天】在快节奏的IT行业中，自动化运维已成为提升工作效率和减少人为错误的关键技术。本文将介绍如何使用Python编写简单的自动化脚本，以实现日常运维任务的自动化。通过实际案例，我们将展示如何用Python脚本简化服务器管理、批量配置更新以及监控系统性能等任务。文章不仅提供代码示例，还将深入探讨自动化运维背后的理念，帮助读者理解并应用这一技术来优化他们的工作流程。
肥猪肥猪-17824
13 3
肥猪肥猪-17824
|
4天前
|
运维 监控 Linux
自动化运维：如何利用Python脚本优化日常任务##
【10月更文挑战第29天】在现代IT运维中，自动化已成为提升效率、减少人为错误的关键技术。本文将介绍如何通过Python脚本来简化和自动化日常的运维任务，从而让运维人员能够专注于更高层次的工作。从备份管理到系统监控，再到日志分析，我们将一步步展示如何编写实用的Python脚本来处理这些任务。 ##
肥猪肥猪-17824
14 1
技术混子
|
8天前
|
运维 Prometheus 监控
自动化运维之路：从脚本到DevOps
【10月更文挑战第25天】在数字化时代的浪潮中，运维不再是简单的服务器管理，而是成为了企业竞争力的核心。本文将带你走进自动化运维的世界，探索如何通过技术手段提升效率和稳定性，以及实现快速响应市场的能力。我们将一起学习如何从基础的脚本编写进化到全面的DevOps实践，包括工具的选择、流程的优化以及文化的建设。无论你是运维新手还是资深专家，这篇文章都将为你提供有价值的见解和实用的技巧。
技术混子
14 3
mzlogin
|
12天前
|
运维 关系型数据库 MySQL
运维｜MySQL 数据库被黑，心力交瘁
前一阵有一个测试用的 MySQL 数据库被黑了，删库勒索的那种，这里记录一下事情经过，给自己也敲个警钟。
mzlogin
28 2
nanshaws
|
1月前
|
SQL 关系型数据库 MySQL
数据库是mysql，使用DBeaver的SQL编辑器执行sql脚本文件时，报错：No active connection 。
遇到这种问题，多半是因为没有与数据库关联
nanshaws
84 1
数据库是mysql，使用DBeaver的SQL编辑器执行sql脚本文件时，报错：No active connection 。
天下无贼001
|
26天前
|
人工智能 运维 Devops
自动化运维之路：从脚本到DevOps的转变
【10月更文挑战第7天】在这篇文章中，我们将一起探索自动化运维的演变历程，从最初的简单脚本到现代的DevOps实践。我们将深入理解自动化如何改变了运维工作的本质，并讨论实现这一转变的关键技术和策略。文章将不包含代码示例，而是聚焦于理念、工具和方法论的介绍，旨在为读者提供一个全面的自动化运维框架视图。
天下无贼001
44 6
Dylaniou
|
24天前
|
运维 Java Linux
【运维基础知识】Linux服务器下手写启停Java程序脚本start.sh stop.sh及详细说明
### 启动Java程序脚本 `start.sh` 此脚本用于启动一个Java程序，设置JVM字符集为GBK，最大堆内存为3000M，并将程序的日志输出到`output.log`文件中，同时在后台运行。 ### 停止Java程序脚本 `stop.sh` 此脚本用于停止指定名称的服务（如`QuoteServer`），通过查找并终止该服务的Java进程，输出操作结果以确认是否成功。
Dylaniou
32 1
肥猪肥猪-17824
|
25天前
|
人工智能 运维 监控
自动化运维：从脚本到工具的演变之路
【10月更文挑战第8天】在数字化时代的浪潮中，运维不再是简单的硬件维护，它已经演变成一场关于效率、稳定性和创新的技术革命。本文将带您领略自动化运维的魅力，从最初的脚本编写到现代复杂的自动化工具，我们将一探究竟，看看这些工具如何帮助运维人员简化日常任务，提升工作效率，并最终推动业务发展。
肥猪肥猪-17824
57 2

热门文章

最新文章

  • 1
    云MSP服务案例|云上Oracle RAC部署运维及实践
  • 2
    IT运维服务商如何将WannaCry拒之门外？恒远志成称安全需防微杜渐
  • 3
    半自动化运维之动态添加数据文件（一)
  • 4
    网络运维团队如何应对最新的黑客威胁？
  • 5
    系统运维
  • 6
    运维调试记录：Ubuntu启动到字符界面和图形界面
  • 7
    10968134>正文 52.puppet自动化运维工具
  • 8
    mysql中的时间函数---运维常用
  • 9
    网络安全设备-认识运维安全管理与审计系统（堡垒机）
  • 10
    考验与机遇并存，传统运维面对新局面可以这样做
  • 1
    关系型数据库的安装和配置数据库节点
    203
  • 2
    MySQL数据库的约束+进阶版新增与查询-2
    81
  • 3
    AIX数据库启动和停止脚本
    41
  • 4
    数据库性能诊断工具DBdoctor通过阿里云PolarDB产品生态集成认证
    354
  • 5
    修改SAP数据库用户密码的参考
    109
  • 6
    JDBC Java标准库提供的一些api(类+方法) 统一各种数据库提供的api
    47
  • 7
    数据库的约束
    31
  • 8
    SQL主体内容一致,但是对于不同的数据库,对于SQL就可能有一些细节的拓展
    46
  • 9
    关系型数据库选择合适的数据库管理系统
    339
  • 10
    关系型数据库做好备份
    70

    • 相关课程

    更多
  • 数据库的前世今生
  • 数据库核心概念
  • 从传统数据库到云数据库演进
  • 数据库常见问题排查
  • 数据库及SQL/MySQL基础
  • 高校精品课-西安交通大学 -数据库理论与技术

    • 相关电子书

    更多
  • DTCC 2022大会集锦《云原生一站式数据库技术与实践》
  • 阿里云瑶池数据库精要2022版
  • 2022 DTCC-阿里云一站式数据库上云最佳实践

    • 相关实验场景

    更多
  • 数据库实验室挑战任务-高级任务
  • 数据库实验室挑战任务-中级任务
  • 数据库实验室挑战任务-初级任务
  • 阿里云数据库产品实验室
  • MongoDB数据库入门
  • 使用DAS实现数据库自动扩容和回缩
    • 下一篇
    DataWorks智能数据建模全面公测开始啦！