By default the number of allowed processes are 150 which may not be enough in production. below is how to increase the processes & sessions and transactions from sys dba user sql> alter system set processes=500 scope=spfile; sql> alter system set sessions=555 scope=spfile; sql> alter system set transactions=610 scope=spfile; sql> shutdown abort sql> startup