Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
The default location of tnsnames.ora file is %ORACLE_HOME%\network\admin on Windows Server 2003/2000/NT plateform and $ORACLE_HOME/network/admin under Unix environment. Net Service Name or tnsnames.ora file has to be created for each of the machines from where you want to launch any of Oracle’s client applications like SQL*Plus, OEM etc.
It’s very important point to note over here that the Net Service Name on
one machine (e.g. “asim”) needs not to be similar to the Net Service
Name on the other machine (e.g. lets suppose “cow”) although both Net
Service Names will resolves to the same Oracle database (e.g.
test.takveen).
You can connect to or manage multiple databases using OEM remotely. All
you need to do is to create the Net Service Name for each of the
databases you want to manage.
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: