Who does not like oracle ? Of course everyone does, however problems arise when you run into trouble. Luckily that oracle make easier for us to trace errors by always assigning to them a specific number ORA-XXXXX. In line with that here is another common error message ORA-12519....:
The root cause of this error message is the low PROCESSES initialization parameter value. In fact the PROCESS parameter describes the total number of operating system process allowed to access the database concurrently.
This total process is divided into user process and background processes, user processes are the processes allotted to the users connected to the database and the background processes are the processes utilized by the database.
Solution outline: Increase the number of PROCESSES parameter value.
How: Try to login as a user with at least a SYS privilege.
sql> alter system set processes=300 scope=spfile;
sql> shutdown immediate;
sql> startup;
Feel free to drop a comment.
The root cause of this error message is the low PROCESSES initialization parameter value. In fact the PROCESS parameter describes the total number of operating system process allowed to access the database concurrently.
This total process is divided into user process and background processes, user processes are the processes allotted to the users connected to the database and the background processes are the processes utilized by the database.
Solution outline: Increase the number of PROCESSES parameter value.
How: Try to login as a user with at least a SYS privilege.
sql> alter system set processes=300 scope=spfile;
sql> shutdown immediate;
sql> startup;
Feel free to drop a comment.
No comments:
Post a Comment