df -lh<\/p>\n\n\n\n
hostname<\/p>\n\n\n\n
cat \/etc\/hosts<\/p>\n\n\n\n
ifconfig<\/p>\n\n\n\n
ps -ef | grep tns<\/p>\n\n\n\n
ps -ef | grep asm<\/p>\n\n\n\n
ps -ef | grep ora_<\/p>\n\n\n\n
ls -l \/dev\/sd*<\/p>\n\n\n\n
ls -l \/dev\/asm*<\/p>\n\n\n\n
lsblk<\/p>\n\n\n\n
env | grep ORA<\/p>\n\n\n\n
find \/ -name alert*.log<\/p>\n\n\n\n
ls -lh \/oracle\/grid\/diag\/tnslsnr\/rac2\/listener\/trace\/listener.log<\/p>\n\n\n\n
ls -lh \/oracle\/asm\/log\/diag\/tnslsnr\/rac2\/listener_scan1\/trace\/listener_scan1.log<\/p>\n\n\n\n
ls -lh \/oracle\/asm\/crf\/db\/rac2\/crfclust.bdb<\/p>\n\n\n\n
\u67e5\u770bALERT \u65e5\u5fd7<\/p>\n\n\n\n
[root@rac2 ~]# find \/ -name alert*.log<\/p>\n\n\n\n
\u67e5\u770bCRS\u65e5\u5fd7<\/p>\n\n\n\n
#find \/ -name crsd.log<\/p>\n\n\n\n
export ORACLE_SID=+ASM1<\/p>\n\n\n\n
sqlplus \/ as sysasm<\/p>\n\n\n\n
select * from gv$instance;<\/p>\n\n\n\n
select instance_name,status from v$instance;<\/p>\n\n\n\n
select name,state from v$asm_diskgroup;<\/p>\n\n\n\n
select name,state,type,total_mb ,free_mb from v$asm_diskgroup;<\/p>\n\n\n\n
col PATH for a40<\/p>\n\n\n\n
set pagesize 400<\/p>\n\n\n\n
select name,path from v$asm_disk_stat;<\/p>\n\n\n\n
col PATH for a15;<\/p>\n\n\n\n
col name for a10;<\/p>\n\n\n\n
col STATE for a10;<\/p>\n\n\n\n
set linesize 455<\/p>\n\n\n\n
set pagesize 455<\/p>\n\n\n\n
select group_number,path,state,total_mb,free_mb from v$asm_disk;<\/p>\n\n\n\n
alter diskgroup DATA add disk ‘\/dev\/asm-diskl’ rebalance power 5;<\/p>\n\n\n\n
lsnrctl status LISTENER<\/p>\n\n\n\n
crs_stat -t<\/p>\n\n\n\n
crsctl status res -t<\/p>\n\n\n\n
crsctl check crs<\/p>\n\n\n\n
crsctl check evmd<\/p>\n\n\n\n
crsctl check crsd<\/p>\n\n\n\n
crsctl check crsd<\/p>\n\n\n\n
crsctl check cssd<\/p>\n\n\n\n
crsctl query css votedisk<\/p>\n\n\n\n
srvctl config database<\/p>\n\n\n\n
srvctl status database -d baydb<\/p>\n\n\n\n
srvctl config database -d baydb -a<\/p>\n\n\n\n
ocrcheck<\/p>\n\n\n\n
ocrconfig -showbackup<\/p>\n\n\n\n
srvctl status nodeapps<\/p>\n\n\n\n
lsnrctl status LISTENER<\/p>\n\n\n\n
asmcmd lsdg<\/p>\n\n\n\n
asmcmd lsdsk<\/p>\n\n\n\n
srvctl status asm -a<\/p>\n\n\n\n
srvctl config asm -a<\/p>\n\n\n\n
\/usr\/sbin\/oracleasm querydisk \/dev\/sd*<\/p>\n\n\n\n
\u67e5\u770b\u78c1\u76d8<\/p>\n\n\n\n
[root@rac2 bai]# oracleasm listdisks<\/p>\n\n\n\n
\u626b\u63cf\u78c1\u76d8<\/p>\n\n\n\n
[root@rac2 bai]# oracleasm scandisks<\/p>\n\n\n\n
\u67e5\u770b\u5bf9\u5e94\u5173\u7cfb<\/p>\n\n\n\n
[root@rac1 dev]# oracleasm querydisk -v -p VOL1<\/p>\n\n\n\n
su – oracle<\/p>\n\n\n\n
env | grep ORA<\/p>\n\n\n\n
crontab -l<\/p>\n\n\n\n
sqlplus \/ as sysdba<\/p>\n\n\n\n
show parameter sga;<\/p>\n\n\n\n
show parameter size;<\/p>\n\n\n\n
show parameter db;<\/p>\n\n\n\n
show parameter session;<\/p>\n\n\n\n
select count(1) from V$SESSION;<\/p>\n\n\n\n
show parameter process;<\/p>\n\n\n\n
select count(1) from V$PROCESS;<\/p>\n\n\n\n
show parameter remote;<\/p>\n\n\n\n
show parameter thread;<\/p>\n\n\n\n
select userenv(‘language’) from dual;<\/p>\n\n\n\n
select status,name from v$controlfile;<\/p>\n\n\n\n
select group#,status,type,member from v$logfile;<\/p>\n\n\n\n
select tablespace_name,status from dba_tablespaces;<\/p>\n\n\n\n
select name,status from v$datafile;<\/p>\n\n\n\n
select segment_name,status from dba_rollback_segs;<\/p>\n\n\n\n
select database_role,switchover_status from v$database;<\/p>\n\n\n\n
col comp_id for a15;<\/p>\n\n\n\n
col version for a15 ;<\/p>\n\n\n\n
col comp_name for a30 ;<\/p>\n\n\n\n
select comp_id,comp_name,status,version from dba_registry ;<\/p>\n\n\n\n
archive log list;<\/p>\n\n\n\n
SELECT A.NAME,A.OPEN_MODE,A.DATABASE_ROLE,A.LOG_MODE FROM v$database A;<\/p>\n\n\n\n
SELECT owner, object_type, status, COUNT(*) count# FROM all_objects GROUP BY owner,object_type, status;<\/p>\n\n\n\n
show parameter cluster<\/p>\n\n\n\n
select * from gv$instance;<\/p>\n\n\n\n
select instance_name,status from v$instance;<\/p>\n\n\n\n
SELECT A.INSTANCE_NAME,A.STATUS,A.VERSION FROM V$INSTANCE A;<\/p>\n\n\n\n
select instance_name,host_name,status from gv$instance;<\/p>\n\n\n\n
SELECT a.NAME,a.DATABASE_ROLE,a.OPEN_MODE,a.LOG_MODE FROM V$DATABASE a;<\/p>\n\n\n\n
\u67e5\u770b\u5b9e\u4f8b\u4e0b\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5:<\/p>\n\n\n\n
set pagesize 999<\/p>\n\n\n\n
set linesize 999<\/p>\n\n\n\n
col file_name for a50;<\/p>\n\n\n\n
col TABLESPACE_NAME for a20;<\/p>\n\n\n\n
SELECT a.tablespace_name “tablespace_name”,<\/p>\n\n\n\n
100-ROUND((NVL(b.bytes_free,0)\/a.bytes_alloc)*100,2) “percent(%)”,<\/p>\n\n\n\n
ROUND(a.bytes_alloc\/1024\/1024,2) “free(M)”,<\/p>\n\n\n\n
ROUND((a.bytes_alloc-NVL(b.bytes_free,0))\/1024\/1024,2) “use(M)”,<\/p>\n\n\n\n
TO_CHAR(SYSDATE,’yyyy-mm-dd hh24:mi:ss’) “time”<\/p>\n\n\n\n
FROM (SELECT f.tablespace_name,<\/p>\n\n\n\n
SUM(f.bytes) bytes_alloc,<\/p>\n\n\n\n
SUM(DECODE(f.autoextensible,’YES’,f.maxbytes,’NO’,f.bytes)) maxbytes<\/p>\n\n\n\n
FROM dba_data_files f GROUP BY tablespace_name) a,<\/p>\n\n\n\n
(SELECT f.tablespace_name, SUM(f.bytes) bytes_free<\/p>\n\n\n\n
FROM dba_free_space f GROUP BY tablespace_name) b<\/p>\n\n\n\n
WHERE a.tablespace_name = b.tablespace_name<\/p>\n\n\n\n
ORDER BY 1 ASC ;<\/p>\n\n\n\n
\u67e5\u770b\u6570\u636e\u6587\u4ef6\u4f7f\u7528\u60c5\u51b5:<\/p>\n\n\n\n
set linesize 400<\/p>\n\n\n\n
set pagesize 350<\/p>\n\n\n\n
col TABLESPACE_NAME for a20;<\/p>\n\n\n\n
col FILE_NAME for a50;<\/p>\n\n\n\n
col size for a15;<\/p>\n\n\n\n
SELECT D.TABLESPACE_NAME,<\/p>\n\n\n\n
D.FILE_NAME,<\/p>\n\n\n\n
D.AUTOEXTENSIBLE,<\/p>\n\n\n\n
D.BYTES \/ 1024 \/ 1024,<\/p>\n\n\n\n
\uff08D.INCREMENT_BY*8)\/1024 INCREMENT_M,<\/p>\n\n\n\n
D.ONLINE_STATUS<\/p>\n\n\n\n
FROM DBA_DATA_FILES D<\/p>\n\n\n\n
ORDER BY D.TABLESPACE_NAME DESC, D.FILE_NAME ASC ;<\/p>\n\n\n\n
\u6570\u636e\u5e93\u7f13\u5b58\u547d\u4e2d\u7387(\u5355\u4f4d\uff1a\u767e\u5206\u6bd4)<\/p>\n\n\n\n
select * from (select round((1 – (sum(decode(name, ‘physical reads’, value, 0)) \/ (sum(decode(name, ‘db clock gets’, value, 0)) + (sum(decode(name, ‘consistent gets’, value, 0)))))) * 100,2) as buffer from v$sysstat), (select round(sum(pinhits) \/ sum(pins) * 100, 2) as library from v$librarycache);<\/p>\n\n\n\n
Latch\u4e89\u7528\u603b\u7b49\u5f85\u6b21\u6570\uff08\u5355\u4f4d\uff1a\u6b21\u6570\uff09 \u65b0\u589e-\u6570\u636e\u53c2\u6570<\/p>\n\n\n\n
select total_waits from v$system_event where event = ‘latch free’<\/p>\n\n\n\n
Latch\u4e89\u7528\u603b\u7b49\u5f85\u65f6\u95f4(\u5355\u4f4d\uff1a\u767e\u5206\u4e4b\u4e00\u79d2) \u65b0\u589e-\u6570\u636e\u53c2\u6570<\/p>\n\n\n\n
select time_waited from v$system_event where event = ‘latch free’<\/p>\n\n\n\n
\u6570\u636e\u5e93\u4e2d\u5bf9\u8c61\u6b63\u5728\u88ab\u9501\u7684\u603b\u6570\uff08\u5355\u4f4d\uff1a\u503c\uff09 \u65b0\u589e-\u6570\u636e\u53c2\u6570<\/p>\n\n\n\n
select count(1) from v$locked_object<\/p>\n\n\n\n
\u5185\u5b58\u4f7f\u7528\u91cf \u65b0\u589e-\u6570\u636e\u53c2\u6570<\/p>\n\n\n\n
SELECT (SELECT ROUND(SUM(VALUE)\/1024\/1024,2) FROM V$SGA)+(SELECT ROUND(VALUE\/1024\/1024,2) FROM V$PGASTAT WHERE NAME=’total PGA allocated’) FROM DUAL;<\/p>\n","protected":false},"excerpt":{"rendered":"
df -lh hostname cat \/etc\/hosts ifconfig ps -ef | grep tns ps -ef | grep asm ps -ef | grep ora_ ls -l \/dev\/sd* ls -l \/dev\/asm* lsblk env | grep ORA find \/ -name alert*.log ls -lh \/oracle\/grid\/diag\/tnslsnr\/rac2\/listener\/trace\/listener.log ls -lh \/oracle\/asm\/log\/diag\/tnslsnr\/rac2\/listener_scan1\/trace\/listener_scan1.log ls -lh \/oracle\/asm\/crf\/db\/rac2\/crfclust.bdb \u67e5\u770bALERT \u65e5\u5fd7 [root@rac2 ~]# find \/ -name alert*.log \u67e5\u770bCRS\u65e5\u5fd7 #find […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=367"}],"version-history":[{"count":1,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/367\/revisions"}],"predecessor-version":[{"id":368,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/367\/revisions\/368"}],"wp:attachment":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}