Click here to Skip to main content
12,240,300 members (54,141 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL Oracle Data
Hi all,

I am new at oracle and I am trying to connect to my local oracle database via using TOAD. In order to do that i need a tns file and listener file. But, I could not produce them. Please help me to get a sample tns and listener file and where I should put them.

Thanks in advance.
Posted 12-Jul-12 22:01pm
Edited 12-Jul-12 22:24pm
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Here sample with path. You need to map(port, service name, etc) it to your install and place them:
tnsnames.ora file:
# tnsnames.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
SampleConnectionName =
( DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = IT-PC)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = orcl)
 )
)

listner.ora file:
# listener.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
MyLISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
  )
)
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 13 Jul 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100