Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to do ORA-00845 errors in oracle, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Problem description: after adjusting the database memory, start the database report ORA-00845: MEMORY_TARGET not supported on this system.

After adjusting the memory of the database, the database starts up and reports an error.

[root@jcdydb1 bin] #. / srvctl start database-d jcdydb

PRCR-1079: Failed to start resource ora.jcdydb.db

CRS-5017: The resource action "ora.jcdydb.db start" encountered the following error:

ORA-00845: MEMORY_TARGET not supported on this system

. For details refer to "(: CLSN00107:)" in "/ oracle/app/11.2.0/grid/log/jcdydb1/agent/crsd/oraagent_oracle//oraagent_oracle.log".

CRS-5017: The resource action "ora.jcdydb.db start" encountered the following error:

ORA-00845: MEMORY_TARGET not supported on this system

. For details refer to "(: CLSN00107:)" in "/ oracle/app/11.2.0/grid/log/jcdydb2/agent/crsd/oraagent_oracle//oraagent_oracle.log".

CRS-2674: Start of 'ora.jcdydb.db' on' jcdydb1' failed

CRS-2674: Start of 'ora.jcdydb.db' on' jcdydb2' failed

CRS-2632: There are no more servers to try to place resource 'ora.jcdydb.db' on that would satisfy its placement policy

-- View server memory, 132103588k / 1024swap 1024 = 125g

Top-19:32:11 up 7:21, 7 users, load average: 1.13,1.16,1.16

Tasks: 2089 total, 1 running, 2088 sleeping, 0 stopped, 0 zombie

Cpu (s): 0.3%us, 0.5%sy, 0.0%ni, 99.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Mem: 132103588k total, 31130024k used, 100973564k free, 216416k buffers

Swap: 67108856k total, 0k used, 67108856k free, 26919636k cached

-- check the kernel parameters for the database and find no problem

[root@jcdydb1 bin] # cat / etc/sysctl.conf

# add for oracle 11gR2 rac

Kernel.shmmni = 4096

Kernel.shmmax = 277439000000

Kernel.shmall = 4294967296

Kernel.aio-max-nr = 1048576

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Net.ipv4.conf.default.rp_filter = 2

Net.ipv4.conf.all.rp_filter = 2

Kernel.sem = 3010 427420 3010 142

[root@jcdydb1 bin] #

Description:

The size of the kernel.shmmax shared memory segment. Does the setting size exceed the SGA size? Can cause performance problems.

Total number of kernel.shmall shared memory pages, set size to physical? Memory size / memory page size.

Get the memory page size through the getconf command:

[root@rac01 ~] # getconf PAGE_SIZE

4096

[root@rac02 ~] # getconf PAGE_SIZE

4096

-- check the / dev/shm size and find that it is only half of the memory, less than 80% of the database memory is the server memory, which does not meet the requirements.

[root@jcdydb1 bin] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/osvg-lv_root

99G 488m 93G 1% /

/ dev/sda1 504M 45M 434M 10% / boot

/ dev/mapper/osvg-lv_data

50g 3.7g 44G 8% / data

/ dev/mapper/osvg-lv_home

9.9G 3.9G 5.5G 42% / home

/ dev/mapper/osvg-lv_ora

99G 12G 82G 13% / oracle

/ dev/mapper/osvg-lv_tmp

32G 9.5g 21G 32% / tmp

/ dev/mapper/osvg-lv_usr

20g 7.4G 12G 40% / usr

/ dev/mapper/osvg-lv_var

9.9G 508m 8.9G 6% / var

/ data/soft/rhel-server-6.4-x86_64-dvd.iso

3.5g 3.5g 0100% / media/rhel64

Tmpfs 62G 0G 65G 0% / dev/shm

Note: the default capacity of / dev/shm is half the size of memory, which can be seen using the df-h command. But it doesn't really take up this memory.

If there are no files under / dev/shm/, it actually takes up 0 bytes of memory.

-- to see who / dev/shm is occupied, quickly increase / dev/shm, and confirm that no important processes are using / dev/shm, kill file users are required.

[root@jcdydb1 bin] # lsof / dev/shm

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME

Pulseaudi 27716 grid mem REG 0,16 67108904 11057360 / dev/shm/pulse-shm-863193574

Gnome-ter 42214 grid mem REG 0,16 67108904 11057310 / dev/shm/pulse-shm-3660319902

[root@jcdydb1 bin] # kill-9 27716 42214

-- check again and find that there is no occupation.

[root@jcdydb1 bin] # lsof / dev/shm

[root@jcdydb1 bin] #

-- umount / dev/shm

[root@jcdydb1 bin] # umount / dev/shm

-- Editor / etc/fstab, add / dev/shm.

[root@jcdydb1 bin] # vi / etc/fstab modification

Tmpfs / dev/shm tmpfs defaults,size=110G 0 0

[root@jcdydb1 bin] # mount / dev/shm

-- View / dev/shm size.

[root@jcdydb1 bin] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/osvg-lv_root

99G 488m 93G 1% /

/ dev/sda1 504M 45M 434M 10% / boot

/ dev/mapper/osvg-lv_data

50g 3.7g 44G 8% / data

/ dev/mapper/osvg-lv_home

9.9G 3.9G 5.5G 42% / home

/ dev/mapper/osvg-lv_ora

99G 12G 82G 13% / oracle

/ dev/mapper/osvg-lv_tmp

32G 9.5g 21G 32% / tmp

/ dev/mapper/osvg-lv_usr

20g 7.4G 12G 40% / usr

/ dev/mapper/osvg-lv_var

9.9G 508m 8.9G 6% / var

/ data/soft/rhel-server-6.4-x86_64-dvd.iso

3.5g 3.5g 0100% / media/rhel64

Tmpfs 110G 0 110G 0% / dev/shm

-- start the database.

[root@jcdydb1 bin] #. / srvctl start database-d jcdydb > successful!

Thank you for reading this article carefully. I hope the article "what to do if there are ORA-00845 errors in oracle" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.