Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SERVICE not LISTENING on node 2 of RAC

TriBBMar 21 2014 — edited Apr 3 2014

I have added a SERVICE, using srvctl, to the CLUSTER and it is displayed as a RESOURCE and ONLINE both nodes

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.db_name.srv_name.svc

      1        ONLINE  ONLINE       server1

      2        ONLINE  ONLINE       server2

...Unfortunately, the SERVICE is displayed in the LISTENER on node 1 but not node2

[server1] > lsnrctl SERVICES

.

.

Service "SRV_NAME" has 1 instance(s).

  Instance "rac1", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0 state:ready

         LOCAL SERVER

[server2] > lsnrctl SERVICES

Not displayed

User the command: srvctl config database -d db_name -a

...the Service is display and both nodes are displayed

[server2] > srvctl config database -d wamuat -a

Database unique name: DB_NAME

Database name:

Oracle home: /u03/wamdb/11.2.0

Oracle user: wamdb

Spfile: +DG_FRA/DB_NAME1/PARAMETERFILE/spfile.1482.842535585

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: DB_NAME

Database instances: DB_NAME1,DB_NAME2

Disk Groups: DG_DATA,DG_FRA

Mount point paths:

Services: SRV_NAME

Type: RAC

Database is enabled

Database is administrator managed

Why is the SERVICE not listed in the LISTENER on NODE 2?

This post has been answered by TriBB on Apr 3 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2014
Added on Mar 21 2014
11 comments
5,860 views