Tuesday, August 2, 2016

DB connection issue :

LISTENER REFUSED THE CONNECTION WITH THE FOLLOWING ERROR :

ORA-12514, TNS :  LISTENER DOESN'T CURRENTLY KNOW OF SERVICE : 

we are using the MEMORY_TARGET feature on these databases, This feature requires the /dev/shm file system to be mounted for at least 10GB(10737418240 bytes). We get ORA-00845: MEMORY_TARGET not supported on this system error when /dev/shm is either not mounted or is mounted with available space  is less than the above mentioned size.  We need to fix this by reclaiming the space so that MEMORY_TARGET can work as expected. ensure that the mount point  /dev/shm for this AMM feature(memory_target ) needs larger /dev/shm
At the time of issue it  is at :
[jptyooradbd1l.ap.health.ge.com:/export/home/grid]
+ASM:grid>df -kh
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                  32G   28G  4.3G  87% /dev/shm



after reboot it came down to:

[jptyooradbd1l.ap.health.ge.com:/dev/shm]
+ASM:grid>df -kh .
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                  32G   17G   16G  52% /dev/shm

No comments:

Post a Comment