How to Resolve ORA-12850 Oracle Error Message

  • by
ORA-12850

ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated

Met an error when I tried to monitor the database by querying sessions.

ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated

There could be many ways to solve this, but I run the following statement to remove ORA-12850.

SQL> alter system flush shared_pool;

System altered.

For a RAC system, you should flush shared pool on other nodes, too.

In this way, we don't have to restart the database.

Leave a Reply

Your email address will not be published. Required fields are marked *