ORA-12519: Message 12519 not found

Asked By 0 points N/A Posted on -

Hi all,

I have installed Oracle database and when I connected to it I have got this error:

ORA-12519: Message 12519 not found

I am not getting this message all the time, sometimes I have connected without any problems. When I get this message I have to try several times before getting connected. I don’t know the reasons of this message and how to set my ORACLE_HOME Environments variable, please I want any help or idea about this.


Answered By 10 points N/A #84980

ORA-12519: Message 12519 not found


I have faced the same problem before, one of my brothers helped me solve this problem. Ok. Cutting the long story short, all you need to do is a few simple steps as the following:-

1. Run SQL*Plus and login as SYSTEM. You should know what password you’ve used during the installation of Oracle DB XE.
2. Run the command “alter system set processes=150 scope=spfile;” in the SQL*Plus
3. VERY IMPORTANT: Restart the database.

Once completed, I think you will not face this error.

Best of luck.

Related Questions