Post date: 17-Jan-2013 14:30:59
[oracle@prim1 ~]$ conn
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 19:55:29 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
1. Check size of your shared memory segment
[root@prim1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
23G 7.0G 15G 34% /
/dev/sda1 99M 17M 77M 18% /boot
tmpfs 460M 0 460M 0% /dev/shm
/dev/sdb1 20G 4.7G 15G 25% /localdisk
2. Check size of memory_target parameter
[oracle@prim1 ~]$ cd $ORACLE_HOME/dbs
[oracle@prim1 dbs]$ grep memory_target initprimdb.ora
*.memory_target=578813952
memory_target is 552 MB and /dev/shm is 460M, which is the reason we are getting this error.
3. Increase your shared memory segment
[root@prim1 ~]# df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 460M 0 460M 0% /dev/shm
[root@prim1 ~]#
[root@prim1 ~]# umount tmpfs
[root@prim1 ~]#
[root@prim1 ~]# mount -t tmpfs shmfs -o size=600m /dev/shm
4. Now check size of your shared memory Segment
[root@prim1 ~]# df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
shmfs 600M 0 600M 0% /dev/shm
5. Start your Database.
[oracle@prim1 ~]$ conn
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 19:59:36 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 577511424 bytes
Fixed Size 1338000 bytes
Variable Size 369100144 bytes
Database Buffers 201326592 bytes
Redo Buffers 5746688 bytes
Database mounted.
Database opened.