Adding a new database on 11gR2 using dbca

Tweet

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.