TNS-12541 :TNS :no listener / client

M.Farhan · 02-07-2014, 07:20 AM

Hi!
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 win32_11gR2_client(32bit) on OS windows 7 64bit. Besides this I trie 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. For further to make ease for you to understand my problems let my briefly post some useful works that I have done

CONFIGURATION ON LINUX

listener.ora

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

tnsnames.ora

Code:

ORCL =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl.testdomain.com)
  )
 )

sqlnet.ora

Code:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle

lsnrctl status listener

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

lsnrctl service listener

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 <machine: testhost.testdomain.com, pid: 5349>
 (ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=13094))
 The command completed successfully

#cd /etc/hosts

Code:

# Do not remove the following line, or various programs
      # that require network functionality will fail.
      127.0.0.1       localhost.localdomain localhost
      192.168.0.107   testhost.testdomain.com testhost
      ::1             localhost6.localdomain6 localhost6

# netstat -an | grep 1521 | grep tcp | grep LISTEN

Code:

tcp        0      0 0.0.0.0:1521

0.0.0.0:* LISTEN

# grep testhost /etc/hosts

Code:

192.168.0.107   testhost.testdomain.com testhost

# dig +short testhost.testdomain.com

Code:

174.137.125.92

CLIENT SIDE DESCRIPTION (WINDOWS 7)

Code:

C:\oracle\product\11.2.0\client_1\network\admin

ENV

Code:

TNS_ADMIN=C:\oracle\product\11.2.0\client_1\network\admin

client tnsnames.ora

Code:

ORCL =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl.testdomain.com)
   )
  )

Now! further when I hit command of ' netstat ' on windows cmd line there is no such port(1521) or IP(192.168.0.107) that shows the result for my, the mentioned oracle server. Also my both machines are pinging perfectly fine. My server machine (OEL 5.7) and client machine (windows 7) are running on the same laptop i.e my server is running on VMworkstation 10.
IP client windows 7: 192.168.0.100
IP server linux : 192.168.0.107

The error that I always received by my client side is

C:\Users\farhan>tnsping orcl

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

PLZ Help me to solve this problem here.
thanks in advance

NOTE: THERE IS NO ANY ORACLE RELATED SERVICES PRESENT (MEANS NOT PRESENT) ON WINDOWS SERVICES

Habitual · 02-11-2014, 11:50 AM

While it's been a "few years" since I've dealt with Oracle and Windows oracle client tools,
Shouldn't orcl.testdomain.com be testhost.testdomain.com in the Windows tnsnames.ora file?