Database Reference
In-Depth Information
tools require Net Service Name or Connect Sting or in other
words tnsnames.ora file. This way of name resolution of Oracle
server is called “Local Naming” method. This is highly
recommended by Oracle and widely used all over the world.
There are other ways too e.g. Directory Naming, Easy Connect
Naming and External Naming. The preconfigured Oracle
database uses local naming and only this form is used is this
topic.
Host naming method requires the existence of external DNS
(Domain Name Server) where as Oracle Internet Directory is
advantageous when we are dealing with complex Oracle
networks having many Oracle Servers running.
In this topic we have used the local naming method as it's widely
used.
Creation of listener.ora file and starting/making sure listener
process is running is mandatory on the server end whereas on the
client side creating tnsnames.ora file is mandatory. Before
starting configuring server and client side Oracle Net make sure
to ping the server using the following command.
Ping <ip address of Oracle Server>
This command is equally good for Unix as well as windows
environments. If you are running or using external DNS
(Domain Name Server) then you can use domain name instead of
ip address of the machine.
Search WWH ::
Custom Search