本文详细解析了使用SQL Plus客户端远程连接数据库实例时所需的两个关键条件：一是客户端侧的tnsnames.ora文件中必须定义与数据库监听器匹配的服务名；二是该服务名须在客户端侧的orcl TNS条目中被定义。文章来源于https://www.cnblogs.com/cnblogs5359/p/10783606.html。
choose two
Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance?
A) A service name must be defined to the listener that matches the service name in the orcl TNS entry.
B) An orcl TNS entry must be defined in the client-side tnsnames.ora file.
C) An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files.
D) The service name orcl must be defined to the listener.
E) An orcl TNS entry must be defined in the server-side tnsnames.ora file.
Answer：AB
(解析：远程连接，客户端需要配置tns，服务端要配置监听，而且对应的service要匹配。来自3组：1015267481)
扫一扫
254
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
