Home » RDBMS Server » Networking and Gateways » Understanding tnsnames.ora file (Oracle 8i, Win 2000)
Understanding tnsnames.ora file [message #304417] |
Wed, 05 March 2008 01:55  |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
Hi,
I need help understanding this tnsnames.ora file.
# C:\ORACLE\ORA92\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
PRO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.143)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pro)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.169)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TO116 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.116)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
TO115 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.116)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
TO23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.23)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
What I understand from this is..
- PRO is the SID_NAME used on the local machine.
- TO23, TO115, TO116 are service names that can access the database from outside
- If I am logged in the computer where the RDBMS is installed and no external connections are going to connect the database then I just need the first part of this file which allows the local service (PRO) to access the database. The rest can be deleted
Please let me know if your views are conflicting
- Das
|
|
|
|
Goto Forum:
Current Time: Sat May 03 05:16:19 CDT 2025
|