Oracle：0RA-03113: end-of-file on communication channel
在启动数据库的时候遇到如题所示的报错，具体情况如下：
发生该错误时，Alert日志的报错如下所示：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
Sat Jul 04 02:27:30 2015 Starting ORACLE instance (normal) ****************** Large Pages Information ***************** Total Shared Global Region in Large Pages = 52 GB (40%) Large Pages used by this instance: 26625 (52 GB) Large Pages unused system wide = 31 (62 MB) (alloc incr 256 MB) Large Pages configured system wide = 26656 (52 GB) Large Page size = 2048 KB RECOMMENDATION: Total Shared Global Region size is 128 GB. For optimal performance, prior to the next instance restart increase the number of unused Large Pages by atleast 38881 2048 KB Large Pages (76 GB) system wide to get 100% of the Shared Global Region allocated with Large pages *********************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 |
造成该错误的原因是：当前的数据库环境启用了大页，但是缺少memlock的设定。
解决方式如下所示：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 |
[oracle@dsrac2 ~]$ cat /etc/security/limits.conf # /etc/security/limits.conf # #Each line describes a limit for a user in the form: # #<domain> <type> <item> <value> # #Where: #<domain> can be: # - an user name # - a group name, with @group syntax # - the wildcard *, for default entry # - the wildcard %, can be also used with %group syntax, # for maxlogin limit # #<type> can have the two values: # - "soft" for enforcing the soft limits # - "hard" for enforcing hard limits # #<item> can be one of the following: # - core - limits the core file size (KB) # - data - max data size (KB) # - fsize - maximum filesize (KB) # - memlock - max locked-in-memory address space (KB) # - nofile - max number of open files # - rss - max resident set size (KB) # - stack - max stack size (KB) # - cpu - max CPU time (MIN) # - nproc - max number of processes # - as - address space limit # - maxlogins - max number of logins for this user # - maxsyslogins - max number of logins on the system # - priority - the priority to run user process with # - locks - max number of file locks the user can hold # - sigpending - max number of pending signals # - msgqueue - max memory used by POSIX message queues (bytes) # - nice - max nice priority allowed to raise to # - rtprio - max realtime priority # #<domain> <type> <item> <value> # #* soft core 0 #* hard rss 10000 #@student hard nproc 20 #@faculty soft nproc 20 #@faculty hard nproc 50 #ftp hard nproc 0 #@student - maxlogins 4 # End of file # Oracle Database 11g RAC grid soft nproc 20470 grid hard nproc 163840 grid soft nofile 10240 grid hard nofile 655360 oracle soft nproc 20470 oracle hard nproc 163840 oracle soft nofile 10240 oracle hard nofile 655360 oracle soft memlock -1 oracle hard memlock -1 [oracle@dsrac2 ~]$ |
——————————————————————————————
Done。
