Database Reference
In-Depth Information
the tree on the left pane of ONM. ONM creates/updates the
tnsname.ora file every time you make a change in Net Service
Name configuration and click on “Save Network Configuration”
under “File” menu. The default location of tnsnames.ora file is
%ORACLE_HOME%\network\admin on Windows Server
2003/2000/NT platforms and
$ORACLE_HOME/network/admin under UNIX environment.
It's very important point to note here that the Net Service Name
on one client machine (e.g. “fan”) needs not to be similar to the
Net Service Name on the other client machine (e.g. “cow”) but
they both can resolve to the same Oracle database server (e.g.
takveen).
Why & when we need Net Service Name (or Oracle Net
client side installation and configuration)?
Just to access Oracle Enterprise Manager Database Control, you
need not to have tnsnames.ora file created on the machine from
where you want to use the Oracle Enterprise Manager Database
Control. Oracle Enterprise Manager Database Control has a web-
interface and can be accessed from anywhere using any Internet
Browser e.g. Opera, FireFox, Internet Explorer etc.
Then why we need Net Service Name? My answers is, whenever
you want to use SQL*Plus, MS Access etc. to connect to Oracle
Database Server either on the same machine where you have
Oracle Database Server or from a different machine located in
different part of the world; you need to install Oracle Net and
configure it for client side i.e. to create tnsnames.ora file.
Starting Oracle Enterprise Manager Database Control
In order to access the Oracle Enterprise Manager Database
Control from a client browser, the dbconsole process has to be
running on the server. Usually, the process starts automatically
after the installation but in case if the process fails or there is a
Search WWH ::
Custom Search