Thursday, March 14, 2024

Minimum Kernel Parameter Settings for Oracle Database 19c Installation - Redhat Linux

 

For Oracle Database kernel parameter and shell limit values


ParameterValueFile

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 value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.

/proc/sys/fs/aio-max-nr
ip_local_port_range

Minimum: 9000

Maximum: 65500

/proc/sys/net/ipv4/ip_local_port_range
rmem_default

262144

/proc/sys/net/core/rmem_default
rmem_max

4194304

/proc/sys/net/core/rmem_max
wmem_default

262144

/proc/sys/net/core/wmem_default
wmem_max

1048576

/proc/sys/net/core/wmem_max

Thursday, March 7, 2024

How to Initiate the AWS Oracle RDS Data Guard switchover using the AWS CLI

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/

AWS DMS Mapping Table (MSSQL) : Loading Table data using boundaries

 MSSQL query boundaries conditions  



SELECT Max(Id)  nt

FROM (SELECT Id,(Ntile(160) over( ORDER BY Id)) nt FROM demo)

test

GROUP BY nt

ORDER BY nt

option (maxDOP 1024)

Monday, February 26, 2024

Oracle Sql developer error: could not install some modules

 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 .