"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?
|