Dream of Mirror Ruins

Find and Remove Trash Files #!/bin/bashPATH=$PATH:.:/etc; export PATHALERT_TRACE=/u01/app/oracle/diag/rdbms/orcl/orcl/trace; export ALERT_TRACELI_TRACE=/u01/app/logs/diag/tnslsnr/pacemaker-1/listener_orcl/trace; export LI_TRACEORACLE_SID=orcl; export ORACLE_SID[[ -d "/u01/app/logs" ]] || echo "No trace directory!!!" && exit 0echo "Deleting: $ORACLE_SID - trace log files"# Copy current trace filecp -p $ALERT_TRACE/alert_$ORACLE_SID.log $ALERT_TRACE/alert_$ORACLE_SID."$(date +%y%m%d)"c...

Oracle Database Inspection Commands OS hostnameip acat /etc/os-releasecat /etc/hostsdf -hTfree -ggrep Huge /proc/meminfocat /proc/cmdlinecat /proc/net/bonding/bond0cat /proc/net/bonding/bond1vmstat 2 5iostat 1 2top -n 1lsnrctl status CRS ocrcheckocrconfig -showbackupcrsctl stat res -tasmcmd lsdg DB set lines 200 pages 100select name,open_mode,log_mode from v$database;select * from v$version;select * from nls_database_parameters;select 'DB Size/Used/Rate',trunc(sum(a.bytes)/1024/1024/1024,...

Oracle Database ADRCI helpshow problemshow problem -p "<id>" Reference ・ ADRCI: ADR Command Interpreter

Generate AWR Report 生成单实例 AWR 报告: @$ORACLE_HOME/rdbms/admin/awrrpt.sql 生成 Oracle RAC AWR 报告: @$ORACLE_HOME/rdbms/admin/awrgrpt.sql 生成 RAC 环境中特定数据库实例的 AWR 报告: @$ORACLE_HOME/rdbms/admin/awrrpti.sql 生成 Oracle RAC 环境中多个数据库实例的 AWR 报告的方法: @$ORACLE_HOME/rdbms/admin/awrgrpti.sql 生成 SQL 语句的 AWR 报告: @$ORACLE_HOME/rdbms/admin/awrsqrpt.sql 生成特定数据库实例上某个 SQL 语句的 AWR 报告: @$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

How to Extend LVM Logical Volume on Linux Option, create LVM partition. echo -e "n\np\n1\n\n\nt\n8e\nw" | fdisk /dev/sdb Create PV. pvcreate /dev/sdb1 Extend VG. vgextend VolGroup /dev/sdb1 Extend LV. lvextend -l +100%FREE /dev/mapper/VolGroup-LogVollvextend -L +100G /dev/mapper/VolGroup-LogVolleextend /dev/mapper/VolGroup-LogVol /dev/sdb1 Grow the filesystem. # For xfs, the device must be mountedxfs_growfs /mounted-point# For ext3, ext4resize2fs /dev/mapper/VolGroup-LogVol

IBM System x3630 M3 Service Manual IBM x3630 M3/M4 Hard Drive LEDs Status Hard disk drive activity LED (front panel): When this LED is flashing, it indicates that the drive is in use. This function is reserved for simple-swap models. For existing models, please see the hot-swap hard disk drive activity and status LEDs (green and amber) that pass from the backplane as the indicators for any activity or warning. Hard disk drive status LED (amber): This amber LED is used on hot-swap SAS/SAT...

How to Safely Reboot a Frozen Linux System Switch to a TTY If your graphical session is frozen you can often switch to a TTY, assuming default settings this can be done with Ctrl+Alt+F1 to F6. System Request (SysRq) sequence Sometimes the system is so frozen, that the TTYs cannot be activated. Then you can use a System Request (SysRq) sequence. Often SysRq is invoked by the Alt + SysRq/PrtSc keys, sometimes the Fn key is involved too (in laptops), While pressing these keys you press the fo...

Configuring DHCP Server on Fedora Install and Configure DHCP. On this example, it shows only for IPv4 configuration. dnf -y install dhcp-servercat > /etc/dhcp/dhcpd.conf << EOF## DHCP Server Configuration file.# see /usr/share/doc/dhcp-server/dhcpd.conf.example# see dhcpd.conf(5) man page## Added by Jove# default lease timedefault-lease-time 600;# max lease timemax-lease-time 7200;# specify network address and subnetmasksubnet 192.168.10.0 netmask 255.255.255.0 { # specify th...

Package Could not Accessed by User '_apt' Due to Permission Denied APPLIES TO Operating System - Ubuntu 22.04.3 LTS SYMPTOMS Package could not accessed by user '_apt' due to permission denied. jove@ubuntu:~/Downloads]$ sudo apt install ./baidunetdisk_4.17.7_amd64.debReading package lists... DoneBuilding dependency tree... DoneReading state information... DoneNote, selecting 'baidunetdisk' instead of './baidunetdisk_4.17.7_amd64.deb'The following packages were automatically installed and ...

Setting Docker Register Mirrors sudo mkdir -p /etc/dockersudo tee /etc/docker/daemon.json <<-'EOF'{ "registry-mirrors": [ "https://docker.m.daocloud.io", "https://dockerproxy.com", "https://docker.mirrors.ustc.edu.cn", "https://docker.nju.edu.cn" ]}EOFsudo systemctl restart docker