This discussion is archived
6 Replies Latest reply: Sep 20, 2012 9:37 AM by Actitud RSS

SINGLETON service over POLICY MANAGED database. 11.2.0.3

Actitud Newbie
Currently Being Moderated
Hello folks.

I've been struggling with a simple SINGLETON SERVICE creation for an existing Policy Managed database on a 11.2.0.3 cluster with two nodes with no success so far.

Environment definition:
- Two nodes 11.2.0.3 cluster
- More than one database (not important I think) all of them configured with the same SERVER POOL
- Each database has two instances, each one running form one of the nodes
- One server pool only

Requirement:
- One of the databases (DB) with its two instances needs a SINGLETON service running in one of the servers (server A).
- If the instance for that database running on A goes down, I need the service to failover to the server B.

Result:
- Failover is not working

Official notes I've checked and tested unsuccessfully (among many blogs and forums):
11gR2(11.2) RAC TAF Configuration for Admin and Policy Managed Databases ID 1312749.1
11gR2 Database Services for "Policy" and "Administrator" Managed Databases ID 1481647.1

Details for all the different components:

Database configuration
B@/u01/oracle> srvctl config database -d DB
Database unique name: DB
Database name: DB
Oracle home: /u01/oracle/product/11.2.0.3
Oracle user: oracle
Spfile: +DATA/DB/spfileDB.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: dev
Database instances: 
Disk Groups: DATA,FLASH
Mount point paths: 
Services: DB_srv
Type: RAC
Database is policy managed
Database status
B@/u01/oracle> srvctl status database -d DB
Instance DB_2 is running on node B
Instance DB_1 is running on node A
Server Pool configuration
B@/u01/oracle> srvctl config srvpool -g dev
Server pool name: dev
Importance: 0, Min: 0, Max: 2
Candidate server names: A,B
Service Configuration
B@/u01/oracle> srvctl config service -d DB
Service name: DB_srv
Service is enabled
Server pool: dev
Cardinality: SINGLETON
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 10
TAF failover delay: 2
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition: 
Service is enabled on nodes: 
Service is disabled on nodes:
Service status BEFORE one of the instances is down
B@/u01/oracle> srvctl status service -d DB
Service DB_srv is running on nodes: A
Service status AFTER instance on A is shut down
B@/u01/oracle> srvctl status service -d DB
Service DB_srv is not running.
Tnsnames entry
DB_srv =
  (DESCRIPTION =
    (ADDRESS =
     (PROTOCOL = TCP)
     (HOST = cluster.dev.sabre.com)
     (PORT = 1521)
    )
     (CONNECT_DATA =
      (SERVICE_NAME = DB_srv)
     )
  )
Let me know if you need any other details.
Any help will be greately appreciated.
Thanks,
Alex.

Edited by: Actitud on Sep 19, 2012 9:26 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points