.

.

Choose General Parameters from the drop down and you will see following screen.

Let the default values in this screen.

Click on ‘Logging & Tracing’ tab and you will see following screen.

You can enable the tracing and logging for the database transactions and would be required to provide the files to store the logs or traces.

Click on ‘Authentication’ tab and you will see following screen. You can set the password for listener related operations in this screen.

Choose Database Services from Dropdown and you will see following screen.

Give the Global Database Name , SID and Oracle Home Directory to configure the database service for the Listener. Save the information and your listener is created and configured. You can change any of the listener’s parameters through oracle net manager.

Use TNSPING to test Oracle Net connectivity

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.

1. Open Command prompt.
2. Write tnsping < SID for the database connectivity you want to check >
3. If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.
4. If you get “TNS-03505: Failed to resolve name” message then tnsping utility is not able to resolve the service name and you need to check the SQLNET.ora and TNSNAMES.ora files on your machine.

Frequently Asked Questions

1. What all tasks can be performed using oracle net manager?

2. What is the use of tnsping utility?

3. How do you enable tracing or logging for a particular listener?

4. What is the significance of “TNS-03505: Failed to resolve name “ message from tnsping utility?

TrackBack URI for this entry

Comments (0)

Subscribe to this comment's feed

Show/Hide comments

Show/Hide comment form