ORA-12528 on 2 Node RAC
Hi,
I am seeing this ORA-12528 Error only on one Node of the 2 Node RAC system which is running on 10.2.0.4 release.
When i see the services on listener on 1st node, it says status as "BLOCKED" as shown below:
Node1
$ lsnrctl services |grep -i inqrstg
Service "INQRSTG" has 1 instance(s).
Instance "inqrstg1", status BLOCKED, has 1 handler(s) for this service...
Service "INQRSTG_XPT" has 1 instance(s).
Instance "inqrstg1", status BLOCKED, has 1 handler(s) for this service...
Whereas on 2nd node, i see connection looks fine
Node2
bash-4.2$ lsnrctl services |grep -i inqrstg
Service "INQRSTG" has 1 instance(s).
Instance "inqrstg2", status READY, has 1 handler(s) for this service...