Hands-On 11 (Configuring a Service Name using the “Net Manager” tool)

As a DBA, you are also responsible for configuring a Service Name using the “Net Manager” tool.  Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Adding a service name

Modifying a service name

Configuring a service name

Testing a service name

Hands-On 11 (Configuring a Service Name using the "Net Manager" tool)
Description:

In this exercise you will learn how to add, modify, view or configure
a Service Name using the "Net Manager" tool. You will also learn how
to test the service name.

--Start

Expand the "Service Name" item.

==
Expand the "Listeners" item.

==
Highlight "Service Naming" and click on the CREATE icon.

==
Enter the new Service Name and click NEXT.

==
Choose the protocol used for the database and click NEXT.

==
Enter the IP address or hostname of the machine that you have 
the listener on with its port number and click NEXT.

==
Enter the database service name with the Dedicated Server 
connection type and then click NEXT.

==
Click on the "Test" button to test the database access.

==
The test was not successful. There is no SCOTT user in the database.
Click on the "Change Login" to change the username and password.

==
Login as the system user and click Okay again.

==
Then repeat the database access test.
The test was successful.
Close the window.

==
Click on the Finish button.

==
As you can see it is very easy to add, modify and configure 
your TNS name.

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!