To increase the sessions and process use the following sqls.
sqlplus "sys as sysdba"
SQL> show parameter processes;
SQL> show parameter sessions;
If the values are less than 300, set them to 300 using the following sqls,
SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=300 scope=spfile;
SQL> shutdown immediate
SQL> startup
Now, restart the oracle process using the following commands.
opmnctl stopall
opmnctl startall
1 comment:
this is exactly what my problem was thanks heaps!!
Post a Comment