The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）

A、The listener is not running on the database node.

B、The TNS_ADMIN environment variable is set to the wrong value.

C、The orcl.oracle.com database service is not registered with the listener.

D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E、The listener is running on a different port.

查看正确答案

更多“The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）”相关的问题

第1题

[单选题] 客户端用于网络连接的两个配置文件文件是（）

A、TNSNAMES.ORA和SQLNET.ORA B、TNSNAMES.ORA和LISTENER.ORA C、TNSNAMES.ORA和INIT.ORA D、SQLNET.ORA和LISTENER.ORA E、INIT.ORA和LISTENER.ORA

点击查看答案

第2题

[单选题] Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）

A、Listener.ora B、Tnsnames.ora C、Cman.ora D、Sqlnet.ora

点击查看答案

第3题

[多选题] 升级前，备份的ORACLE的参数文件有（）

A、initomc.ora B、init.ora C、tnsnames.ora D、tnsname.omc

点击查看答案

第4题

[单选题] Which of the following files can be used to configure connection pooling in the shared server environment？（）

A、INIT.ORA B、SQLNET.ORA C、TNSNAMES.ORA D、SERVICES.ORA E、LISTENER.ORA

点击查看答案

第5题

[单选题] Which of the following file should be configured for dynamic service registration？（）

A、LISTENER.ORA B、SQLNET.ORA C、INIT.ORA D、TNSNAMES.ORA

点击查看答案

第6题

[] When you use the Oracle Net Configuration Assistant to specify the naming method， which file is updated？（）

A、A.INIT.ORA B、B.SQLNET.ORA C、C.LISTENER.ORA D、D.TNSNAMES.ORA

点击查看答案

第7题

[单选题] A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect， it receives a TNS error. By carefully examining the environment， a tnsnames.ora is found only on the Oracle server machine， among other things. After copying this tnsnames.ora onto the client machine， the client is able to connect to the server. Which statement is true？（）

A、tnsnames.ora must be on the client machine for local naming. B、tnsnames.ora must be removed from the server for the connection to work. C、tnsnames.ora must be on both the client and server machines for local naming. D、tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.