Wednesday 18 September 2013

Oracle Database Starting Error - ORA-00845: MEMORY_TARGET not supported on this system [SOLVED]


Guys

I got this error when I start oracle instance.

"ORA-00845: MEMORY_TARGET not supported on this system"

Some of the forum said about of tmpfs size which is mounted on /dev/shm.
Then I saw this post.
So I suspected it isn't enough space of share memory.

I checked with "df" command.


That space is currently amount mounted on /dev/shm. So I think that 5.9G isn't enough.
It's need to set a mount which over 5.9G manually.

Then I changed at /etc/fstab  as below. (changed "default" to "size=6g" )


Then, have restarted the host and checked the size with "df" again.


Then , try to start the instance again.

#sqlplus / as sysdba
SQL>startup

This time nothing error occur. :)

>>

UTEE

 Ref: http://www.oracle-base.com/articles/11g/automatic-memory-management-11gr1.php

Tuesday 17 September 2013

Oracle Listener Can't Start Error - Linux Error: 29: Illegal seek [SOLVED]

Hi Guys,

I'm want to share how to solve to Oracle Listener Error "Linux Error: 29: Illegal seek" .

This Error occur when starting listener on linux box.



This Listener must support to the remote connection also.
On the First, I checked on the /etc/hosts file.

If I configured to /etc/hosts file with " 127.0.0.1 localhost localhost.localdomain" (only one-line), I can start oracle listener as well.
But If I put other hostname for remote connection at /etc/hosts like "192.168.1.2 localhost localhost.localdomain" , I can't start listener anymore and got above error.

I tried a few changes on /etc/hosts. But It isn't working.
Then, I read at the oracle wiki about of listener. I decided to change the name at the listener.ora file.

So go to the listener file location .

 I changed as putting IP (192.168.1.2) at HOST.


Then, save the file and start the listener.

#lsnrctl start

It's working without any error. :)

>>

UTEE

Ref : http://docs.oracle.com/cd/E11882_01/network.112/e10836/listenercfg.htm