1Z0-082 - Oracle Database Administration I Configuring Oracle Net Services Questions and Answers

Question 1

A client is attempting to connect to an Oracle database using the following connect string: `sqlplus scott/tiger@//dbhost:1527/orclpdb`. This connection attempt is failing. The administrator has verified the database is running and the listener on `dbhost` is configured to listen on port 1527 for the service `orclpdb`. Which Oracle Net naming method is being used, and what is the key benefit of this method?

Accepted Answer

Easy Connect (or Host Naming), which allows for simple TCP/IP connections without requiring a `tnsnames.ora` file.

Answer

The connect string syntax `//host[:port][/service_name]` is characteristic of the Easy Connect naming method. The primary advantage of this method is its simplicity; it eliminates the need for client-side configuration files like `tnsnames.ora` or directory server lookups for basic TCP/IP connections.

Question 2

A database administrator needs to ensure that clients resolve connect identifiers by first checking a local `tnsnames.ora` file, and if not found, then attempting to resolve using the Easy Connect naming method. Which parameter in the `sqlnet.ora` file should be configured to define this specific resolution order?

Accepted Answer

NAMES.DIRECTORY_PATH

Answer

The `NAMES.DIRECTORY_PATH` parameter in the `sqlnet.ora` file specifies the order of naming methods the client will use to resolve a connect identifier. To prioritize local naming followed by Easy Connect, this parameter should be set to `(TNSNAMES, EZCONNECT)`.

Question 3

You are troubleshooting a connection issue where a client receives an `ORA-12154: TNS:could not resolve the connect identifier specified` error. The client is configured to use the Local Naming method. Which of the following is the MOST likely cause of this error?

Accepted Answer

The net service name used in the connect string does not have a corresponding entry in the `tnsnames.ora` file.

Answer

The `ORA-12154` error specifically indicates that the client was unable to resolve the provided connect identifier (net service name) into a connect descriptor. When using the Local Naming method, this resolution is done via the `tnsnames.ora` file. The error means the alias is either missing from the file, the file cannot be found, or there is a syntax error in the file.

Question 4

Which two Oracle Net Services configuration files are primarily involved in a standard client-server connection using the Local Naming method?

Accepted Answer

`listener.ora` and `tnsnames.ora`

Answer

In a typical Local Naming scenario, the `tnsnames.ora` file on the client side is used to resolve the net service name into a connect descriptor (host, port, service name). The listener process on the server side reads its configuration from the `listener.ora` file to know which protocol addresses to listen on for incoming connection requests.

Question 5

A DBA is using the Oracle Net Manager (netmgr) graphical tool. Which of the following tasks can be accomplished using this utility?

Accepted Answer

Configuring listeners, naming methods, and network profiles.

Answer

Oracle Net Manager is a graphical utility specifically designed for configuring Oracle Net Services. Its primary functions include configuring listeners (`listener.ora`), naming methods like Local Naming (`tnsnames.ora`) and Directory Naming, and managing profile settings (`sqlnet.ora`).

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Configuring Oracle Net Services Questions and Answers