Heterogeneous Connectivity :: Query In SQL Server from Oracle  9.2

Oct 24, 2012

How can I to connect and execute query from Oracle without to use others products ( DG4MSQL ....etc) ?using 9.2.08

View 5 Replies


ADVERTISEMENT

Heterogeneous Connectivity :: HS To Postgre ORA-28511

Feb 14, 2013

select from the postgre databse works just fine (however when i select data column alone it returns as date, if i select it together with som condition in where clause it returns varchar).

-- this runs ok
select
t."idbill",
t."idpoint"
from "crm"."bills2points"@dl_carecloud t
,"crm"."bills"@dl_carecloud brg
where 1=1
and t."idbill" = brg."idbill"
and t."idbill" = 9685;
[code]....

View 9 Replies View Related

Heterogeneous Connectivity :: Connecting From 9.2.0.8 Database On AIX To MS SQL 2008R2?

May 30, 2013

We have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .

Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)

Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)

1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?

2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?

3] Is there any other solution apart from using "Database Gateway for SQL Server " ?

View 1 Replies View Related

Heterogeneous Connectivity :: Configure HS For Excel File

Jul 19, 2012

I am trying to configure HS for Excel file. I am getting following error:

SQL> select table_name from all_tables@ODBCEXCEL;
select table_name from all_tables@ODBCEXCEL
*
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from ODBCEXCELHeres my setup:
[code]....

View 6 Replies View Related

Heterogeneous Connectivity :: Connecting MS SQL Server From Oracle Using DBLink?

Nov 12, 2013

Oracle 11g on linuxdestination : ms sql server 2005 i need to create the db link from oracle to ms sql server to view the tables , is it posibble without configuring the gateways( as looks like it is licenced product) 

View 2 Replies View Related

Heterogeneous Connectivity :: Create Interface Between Oracle And SQL Server

Dec 5, 2012

I am working on oracle and pl/sql since some time. so just a novice. I don't know much about sql server or transact sql, etc..I have a requirement to create an interface between Oracle and sql server.

we have a database on oracle and another on sql server. my requirement is to create an interface between oracle and sql server and see how can I update one (or more) tables (I am guessing using pl/sql) on sql server.

View 2 Replies View Related

Heterogeneous Connectivity :: How To Configure Parameters HS_LANGUAGE And CHARSET

Aug 21, 2012

Oracle Corporation --- TUESDAY AUG 21 2012 11:17:46.685

Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with Oracle Database Gateway for ODBC

oracle server NLS_CHARACTERSET is UTF8 and mysql server Character set is UTF8, how should i configure the parameters HS_LANGUAGE(initsid.ora) and CHARSET(odbc.ini)? now i
configure the CHARSET = UTF8 and HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15,but the sql query reslut like this:

SELECT "id","name" FROM "accounts"@LNMYSQL
_______________________________________
xy-20120712-00016728 éå£«ç„±

the name Column is Garbled.

View 1 Replies View Related

Heterogeneous Connectivity :: Oracle Gateway Plus Materialized View?

Sep 4, 2012

we have microsoft sql server, oracle gateway server (11G) and database server (10.2.0.5) we already make the full setup, and it's working.

we create materialized view into oracle server to read a data from sql server, but the refresh of MV take long time so we are planing to create the materialized view into oracle gateway server.

create MV into oracle gateway server?i mean i don't want to download oracle database instance for only one MV.

View 5 Replies View Related

Heterogeneous Connectivity :: DG4ODBC Update Data From Oracle To SQL Server

Oct 3, 2013

11.2.0.1. Using DG4ODBC to update data from oracle to sqlserver and vice-versa using dblinks?

View 6 Replies View Related

Heterogeneous Connectivity :: Change When Moving System Using Gateway ODBC?

Jan 27, 2013

Oracle 11gR2
Linux 6.x
Sybase 12 (on Windows)
unixODBC 3.2.x
Sybase Client 12
------------------------

Given the following files or structures that are important to the proper operation of the ODBC Gateway connecting to a remote Sybase database:

listener.ora
tnsnames.ora
initmydblink.ora ( my version of the initdg4odbc.ini )
dblink (not a file but the dblink in the Oracle database)
odbc.ini
odbcinst.ini

What files (and what properties within those files) may/must be changed if the remote Sybase db and system is different (i.e. the Sybase database source has been changed to something 'new')? For example, I can that the odbc.ini file is going to have to be alterer to point to the new database server IP address, database port, database name?

View 1 Replies View Related

Heterogeneous Connectivity :: Error While Querying Database Link From Oracle 10g To Postgres 8.2

Mar 26, 2013

I have installed unixodbc 2.3.1, postgres odbc driver (psqlodbc-07.03) and dg4odbc 11.2..On querying : select sysdate from dual@dblink_postgresql, the following error occurs:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found {01000}
ORA-02063: preceding 2 lines from DBLINK_POSTGRES

Similar error appears in the trace file as well.

[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a'
$ isql -v postgresql postgres postgres@2012
[01000][unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found
[ISQL]ERROR: Could not SQLConnect

However the file is present in the location and has no permission related problems.

$ pwd
/oracle/psqlodbc/lib
$ ls -lrt
total 2952
-rwxr-xr-x 1 oracle oinstall 663 Mar 25 15:28 psqlodbc.la
-rw-r--r-- 1 oracle oinstall 731419 Mar 25 15:28 libpsqlodbc.a
-rw-r--r-- 1 oracle oinstall 12215 Mar 25 22:11 win_md5.o
-rw-r--r-- 1 oracle oinstall 18100 Mar 25 22:11 options.o
[code]....

View 11 Replies View Related

Heterogeneous Connectivity :: Datatype Nvarchar (max) Not Accessible (DBLink From Sql 2005 To Ora 11gR2 )?

Jun 16, 2012

i have created the DB LINK from Oralce 11gR2 to MS Sql Server 2005,able to access the view of Sql Server from Oralce,but the Columns which have Datatype nvarchar(max) in Sql Server am not able to access through DB Link.

View 1 Replies View Related

Heterogeneous Connectivity :: Database Link Between Oracle11g Express Edition And MySQL using Odbc

Nov 8, 2012

I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.

View 1 Replies View Related

Query Without Login To Oracle database From Linux OS?

Aug 21, 2013

can we query this without login to the oracle  database from linux os?database is up and running . /apps/oracle/product/11.2.0/dbhome/bin/sqlplus system/passwd select name from v$database;

View 5 Replies View Related

PL/SQL :: AES128 Encryption Compatible With Oracle  And C#

Jun 20, 2013

I am trying to have an encryption logic written in Pl/SQL that could decrypt the value which is encrypted in Dot Net, using AES128 algorithm. Everytime when i try to have the decryption done, i lands up in one or the other error message. Below is the code snippet which i use. create or replace

FUNCTION decryptAES (EncryptedText IN VARCHAR2,EncKey IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC  IS   key_bytes_raw  RAW (2048);  l_ decrypted_raw   RAW (2048);  encryption_type    PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_AES128; BEGIN  key_bytes_ raw:= UTL_RAW. CAST_TO_ RAW (EncKey);  l_decrypted_raw := dbms_crypto.decrypt  (src =>utl_raw.cast_to_raw(EncryptedText),  typ => encryption_type,   key => key_bytes_raw  );          RETURN (UTL_RAW.CAST_TO_VARCHAR2 (l_decrypted_raw));   END decryptAES.

View 3 Replies View Related

Character Set Of Heterogeneous Connection?

Jun 22, 2011

i am trying to insert records (with varchar2 fields) into mysql database from oracle through heterogeneous connection..but after insert, and when i query the inserted data which inserted in arabic, it appears as question marks '?????????'

the character set of oracle database is AR8MSWIN1256...and the character set of mysql database is UTF8...

is there any configuration to the heterogeneous connection that configure the character set ?

View 1 Replies View Related

SQL & PL/SQL :: Heterogeneous Database Integrated

Oct 30, 2012

Now I have a question : I had Application ERP (use Oracle 10g) and another Application PLM(use MSSQL) , I want to integrated this two application,but I do'nt know how to begin ? is this any document can study? Beside , Is Oracle 10.2.0.1 transparent Gateway for MSSQL is free?? or charged? if free , where to download?

View 5 Replies View Related

Networking And Gateways :: Oracle Heterogeneous Services

Mar 13, 2010

I have following file setup for Oracle heterogeneous services for MS Access. I also need to add one more dsn for MS Excel.

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MyConn
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Note: MyConn is for MS Access that I cretaed.

Can we use like this

HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.

View 3 Replies View Related

ODBC Connectivity Rather Than OTG?

Feb 1, 2013

What are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?

All I need to do in the stored procedure is a simple insert statement into a DB2 table.

What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?

What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.

View 1 Replies View Related

Server Administration :: Manual Standby Database On Heterogeneous Platform

Apr 24, 2012

We have a 2 node RAC installation on IBM AIX 5.3 with Oracle Standard Edition. We need to create a manual standby database (becoz Standard Edition does not allow Dataguard confign). Can we do this on a different platform (eg: Linux/Windows). This is to make use of existing servers for the standby environment.

View 1 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

Oracle 9i With PHP - Connectivity To Database

May 2, 2007

I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?

View 3 Replies View Related

Forms :: CCTV Connectivity With 6i

Nov 13, 2012

I want to connect CCTV camera with forms 6i. User can save the image or record a video either on File system or Database.

View 1 Replies View Related

Networking And Gateways :: Accessing MS-ACCESS From Oracle Using Heterogeneous Service Agents

Nov 13, 2011

I have a requirement wherein I need to access the MS ACCESS database table from Oracle Client.I have created ODBC data source and have configured tnsnames.ora and listener.ora for the same. As a next step I am trying to configure HS init file for hsodbc connection but couldn't find the directory hs in $ORACLE_HOME (<ORACLE_HOME>hsadmininit******.ora). Any patch that needs to be applied for hsodbc connection in the server.

View 3 Replies View Related

Cluvfy - Verify Node Connectivity?

Aug 12, 2010

I get the following output for node connectivity check as part of pre clusterware installation checks.oracle@cps-oracle-1.homer.com% runcluvfy.sh comp nodecon -n cps-oracle-1,cps-oracle-2 -verbose

Verifying node connectivity
Verification of node connectivity was unsuccessful on all the nodes.

The above output i get for node connectivity component check. I pinged each public and private interface on node and found them to be working.The CRS is for Oracle10Gr2.

View 3 Replies View Related

Precompilers, OCI & OCCI :: Connectivity Between C And Oracle?

Aug 12, 2008

Is it possible to connect with Oracle using C?

View 2 Replies View Related

Forms :: Fingerprint Device Connectivity With 10g?

Mar 5, 2011

I am working on 10g. I have to capture and retrive thumb impression through biometric device on forms. And then store it in database.

Already working in VB . I have its jar files also.

View 1 Replies View Related

Networking And Gateways :: Connectivity Between MS-Access And Oracle SQL

Feb 3, 2011

I am currently using Oracle 10.2.0.1 version, in a single PC (test server) and MS-Access (2003) in it.

I was trying to use the logic of HS ODBC connectivity, but when i try to select the table from the MS-Access i am getting the following error.

"ORA-12154: TNS:could not resolve the connect identifier specified".

to create the successful connection between the MS-ACCESS and ORACLE. I just need to read some data from MS-ACCESS on a monthly base from a particular table.

View 1 Replies View Related

PL/SQL :: Connectivity Code To Connect Oracle DB In UNIX?

Jun 13, 2013

i need a connectivity code to connect oracle DB in UNIX.pls send me a code exactly.

View 2 Replies View Related

Opening Of Port 1521 For Database Connectivity Through Firewall?

Nov 8, 2012

we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.

Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.

My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?

Environment:
Oracle 11.2.0.3
UNIX AIX 5.3/6.1

View 2 Replies View Related







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