Oracle DBA Daily Checklist
发布时间：2023-02-17 09:22:34 所属栏目：Oracle 来源：互联网
导读：There are several routine checklist and tasks to do in Oracle database by DBA ( Database Administrator ). This checklist and tasks are as follows. All scripts are valid for Single and RAC Database and Exadata. If you dont use RAC,then you
|
There are several routine checklist and tasks to do in Oracle database by DBA ( Database Administrator ). This checklist and tasks are as follows. All scripts are valid for Single and RAC Database and Exadata. If you don’t use RAC,then you can ignore scripts for other Nodes and SCAN Listener etc.. 1- Oracle instance(s) are running or not. Use the following script to check Oracle Instance Processes If RAC is used,then check all Instances of database. Linux: Check SMON or PMON process [oracle@msddbadm01 ~]$ ps -ef | grep smon or [oracle@msddbadm01 ~]$ ps -ef | grep pmon Check all Instance of any database as follows. [oracle@msddbadm01 ~]$ srvctl status database -d <DB_NAME> [oracle@msddbadm01 ~]$ ps -ef | grep smon oracle 140550 1 0 2019 ? 00:01:49 asm_smon_+ASM1 root 147726 1 1 2019 ? 1-04:06:08 /u01/app/12.1.0.2/grid/bin/osysmond.bin oracle 156342 1 0 2019 ? 00:13:57 ora_smon_msd1 oracle 248609 246524 0 12:02 pts/0 00:00:00 grep smon [oracle@msddbadm01 ~]$ [oracle@msddbadm01 ~]$ srvctl status database -d msd Instance msd1 is running on node msddbadm01 Instance msd2 is running on node msddbadm02 [oracle@msddbadm01 ~]$ 2- Local ( and SCAN ) listeners are running or not. Use the following script to check Listeners [oracle@msddbadm01 ~]$ lsnrctl status [oracle@msddbadm01 ~]$ srvctl status scan_listener [oracle@msddbadm01 ~]$ lsnrctl status LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 10-MAR-2020 14:42:31 copyright (c) 1991,2019,Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production Start Date 04-JAN-2020 17:36:35 Uptime 65 days 21 hr. 5 min. 55 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/msdidb01/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.63.34)(PORT=1521))) Services Summary... Service "+APX" has 1 instance(s). Instance "+APX1",status READY,has 1 handler(s) for this service... Service "+ASM" has 1 instance(s). Instance "+ASM1",has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1",has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1",has 1 handler(s) for this service... Service "MSDB" has 1 instance(s). Instance "MSDB1",has 1 handler(s) for this service... Service "MSDBXDB" has 1 instance(s). Instance "MSDB1",has 1 handler(s) for this service... Service "SYS$GGS_ADMIN.OGGQ$RCCB01.MSDB" has 1 instance(s). Instance "MSDB1",has 1 handler(s) for this service... Service "SYS$GGS_ADMIN.OGGQ$RCCB02.MSDB" has 1 instance(s). Instance "MSDB1",has 1 handler(s) for this service... The command completed successfully [oracle@msddbadm01 ~]$ [oracle@msddbadm01 ~]$ [oracle@msddbadm01 ~]$ [oracle@msddbadm01 ~]$ srvctl status scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is running on node msdidb03 SCAN Listener LISTENER_SCAN2 is enabled SCAN listener LISTENER_SCAN2 is running on node msdidb01 SCAN Listener LISTENER_SCAN3 is enabled SCAN listener LISTENER_SCAN3 is running on node msdidb06 [oracle@msddbadm01 ~]$ 3- Check the Server Storage or disk of Oracle database . Check if ASM and File system disks size are enough or not. Use the following script to check Filesystem disks. Check Filesystem disks. [oracle@msddbadm01 ~]$ df -h Unix [oracle@msddbadm01 ~]$ df -g [oracle@msddbadm01 ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbSys1 30G 25G 3.8G 87% / tmpfs 755G 6.5G 749G 1% /dev/shm /dev/sda1 488M 28M 425M 7% /boot /dev/mapper/VGExaDb-LVDbOra1 197G 109G 79G 59% /u01 /dev/sda2 254M 24M 231M 10% /boot/efi /dev/mapper/VGExaDb-openvlv 15G 38M 14G 1% /usr/openv /dev/asm/acfs_vol1-371 9.8T 4.8T 5.0T 49% /goldengate [oracle@msddbadm01 ~]$ Check Oracle ASM diskgroups. Use the following script to check diskgroup size. [grid@msdidb01 ~]$ asmcmd lsdg [grid@msdidb01 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
