RAC 集群 连接的时候报错 ora-12541

首先 监听的信息

Listening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.21.205)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.21.206)(PORT=1521)))Services Summary...

oracle install_client配置的tns信息

racdb_test=  (DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=10.100.21.204)      (PORT=1521)    )    (CONNECT_DATA=      (SERVER=dedicated)      (SERVICE_NAME=orclprd)    )  )

可是在前端连接的时候，报错ora-12541

这里是rac集群环境，检测相关参数

  SQL> show parameter remote_listenerremote_listener            racdb-scan:1523

可见rac监听的端口是1523

racdb_test=  (DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=10.100.21.204)      (PORT=1523)    )    (CONNECT_DATA=      (SERVER=dedicated)      (SERVICE_NAME=orclprd)    )  )

按如下修改后，可以用scan-ip 去正常连接数据库了