title: TNS-12541 :TNS :no listener
body: <p>I am newbie in oracle dba so need help that could meet my mind. I have installed my oracle 11gr2 database on virtual machine with OS OEL 5.7 and want to connect my this remote database with toad32bit. So i do follow some useful links and downloaded and installed <strong>win32_11gR2_client on OS windows 7 64bit</strong>. Besides try my best to follow the instructions my client is not able to connect with my remote oracle database.On client side working with cmd for tnsping sidname always get no tns listener with error as i mentioned above </p>
  
  <p><strong>brief descriptions</strong>
         LINUX MACHINE:</p>
  
  <p>listener.ora</p>
  
  <pre><code>LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
  )
  )
  ADR_BASE_LISTENER = /u01/app/oracle
  </code></pre>
  
  <p>tnsnames.ora</p>
  
  <pre><code>ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl.testdomain.com)
    )
   )
  </code></pre>
  
  <p>sqlnet.ora</p>
  
  <pre><code>NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
  ADR_BASE = /u01/app/oracle
  </code></pre>
  
  <p>lsnrctl status listener</p>
  
  <pre><code>Alias                     LISTENER
  Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  Start Date                03-FEB-2014 15:08:43
  Uptime                    0 days 1 hr. 32 min. 59 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
  Listener Log File         /u01/app/oracle/diag/tnslsnr/testhost/listener/alert/log.xml
  Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=1521)))
  Services Summary...
  Service "orcl.testdomain.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
  Service "orclXDB.testdomain.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
  The command completed successfully
  </code></pre>
  
  <p>lsnrctl service listener</p>
  
  <pre><code> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
   Services Summary...
   Service "orcl.testdomain.com" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
   Handler(s):
   "DEDICATED" established:0 refused:0 state:ready
   LOCAL SERVER
   Service "orclXDB.testdomain.com" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
   Handler(s):
   "D000" established:0 refused:0 current:0 max:1022 state:ready
   DISPATCHER &lt;machine: testhost.testdomain.com, pid: 5349&gt;
   (ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=13094))
   The command completed successfully
  </code></pre>
  
  <p>WINDOWS 7 CLIENT DESCRIPTION
      C:\oracle\product\11.2.0\client_1\network\admin
      ENV TNS_ADMIN=C:\oracle\product\11.2.0\client_1\network\admin</p>
  
  <p><strong>NOTE: THERE IS NO ANY ORACLE RELATED SERVICES PRESENT (<em>MEANS NOT PRESENT</em>) ON WINDOWS SERVICES</strong></p>
  
  <p>my client tnsnames.ora</p>
  
  <pre><code>ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl.testdomain.com)
     )
    )
  </code></pre>
  
  <p>C:\Users\farhan>tnsping orcl     (and the result is)</p>
  
  <pre><code>Used parameter files:
  C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
  
  Used TNSNAMES adapter to resolve the alias 
  Attempting to contact (DESCRIPTION = (ADDTESS_LIST = (ADDRESS - (PROTOCOL = TCP (HOST = 
  testhost.testdomain.com)(PORT = 1521))) (CONNECT_DATA= (SERVER = DEDICATIED) (SERVICE_NAME
  = orcl) (INSCTANCE_NAME = orcl) (GLOBAL_NAME = orcl.testdomain.com)(RDB_DATABSE =   orcl)) (TYPE_OF_SERVICE = dedicaated))
  TNS-12541 : TNS:no listener
  </code></pre>
  
  <p>cat /etc/hosts  (the result is)</p>
  
  <pre><code>      # Do not remove the following line, or various programs
        # that require network functionality will fail.
        #127.0.0.1              testhost.testdomain.com testhost localhost.localdomain localhost
        127.0.0.1               localhost.localdomain localhost
        #10.10.1.114             testhost.testdomain.com testhost
        192.168.0.103   testhost.testdomain.com testhost
        ::1             localhost6.localdomain6 localhost6
  </code></pre>
  
  <p>for further insturctions that i have asked to  post </p>
  
  <pre><code># netstat -an | grep 1521 | grep tcp | grep LISTEN
  tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      
  [root@testhost ~]# grep testhost /etc/hosts
  #127.0.0.1              testhost.testdomain.com testhost localhost.localdomain localhost
  #10.10.1.114             testhost.testdomain.com testhost
  192.168.0.103   testhost.testdomain.com testhost
  [root@testhost ~]# dig +short testhost.testdomain.com
  174.137.125.92
  </code></pre>