In this post, you’ll learn more about the Oracle ErrorORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated
Reason for the Error ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated
When executing a query on a gv$ fixed view, one or more instances failed to allocate a slave to process query.
How to fix the Error ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated ?
You can fix this error in Oracle by following the below steps
Check trace output for instances on which slaves failed to start. GV$ query can only proceed if slaves can be allocated on all instances.