Oracle Database ADRCI
Oracle Database ADRCI helpshow problemshow problem -p "<id>" Reference ・ ADRCI: ADR Command Interpreter
Generate AWR Report
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
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 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
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
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
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
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
Configuring SSH Port Forwarding
Configuring SSH Port Forwarding 本地静态端口转发(SSH 正向代理) 远程静态端口转发 (SSH 正向代理) 远程静态端口转发(SSH 反向代理) 动态端口转发(SSH socks5 代理) 例子 [root@hlj-jumpserver ~]# cat /usr/lib/systemd/system/ssh-agent.service[Unit]Description=ssh agentAfter=network.target[Service]Type=forkingExecStart=/bin/sh -c '/usr/bin/ssh -fNCR 43215:10.44.1.2:80 -p 22222 gzy@101.163.9.100&& /usr/bin/ssh -fNCR 33333:10.44.1.1:22 -p 22222 gzy@101.163.9.100 && /usr/bin/ssh -fNCR 33334:10.44.1.2:22 -p 22222 gzy@101.1...
Configuring Oracle Enterprise Manager 11g
Configuring Oracle Enterprise Manager 11g Oracle Database - Enterprise Edition - version 11.2.0.4.0 export ORACLE_HOSTNAME=ora_vipemctl status dbconsole-- deconfigemctl stop dbconsoleemca -deconfig dbcontrol dbemca -repos drop-- configemca -repos createemca -config dbcontrol db-- reconfig portsemca -reconfig ports -DBCONTROL_HTTP_PORT 1158-- unsecure httpemctl unsecure dbconsoleemctl start dbconsole














