OraFAQ Forum: Networking and Gateways » accessing oracle behind firewall (ora-12541 no listener error)

Home » RDBMS Server » Networking and Gateways » accessing oracle behind firewall (ora-12541 no listener error)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

accessing oracle behind firewall (ora-12541 no listener error) [message #123211]

Fri, 10 June 2005 09:56

bertvk
Messages: 3
Registered: June 2005
Location: Assen

Junior Member

Hello,

I've got an oracle server running on our intranet. It's working fine so no problems there.

No I want to access this server from outside our company.
We've got the following setup:

computer outside: ip: aaa.aaa.aaa.aaa

Firewall ip: bbb.bbb.bbb.bbb

oracle server: 172.ccc.ccc.ccc.

all traffic from aaa to bbb on all ports is forwarded to the oracle server: 172.ccc

I've got the computer outside setup in tnsnames.ora to connect to computer bbb.bbb

When I try to connect to oracle from computer outside I get the ora-12541 no listener error. The listener is running because inside the company everyone can connect.

What should I do?

Regards,
Bert van Kammen

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #123215 is a reply to message #123211]

Fri, 10 June 2005 10:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Can you ping the server from outside?
if yes then
Make sure the concerned listener port is open from outside.
or the problem might be with ipredirection.
What kind of OS is on the server?
if windows , set the registry settting USE_SHARED_SOCKET = TRUE and bounce the server. try again.

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #123245 is a reply to message #123215]

Fri, 10 June 2005 14:50

bertvk
Messages: 3
Registered: June 2005
Location: Assen

Junior Member

I can't ping the server, but that's because the firewall or our router is denying it.

We made a forwarding rule in the firewall that routes all
the traffic from outside from my ip to the database server.

I don't know the OS but will check this on monday. Will try the registry setting also.

Thanks for the reply.

By the way: did you do some work for the missing link about two years ago?

Regards,
Bert van Kammen

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #123247 is a reply to message #123245]

Fri, 10 June 2005 15:07

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I can't ping the server, but that's because the firewall or our router is denying it.
Now That is pretty much an OS/FIREWALL/NETWORK issue.
you need to resolve this first!.

>>By the way: did you do some work for the missing link about two years ago?

I am sorry. I have no idea what you are talking about.

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #123249 is a reply to message #123247]

Fri, 10 June 2005 15:14

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Well ping may be blocked on firewall/router level...

Do check for the response on listener specific ports from your machine.
Default port is 1521 (unless listener is configured to run on other ports)
Check for these ports by telneting them or using some port scanning utility like nmap.

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #123250 is a reply to message #123247]

Fri, 10 June 2005 15:46

bertvk
Messages: 3
Registered: June 2005
Location: Assen

Junior Member

I should have been more specific. Ping request are denied. I can reach the server.

Did in fact a port scan (thanx for the tip) and it seems like that the forwarding rule doesn't work. I will contact the network administrator on monday and hope he can help.

Thanks for the response.

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #133986 is a reply to message #123250]

Tue, 23 August 2005 01:28

twerth
Messages: 1
Registered: August 2005

Junior Member

Hi!

We have exactly the same problem as you described here.

Did you find a solution for this?

Thx

Report message to a moderator

Re: accessing oracle behind firewall (ora-12541 no listener error) [message #134053 is a reply to message #133986]

Tue, 23 August 2005 07:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Is there a firewall involved in the windows machine?
set USE_SHARED_SOCKET=TRUE registry setting and reboot.
try again.

Report message to a moderator

Previous Topic:	SQL Loader Return Codes
Next Topic:	Listener doesn't start (Oracle 9.2.0.5, Solaris 9)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 14:45:16 CDT 2025