Jairam wrote:Have a look at http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] - Help! I can’t connect to my database
As you said I ran lsnrctl version command and found that the listener is running on different oracle version on the same server.It's working fine after setting the environment variables properly.,
But I have a problem while connecting the database from a remote server. The oracle version in remote server is 10.2.0.5 and the source DB version is 18.104.22.168
(But the listener is running in 10.1.0.3 version on source server).,While checking the tnsping from target server I got the error as "TNS-12541: TNS:no listener"
$ tnsping test
TNS Ping Utility for HPUX: Version 10.2.0.5.0 - Production on 18-JAN-2013 07:59:54
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = abcd)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test)))
TNS-12541: TNS:no listener