|
|
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 CENTOS
install-solaris
install-solaris(1M) install-solaris(1M) NAME
install-solaris - install the Solaris operating system SYNOPSIS
install-solaris install-solaris invokes the Solaris Install program. Depending on graphical capability and available memory at the time of invocation, install-solaris invokes either a text-based installer or a graphical installer. The following minimum requirements for physical memory dictate which features are available during installation: For SPARC machines: 128 MB Minimum physical memory for all installation types 128 MB Minimum physical memory required for windowing system 384 MB Minimum physical memory required for graphical-based installation For x86 machines: 256 MB Minimum physical memory for all installation types 256 MB Minimum physical memory required for windowing system 512 MB Minimum physical memory required for graphical-based installation In some cases, even if the minimum physical memory is present, available virtual memory after system startup can limit the number of fea- tures available. install-solaris exists only on the Solaris installation media (CD or DVD) and should be invoked only from there. Refer to the for more details. install-solaris allows installation of the operating system onto any standalone system. install-solaris loads the software available on the installation media. Refer to the for disk space requirements. Refer to the for more information on the various menus and selections. See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcdrom (Solaris instal- | | |lation media) | +-----------------------------+-----------------------------+ |Interface Stability |Evolving | +-----------------------------+-----------------------------+ pkginfo(1), install(1M), pkgadd(1M), attributes(5) It is advisable to exit install-solaris by means of the exit options in the install-solaris menus. 23 Sep 2005 install-solaris(1M)