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 Go to next message
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
Re: Understanding tnsnames.ora file [message #304525 is a reply to message #304417] Wed, 05 March 2008 08:57 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>If I am logged in the computer where the RDBMS is installed

From http://www.orafaq.com/forum/m/304355/74940/#msg_304355

search for Configuring listener manually [message #304350 is a reply to message #304307 ]


Asking the same question multiple times, will get you the same answer.
Previous Topic: Configuring listener manually
Next Topic: Listener problem
Goto Forum:
  


Current Time: Wed Apr 24 15:45:10 CDT 2024