Portal
Language
 
Home>Knowledge Base>Root>CampaignMax>CampaignMax Database Creation or Update causes ORA-12516 or ORA-12520 errors
User Login
Username
Password
 
 Login
Information
Article ID199
Created On1/21/2012
Modified1/21/2012

CampaignMax Database Creation or Update causes ORA-12516 or ORA-12520 errors

This usually means that Oracle has exhausted its process pool and cannot continue.  Frequently, the database will automatically shutdown after getting this error.  To increase the number of process:

  1. Connect to the database as the sysdba. Load "sqlplus / as sysdba" from a windows command prompt.
  2. Enter "show parameter processes". For the default XE install, this value is set to 40 which is too small to run the create utility.
  3. To change the value enter "alter system set processes=100 scope=spfile;"
  4. The server needs to be restarted for this change to take effect. Enter "startup force" to restart the database.

After the database is restarted, the creation utility should run without a problem.