..read more

  RPM required to enable X11 display on Linux --------------------------------------------- yum install  xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y ..read more

Enabling SSH login as root user on Red Hat Enterprise Linux 9 (AWS EC2) login as root user  cd /etc/ssh/sshd_config.d [root@ip-110.1.1.1.1 sshd_config.d]# ls -lrt total 8 -rw-------. 1 root root 719 Jan  8 12:31 50-redhat.conf -rw-------. 1 root root  27 Mar 14 16:19 50-cloud-init.conf [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1.1.1.1 sshd_config.d]# vi 50-cloud-init.conf [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1.1.1.1 sshd_config.d]# [root@ip-110.1 ..read more

SHMMAX and SHMALL parameters QUESTION 1 =========== What is the maximum value of SHMMAX for a 32-bit (x86) Linux system? Oracle Global Customer Support officially recommends a " maximum" for SHMMAX of just less than 4Gb, or 4294967295. The maximum size of a shared memory segment is limited by the size of the available user address space. On 32-bit systems, this is a theoretical 4GB. The maximum possible value for SHMMAX is just less than 4Gb, or 4294967295. Setting SHMMAX to 4GB exactly will give you 0 bytes as max, as this value is interpreted as a 32-bit number and it wraps around. QUE ..read more

  Command to see Kernel Parameter Values  Parameter Command semmsl, semmns, semopm, and semmni # /sbin/sysctl -a | grep sem This command displays the value of the semaphore parameters in the order listed. shmall, shmmax, and shmmni # /sbin/sysctl -a | grep shm This command displays the details of the shared memory segment sizes. file-max # /sbin/sysctl -a | grep file-max This command displays the maximum number of file handles. ip_local_port_range # /sbin/sysctl -a | grep ip_local_port_range This command displays a range of port numbers ..read more

  For Oracle Database kernel parameter and shell limit values Parameter Value File semmsl semmns semopm semmni 250 32000 100 128 /proc/sys/kernel/sem shmall Greater than or equal to the value of shmmax, in pages. /proc/sys/kernel/shmall shmmax Half the size of physical memory in bytes See My Oracle Support Note 567506.1 for additional information about configuring shmmax. /proc/sys/kernel/shmmax shmmni 4096 /proc/sys/kernel/shmmni panic_on_oops 1 /proc/sys/kernel/panic_on_oops file-max 6815744 /proc/sys/fs/file-max aio-max-nr 1048576 Note: This valu ..read more

Switch primary to read replica (standby ) and vice-versa AWS CLI : aws rds switchover-read-replica --db-instance-identifier ora-orcl-demo2 --region us-west-2 aws rds switchover-read-replica --db-instance-identifier ora-orcl-demo1  --region us-east-1 aws rds describe-db-instances --db-instance-identifier ora-orcl-demo1  AWS Link  https://aws.amazon.com/blogs/database/managed-oracle-data-guard-switchover-with-amazon-rds-for-oracle ..read more

 Oracle SQL Developer Error  :  Solutions : Go to command prompt C:\Users\akpandey\AppData\Roaming\SQL Developer\system22.2.1.234.1810\system_cache\config\Modules delete all files here  restart the SQLDeveloper . This solution work in my case all connection all there .  ..read more

 DMS mapping task JSON - AWS  {     "rules": [         {             "rule-type": "transformation",             "rule-id": "828748134",             "rule-name": "828748134",             "rule-target": "schema",             "object-locator": {                 "schema-name": "dbo"             },             ..read more

  Query to check , all node are serving connection in RAC Query-1 select inst_id,count(*) from    gv$session where    username is not null group by    inst_id; Query-2 select    inst_id,    count(*) from    gv$session where    status='ACTIVE' and username is not null group by    inst_id ..read more