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 é士焱
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]....
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.
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]....
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)
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.
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.
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?
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]....
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.
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.
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.
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.
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 ?
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?
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.
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.
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)
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 ?
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.
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.