unix_chkpwd password check failed for user root
unix_chkpwd password check failed for user root SYMPTOMS "/var/log/secure"Mar 4 16:29:15 localhost sshd[5918]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=192.168.3.44 user=rootMar 4 16:29:17 localhost sshd[5918]: Failed password for root from 192.168.3.44 port 62079 ssh2Mar 4 16:29:20 localhost unix_chkpwd[5921]: password check failed for user (root) CAUSE The /etc/ssh/sshd_config file disables root from using the password to log in. PermitR...
Hardware and Software Requirements for Edge Conductor
Hardware and Software Requirements for Edge Conductor Install and Setup Ubuntu 22.04 For temporary network configurations, you can use the ip command which is also found on most other GNU/Linux operating systems. ~]$ sudo ip addr add 10.102.66.200/24 dev enp0s25~]$ ip link set dev enp0s25 up~]$ ip link set dev enp0s25 down~]$ sudo ip route add default via 10.102.66.1~]$ cat >> /etc/resolv.conf << EOFnameserver 8.8.8.8nameserver 8.8.4.4EOF To configure your system to use static a...
Installing Oracle Database 10.2.0.5 RAC on RHEL 5.7
Installing Oracle Database 10.2.0.5 RAC on RHEL 5.7 Operating System: RHEL 5.7 Grid Infrastructure: 10201_clusterware_linux_x86_64.cpio Database Software: 10201_database_linux_x86_64.cpio Patches: p8202632_10205_Linux-x86-64.zip Pre-Installation Preparation and Verification Verifying and Updating the redhat-release File. ~]# rpm -q redhat-release~]# cp /etc/redhat-release /etc/redhat-release.orig~]# cat > /etc/redhat-release << EOFRed Hat Enterprise Linux AS release 3 (Taroon)EOF...
PROC-22 The OCR backend has an invalid format
PROC-22 The OCR backend has an invalid format APPLIES TO Oracle Database - Version 10.2.0.5 RAC SYMPTOMS ~]# tail -n2 /var/log/messagesFeb 21 13:54:18 rac1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.3718.Feb 21 13:54:18 rac1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.3815.~]# cat /tmp/crsctl.3815OCR initialization failed with invalid format: PROC-22: The OCR backend has an invalid format CAUSE The OCR raw de...
su command fails with resource temporarily unavailable
su command fails with resource temporarily unavailable SYMPTOMS ~]# su - gridLast login: Mon Feb 19 12:15:34 CST 2024 on pts/0su: failed to execute /bin/bash: Resource temporarily unavailable CAUSE The maximum number of user processes exceeded the limit. ~]# ps h -Led -o user | sort | uniq -c | grep grid SOLUTION Increase the nproc values in /etc/security/limits.d/97-oracle-database-11g-limits.conf. ~]# cat >>/etc/security/limits.d/97-oracle-database-11g-limits.conf <<EOFgrid ...
High Availability Configuration Optimization
High Availability Configuration Optimization 初始化参数： 配置 alternate 归档路径，通常是 LOG_ARCHIVE_DEST_1，防止归档目录满，导致数据库挂起。 配置 FAST_START_MTTR_TARGET 参数，减少故障恢复时间。 LOG_BUFFER 参数至少 128MB。 设置 SGA_TARGET 参数，启用自动共享内存管理，并将 USE_LARGE_PAGES 参数，设为 AUTO_ONLY 或 ONLY。 设置 ARCHIVE_LAG_TARGET 参数，定时触发日志切换归档。 Active Data Guard： 自动块修复，配置 LOG_ARCHIVE_CONFIG、LOG_ARCHIVE_DEST_n 和 FAL_SERVER 参数。 DB_BLOCK_CHECKSUM，推荐 DB_BLOCK_CHECKSUM=TYPICAL，最小开销。 DB_BLOCK_CHECKING，推荐 DB_BLOCK_CHECKING=MEDIUM，推荐先在备库上设置，没问题后再主库配置。 DB_LOST_WRI...
How To Check DataGuard Status
How To Check DataGuard Status Oracle Database - 11.2 Show the last archive produced in primary and the last archive applied to standby. SET linesize 200 pagesize 100SELECT a.thread#, b.last_seq prmy_last_file, a.applied_seq stdby_last_file, CASE WHEN b.last_seq - a.applied_seq > 2 THEN '=>' ELSE to_char(b.last_seq - a.applied_seq) END archive_difference, TO_CHAR (a.latest_apply_time, 'dd/mm/yyyy hh24:mi:ss') stdby_latest_time FROM (SELECT resetlogs_id, thread#, MAX(seque...
ORA-00245
ORA-00245 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 Oracle Grid Infrastructure - version 11.2.0.4.0 SYMPTOMS Starting backup at 15-FEB-24using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-0...
Managing the Online Redo Log
Managing the Online Redo Log Creating Redo Log Groups and Members Creating Redo Log Groups. ALTER DATABASE ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 100M BLOCKSIZE 512; Creating Redo Log Members. ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.rdo' TO GROUP 2; Relocating and Renaming Redo Log Members SHUTDOWN IMMEDIATEmv /diska/logs/log1a.rdo /diskc/logs/log1c.rdomv /diska/logs/log2a.rdo /diskc/logs/log2c.rdoSTARTUP MOUNTALTER DATABASE RENAME FILE...
How to enable and disable flashback
How to enable and disable flashback Oracle Database - Enterprise Edition - version 11.2.0.4.0 Enable flashback Make sure the database is in archive log mode. Refer: How to enable and disable archive log mode To enable flashback we need to set two parameters: DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE. SQL> alter system set db_recovery_file_dest='/home/oracle/app/oracle';System altered.SQL> alter system set db_recovery_file_dest_size=10g;System altered.SQL> show paramete...
