Skip to Main Content

Oracle Database Discussions

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!

Policy managed database - No servers in the server pool where db is there.

654755Aug 28 2010 — edited Mar 11 2011
Hi ,
I have created Administrator managed real application cluster database and the database is runniing fine .Then i stoppped that database and created one Policy managed database on the same setup. When i am trying to start the policy manages database i have got the following error.

# ./srvctl start database -d polidb
PRCR-1079 : Failed to start resource ora.polidb.db
CRS-2643: The server pool(s) where resource 'ora.polidb.db' could run have no servers
#

When i tried to move the server to the pool (raja) where my database is installed , i am getting the following error.

# ./srvctl relocate server -n veyron,skyline -g ora.raja
PRCR-1114 : Failed to relocate servers veyron,skyline into server pool ora.raja
CRS-0217: Could not relocate resource 'skyline'.
CRS-0217: Could not relocate resource 'veyron'.

Currently the servers are in Generic pool.

# ./srvctl status srvpool
Server pool name: Free
Active servers count: 0
Server pool name: Generic
Active servers count: 2
Server pool name: raja
Active servers count: 0

Any idea why i am getting this error. Please note that ocr and voting disks are in ASM . Could any one please tell me how to move the server to the pool (raja) ?

Below is the crs_stat -t output.

# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE skyline
ora...._DG1.dg ora....up.type OFFLINE OFFLINE
ora...._DG2.dg ora....up.type OFFLINE OFFLINE
ora....ER.lsnr ora....er.type ONLINE ONLINE skyline
ora....N1.lsnr ora....er.type ONLINE ONLINE veyron
ora.asm ora.asm.type ONLINE ONLINE skyline
ora.eons ora.eons.type ONLINE ONLINE skyline
ora.filedb.db ora....se.type OFFLINE OFFLINE
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE skyline
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE skyline
ora.polidb.db ora....se.type OFFLINE OFFLINE
ora.scan1.vip ora....ip.type ONLINE ONLINE veyron
ora....SM2.asm application ONLINE ONLINE skyline
ora....NE.lsnr application ONLINE ONLINE skyline
ora....ine.gsd application OFFLINE OFFLINE
ora....ine.ons application ONLINE ONLINE skyline
ora....ine.vip ora....t1.type ONLINE ONLINE skyline
ora....SM1.asm application ONLINE ONLINE veyron
ora....ON.lsnr application ONLINE ONLINE veyron
ora.veyron.gsd application OFFLINE OFFLINE
ora.veyron.ons application ONLINE ONLINE veyron
ora.veyron.vip ora....t1.type ONLINE ONLINE veyron
#
#

Thanks
TMR
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2011
Added on Aug 28 2010
3 comments
2,948 views