iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Fundamentals II

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 |

 

Lesson 28

"Never believe that a few caring people can't change the world. For, indeed, that's all who ever have." -Margaret Mead

 

Read first then play the video:

   DBA-VIDEO -Configuring a Service Name using the Net Manager Tool

   

Configuring a Service Name using the “Net Manager” tool

Introduction

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

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:

 

1. Adding a service name

2. Modifying a service name

3. Configuring a service name

4. Testing a service name

 

The second important element on the Oracle Network Configuration is a file called TNSNAMES.ORA. This is one of Oracle net work technique to connect clients to the database server.

Go to Start > Programs > Oracle Home > Configuration and Migration Tools >, then select the Net Manager option.

In the Oracle Net Configuration section, expand the Local item. In the Local item, you can create, delete, or change a database default user profile, service naming, and listeners.

 

List all Service Names

Click on the ‘+’ sign next to the ‘Service Naming’ item. This will list all of the Service Name in the TNSNAMES file. A Service Name tells PC client where your database server is, what type of protocol to use, and what port the listener is using.

 

Create a Service Name

To create a Service Name, highlight the Service Naming item and then click on the Green ‘+’ sign (Create icon). In the ‘Net Service Name Wizard: Welcome’ window, type your net service name (myaccess). Click Next.

 

Changing Protocol

In the Protocol window, select TCP/IP (Internet Protocol) option and click Next.

In the Protocol Setting window, enter your server name if it was defined in the Domain Server Name or its IP address. Type also its port number that the listener is using such as 1521. And then click Next.

 

Database Connection Type

In the Service window, type your instance name and make your connection type as a dedicated server. Use dedicated server if you don’t have so many connection at the same time. Use the share server or MTS (Multi-Threaded Server) if you have a lots of user accessing to your database at one given time. Click Next.

 

Test Connection

Click on the Test button to test the connection. If failed check the userid and password. To change the userid and password, you should click on the ‘Change Login’ push button on the window. Type the right userid and password (SYSTEM/MANAGER) and click OK to close the window. In the Connection Test window, click on the ‘Test’ button again. If your user id or your net work configuration parameter were right, then you get ‘The connection test was successful.’

Then Close the window and click ‘Finish.’ Notice that the ‘MYACCESS’ service name was added to the list of Service Name.

If you go and open your tnsnames.ora file you should be able to see the new entry (MYACCESS) in the file.

Open the MS explorer and check the file in (%ORACLE_HOME.ORA

 

"Once you get into this great stream of history, you can't get out." -Richard Milhous Nixon

 

Questions:

Q: How do you add a service name using the Net Manager tool?

Q: How do you modify a service name the Net Manager tool?

Q: How do you test a service name using the Net Manager tool?