Database - RAC/Scalability (MOSC)

MOSC Banner

setup dbcontrol for rac in 11.2.0.3 cannot to instances with error: ORA-12505: TNS:listener does not

edited Dec 18, 2013 3:25AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
Hi,

We have a cluster of 3 nodes in Linux 5.6 at 11.2.0.3.5.

There are several  databases running in the cluster and SCAN is up and running.

We are trying to setup the dbcontrol for RAC databases with emca.

Although the setup seems successful but the instances cannot be displayed.

When I went troubleshoot with the log in $ORACLE_HOME/host_uniquename/sysman/log/emagent.trc, I saw the folowing error:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor on the sql statement:

dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-vip)(PORT=1521))(CONNECT_DATA=(SID=POC_RAC3)))

It kind of surprise me that the agent use the host-vip  instead of the scan_ip to make the connection.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center