After patching 19.26 , we received complain from Application team that they were facing below error while executing one particular SQL_ID
ORA-07445: exception encountered: core dump [qcpibfa()+235] [SIGSEGV] [ADDR:0x7FFF6A9C7C88] [PC:0x4BF0E4B] [Address not mapped to object] []
[root@rac01 ]$ cat /etc/security/limits.conf ---Before
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240-------------------------unlimited
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
oracle soft data unlimited
oracle hard data unlimited
oracle soft core unlimited
oracle hard core unlimited
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240------------------------unlimited
grid hard stack 32768
grid hard memlock 134217728
grid soft memlock 134217728
grid soft data unlimited
grid hard data unlimited
grid soft core unlimited
grid hard core unlimited
We had # hash the value of stack for Grid and Oracle users and added * (unlimited)
[root@rac01 ]$ cat /etc/security/limits.conf ---After
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
#oracle soft stack 10240
#oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
oracle soft data unlimited
oracle hard data unlimited
oracle soft core unlimited
oracle hard core unlimited
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
#grid soft stack 10240
#grid hard stack 32768
grid hard memlock 134217728
grid soft memlock 134217728
grid soft data unlimited
grid hard data unlimited
grid soft core unlimited
grid hard core unlimited
* soft stack unlimited
* hard stack unlimited
[oracle@rac01 limits.d]$ cat oracle-database-preinstall-19c.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack unlimited
oracle hard stack unlimited
oracle hard memlock 134217728
oracle soft memlock 134217728
oracle soft data unlimited
oracle hard data unlimited
[oracle@rac01 limits.d]$ cd /etc/security/limits.d
[oracle@rac01 limits.d]$ ls -lrt
total 8
-rw-r--r-- 1 root root 1205 Feb 24 07:42 oracle-database-preinstall-19c.conf_24feb2025
-rw-r--r-- 1 root root 1213 Feb 24 07:43 oracle-database-preinstall-19c.conf ----------------Before
[oracle@bms04dbamd03p limits.d]$ cat oracle-database-preinstall-19c.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240 ---Before
oracle hard stack 10240 ---Before
oracle hard memlock 134217728
oracle soft memlock 134217728
oracle soft data unlimited
oracle hard data unlimited
[oracle@rac01 limits.d]$ ls -lrt
total 8
-rw-r--r-- 1 root root 1205 Feb 24 07:42 oracle-database-preinstall-19c.conf_24feb2025
-rw-r--r-- 1 root root 1213 Feb 24 07:43 oracle-database-preinstall-19c.conf ----------------After
[oracle@bms04dbamd03p limits.d]$ cat oracle-database-preinstall-19c.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack unlimited ---After
oracle hard stack unlimited ---After
oracle hard memlock 134217728
oracle soft memlock 134217728
oracle soft data unlimited
oracle hard data unlimited
=======================================
We have also made the change in the s_crsconfig_rac01_env.txt file for CRS_LIMIT_STACK value from 2048 to 16384
[grid@rac01 install]$ cat s_crsconfig_rac01_env.txt
#########################################################################
#This file can be used to set values for the NLS_LANG and TZ environment
#variables and to set resource limits for Oracle Clusterware and
#Database processes.
#1. The NLS_LANG environment variable determines the language and
# characterset used for messages. For example, a new value can be
# configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8
#2. The Time zone setting can be changed by setting the TZ entry to
# the appropriate time zone name. For example, TZ=America/New_York
#3. Resource limits for stack size, open files and number of processes
# can be specified by modifying the appropriate entries.
#
#Do not modify this file except as documented above or under the
#direction of Oracle Support Services.
#########################################################################
TZ=Europe/Berlin
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
CRS_LIMIT_STACK=2048----------------------------we had this value
CRS_LIMIT_OPENFILE=65536
CRS_LIMIT_NPROC=65536
TNS_ADMIN=
[root@rac01 ~]$ cd /applications/oracle/g19.3.0/grid_home/crs/install
[root@rac01 install]$
[root@rac01 install]$
[root@rac01 install]$
[root@rac01 install]$ ls -lrt *s_*
-rwxr-xr-x. 1 root oinstall 3593 Dec 30 2014 s_crsconfig_defs
-rwxr-xr-x 1 root oinstall 1000 Sep 19 16:46 s_crsconfig_rac01_env.txt_bkp_25022025
-rwxr-xr-x. 1 root oinstall 7348 Jan 20 14:03 s_oraolr.pm
-rwxr-xr-x. 1 root oinstall 19742 Jan 20 14:03 s_oraocr.pm
-rwxr-xr-x. 1 root oinstall 3917 Jan 20 14:03 s_orachm.pm
-rwxr-xr-x. 1 root oinstall 141610 Jan 20 14:03 s_crsutils.pm
-rwxr-xr-x 1 root oinstall 1001 Feb 25 15:53 s_crsconfig_rac01_env.txt
[oracle@rac01 install]$ cat s_crsconfig_rac01_env.txt
#########################################################################
#This file can be used to set values for the NLS_LANG and TZ environment
#variables and to set resource limits for Oracle Clusterware and
#Database processes.
#1. The NLS_LANG environment variable determines the language and
# characterset used for messages. For example, a new value can be
# configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8
#2. The Time zone setting can be changed by setting the TZ entry to
# the appropriate time zone name. For example, TZ=America/New_York
#3. Resource limits for stack size, open files and number of processes
# can be specified by modifying the appropriate entries.
#
#Do not modify this file except as documented above or under the
#direction of Oracle Support Services.
#########################################################################
TZ=Europe/Berlin
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
CRS_LIMIT_STACK=16384 -------------------------------------------------------------> Changed this value from 2048 to 16384
CRS_LIMIT_OPENFILE=65536
CRS_LIMIT_NPROC=65536
TNS_ADMIN=
No comments:
Post a Comment