Recently attempted to upgrade a database from 220.127.116.11 to 18.104.22.168 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:
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:
then run the following command:
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.