Database startup times ORA-00845 Error resolution method

Problem Description : Detection of a node database down, through the Sqlplus system when the display connection is an empty instance, try to restart the database via startup error, prompt Memory_ Targetnot supported on the This system, check the alarm log memory_target failure, to increase the /dev/shm size to solve the problem

Log in database times the error message is as follows:

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.4.0 Productionon Mon Oct 30 09:26:35 2017

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

Connected to an idle instance.

Sql> Startup

Ora-00845:memory_target not supported on the This system

The following information is reported in the background log:

Starting ORACLE instance (normal)

Warning:you is trying to use Thememory_target feature. This feature requires THE/DEV/SHM the file system to bemounted for at least 13522436096 bytes. /DEV/SHM is either no mounted or ismounted with available space less than this size. Please fix the Memory_targetcan work as expected. Current available are 12203786240 and used is 454021120bytes. Ensure the mount point is/dev/shm for this directory.

Memory_target needs LARGER/DEV/SHM

Problem Analysis :

because oracle11g is used in the AMM, when the Memory_target is greater than /DEV/SHM when the prompt does not support this system, so that the error can not start the database, due to /dev/ SHM is through the size of Tmpfs, which can be resolved by modifying this size in a Linux environment.

Workaround :

1 . View current tmpfs size information

[[Email protected]~]$ df-h

Filesystem Size used Avail use% mounted on

/dev/mapper/vg_db01-logvol02 229G 65G 153G 30%/

Tmpfs 12G 434M 12G 4%/dev/shm-- here to modify

/dev/sde1 485M 40M 420M 9%/boot

/dev/mapper/vg_db01-logvol00 30G 5.0G 24G 18%/usr

[Email protected]~]$ mount-o size=20g-onr_inodes=1000000-o noatime,nodiratime-o REMOUNT/DEV/SHM

Mount:onlyroot can do

Modify The Tmpfs size to switch to the root user by following the root user

[Email protected]~]$ su Root

Password:

2, modify the Tmpfs size

[Email protected]]# mount-o size=20g-o nr_inodes=1000000-o noatime,nodiratime-o REMOUNT/DEV/SHM

[[Email protected]]# df-h

Filesystem Size used Avail use% mounted on

/dev/mapper/vg_db01-logvol02 229G 65G 153G 30%/

Tmpfs 20G 434M 20G 3%/dev/shm--Modified size

/dev/sde1 485M 40M 420M 9%/boot

/dev/mapper/vg_db01-logvol00 30G 5.0G 24G 18%/usr

3, after modifying the TMPFS size, then log in the database to restart the instance

[Email protected]~]$ sqlplus/as SYSDBA

Sql*plus:release 11.2.0.4.0 Production on Mon Oct 30 09:42:02 2017

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

Connected Toan Idle instance.

sql>startup;

Oracleinstance started.

Total Systemglobal Area 1.3462E+10 bytes

Fixed Size 2265984 bytes

Variable Size 7381978240 bytes

Databasebuffers 6039797760 bytes

Redo buffers 38014976 bytes

Databasemounted.

Database opened. - Show Startup Success

-- query whether the current DB instance is normal

Sql>select Open_mode from V$database;

Open_mode

--------------------

READ WRITE

This article is from the "My main beam margin" blog, please be sure to keep this source http://xiaocao13140.blog.51cto.com/6198256/1977439

Database startup times ORA-00845 Error resolution method