Hi Oracle Lovers , This is a very common problem if u don't plan for your DB processes :-)
Don't worry this problem is solved with a minimum down time :-( To effect this in your DB u need to restart your DB :-(
Don't worry this problem is solved with a minimum down time :-( To effect this in your DB u need to restart your DB :-(
Just login Database as sysdba (Wait for a process end normally ), then just alter the system parameter file to maximum process 1500.
1.SQL> select count(*) from v$process; to see the number of processes running. After that I've change the parameter file by following command.
2. SQL> alter system set processes=1500 scope=spfile;
SQL> shutdown immediate
SQL> startup
:-)
No comments:
Post a Comment