首先 监听的信息
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_listener
remote_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 去正常连接数据库了