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


ADVERTISEMENT

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

Control Timeout Before Connecting Via DBLink?

Feb 28, 2012

Is there any way to control the timeout before connecting via dblink. the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,

So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.

the database version is 10gr2.

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

Export/Import/SQL Loader :: Server Connecting Oracle DB Using Linked Server Execution Delay

Jul 24, 2012

I have installed Oracle server and SQL Server on separate machines which cause me a time delay of 21 seconds for each execution. Why executions delay?  I have set RPC out (true).

Note: My main concern is either if the query is correct/incorrect it executes for 21 seconds._

Another case when I have both servers on the same machine it executes in milliseconds. I have tried Following methods in SQL SERVER.

*1, Using OPENQUERY:*
SELECT * From OPENQUERY(Linked Server Name,’Select * from OracleTableName ‘)

*2, Using Exec:*
DECLARE @sql NVARCHAR(MAX);
SET @sql =(’Select * from OracleTableName ‘);
EXEC (@sql) AT Linked Server Name ;

How to reduce the time delay caused for the execution?

View 0 Replies View Related

Connecting Oracle 8 To SQL Server

Dec 5, 2011

I'm trying to make a connection to sql server from an ORACLE 8.0.4 (I know, it's ancient) but can't seem to get it to work. I've read a lot of articles on the internet regarding the Heterogeneous Services but just can't get it to work on my system. Therefor I tried an example on connecting to an Excel workbook I found on another forum [URL] but that gives me the same problem as with connecting to sql server.

Here is what I've got:
initFRUIT.ora
CODEHS_FDS_CONNECT_INFO = SPONGE
HS_FDS_TRACE_LEVEL = OFF
LISTENER.ORA
CODESTARTUP_WAIT_TIME_LISTENER = 0

[code]....

One thing I noticed is that I do not have an hsodbc.exe file in my \bin, should it be there?
(I also tried Tgmsql80 in stead of hsodbc as program in Listener, resulting in an extended time of testing the connectivity but with the same result)

Is there any way I can test parts of the connection to limit the location of the problem? (e.g. does the listener get to the TNS)

View 2 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Networking And Gateways :: Connecting Two Oracle Database In Different Server?

Jul 13, 2012

connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.

how to use the tnsnames,ora and listener.ora file for connecting both system.

View 39 Replies View Related

Networking And Gateways :: Connecting Oracle To SQL Server Via Database Link?

May 24, 2011

Connecting Oracle to SQL Server via database link.

I am trying to connect from Oracle 10G to a SQL Server database. I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of the documentation describe how each option works.

As an example, i have been given the following information on the database i need to connect to (i.e. the SQL Server database)

- Username
- Password
- Database Name [lets assume the database name is data_extract]

To connect the above i made the following changes

$ORACLE_HOME/hs/admin/inithsodbc.ora
---------------------------------------
HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0
$ORACLE_HOME/network/admin/tnsnames.ora
---------------------------------------
sqlserver.db =
(DESCRIPTION =

[code]....

Note: In listener.ora, i only added the last SID_DESC entry. I then went on and created the database link as shown below

create database link sqlservdb using 'sqlserver.db';

When i try to access a table i get the following error

sqlplus> select * from TESTTABLE@sqlservdb;
select * from TESTTABLE@sqlservdb
*
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 ORASQLSERVER

A couple of things i am not sure of:

- Where do i specify the username and password to access the sql server from the oracle db to the sql server db

- Having read around on the internet, i can see some people refering to a DSN datasource. I am told that the information that i have is all i need. Is this correct or do i need something else?

- The sid i specified in inithsodbc.ora and tnsnames.ora is actually the sql server database. Is this correct?

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

Mobile Server :: Connecting To Oracle Database Mobile Manager Workspace Using The Browser

Jul 3, 2013

I Have installed the oracle database 11g, the oracle database mobile server and i use Glassfish as the application server. Everything is fine i have tested the mobile server configuration using Oracle mobile server workbench the mobile server runs  but when i want to connect to the mobile manager workspace via the browser using

[URL].......

I have a server error HTTP 404- The requested resource () is not available .

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

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

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

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

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

Getting Data Over SQL Server DBLink

Apr 17, 2012

I just created a dblink from our Oracle 9i database to a SQL Server 2008 R2 Server using oracle heterogeneous services. The dblink seems to be OK and I can query the remote SQL Server database but I only get results for numeric columns.

Say the remote SQL Server table was created like:

CREATE TABLE [MITLOC] (
[MLCONO] [numeric](3, 0) NOT NULL,
[MLWHLO] [nchar](3) NOT NULL,
[MLITNO] [nchar](15) NOT NULL,
[MLWHSL] [nchar](10) NOT NULL,
[MLBANO] [nvarchar](20) NOT NULL,
[MLCAMU] [nvarchar](20) NOT NULL,
[MLFACI] [nchar](3) NOT NULL,
[MLWHLT] [nchar](2) NOT NULL,
[MLSTQT] [numeric](15, 6) NOT NULL)

The remote dblink is named after M3PREP.

Then if I run:

CODEselect MLCONO, MLSTQT from MITLOC@M3PREP => this works OK and I get the two columns.

If I run:

CODEselect * from MITLOC@M3PREP => I get the same results as in the previous query and all nchar, nvarchar type columns are missing, I only get the same two columns.

If I run:

CODEselect MLCONO, MLWHLO from MITLOC@M3PREP=> I get ORA-00904 - the column name entered is either missing or invalid.

I set up my .ora init file like this, I suspect there is something missing here, is it related to the NLS_LANG or so?

CODE#
# HS init parameters
#
HS_FDS_CONNECT_INFO = M3PREP
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE_NAME = M3PREP.LOG

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

View 1 Replies View Related

SQL & PL/SQL :: Accessing Data From Server By Using DBLINK

Oct 22, 2010

We are accessing data from the server ADM.WORLD by using DBLINK.We got the following error.

PL/SQL: ORA-04052: error occurred when looking up remote object
sysadm.PS_HP_INC_ELIG_VW@ADM.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-28000: the account is locked
ORA-02063: preceding line from ADM

For that we checked in the server ADM.WORLD for the account the account is showing locked .After that we successfully accessed the object sysadm.PS_HP_INC_ELIG_VW@ADM.WORLD.

For next day also the account is locked.Why the account is frequently locking.

View 15 Replies View Related







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