Adding a new database on 11gR2 using dbca


I needed to add a new database to test some BACKUP/RESTORE commands.












I selected a Custom Database








I used the same ASM disk groups available for an already active database.







I want to give 40% of available memory to SGA and PGA

I increased the number of processes.






Oracle 11g is using a new mechanism for managing shared memory: you need to configure large enough tmpfs on /dev/shm device to fit all requested memory up to MEMORY_MAX_TARGET.
To solve this problem you should correct as follow:
# umount tmpfs
# mount -t tmpfs shmfs -o size=3200m /dev/shm

The same alert on dbca log


To by-pass this error I reduced the amount of memory requested during this setup










The new database is now available to be used.




















download
alternative link download