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
EMCA Fails with Error ORA-12541
EMCA Fails with Error ORA-12541 APPLIES TO Operating System - Red Hat Enterprise Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4 Oracle Grid Infrastructure - Version 11.2.0.4 SYMPTOMS Enterprise Manager Configuration Assistant (EMCA) fails with error: [oracle@sj-node2 ~]$ emca -repos dropSTARTED EMCA at Aug 10, 2023 2:52:19 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following informa...
The Listener Supports no Services After Changed IP or Port
The Listener Supports no Services After Changed IP or Port APPLIES TO Operating System - Red Hat Enterprise Linux Server 7.9 / Linux 7 Oracle Database - Enterprise Edition - version 11.2.0.4 / 11g Oracle Grid Infrastructure - version 11.2.0.4 / 11g SYMPTOMS Change listener to uses non-local IP address or non-default port number, and instance cannot register services automatically. [oracle@sj-node2 admin]$ cat listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/...
Package compat-libstdc++-33-3.2.3 Missing on RHEL 7
Package compat-libstdc++-33-3.2.3 Missing on RHEL 7 APPLIES TO Operating System - Red Hat Enterprise Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4 Oracle Grid Infrastructure - Version 11.2.0.4 SYMPTOMS Package: compat-libstdc++-33-3.2.3 (x86_64) - This is a prerequisite condition to test whether the package "compat-libstdc++-33-3.2.3 (x86_64)" is available on the system. CAUSE No install the package compat-libstdc++-33-3.2.3 (x86_64). SOLUTION curl -o /soft/c...
The runInstaller Start Failed Due to Could not Execute xdpyinfo
The runInstaller Start Failed Due to Could not Execute xdpyinfo APPLIES TO Operating System - Oracle Linux Server 7.9 / Linux 7 Oracle Database - Enterprise Edition - Version 11.2.0.4 / 11g Oracle Grid Infrastructure - Version 11.2.0.4 / 11g SYMPTOMS ~]$ /soft/grid/runInstallerStarting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 43392 MB PassedChecking swap space: must be greater than 150 MB. Actual 8063 MB PassedChecking monitor: must ...
Installing Oracle Database 11.2.0.4 on RHEL 7.9
Installing Oracle Database 11.2.0.4 on RHEL 7.9 Operating System: Red Hat Enterprise Linux Server release 7.9 (Maipo) Oracle Database: p13390677_112040_Linux-x86-64_{1..2}of7.zip Oracle Oracle Single Instance Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel \libxcb libib...
Installing Pacemaker Corosync Cluster on RHEL 7
Installing Pacemaker Corosync Cluster on RHEL 7 RHEL 7.9 pacemaker-1.1.21-4.el7.x86_64 corosync-2.4.5-4.el7.x86_64 Object Value Hostname nood1, node2 Public NICs bond0, Mode 1, eno1, eno2 Node Public IP 192.168.3.249, 192.168.3.250 Private NICs bond1, Mode 1, eno3, eno4 Node Private IP 100.100.100.249, 100.100.100.250 Cluster Name my_cluster BusType iSCSI, 192.168.3.112 Shared Disk 1 5GB Shared Disk 2 10GB Setting Media ISO YUM Repository ・ Configuring Yum Reposi...
RMAN Configuration
RMAN Configuration Showing the Default RMAN Configuration 11.2.0.4 RMAN> SHOW ALL;using target database control file instead of recovery catalogRMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCON...
ORA-03113, ORA-19815
ORA-03113, ORA-19815 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 SYMPTOMS 数据库打开时，报 ORA-03113 错误： SQL> startupORACLE instance started.Total System Global Area 521936896 bytesFixed Size 2254824 bytesVariable Size 373295128 bytesDatabase Buffers 138412032 bytesRedo Buffers 7974912 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 10579Session ID: 63 Serial number: 5 CAUSE 查看数据库 alert 日志，提示...
