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

  • by

ORA-12850

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're 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.

Leave a Reply

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