ORA-27102: out of memory No left on device

Recently attempted to upgrade a database from 11.2.0.1 to 11.2.0.3 on a linux redhat-6.

Whenever i tried to run dbua – i would get sp2-0640: Not Connected.  When i looked at the log in the new oracle home – $ORACLE_HOME/log/diag/rdbms/dbuaxxxxxx directory would say :

Fri Jul 19 11:00:00 2013
The value of parameter shared_pool_size is below the required minimum
It has been reset to the minimum value
Starting ORACLE instance (normal)

So i tried set the sga_target higher and shared_pool higher but received :

ORA-27102: out off memory Linux-X86_64: Error: 28: No space left on device.

also , it said the sga_Target needed to be 6080M – anything higher would get the above error.

Anyway the problem is that shmall is too low – metalink # 301830.1

shmall shoujld be set to the sum of all SGA’s on the system, divided by pagesize.  the below data is from the metalink note:

The page size can be determined using the following command:

$ getconf PAGE_SIZE 
4096

For example, if the sum of all the SGAs on the system is 16Gb and the result of  ‘$ getconf PAGE_SIZE’ is 4096 (4Kb) then set shmall to 4194304 pages

As the root user set the shmall to 4194304 in the /etc/sysctl.conf file:

kernel.shmall = 4194304

then run the following command:

$ sysctl -p
$ cat /proc/sys/kernel/shmall
4194304

NOTE:

The above command loads the new value and a reboot is not necessary.

Switch back to being the oracle user and retry the startup command.

 

Advertisements