too many cpu for me
By Roman Ivanov on Feb 15, 2009
When you are creating Oracle Database using templates/examples from the Oracle Database distribution you may fail with ORA-00018: maximum number of sessions exceeded. This can happen on a systems with Niagara chip. It seems that it have too many CPUs (virtual ones). Quick workaround is to turn off most of them at this time:
# psradm -f 16-255
Then create database and turn them back.
# psradm -n 16-255
Your system may have not so many (256) vCPUs. I faced the same problem with 64 vCPU and solution works for me.
The same trick works for Oracle Application Server reporting ORA-00371: not enough shared pool memory. Confirmed by Alexey, such trick is working.
Update: Glenn Fawcett offers another solution, suggesting to set CPU_COUNT on systems that have large number of vcpu's.