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