ORA-12514 with CMAN

I have quite a specific problem, for which I'm hoping you may have the solution.  

I have implemented CMAN 11.2 on SPARC and would like to duplicate a database "from active database". For this to work (without CMAN) you need to statically register target and auxiliary with their listeners. So you'd have a SID_LIST_LISTENER similar to this:  

LISTENER= (DESCRIPTION=   (ADDRESS_LIST=    (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.225)(PORT=1521))   )

)    

SID_LIST_LISTENER= (SID_LIST=   (SID_DESC=    (SID_NAME=cmandb)

   (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

  )

)  

This works on the local host-I can connect as sysdba via NET*8 even if the instance is down and start/stop it. However I cannot connect via CMAN, and it's quite clear as to why. If my database CMANDB is up, I see it on the CMAN host:  

[oracle_at_cman trace]$ cmctl  

CMCTL for Linux: Version 11.2.0.2.0 - Production on 21-JUL-2011 16:57:09  

Copyright (c) 1996, 2010, Oracle. All rights reserved.  

Welcome to CMCTL, type "help" for information.  

CMCTL> administer cman1

Current instance cman1 is already started

Connections refer to
(address=(protocol=tcp)(host=192.168.99.224)(port=1821)).

The command completed successfully.

CMCTL:cman1> show service

Services Summary...

Proxy service "cmgw" has 1 instance(s).

  Instance "cman", status READY, has 2 handler(s) for this service...

    Handler(s):

"cmgw001" established:20 refused:0 current:0 max:256 state:ready

         <machine: 127.0.0.1, pid: 2298>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=23589))

"cmgw000" established:22 refused:0 current:0 max:256 state:ready

         <machine: 127.0.0.1, pid: 2294>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=31911))

Service "cmandb" has 1 instance(s).

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

    Handler(s):

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

         REMOTE SERVER   (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=192.168.100.225))) Service "cmon" has 1 instance(s).

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

    Handler(s):

"cmon" established:4 refused:0 current:1 max:4 state:ready

         <machine: 127.0.0.1, pid: 2282>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59541))

The command completed successfully.  

As soon as the instance is down, this entry disappears:  

CMCTL:cman1> show service

Services Summary...

Proxy service "cmgw" has 1 instance(s).

  Instance "cman", status READY, has 2 handler(s) for this service...

    Handler(s):

"cmgw001" established:20 refused:0 current:0 max:256 state:ready

         <machine: 127.0.0.1, pid: 2298>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=23589))

"cmgw000" established:22 refused:0 current:0 max:256 state:ready

         <machine: 127.0.0.1, pid: 2294>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=31911))

Service "cmon" has 1 instance(s).

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

    Handler(s):

"cmon" established:4 refused:0 current:2 max:4 state:ready

         <machine: 127.0.0.1, pid: 2282>

         (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59541))

The command completed successfully.  

Does anyone have a suggestion how to "statically" register the database with connection manager? I tried google and MOS but drew a blank. I also have an SR open but little hope as always.  

Thanks for any pointers,  

Martin

--
http://www.freelists.org/webpage/oracle-l