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