Troubleshooting listener issues in RAC

The backup kept failing to make a connection to the database using EBR_RACDB tns string.
This was because the service was not activated in CRS stack. First create the service and
add the service as follows and this will resolve the issue.

run this command to see if all service is running.

$ORA_CRS_HOME/bin>crsstat -t

HA Resource Target State
------------------------------- --------- -----------------
ora.RACDB.RACDB1.RACDB1.srv ONLINE ONLINE on node1
ora.RACDB.RACDB1.cs ONLINE ONLINE on node1
ora.RACDB.RACDB1.inst ONLINE ONLINE on node1
ora.RACDB.RACDB2.RACDB2.srv ONLINE ONLINE on node2
ora.RACDB.RACDB2.cs ONLINE ONLINE on node2
ora.RACDB.RACDB2.inst ONLINE ONLINE on node2

If any of the above services appear offline or doesnt appear at all. Then add the services to the CRS stack and start the services.

srvctl add service -d RACDB -s RACDB1 -r RACDB -a RACDB1 -P NONE

srvctl start service -d RACDB -s RACDB1 -i RACDB1

srvctl add service -d RACDB -s RACDB2 -r RACDB -a RACDB2 -P NONE

srvctl start service -d RACDB -s RACDB2 -i RACDB2

Once all the services are up and running check the connectivity.

node1:RACDB:/ora/admin>rman target ebr@ebr_RACDB

node1:RACDB1:/ora/admin>rman target ebr@EBR_RACDB

Recovery Manager: Release 10.2.0.3.0 - Production on Tue Feb 16 20:51:33 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

target database Password: <-- feed it with the password
connected to target database: RACDB (DBID=1894566972)