Tuesday Aug 24, 2010
Sunday Feb 15, 2009
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.
Roman (pomah) Ivanov, ISV Engineering. Tips how to run Oracle best on Sun. Performance monitoring and tuning for system administrators. OpenSolaris user experience.
- Oracle VM Templates теперь доступны для платформы SPARC
- Самостоятельная сборка и публикация пакетов IPS в Solaris 11
- Oracle Solaris 11 уже скоро
- Oracle Day 2011 - Москва
- OVM Templates: Oracle Solaris Container with Oracle Database 11gR2
- У Oracle RU появились свои аккаунты на Facebook, Twitter и Youtube
- This blog will move soon
- White paper updated: Running Oracle Real Application Clusters on Oracle VM Server for SPARC 2.0
- Read Me First
- Oracle Database Single Instance на ZFS: учимся готовить.