Database - RAC/Scalability (MOSC)

MOSC Banner

LISTENERS(scanlistner and both other listners on both nodes) show state intermediate instead of Onli

edited Feb 13, 2013 2:29AM in Database - RAC/Scalability (MOSC) 6 commentsAnswered ✓
i have a rac enviroment on 11gr2 11.2.0.3 and my database is functioning but with problems. there is no load balancing through the scanip ,and due to this all transactions are fired just to one Node ,thereby leaving the other node idle while the other is over congested.looking at  crsctl stat res -t, i realised my listener resourses show (not all endpoints Registered and their states are not Online But intermediate as shown below.
oracle@tbo12:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
               ONLINE  ONLINE       tbo11
               ONLINE  ONLINE       tbo12

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center