How To Connect To Oracle Server With Tunneling

Jul 23, 2013

Web Server(port80) and SSH Server(port 212) and Oracle client with sqlplus (192.168.137.2)
||
||
SSH client (192.168.137.1/128.21.31.111)
||
||
Oracle Server (port 1521) (128.21.31.112)

my php program have to access the db on oracle server, and then i do this on my SSH client

ssh -p 212 user@192.168.137.2 -R 1521:128.21.31.112:1521

View 1 Replies


ADVERTISEMENT

Server Administration :: How To Connect Oracle Client To Remote Server DB

Jun 29, 2013

I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.

On the server machine I configured oracle server in the following way:

Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:

Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521

All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.

With SQL Plus as by the official documentation I have entered the following command:

CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.

With SQL Developer I have entered the same parameter.

But with both SQLPlus and SQL Developer the connection fails.

View 14 Replies View Related

Server Administration :: Connect 500+ Client To Remote Oracle Server?

Aug 10, 2010

we have oracle server. we have to connect 500+ client machine to oracle server.

is it i need to install client version to all 500+ or any other shortcut way?

View 6 Replies View Related

How To Connect Between Oracle To SQL DB Server

Jul 17, 2012

OS: RHEL 5.7 64 bit
DB: 11.2.0.2 SE 64 bit

We have a scenairo in which we have two servers one is a Oracle server and the other is SQL server and we need to enable automated Emails from the oracle DB server. As the Oracle server is not whitelisted and we have a SQL server which is already whitelisted so is it possible to connect from Oracle server to Sql server so that the automated emails will be generated from the sql server (as it is whitelisted) and we do not want to whitelist the oracle server.

View 3 Replies View Related

Connect To 10g Oracle Server From 9i Client

Apr 18, 2008

Is it possible to connect to 10g oracle server from 9i client?

View 1 Replies View Related

Forms :: Can Oracle 11g Connect To DB2 Or SQL Server

Sep 24, 2010

I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc.

Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?

View 1 Replies View Related

Connect To Oracle From Another Server That Does Not Have Any Oracle Applications On It

Mar 7, 2007

I am trying to connect to Oracle from another server that does not have any Oracle applications on it.

I tried Perl, PHP, Java but each require parts of Oracle installed.

View 2 Replies View Related

Server Administration :: Unable To Connect To Oracle 11g Using Forms 4.5

Apr 21, 2011

We are unable to connect to Oracle 11.1.0.7.0 from Oracle Forms 4.5..However we are able to connect using Oracle forms 6i

Now Forms 4.5 is old and not supported, however apart from Tests I will need prove it to the higher ups...Do we have any link, document which will cover such compatibility issue?

View 7 Replies View Related

Efficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX

Mar 8, 2011

I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.

View 1 Replies View Related

OLE DB :: Connect Oracle DB In Windows 2003 Server From Linux Desktop

Aug 18, 2012

I have Oracle 9i DB in windows 2003 server, I want to access this DB from Linux desktop. Is there any 'client software' is available to connect Or procedure to connect the DB.

View 0 Replies View Related

Networking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?

Mar 11, 2011

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)

View 4 Replies View Related

Server Administration :: Oracle Hang - Client Cannot Connect Database

Apr 29, 2012

all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log

alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604

[code]...

View 5 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

Server Administration :: Unable To Connect To The Server?

Sep 16, 2010

I am getting this error ( ORA-12516: TNS:listener could not find available handler with matching protocol stack ) When I am trying to connect to the server through my application in which I am using SOAP

View 1 Replies View Related

How To Connect To SQL Database Server

Feb 23, 2009

I do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.

View 1 Replies View Related

Unable To Connect To Sql Server From 11g?

Jun 21, 2012

When we tried to query a data from the sql server we are getting the below generic error message i

SQL> select * from all_users@testing
2 /
select * from all_users@testlink1
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from TESTLINK1

below are the details setup / configuration done by us:

os :windows 2008 server.
database "oracle standard edition
Command Line input /output:
C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc
Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
Oracle Database Gateway for ODBC

[code]....

View 1 Replies View Related

Forms :: Connect SQL Server With 6i?

Feb 25, 2010

Is it possible to connect SQL Server 2000 with Forms6i?

View 1 Replies View Related

Windows :: Connect Tow Server Of Same DataFile

Nov 10, 2010

I have Tow Virtual Servers (Connect As Cluster) in the Same Computer The Files In the Drive C Different (of the Tow Servers) And Others Like (e,f,q) The Same Files

And There is Database of both Servers That Have Same Name Let say orcl and both database Have same Schema let Say sch
How I can Share The Data when i am insert to table. in the schema sch in the server A i can see Same Data That I have Inserted In the Schema sch in the server B.

View 4 Replies View Related

Server Administration :: Unable To Connect To 11g EM?

Nov 22, 2012

1-How much memory is needed to use the Oracle 11g Enterprise Manager? (Probabely other parts need less memory than EM)

2-When i try to connect to Oracle 11g , get the following error?

View 2 Replies View Related

Connect Win 2008 32 Bit Server And Win 7 64 Bit Client?

Jul 17, 2012

can connect a 64 bit Oracle 11g Release 2 on a Windows 7 client with a 32 bit Oracle 11g Release 2 on a Windows 2008 server?

View 5 Replies View Related

Connect To SQL Server Database Via Toad

Jun 25, 2013

how to connect to sql server databases via toad. I have used toad to connect to oracle databases, but never to a sql server database. To connect to an oracle database, we first install the client and then add the tnsentry of the database to the tnsnames.ora file and then we can directly connect to the oracle database right?So I was wondering if there are any steps like that to be followed to connect to the sql server databases.  

View 2 Replies View Related

Forms :: Failed To Connect To Server

Oct 15, 2010

I have a pb went i can access on my forms server:

FRM-92050: Failed to connect to the Server: ://127.0.0.1/servlet/oracle.form...enerServlet:-1

java.net.ConnectException: Connection refused

View 1 Replies View Related

Server Utilities :: Connect To Databases With DBLINK

Jul 17, 2013

I'm try to connect to databases with DBLINK. It works, but I drop the dblink to do it again in the final server. The problem that I now is that there is not any DBLINK in my database but I can see the data of the other database (with select 1 from DATABASE.TABLE)

Is my database saving the data of the other database without de DBLINK?

View 4 Replies View Related

Server Administration :: Unable To Connect To Database

Nov 27, 2010

I have installed a database in D drive. I want to create another database in the same machine. I tried installing the new database using DBCA. Installation was ok. I added entry in TNS file.

When i try to login to this new database from other machine, i am unable to connect to this database. I made an entry in TNS on my local machine. It says the user id /password is wrong, even though they r correct. I am using the same password to delete the database.

View 3 Replies View Related

Server Administration :: Unable To Connect To Database?

Sep 26, 2013

I migrated one database ( DB1) from old database server to new database server where user accounts were locked before migrating the database.But migration was successful and database and accounts got created in new database server.

In old database server , user accounts status is locked and in new database server user accounts are open but still i am unable to connect to database using new user in new database server.

why im unable to connect to database whose accounts are open?

View 6 Replies View Related

Server Administration :: Connect 9i To 10g With Same Database And User?

Oct 19, 2012

last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .

View 3 Replies View Related

Forms :: FRM-41213 - Cannot Connect To Reports Server

Mar 4, 2012

I'm having trouble with my forms builder. I can't connect to my reports server.

DECLARE
REP_ID REPORT_OBJECT;
REP_J_ID VARCHAR2(25);
SERVER_LENGTH NUMBER;
REP_STATUS VARCHAR2(25);

[code]...

View 1 Replies View Related

Server Administration :: Connect To Idle Instance

May 11, 2011

Getting the below message even after doing the

oracle@ttlwaurd001:~$ ps -ef | grep pmon
oracle 7779 1 0 Feb08 ? 00:00:07 ora_pmon_WGRGOLD1
oracle 10155 1 0 Feb20 ? 00:30:48 ora_pmon_DPTLS01
oracle 12354 1 0 Feb20 ? 00:00:53 ora_pmon_DOEMS01
oracle 17902 1 0 Feb20 ? 00:00:13 ora_pmon_DREPS01
oracle 23745 23360 0 19:51 pts/4 00:00:00 grep pmon
oracle@ttlwaurd001:~$
oracle@ttlwaurd001:~$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 19:49:54 2011

Copyright 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.

oracle@ttlwaurd001:~$ echo $ORACLE_SID
DPTLS01

View 15 Replies View Related

XE :: Can Use A 32bit Client To Connect To 64bit Server

Sep 10, 2012

Just wanted to know if 11XE (R2,32bit) will install and work correctly on Windows Server 2008 R2 x64?

I would like to install either the Oracle 11g Client and/or ODP.NET(x86 and x64) on the same machine, would this work? I cannot find any documentation regarding this and so far I am having some issues. At this point in time I have 11XE and ODP.Net (both x86) on this x64 machine under separate Oracle_homes and I cannot connect to the XE database from either SQLPlus client installed with the respective Oracle_Home..

Can I use a 32bit client to connect to a 64bit server?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved