we have single instance db01 and standby db02. we don't have any entries in our listener.ora
getting
Command SWITCHOVER TO DB01 completed
07/17/2015 09:54:54
Failed to connect to remote database DB02. Error is ORA-12514
Failed to connect to remote database DB02. Error is ORA-01034
07/17/2015 09:54:58
PING[ARC2]: Heartbeat failed to connect to standby 'DB02'. Error is 12537.
*** 2015-07-12 11:51:29.339 2932 krsi.c
we have services select * from dba_services;
DB service primary DB01 standby DB02
also have service DBXDB
our StaticConnectIdentifier
EDIT DATABASE DB02 SET PROPERTY StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=666.6.6.666)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB02)(INSTANCE_NAME=DB02)(SERVER=DEDICATED)))
Command EDIT DATABASE DB02 SET PROPERTY StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=16666.666.666)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB02)(INSTANCE_NAME=DB02)(SERVER=DEDICATED))) completed
07/11/2015 22:17:18
EDIT DATABASE DB01 SET PROPERTY StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1666.6.666.666)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB01)(INSTANCE_NAME=PROD)(SERVER=DEDICATED)))
Command EDIT DATABASE DB01 SET PROPERTY StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1666.6.666.666)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB01)(INSTANCE_NAME=PROD)(SERVER=DEDICATED))) completed
shound the service name above be the service name of the Data Broker:DBXDB service rather than the service name of the database