Database Networking (MOSC)

MOSC Banner

ORA-12528 on 2 Node RAC

edited Apr 16, 2014 12:00PM in Database Networking (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center