LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 05-20-2004, 10:42 AM   #1
hpmface
LQ Newbie
 
Registered: May 2004
Posts: 2

Rep: Reputation: 0
Unhappy tnsping : TNS-12541: TNS: no listener


Hi all, i have a problem to connect to a oracle database instance with my client.

client OS = Fedora core 1 with oracle 10g client
server OS = HP UX.

between client and server there is a firewall and other server HPUX

i configured tnsnames.ora and sqlnet.ora on client

i know for connect my oracle client to the database server i need to open an ssh connection forward ports

this is my ssh connection string:

ssh -A1 -t fwuser@firewall ssh -A -g -L 1551:server1:1551 -t server1user@server1 ssh -A -g -L 1551:dbserver:1521 -t oracle@dbserver

this connection works....makes a connect to db server but i don't know if port forwarding works ..

after this , (like oracle user) on client i try tnsping and i receive this reply :


#############
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1551))
(CONNECT_DATA=(SERVICE_NAME=DB)(CID=(PROGRAM=)
(HOST=cerliani)(USER=oracle))))

VERSION INFORMATION:
TNS for Linux: Version 10.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.1.0.2.0 - Production
Time: 20-MAY-2004 16:06:06
Tracing to file: /home/oracle/product/10g/network/log/conn.log_17364.trc
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0

#############

can anyone help me ?

thanks in advance.

FAB
 
Old 05-20-2004, 05:52 PM   #2
Capt_Caveman
Senior Member
 
Registered: Mar 2003
Distribution: Fedora
Posts: 3,658

Rep: Reputation: 57
Not a security question. Moving thread to Linux - Networking.
 
Old 05-21-2004, 10:53 PM   #3
mieslep
LQ Newbie
 
Registered: May 2004
Location: Minneapolis, USA
Distribution: Mandrake 10CE
Posts: 19

Rep: Reputation: 0
Re: tnsping : TNS-12541: TNS: no listener

The following bit:

Quote:
Originally posted by hpmface

Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1551))
(CONNECT_DATA=(SERVICE_NAME=DB)(CID=(PROGRAM=)
(HOST=cerliani)(USER=oracle))))
says to me that you're trying to connect to a TNS listener on your localhost. What is the exact syntax of "tnsping" that you're running, and can you put a copy of the corresponding tnsnames.ora entry?
 
Old 05-31-2004, 07:55 AM   #4
hpmface
LQ Newbie
 
Registered: May 2004
Posts: 2

Original Poster
Rep: Reputation: 0
this is the entry in tnsnames.ora :

PIPPO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 127.0.0.1)
(PORT = 1551))
)
(CONNECT_DATA =
(SERVICE_NAME = PIPPO)
)
)



i try this command :

tnsping PIPPO
 
Old 05-31-2004, 12:38 PM   #5
mieslep
LQ Newbie
 
Registered: May 2004
Location: Minneapolis, USA
Distribution: Mandrake 10CE
Posts: 19

Rep: Reputation: 0
I think you have two problems:

1. Your local (client) tnsnames.ora thinks that PIPPO is running on your local machine (host = 127.0.0.1 means localhost). So you need to specify the host where the database (and listener) reside.

2. You're doing this over a firewall. You have a listener running on port 1521 but are using 1551 in your tnsnames.ora.

If you have other Oracle clients on the non-trusted network then maybe you just need to fix the hostname. If that doesn't work, then you've a more challenging problem.

If you have control over your client's network location in respect to the firewall, then put it on the server (secure) side of the firewall, change your hostname, and change the port to 1521.

This will test your Oracle-side configuration, without the complication of your firewall. Once you get tnsping to work from there, move your client back to the non-secure side.

You may need to update your port back to 1551, but there's not enough information on your post to comment about firewall, port-forwarding, port-tunneling, or anything else along these lines.

Good luck!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard (xkb) listener eantoranz Linux - Software 3 01-01-2006 01:00 AM
TNS: lost contact jerrymei Linux - Software 0 05-26-2004 03:58 AM
smtp listener (sendmail) nabil_boussetta Linux - Networking 4 03-13-2004 10:45 PM
SQLPLUS and TNS Listner PROBLEM cyrilbritto Linux - General 2 08-19-2003 02:50 AM
RIP listener for Linux rodda Linux - Networking 1 02-06-2003 03:21 AM


All times are GMT -5. The time now is 05:34 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration