Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What if there is an ORA-00845 error in oracle11g?

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/01 Report--

Editor to share with you how to do ORA-00845 errors in oracle11g, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

After upgrading the oracle11g11.1.0.6 version database to version 11.1.0.7, after installing patch p6890831_111070_Linux-x86.zip, and then upgrading the database through dbua, the prompt "MEMORY_TARGET not supported on this system" appears, and then the database upgrade is aborted. Therefore, after carefully examining this problem, the original oracle11g version will not only have this problem when upgrading, but also if you set up MEMORY_TARGET improperly. This problem can also occur.

In fact, this problem is caused by the setting of SGA beyond the size of the operating system / dev/shm.

The following is an article written by Lao Yang about this error:

The Linux version of Oracle 11g may report an error when starting after modifying MEMORY_TARGET or SGA_TARGET:

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORA-00845: MEMORY_TARGET not supported on this system (just encounter this problem, turn this article around)

This problem is due to setting the size of SGA to exceed the size of the operating system / dev/shm:

[root@enterprice64] # df-k / dev/shm

Filesystem 1K-blocks Used Available Use% Mounted on

Tmpfs 4089416 0 4089416 / dev/shm

Oracle is described in the metalink document: Doc ID: Note:460506.1. There are only two ways to solve this problem, one is to modify the initialization parameters so that the setting of SGA in the initialization parameters is less than the size of / dev/shm, and the other is to adjust the size of / dev/shm.

You can modify the size of / dev/shm by modifying / etc/fstab:

[root@enterprice64 ~] # vi / etc/fstab

LABEL=/ / ext3 defaults 1 1

LABEL=/boot / boot ext3 defaults 1 2

LABEL=/data / data ext3 defaults 1 2

Devpts / dev/pts devpts gid=5,mode=620 0 0

# tmpfs / dev/shm tmpfs defaults 0 0

Tmpfs / dev/shm tmpfs defaults,size=10240M 0 0

LABEL=/home / home ext3 defaults 1 2

LABEL=/opt / opt ext3 defaults 1 2

Proc / proc proc defaults 0 0

Sysfs / sys sysfs defaults 0 0

LABEL=/usr / usr ext3 defaults 1 2

LABEL=/var / var ext3 defaults 1 2

LABEL=SWAP-sda8 swap swap defaults 0 0

~

~

"/ etc/fstab" 13L, 965C written

[root@enterprice64 ~] # umount / dev/shm

[root@enterprice64 ~] # mount / dev/shm

[root@enterprice64] # df-k / dev/shm

Filesystem 1K-blocks Used Available Use% Mounted on

Tmpfs 10485760 0 10485760 / dev/shm

[root@enterprice64 ~] # su-oracle

[oracle@enterprice64 ~] $sqlplus "/ as sysdba"

IXDBA.NET Community Forum

SQL*Plus: Release 11.1.0.6.0-Production on Tue Oct 23 15:42:42 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 4743446528 bytes

Fixed Size 2143824 bytes

Variable Size 3892316592 bytes

Database Buffers 805306368 bytes

Redo Buffers 43679744 bytes

Database mounted.

Database opened.

Modify / etc/fstab, re-mount / dev/shm, and then start the database.

The above is all the contents of the article "what to do if there is an ORA-00845 error in oracle11g". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.

Views: 247

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report