Tuesday, June 21, 2016

Incident (ORA-3137[12333]) detected. OR Async driver not configured : errno=13

Reasons:
Due to Async driver not configure, ORA-3137[12333] incident occur.  when incident occur Async driver permission like below: 

#ll  -l /dev/async
crw-r--r--   1 root       sys        101 0x000104 Aug  6  2015 /dev/async
Here:
Access permission(crw-r--r--): 644
user:  root
group: sys

Solution:
Step-1: Change Async driver permission like below:
Access Permission: 660
user:oracle
group: dba

# chown oracle:dba /dev/async
# ll /dev/async
crw-r--r--   1 oracle     dba        101 0x000104 Aug  6  2015 /dev/async
# chmod 660 /dev/async
#  ll /dev/async
crw-rw----   1 oracle     dba        101 0x000104 Aug  6  2015 /dev/async

Step-2: Change the value of max_async_ports. max_async_ports limits the maximum number of processes that can concurrently
use /dev/async. Set this parameter to the sum of  'processes' from init.ora + number of background processes. 

# kctune max_async_ports=5500
     ==> Update the automatic 'backup' configuration first? yes
       * The automatic 'backup' configuration has been updated.
       * Future operations will update the backup without prompting.
       * The requested changes have been applied to the currently
         running configuration.
Tunable                    Value  Expression  Changes
max_async_ports  (before)   4096  Default     Immed
                 (now)      5500  5500

# kctune max_async_ports
Tunable          Value  Expression  Changes
max_async_ports   5500  5500        Immed

No comments:

Post a Comment