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

The following bit:

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?

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

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!