TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Cause: The listener was not configured with a default service and SERVICE_NAME was missing from the CONNECT_DATA received by the listener.
Action: Possible solutions are:
- Configure DEFAULT_SERVICE parameter in LISTENER.ORA with a valid service name. Reload the listener parameter file using reload []. This should be done by the LISTENER administrator.

- If using a service name, Check that the connect descriptor corresponding to the service name in TNSNAMES.ORA has a SERVICE_NAME or SID component in the CONNECT_DATA.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

TNS-12504：TNS：侦听器未在CONNECT_DATA中授予SERVICE_NAME,
.原因：侦听器未配置默认服务，并且侦听器收到的CONNECT_DATA中缺少SERVICE_NAME。,
.行动：可能的解决办法是：,
.- 使用有效的服务名称在LISTENER.ORA中配置DEFAULT_SERVICE参数。使用reload []重新加载侦听器参数文件。这应由LISTENER管理员完成。,
.,
.- 如果使用服务名称，请检查与TNSNAMES.ORA中的服务名称相对应的连接描述符在CONNECT_DATA中具有SERVICE_NAME或SID组件。,
.,
.

aiaiDBA

13718043309

010-86462881

TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

1 个回答

相似问题