ORA-12514 with CMAN
- From: "Martin Bach" <development@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2011 17:04:02 +0100
Dear all,
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@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
Other related posts:
- » ORA-12514 with CMAN - Martin Bach
