Startup a policy managed database fails with CRS-2643

Setup :  RAC database : 12.1  CRS : 12.1

[grid@gract1 gpnpd]$  srvctl start  database -d gract1
PRCR-1079 : Failed to start resource ora.gract1.db
CRS-2643: The server pool(s) where resource 'ora.gract1.db' could run have no servers

Check the pool our datbase is connected to: 
[grid@gract1 gpnpd]$ srvctl config database -d gract1
Database unique name: gract1
Database name: gract1
Oracle home: /u01/app/oracle/product/121/racdb
Oracle user: oracle
Spfile: +DATA/gract1/spfilegract1.ora
Password file: +DATA/gract1/orapwgract1
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 12c_pool
Database instances: 
Disk Groups: DATA
Mount point paths: 
Services: pdb_s1
Type: RAC
Start concurrency: 
Stop concurrency: 
Database is policy managed
--> Database is attached to 12c_pool

Check  server pool setup
[grid@gract1 gpnpd]$ srvctl status serverpool -detail
Server pool name: Free
Active servers count: 0
Active server names: 
Server pool name: Generic
Active servers count: 0
Active server names: 
Server pool name: 12c_pool
Active servers count: 0
Active server names: 
Server pool name: NEW_12c_pool
Active servers count: 1
Active server names: gract1
NAME=gract1 STATE=ONLINE
--> 12c_pool doesn't have any active server

Relocate database to the NEW_12c_pool 
[grid@gract1 gpnpd]$ srvctl modify database -d gract1 -g NEW_12c_pool
[grid@gract1 gpnpd]$ srvctl config database -d gract1
Database unique name: gract1
Database name: gract1
Oracle home: /u01/app/oracle/product/121/racdb
Oracle user: oracle
Spfile: +DATA/gract1/spfilegract1.ora
Password file: +DATA/gract1/orapwgract1
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: NEW_12c_pool
Database instances: 
Disk Groups: 
Mount point paths: 
Services: pdb_s1
Type: RAC
Start concurrency: 
Stop concurrency: 
Database is policy managed

Verify that database is started an available in gract1
[grid@gract1 gpnpd]$ ps -elf | grep smon
0 S oracle   17516     1  0  80   0 - 406310 semtim 12:49 ?       00:00:00 ora_smon_gract1_1
[root@gract1 Desktop]#  srvctl status database -d gract1
Instance gract1_1 is running on node gract1

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>