ORA-00845:
MEMORY_TARGET not supported on this system
###########################################################
[oracle@machine1 ~]$ export ORACLE_SID=PROD
[oracle@machine1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar
17 08:16:14 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> show parameter MEMORY_TARGET
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> exit
Disconnected
### Check
the shared memory in machine and increase "/dev/shm" value
[oracle@machine1
~]$ df -h
Filesystem
Size Used Avail Use% Mounted on
/dev/sda3
6.8G 3.4G 3.1G
52% /
tmpfs 936M
447M 490M 48% /dev/shm <<<<===========
/dev/sda5
6.8G 5.8G 643M
91% /opt
/dev/sda1
12G 7.0G 4.1G
64% /u01
/dev/sda2
7.7G 191M 7.2G
3% /u02
[oracle@machine1 ~]$ su - root
Password:
[root@machine1 ~]# mount -t tmpfs shmfs -o size=2048m /dev/shm
[root@machine1 ~]#
add entry like
[root@machine1 ~]# vi /etc/fstab
add entry like
[root@machine1 ~]# vi /etc/fstab
[..]
tmpfs /dev/shm tmpfs size=2G 0 0
[..]
[root@machine1 ~]# df -h
Filesystem
Size Used Avail Use% Mounted on
/dev/sda3
6.8G 3.4G 3.1G
52% /
tmpfs 2.0G 0
2.0G 0% /dev/shm
<<<<<=============Increased it as 2GB
/dev/sda5
6.8G 5.8G 643M
91% /opt
/dev/sda1
12G 7.0G 4.1G
64% /u01
/dev/sda2
7.7G 191M 7.2G
3% /u02
shmfs
2.0G 0 2.0G
0% /dev/shm
####
Let's connect now .
[oracle@machine1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar
17 08:37:39 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 780824576 bytes
Fixed Size 2217424 bytes
Variable Size 469764656 bytes
Database Buffers 306184192 bytes
Redo Buffers 2658304 bytes
Database mounted.
Database opened.
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 748M
memory_target
big integer
748M
shared_memory_address integer 0
Thank you ):-
Do you like this post? Please share this article.
HTML Link Code:
1 comments:
Hi Surendra, I hope we should check with UNIX team to have the size for /dev/shm, in some environments we re not supposed to change right.
ReplyPost a Comment