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
Old 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: TNSSmilieperation 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

How to connect to oracle ??

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

How to connect ORACLE using PERL

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

How to connect oracle from unix

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

Perl connect to remote oracle db without local oracle installation

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

Unix - Oracle DB Connect

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

Not able to connect Oracle

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

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

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

Connect to Oracle using sqlplus

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

Identify a specific environment Oracle variable to connect a remote Oracle database ?

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

Connect to Oracle database

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
aseqnet(1)						      General Commands Manual							aseqnet(1)

NAME
aseqnet - ALSA sequencer connectors over network SYNOPSIS
aseqnet [remotehost] DESCRIPTION
aseqnet is an ALSA sequencer client which sends and receives event packets over network. Suppose two hosts connected by network, hostA as a server and hostB as a client. The ALSA sequencer system must be running on both hosts. For creating the server port, run the following on hostA: hostA% aseqnet sequencer opened: 128:0 Then a user client 128 with port 0 was opened on hostA. (The client number may vary.) For creating the (network-)client port, run aseqnet with the hostname of the server: hostB% aseqnet hostA sequencer opened: 132:0 Now all events sent to hostA:128:0 are transferred to hostB:132:0, and vice versa. The ports created by aseqnet can be connected arbitrary to other sequencer ports via aconnect(1). For example, to connect hostB:132:0 to a MIDI output device 65:0: hostB% aconnect 132:0 65:0 Then events to hostA:128:0 will be delivered to hostB:65:0. The following command plays MIDI on hostB. hostA% pmidi -p 128:0 foo.mid The multiple clients may exist simultaneously. If hostC is connected as a client to hostA, events from from hostA are sent to all con- nected network clients, i.e. hostB and hostC. However, only one connection is allowed from a client to a server. To disconnect network, stop all clients before server by ctrl-C or sending signal to them. The server will automatically quit. OPTIONS
-p port Specify the TCP port number or TCP service name. -s addr Subscribe to the given address for read automatically. -d addr Subscribe to the given address for write automatically. -v Verbose mode. SEE ALSO
aconnect(1), pmidi(1) AUTHOR
Takashi Iwai <tiwai@suse.de>. January 1, 2000 aseqnet(1)
All times are GMT -4. The time now is 08:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy