|
|
Sponsored Content
Operating Systems
Solaris
Connect Oracle from NATted IP
Post 302237745 by skbpk_in on Thursday 18th of September 2008 09:27:12 AM
09-18-2008
Connect Oracle from NATted IP
We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X).
We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the sun server in connected.
we have one more sun solaris 9 server (say B), with oracle 9 installed and running, at another place (say Y) (approx 400 Kilo meters away). This "B" server is connected with "A" server through router => Leased Line > Router => LAN.
At one particular day we do NATting in such a way that the request to IP of "A" server was redirected to "B" server. During this period when we try to access the oracle or tnsping the oracle it says "TNS-12535: TNS
peration timed out". we tried to connect to the server "B" with oracle port 1521 from command prompt using telnet it says "Connecting To 'IP add of A server' ...Could not open a connection to host on port 1521 : Connect failed"
We contacted our network team to arrive at a solution. They have connected one separate switch for one windows client and the switch is connected through a separate modem and a separate ISDN line ("because we are on the same LAN connecting from separate line will solve the issue" told by our network team). But still we cannot connect to oracle from the application as well as through "sqlplusw".
If we remove the NAT and connect to the actual IP of server B from location X through telnet to oracle port 1521 it gets connected.
We don't have any firewall at both ends. Our network team says that all ports are open; nothing is blocked.
Please anybody provide a solution.
We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the sun server in connected.
we have one more sun solaris 9 server (say B), with oracle 9 installed and running, at another place (say Y) (approx 400 Kilo meters away). This "B" server is connected with "A" server through router => Leased Line > Router => LAN.
At one particular day we do NATting in such a way that the request to IP of "A" server was redirected to "B" server. During this period when we try to access the oracle or tnsping the oracle it says "TNS-12535: TNS
peration timed out". we tried to connect to the server "B" with oracle port 1521 from command prompt using telnet it says "Connecting To 'IP add of A server' ...Could not open a connection to host on port 1521 : Connect failed"We contacted our network team to arrive at a solution. They have connected one separate switch for one windows client and the switch is connected through a separate modem and a separate ISDN line ("because we are on the same LAN connecting from separate line will solve the issue" told by our network team). But still we cannot connect to oracle from the application as well as through "sqlplusw".
If we remove the NAT and connect to the actual IP of server B from location X through telnet to oracle port 1521 it gets connected.
We don't have any firewall at both ends. Our network team says that all ports are open; nothing is blocked.
Please anybody provide a solution.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am a new user, who wants to connect to oracle through shell scripting.
Can anybody help me?
Regards,
Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies
2. Shell Programming and Scripting
Hi Friends,
I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.
Could anyone pls let me know.
I've tried below command which i found in some website, But it throws some error.:confused:
Executed:
perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies
3. Shell Programming and Scripting
Hi All,
I am trying to connect oracle from unix mechine but i am getting an error like
Ksh: sqlplus: not found
Any one please tell me how to connect oracle from unix mechine.
I would appreciate if any one send the query.
Regards,
Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies
4. Shell Programming and Scripting
I want to use Perl to connect to a remote Oracle DB
I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server.
Is this possible?
I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies
5. Shell Programming and Scripting
Hello,
Returing to Unix scripts after a long while,
This might be a simple question for most of you ,
I need to connect from a .sh script to oracle, select XYZ.nextval from dual ,
, meaning either get the Current Val or Next Val for a sequence.
How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies
6. UNIX for Dummies Questions & Answers
In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies
7. Shell Programming and Scripting
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies
8. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
9. UNIX and Linux Applications
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
10. Shell Programming and Scripting
could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever.
requirement:
1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
LEARN ABOUT PHP
mongoconnectionexception
MONGOCONNECTIONEXCEPTION(3) 1 MONGOCONNECTIONEXCEPTION(3) The MongoConnectionException class INTRODUCTION
Thrown when the driver fails to connect to the database. There are a number of possible error messages to help you diagnose the connection problem. These are: o No candidate servers found Thrown when the driver cannot establish a connection to MongoDB (fulfilling the ReadPreferences, if specified). o No server name given. This error occurs if you pass in "" as the server name, probably because of an typo with string interpola- tion, e.g., "$servr" instead of "$server". o failed to get host [hostname] or port [portnum] from [server]. This indicated that the server string was malformed. "[hostname]" and "[portnum]" will be as much as the driver could dicipher of it. o Operation in progress Connecting to the database timed out. o Transport endpoint is not connected Generally means that the connection string isn't correct, the driver couldn't even find the database server. o couldn't determine master No server in a replica set connection was identified as the primary. o couldn't get host info for [server] This indicated that DNS could not resolve the server address you gave. This could easily be caused by a typo, for example, "server" instead of "$server". o Invalid Argument This can be caused by attempting to connect to a machine that is up but that the database isn't actually running on. Make sure that you've started the database server before connecting. o Permission denied This means that the socket could not be opened due to permissions issues. On Red Hat variants, this can be caused by a default setting that does not allow Apache to create network connections. You can override this setting by running: $ /usr/sbin/setsebool -P httpd_can_network_connect 1 If the error message is not listed above, it is probably an error from the C socket, and you can search the web for its usual cause. CLASS SYNOPSIS
MongoConnectionException MongoConnectionExceptionextends MongoException PHP Documentation Group MONGOCONNECTIONEXCEPTION(3)