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


ADVERTISEMENT

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

How To Configure Charset Unicode

Aug 15, 2012

I need to configure character set for my database. I have 2 options:

AL16UTF16 - require 2 bytes per character (fixed length)
UTF8 - character length - 1 until 4 bytes. (variable length)

until here ok...

The AL16UTF16 certainly will occupy more space than UTF8. So my question is, When would I need use AL16UTF16 character set mode?

I hear one time, when a database write many values with the same length. it does it in the same HD cylinder. So the HD arm could with a single movement read all the fields in cylinder completely. Improving the read/write performance.

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

PL/SQL :: Convert CLOB With WE8ISO8859P15 Charset To UTF-8 Charset

Jun 28, 2013

I have a CLOB containing a XML code and all XML tags where created using the DB charset: WE8ISO8859P15.

For example:

{code}

<?xml version="1.0" encoding="ISO-8859-1"?>
<certidao xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<funcionario>

[Code]...

I need to maintain this charset value.

But now I need to convert all my CLOB data into UTF-8 charset for external requirements and stored this new CLOB in a table column.

I can't change the charset of the session. I've tried to use a function

{code}
FUNCTION convert_xml (pcl_xml IN CLOB)
RETURN CLOB

[Code]....

This function apparently works, but when I try to validate the XML content (after I replace the encoding="ISO-8859-1" to encoding="UTF-8") the validation software tells me that I have some characters that should not be present in a file using UTF-8 encoding.

View 1 Replies View Related

Charset On Silent Installation

Apr 5, 2011

I am installing oracle 11 by silent installation.I want my charset to be UTF16, how can i change it.

View 1 Replies View Related

CHARSET ORACLE Database Duplication?

Sep 22, 2010

Can i duplicate a database that is in a different CHARACTER SET?

If i can't made the duplication in a direct way, how can i convert or transform to duplicate a database from one character set o another?

View 7 Replies View Related

Globalization :: Charset Not Working While Consuming UTF-8-Webservice With PL/SQL?

Mar 3, 2013

I read and tried a lot, but I can't consume a UTF-8-Webservice correct in a 11gR2-DB: German "Umlaute" like ü are displayed/written as ü.

The service sends all correct. (tested with soap-ui 4.5.1)

The DB-NLS-Parameters are:
SQL> select * from NLS_DATABASE_PARAMETERS;
PARAMETER                      VALUE
------------------------------ --------------------------
NLS_LANGUAGE                   GERMAN
NLS_TERRITORY                  GERMANY

[code]...

I consume Service with that skript:

DECLARE
   l_http_request     UTL_HTTP.req;
   l_http_response    UTL_HTTP.resp;
   l_buffer_size      NUMBER (10) := 512;
   l_line_size        NUMBER (10) := 50;
   l_lines_count      NUMBER (10) := 20;
  
[code]....

What can I do, to get the response correct in NLS_CHARACTERSET WE8MSWIN1252.I think, it must be possible to convert the response, but I didn't found the correct solution.And I don't understand, why the body_charset is ever "ISO-8859-1" (commented in procedure). Settings utl_http.body_charset is without effect.

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







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