당신은 주제를 찾고 있습니까 “hs gateway null connection context at exit – #33 Connect Sql Server Database in Oracle | Heterogeneous Service in Oracle |Oracle Database Gateway“? 다음 카테고리의 웹사이트 https://chewathai27.com/you 에서 귀하의 모든 질문에 답변해 드립니다: https://chewathai27.com/you/blog. 바로 아래에서 답을 찾을 수 있습니다. 작성자 Badani Sir 이(가) 작성한 기사에는 조회수 6,832회 및 좋아요 76개 개의 좋아요가 있습니다.
hs gateway null connection context at exit 주제에 대한 동영상 보기
여기에서 이 주제에 대한 비디오를 시청하십시오. 주의 깊게 살펴보고 읽고 있는 내용에 대한 피드백을 제공하세요!
d여기에서 #33 Connect Sql Server Database in Oracle | Heterogeneous Service in Oracle |Oracle Database Gateway – hs gateway null connection context at exit 주제에 대한 세부정보를 참조하세요
Oracle Database Gateways provide the ability to transparently access data residing in a non-Oracle system from an Oracle environment
0:00 Introduction to Oracle Database gateway
2:25 download and install oracle database gateway
05:51 Create new Listener in between setup
07:35 create odbc data source
09:05 Configure initdg4odbc.ora file
10:20 Configure Listener in Gateway home
12:00 Configure tnsnames.ora file in oracle database home
14:30 Create database link to connect with sql server
#oracle #oracle19c #database #badanisir
Email :- [email protected]
hs gateway null connection context at exit 주제에 대한 자세한 내용은 여기를 참조하세요.
Using StarSQL with Oracle Database Gateway for ODBC
HS Gateway: NULL connection context at exit. Solution: Verify the configuration in tnsnames.ora; the location of HS=OK should be after the …
Source: www.starquest.com
Date Published: 3/5/2022
View: 9703
Oracle HS fails to operate on mysql-connector-odbc-5.3.4-1.el7
Bug #78242, Oracle HS fails to operate on mysql-connector-odbc-5.3.4-1.el7 … HS Gateway: NULL connection context at exit Exiting hgoexit, …
Source: bugs.mysql.com
Date Published: 8/11/2021
View: 9354
ORA-28545 when querying HS gateway in Oracle 12c
Recently I upgraded a Windows environment that used the Heterogeneous Services to connect to an external ODBC datasource via a database link.
Source: dbamarco.wordpress.com
Date Published: 10/10/2021
View: 1842
Heterogeneous Services NCR-00002 – Oracle Forum
Gurus, I am trying to connect an Oracle 10g system to an MS SQL server. … NCR: Inval usage HS Gateway: NULL connection context at exit …
Source: community.spiceworks.com
Date Published: 9/5/2022
View: 2304
Oracle talking to SQL Server over a normal database link?
freetds is a free odbc driver that allows connection to SQL Server (others are available of … HS Gateway: NULL connection context at exit.
Source: dbaharrison.blogspot.com
Date Published: 8/4/2022
View: 9218
Create a postgres with dg4odbc oracle dblink – eehelp.com
… HS Gateway: NULL connection context at exit Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:108 FUNCTION:hgoexit() ID:Connection context
Source: www.eehelp.com
Date Published: 12/19/2022
View: 6547
Using heterogeneous database services to connect to AS/400 …
HS Gateway: NULL connection context at exit. dg4odbc ORA-28546: connection initialization failed, probable Net8 admin error.
Source: shannonscncjdeblog.blogspot.com
Date Published: 2/1/2021
View: 1067
MySQL Forums – Connector/ODBC
I am using MYSQL CONNECTOR as a driver for ODBC connection to a MYSQL database. … HS Gateway: NULL connection context at exit
Source: galee.rssing.com
Date Published: 5/21/2022
View: 2024
주제와 관련된 이미지 hs gateway null connection context at exit
주제와 관련된 더 많은 사진을 참조하십시오 #33 Connect Sql Server Database in Oracle | Heterogeneous Service in Oracle |Oracle Database Gateway. 댓글에서 더 많은 관련 이미지를 보거나 필요한 경우 더 많은 관련 기사를 볼 수 있습니다.
주제에 대한 기사 평가 hs gateway null connection context at exit
- Author: Badani Sir
- Views: 조회수 6,832회
- Likes: 좋아요 76개
- Date Published: 2020. 7. 28.
- Video Url link: https://www.youtube.com/watch?v=ASVM4Vj9gdI
Using StarSQL with Oracle Database Gateway for ODBC
StarQuest Technical Documents
Using StarSQL with the Oracle Database Gateway for ODBC
Last Update: 24 April 2020
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ059
Abstract
The Oracle Database Gateway for ODBC (DG4ODBC), combined with StarSQL, makes it possible to integrate DB2 data with Oracle applications.
This document demonstrates how to configure and use the Database Gateway for ODBC with StarSQL.
Solution
Obtaining and installing the Gateway:
In Oracle 11g and later, the gateway is included in the installation of the Oracle database. In older versions, it may be a separate installation. The bitwidth of the gateway usually matches that of the database distribution, so if you install the 64-bit version of Oracle, you will need to use the 64-bit version of StarSQL.
An Oracle DB license includes a license for the Gateway for ODBC; no additional license is required. The Gateway does not need to be running on the same machine as the Oracle database.
Some literature may refer to the Gateway as DB-Link (or Database Link).
Previous Oracle distributions contain an older version of the gateway named “Hetergenous Services Generic Connectivity using ODBC” (hsodbc); this is a 32-bit application even in 64-bit Oracle 10g distributions. The 11g version of DG4ODBC can be installed in pre-11g environments, provided you install a patch; see Oracle tech notes for details.
To verify that the Gateway is installed and display its version, locate the dg4odbc executable ($ORACLE_HOME/bin/dg4odbc.exe e.g. C:\oracle\product\11.1.0\db_1\bin\dg4odbc.exe on Windows) and invoke it from a command line.
Configuring and using DG4ODBC:
Create and verify a StarSQL ODBC system data source (e.g. MYDSN). On UNIX, system data sources are typically stored in /usr/local/etc/odbc.ini. Locate the $ORACLE_HOME/hs/admin directory (e.g. C:\oracle\product\11.2.0\db_1\hs\admin on Windows; /opt/oracle/product/11.2.0/dbhome_1 on UNIX ) and copy the template configuration file initdg4odbc.ora to a new file (e.g. initmysys.ora). Edit the new configuration file (initmysys.ora) and specify the name of the StarSQL ODBC data source:
HS_FDS_CONNECT_INFO = MYDSN On UNIX, specify the location of the ODBC Driver Manager in $ORACLE_HOME/hs/admin/initmysys.ora – for example::
HS_FDS_SHAREABLE_NAME=/usr/share/starsql64/odbc/lib/libodbc.so
(This example is for 64-bit StarSQL on Linux; specify the appropriate value for your StarSQL installation).
On UNIX, specify HS_LANGUAGE if necessary (see Troubleshooting below): HS_LANGUAGE=american_america.we8mswin1252 Edit $ORACLE_HOME/network/admin/listener.ora (e.g. C:\oracle\product\11.2.0\db_1
etwork\admin\listener.ora) and add the following. Note that a sample is available in $ORACLE_HOME/hs/admin/listener.ora.sample: LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
) SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=mysys)
(ORACLE_HOME=C:\oracle\product\11.2.0\db_1)
(PROGRAM=dg4odbc)
)
) On UNIX, the ENVS parameter must be used to set LD_LIBRARY_PATH (Solaris & Linux), LIBPATH (AIX), or SHLIB_PATH (HP-UX) to the location of the ODBC Driver Manager. For example: SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=mysys)
(ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1)
(PROGRAM=dg4odbc)
(ENVS=”LD_LIBRARY_PATH=/usr/share/starsql64/odbc/lib”)
)
) On UNIX, the case of the SID_NAME specified in listener.ora should match the case of the init filename in hs/admin. e.g. if SID_NAME=MYSYS, then the hs/admin file must be named initMYSYS.ora, not initmysys.ora. Edit $ORACLE_HOME/network/admin/tnsnames.ora (e.g. C:\oracle\product\11.2.0\db_1
etwork\admin\tnsnames.ora) and add the following. Be sure HS=OK comes after the closing bracket of CONNECT_DATA: mysys =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=mysys))
(HS=OK)
) Confirm that network/admin/listener.ora and tnsnames.ora are using hostnames rather than IP address. Stop and restart the TNS Listener service using the Services control panel (Windows) or the commands lsnrctl stop; lsnrctl start (UNIX). Use the commands lsnrctl status and tnsping mysys to verify the status of the listener. Using SQL Plus, odbctest, or another tool that allows entry of SQL statements, connect to the Oracle database as a user with sufficient authority (e.g. SYS AS SYSDBA ) and create a public database link. If you are using an Oracle multitenant container database (CDB ) available in Oracle 12 & later, create the public database link in the environment where you plan to use it; in most cases, this will be a PDB.:
SQL> CREATE PUBLIC DATABASE LINK mydblink CONNECT TO “db2user” IDENTIFIED BY “db2password” USING ‘mysys’;
To verify the link, enter the following SQL to fetch data from a table on the DB2 system:
Hints
The connection remains established until the Oracle session ends. Another session or user can access the same database link and get a distinct connection to the gateway and ODBC data source. On Windows, each connection will appear as a dg4odbc.exe task in Windows Task Manager, running as user SYSTEM (or whatever user ID the Oracle service runs as). Similarly, on UNIX you can use ps and look for dg4odbc processes.
Using SQL Developer, you can view the properties of the database link. It also includes a “Test Database Link” function; in order for that test to succeed, a table named “dual” must exist in the user’s default schema on the DB2 host database.
Creating a view in the Oracle database allows you to examine the table structure and data using Oracle SQL Developer – e.g.
SQL> CREATE VIEW MYVIEW AS SELECT * FROM [email protected];
Metadata from the DB2 database is displayed as if it were an Oracle database. For example, using the desc statement in SQLPLUS will convert the column information to Oracle data types:
SQL> desc [email protected];
Name Null? Type
FLD1 NUMBER(10)
Accessing a non-Oracle data dictionary table or view is identical to accessing a data dictionary in an Oracle database. You issue a SELECT statement specifying a database link. The Oracle data dictionary view and column names are used to access the non-Oracle data dictionary. Synonyms of supported views are also acceptable.
For example, the following statement retrieves a list of all schemas in the DB2 system:
UNIX considerations
The 64-bit Gateway passes 64-bit values to SQLLEN/SQLULEN ODBC API parameters, and therefore must be used with a 64-bit SQLLEN/SQLULEN ODBC driver manager; it is important to use unixODBC 2.2.14 or later (supplied with StarSQL) in 64-bit environments. Note that many Linux distributions ship an older version of unixODBC.
On HP-UX PA-RISC, dg4odbc is a 32-bit application.
On AIX, the Gateway is linked with the ODBC driver manager as libodbc.so rather than libodbc.a. If you are using unixODBC as shipped by StarQuest, you will need to extract libodbc.so from libodbc.a using the ar command.
Troubleshooting and Known Issues:
Tracing:
To enable DG4ODBC tracing, edit $ORACLE_HOME/hs/admin/initmysys.ora and set HS_FDS_TRACE_LEVEL to a value between 1 (less detail) and 4 (maximum detail). Trace files will be created in the $ORACLE_HOME/hs/log (or trace) directory.
Because the Gateway runs as part of the Oracle service, capturing DRDA and ODBC traces on Windows can be challenging.
We recommend using the StarPipes Gateway to capture DRDA traces on Windows.
On UNIX, enable DRDA tracing by adding the following to etc/swodbc.ini in the StarSQL program directory:
[Tracing]DRDA = ON
DRDATraceFile = /tmp/trace.sqd
To capture an ODBC trace on Windows, open the tracing panel of ODBC Administrator and select Machine-wide Tracing. The Log file path is ignored; the ODBC trace will be created as SQL.LOG in the \Windows\temp directory.
To capture an ODBC trace on UNIX, set the following in /usr/local/etc/odbcinst.ini:
[ODBC]Trace = 1
Trace File = /tmp/sql.log
On UNIX systems you can use strace (Linux) or truss (other platforms) to capture the system calls made by dg4odbc. You will need to identify the process ID of the tns listener process.
# ps -eaf | grep tns
# strace -fae -o /tmp/dg4odbc.log -p
OR
# truss -fae -o /tmp/dg4odbc.log -p
Error Conditions – environment variables
If you get the following error on UNIX, be sure that the ENVS parameter has been specified in listener.ora:
[unixODBC][Driver Manager]Driver’s SQLAllocHandle on SQL_HANDLE_DBC failedIf necessary, add the environment variable _STARSQL32 or _STARSQL64 to the ENVS line in listener.ora – e.g.:
Linux: (ENVS=”LD_LIBRARY_PATH=/usr/share/starsql64/odbc/lib, _STARSQL64=/usr/share/starsql64″) Solaris: (ENVS=LD_LIBRARY_PATH=/opt/starsql64/odbc/lib:/opt/starsql64/lib:/u01/app/oracle/product/11.2.0/dbhome_1/lib, LD_LIBRARY_PATH_64=/opt/starsql64/odbc/lib:/opt/starsql64/lib:/u01/app/oracle/product/11.2.0/dbhome_1/lib,_STARSQL64=/opt/starsql64
Invalid tnsnames.ora configuration
Issue: If you get this error:
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
HS Gateway: NULL connection context at exit
Solution: Verify the configuration in tnsnames.ora; the location of HS=OK should be after the closing bracket of CONNECT_DATA:
WRONG:
mysys =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=mysys)
(HS=OK))
) CORRECT:
mysys =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=mysys))
(HS=OK)
)
No message displayed for connection problems
Issue: If you get the following connection error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Solution: edit $ORACLE_HOME/hs/admin/initmysys.ora and specify an appropriate value for HS_LANGUAGE
HS_LANGUAGE=american_america.we8mswin1252
# HS_LANGUAGE=AL32UTF8
Error due to case mismatch
Symptom: SQL statement fails with:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from MYSYS
and there is no useful information in the HS log
Solution:
Make sure that the case of the name matches between the SID defined in listener.ora and the filename of the HS init file – e.g. this error might occur on UNIX if listener.ora contains SID=MYSYS but the filename is hs/admin/initmysys.ora.
However, most other uses of the name are case-insensitive e.g.
tnsping mysys is the same as tnsping MYSYS
SELECT * FROM [email protected] is the same as SELECT * FROM [email protected]
Error due to port or hostname mismatch
Symptom: SQL statement fails with:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
and an HS log is not produced.
Solution:
This condition may occur if there is a problem with port or hostnames. In this case, tnsping will also likely fail. We have encountered this error when listener.ora and tnsnames.ora was configured with IP address rather than a hostname, or when the wrong port was specified for the entry added to tnsnames.ora.
Incomplete data
The following tip is applicable only to UNIX users using older versions of StarSQL; we recommend that Windows and Linux users, especially on 64-bit platforms, use StarSQL 6.11 or later; other UNIX users should use StarSQL 5.63 or later.
Issue: A customer using 64-bit Oracle 11g on UNIX encountered a problem where the ODBC connection was terminated abruptly before retrieving all available data.
Solution: Upgrade to StarSQL 5.63 or later, or configure setting the following settings in $ORACLE_HOME/hs/admin/initmysys.ora:
HS_FDS_FETCH_ROWS=1
HS_RP_C_FETCH_REBLOCKING=OFF
Problems when using WHERE clause (AlwaysWide=Y)
If StarSQL 6.x is configured for AlwaysWide=Y, you may get the following error when using a WHERE clause in an UPDATE or DELETE statement. In addition, using a WHERE clause in a SELECT statement will fail to find any matching rows. We recommend configuring AlwaysWide=N (default) in the StarSQL data source.
ORA-02070: database MYDBLINK does not support some function in this context
Performance Tips
Insert multiple rows with one statement.
Use the DBMS_HS_PASSTHROUGH Oracle PL/SQL package to configure the passthrough SQL feature. Statements are sent directly to the DB2 system without being interpreted by the Oracle server.
ORA-28545 when querying HS gateway in Oracle 12c
Since our customers are forced to move to Oracle Database 12.1, I am in the role to support their upgrades. Recently I upgraded a Windows environment that used the Heterogeneous Services to connect to an external ODBC datasource via a database link. The configuration is a little tricky, but pretty straight forward once you get the idea.
First, there must be an ODBC datasource. That is a simple System DSN which was already in place.
Second, you have to choose a kind of “virtual” SID for your connection to this ODBC datasource.
Third, create an init.ora in the $ORACLE_HOME/hs/admin directory and put at least one parameter into it:
HS_FDS_CONNECT_INFO=”
” Fourth, add static SID to the listener by modifying the listener.ora file:
SID_LIST_LISTENER_STD = (SID_LIST = (SID_DESC= (SID_NAME=
) (ORACLE_HOME=c:\oracle\product\12.1.0.2\dbprod) (PROGRAM=dg4odbc) ) ) Then reload the listener configuration to make it active.
Fifth, create a tnsnames.ora entry that points to the listener and the virtual SID. Make sure, you specify “HS=OK”.
MYODBCDS = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST =
)(PORT = 1521)) (CONNECT_DATA = (SID = ) ) (HS = OK) ) Sixth and finally, create a database link that points to the tnsnames entry:
SQL> create database link myodbcds connect to
identified by using “MYODBCDS”; Database link created. All those steps were done years ago in the old 11.2 environment. Everything worked fine there. So I simply copied all the configuration details to the new 12.1 Oracle home. Then I moved the listener to the new 12.1 home and upgraded the database. But when testing the HS connection, the following happened:
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 28 11:30:45 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Last Successful login time: Tue Mar 28 2017 11:06:02 +02:00 Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 – 64bit Production SQL> select * from dual@myodbcds ; select * from dual@myodbcds * 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 MYODBCDS
I checked the listener services, the connection seemed to be established successfully.
C:\>lsnrctl services listener LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 28-MAR-2017 11:39:05 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
)(PORT=1521))) Services Summary… Service “ ” has 1 instance(s). Instance “ “, status UNKNOWN, has 1 handler(s) for this service… Handler(s): “DEDICATED” established:1 refused:0 LOCAL SERVER The command completed successfully So I created a new listener in the old 11.2 home that used another port to test things. The 11.2 listener worked fine. So what is the difference between both listeners?
After a little research I stumbled upon the Windows services. The database service was not running as LocalSystem but as a domain user. This is because the database writes it’s backups to an UNC share. Both, 11.2 and 12.1, listeners used the LocalSystem account. So I changed the 12.1 listener to use the domain account too and this solved the problem.
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 28 11:39:10 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Last Successful login time: Tue Mar 28 2017 11:36:53 +02:00 Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 – 64bit Production SQL> select * from dual@myodbcds; D – X
I have no idea why the 11.2 listener can run as LocalSystem whilst the 12.1 listener cannot. But generally I think it is a good practice to run listener and database services with the same user credentials.
Heterogeneous Services NCR-00002
Hi,Before you go delving too deep in the various APPS layers, please check if the MS SQL server has an internal firewall active.If so, check that your listener port is OK (1521 or whatever you use, bear in mind that the APP layer for the PDBC might use an ADDITIONAL port to do what it needs to do), and at least get your network team to look at the packets between the systems , they may be able to tell you where the blockage is (it is often network/firewall or routing in these cases, and error messages are often confusing at best).HTH, Tony.
Oracle talking to SQL Server over a normal database link?
Now annoyingly this is quite easy from SQL to Oracle – it’s a little more fiddly the other way round.
I’ve been meaning to post on this for a while as it’s something I’ve done many time over the years and I always struggle to find a good note that describes all the steps required to create a direct link.
And to be clear here what i am doing is making a SQL Server database ‘appear’ at the end of a normal database link. So i will have the ability to say
select * from table@SQLServer
directly from in sqlplus – now wouldn’t that be nice……
My example here uses what is known as “database gateway for odbc” or “dg4odbc for short (in earlier oracle version prior to 11.1 it was knows as “heterogeneous services for odbc” or “hsodbc”). Neither of those flows off the tongue very well. You’ll see as i go through the example a lot of things still refer to “hs” – this is just for historic reasons.
In my case I’m running Oracle 11.2.0.2 (just what i had to hand no particular reason for that exact version) and i’m on SLES11 sp 2 (though i think the steps shown are reasonably Linux generic).
Before we get started just a quick summary of how the thing hangs together – the flow of processing is as follows:
Database link -> tnsnames -> listener ->dg4odbc->odbc driver -> sql server
so we are essentially creating an odbc connection and then telling oracle how to get to it and use it.
Right now that’s all clear then lets get started.
For me the first thing to do was to get out friendly unix team to install some software for me
The 3 rpms they installed were (though i think the development one is not required)
# rpm -qa |grep -i odbc unixODBC-devel-2.2.12-198.17 unixODBC-2.2.12-198.17 freetds-unixodbc-0.91-1
This was done for me as i do not have root rights.
unixODBC is the driver manager software (just think of the odbc tool on windows where lots of different vendors drivers are installed and managed – this is the driver manager software)
freetds is a free odbc driver that allows connection to SQL Server (others are available of course)
Once that software is installed what i first want to prove is that i can just create an odbc connection outside of oracle.
After installation of unixODBC i have 2 config files to deal with
/etc/unixODBC/odbc.ini – containing specific database connection details – driver/location etc
and
/etc/unixODBC/odbcinst.ini – which contains the odbc drivers installed on the system (in this case just FreeTDS)
So in the odbcinst.ini i have
[FreeTDS] Description = FreeTDS unixODBC Driver Driver = /usr/lib64/libtdsodbc.so.0 Setup = /usr/lib64/libtdsodbc.so.0 UsageCount = 1At this point the odbc.ini was empty
Now as i don;t have root rights i got the unix team to give me sudo access to run the odbcinst program which lets you add and remove drivers/database connections (this you don’t have to do – you could just edit the 2 files directly if you have rights)
I preconfigured a template file (/tmp/test.temp) with the details of what i wanted to connect to – this takes the following format
[DEMO] Driver = FreeTDS Description = Demo connection Trace = No Server = sql server hostname here Database = sql server db name here UID = username here Password=password here Port = 1435As you can see this entry is specifically saying i want to use the FreeTDS driver please. To install this i now run
sudo odbcinst -i -s -f /tmp/test.temp
i for install s for data source and f for the template file with the definition
Now odbc.ini contains the definition i just installed – i am now in a position to test it – this can be done with the isql tool which comes as part of unixodbc
I just pass in the DSN name (DEMO as defined earlier) as well as the username and password (which makes me wonder why they are in the config file at all – anyway…)
oracle@server:> isql DEMO username password +—————————————+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +—————————————+ SQL>
And we get a Connected! message implying this is some kind of miracle…….
Now lets try and run some SQL
SQL> select product from master.sys.servers; +—————————————————————————————————————————————————————————————————————————————————————-+ | product | +—————————————————————————————————————————————————————————————————————————————————————-+ | SQL Server | +—————————————————————————————————————————————————————————————————————————————————————-+ SQLRowCount returns 1 1 rows fetched
And all that seems fine – we have a working odbc driver in place and we can get to our desired destination – now comes the tricky part – wrapping up the Oracle layer on top – this was not easy to get to the bottom of (even though I’ve done this many times before on other platforms….)
The first thing i did was create a new listener – this isn’t 100% essential it could be all in one but it’s nice to keep it away from the ‘normal’ stuff
first up new listener
/oracle/11.2.0.2.0.DB/network/admin]# cat listener.ora DEMO = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1545)) ) )
SID_LIST_DEMO = (SID_LIST = (SID_DESC= (SID_NAME=DEMO) (ORACLE_HOME=/oracle/11.2.0.2.0.DB) (PROGRAM=hsodbc) ) )
Nothing really special there – just the program part may look odd to you
The next step is to create something that maps to the SID_NAME of DEMO listed in the listener.ora – what will happen when connections are sent to the listener is that it will call the hsodbc program and try and connect to something which has a config called DEMO.
This DEMO config sits in $ORACLE_HOME/hs (probably a directory you never noticed before…)
The content of this file is as follows:
/oracle/11.2.0.2.0.DB/hs/admin]# cat initDEMO.ora HS_FDS_CONNECT_INFO = DEMO HS_FDS_TRACE_LEVEL = 1 HS_FDS_TRACE_FILE_NAME = /tmp/hstrace.log HS_FDS_SHAREABLE_NAME = /usr/lib64/libtdsodbc.so.0
The first line is the key mapping line here we are saying the listener has routed something with a SID_NAME of DEMO to this file – this will now go off and try and find a HS_FDS_CONNECT_INFO (the DSN basically) – also called DEMO.
We then need a tns entry for out client to be able to find out where this SQL Server DB is – note the content refers to the local server on the new listener port we just created (nothing remote here) and we have to include the special HS=OK value to tell oracle there is some crazy odbc stuff going on.
DEMO = ( DESCRIPTION = ( ADDRESS = ( PROTOCOL = TCP ) ( HOST = servername) ( PORT = 1545 ) ) ( CONNECT_DATA = ( SID = DEMO ) ) ( HS = OK ) )
If we try and tnsping this address
tnsping demo
TNS Ping Utility for Linux: Version 11.2.0.2.0 – Production on 10-DEC-2014 19:42:19
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files: /oracle/11.2.0.2.0.DB/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact ( DESCRIPTION = ( ADDRESS = ( PROTOCOL = TCP) ( HOST = server) ( PORT = 1545)) ( CONNECT_DATA = ( SID = DEMO)) ( HS = OK)) TNS-12541: TNS:no listener
We get a failure as the listener is not started – so lets start it
lsnrctl start demo
LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 10-DEC-2014 19:42:42
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/11.2.0.2.0.DB/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.2.0.2.0 – Production System parameter file is /oracle/11.2.0.2.0.DB/network/admin/listener.ora Log messages written to /oracle/diag/tnslsnr/server/demo/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1545))) TNS-01201: Listener cannot find executable /oracle/11.2.0.2.0.DB/bin/hsodbc for SID DEMO
Listener failed to start. See the error message(s) above…
And now begins the first of many issues in getting this working…. At least this first issue is obvious – it’s back to the point i mentioned earlier – the whole thing was renamed so hsodbc no longer exists – i need to update my listener entry with the new program dg4odbc – which i do below
DEMO = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1545)) ) )
SID_LIST_DEMO = (SID_LIST = (SID_DESC= (SID_NAME=DEMO) (ORACLE_HOME=/oracle/11.2.0.2.0.DB) (PROGRAM=dg4odbc) ) )
Now i try and start it again
lsnrctl start demo
LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 10-DEC-2014 19:45:15
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/11.2.0.2.0.DB/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.2.0.2.0 – Production System parameter file is /oracle/11.2.0.2.0.DB/network/admin/listener.ora Log messages written to /oracle/diag/tnslsnr/server/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server=1545)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server=1545))) STATUS of the LISTENER ———————— Alias demo Version TNSLSNR for Linux: Version 11.2.0.2.0 – Production Start Date 10-DEC-2014 19:45:16 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/11.2.0.2.0.DB/network/admin/listener.ora Listener Log File /oracle/diag/tnslsnr/server/alert/log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server=1545))) Services Summary… Service “DEMO” has 1 instance(s). Instance “DEMO”, status UNKNOWN, has 1 handler(s) for this service… The command completed successfully
Thats better – now lets try the tnsping
tnsping demo
TNS Ping Utility for Linux: Version 11.2.0.2.0 – Production on 10-DEC-2014 19:45:28
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files: /oracle/11.2.0.2.0.DB/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact ( DESCRIPTION = ( ADDRESS = ( PROTOCOL = TCP) ( HOST = server) ( PORT = 1545)) ( CONNECT_DATA = ( SID = DEMO)) ( HS = OK)) OK (10 msec)
So now we are looking good
Lets try sqlplus now to this connection (using some random username/password)
sqlplus a/b@demo
SQL*Plus: Release 11.2.0.2.0 Production on Wed Dec 10 19:46:08 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-28547: connection to server failed, probable Oracle Net admin error
That’s not good…a check in the log directory shows this…..
$ORACLE_HOME/hs/log
Oracle Corporation — WEDNESDAY DEC 10 2014 19:46:08.804
Heterogeneous Agent Release 11.2.0.2.0
HS Agent diagnosed error on initial communication, probable cause is an error in network administration Network error 2: NCR-00002: NCR: Invalid usage HS Gateway: NULL connection context at exit
But the listener seems happy enough…..
10-DEC-2014 19:48:24 * (CONNECT_DATA=(SID=DEMO)(CID=(PROGRAM=sqlplus@server)(HOST=server)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=51495)) * establish * DEMO * 0
So what could be wrong – a bit of digging (hoping really as there was not a lot to go on) revealed that maybe i had to tell it exactly where the odbc.ini file was – so i did that in the initDEMO.ora file by adding a line at the end.
HS_FDS_CONNECT_INFO = DEMO HS_FDS_TRACE_LEVEL = Debug HS_FDS_TRACE_FILE_NAME = /tmp/hstrace.log HS_FDS_SHAREABLE_NAME = /usr/lib64/libtdsodbc.so.0 set ODBCINI=/etc/unixODBC/odbc.ini
I also realized that i had to also add some environment specific LD_LIBRARY_PATH settings so that the listener would be able to find all the libraries it needed – so i added an extra line to the listener.ora as shown below
DEMO = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1545)) ) )
SID_LIST_DEMO = (SID_LIST = (SID_DESC= (SID_NAME=DEMO) (ORACLE_HOME=/oracle/11.2.0.2.0.DB) (PROGRAM=dg4odbc) (ENVS=LD_LIBRARY_PATH=/usr/lib64/unixODBC:$ORACLE_HOME/lib) ) )
To check these are picked up ok after a restart we can do some clever stuff in lsnrctl to reveal it – see demo below
LSNRCTL> set displaymode verbose Service display mode is VERBOSE LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1545))) Services Summary… Service “DEMO” has 1 instance(s). Instance “DEMO”, status UNKNOWN, has 1 handler(s) for this service… Handler(s): “DEDICATED” established:1 refused:0 LOCAL SERVER (ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0.2.0.DB/bin/dg4odbc)(ENVS=’LD_LIBRARY_PATH=/usr/lib64/unixODB C:$ORACLE_HOME/lib,ORACLE_HOME=/oracle/11.2.0.2.0.DB,ORACLE_SID=DEMO’)(ARGV0=dg4odbcDEMO)(ARGS='(LOCAL=NO)’)) The command completed successfully
So now feeling confident lets create a database link and give it a try….. (and note i used username and password in double quotes to force the specific case to be kept)
create database link demo connect to “username” identified by “password” using ‘DEMO’;
Database link created.
Now lets try and select from it
select product from “master.sys.databases”@demo; select product from “master.sys.databases”@demo * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from DEMO
And a suitable disaster – lets check the logs again – and at least we get something better to go on – progress at least
from hs/log directory
Entered hgolofns at 2014/12/10-20:12:04 hoaerr:28500 Exiting hgolofns at 2014/12/10-20:12:04 Failed to load ODBC library symbol: /usr/lib64/libtdsodbc.so.0(SQLDescribeParam)
A bit of digging again revealed the issue – i had mentioned the freetds library in my config – that was wrong – i needed the generic unixodbc library – so i updated that in the initDEMO.ora file
HS_FDS_CONNECT_INFO = DEMO HS_FDS_TRACE_LEVEL = Debug HS_FDS_TRACE_FILE_NAME = /tmp/hstrace.log HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so set ODBCINI=/etc/unixODBC/odbc.ini
I restarted listener just in case and tried again
select product from “master.sys.databases”@demo; select product from “master.sys.databases”@demo * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [
Still not working but the trace file changed
Exiting hgopoer, rc=0 at 2014/12/10-20:17:04 hgocont, line 2754: calling SqlDriverConnect got sqlstate I Exiting hgocont, rc=28500 at 2014/12/10-20:17:04 with error ptr FILE:hgocont.c LINE:2774 FUNCTION:hgocont() ID:Something other than invalid authorization Exiting hgolgon, rc=28500 at 2014/12/10-20:17:04 with error ptr FILE:hgolgon.c LINE:790 FUNCTION:hgolgon() ID:Calling hgocont
Another quick search revealed that this setting may need to be mentioned in the odbc.ini and odbcinst.ini for all freetds connections
TDS_Version = 8.0
So i added the line into the odbc.ini and odbcinst.ini (well i had to use odbcinst to do it – you might be able to just vi the file) – as an example here is the odbcinst.ini config now
cat odbcinst.ini
[FreeTDS] Description = FreeTDS unixODBC Driver Driver = /usr/lib64/libtdsodbc.so.0 Setup = /usr/lib64/libtdsodbc.so.0 UsageCount = 3 TDS_Version = 8.0I then tried again…this time getting a different error – ORA-28513 returned – looking and traces and googling then revealed a multibyte characterset problem – this could be resolved by setting yet another config line in the initDEMO.ora config file to fix the LANGUAGE/CHARSET to be used – see HS_LANGUAGE below
cat initDEMO.ora HS_FDS_CONNECT_INFO = DEMO HS_FDS_TRACE_LEVEL = Debug HS_FDS_TRACE_FILE_NAME = /tmp/hstrace.log HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1 set ODBCINI=/etc/unixODBC/odbc.ini
And we try again……..
select product from “master.sys.databases”@demo; select product from “master.sys.databases”@demo * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [unixODBC][FreeTDS][SQL Server]Login failed for user ‘username’. {42000,NativeErr = 18456}[unixODBC][FreeTDS][SQL Server]Unable to connect to data source {08001} ORA-02063: preceding 2 lines from DEMO
And this is the first point where it looks like a credential issue – lets see what sql server says
Message Login failed for user ‘username’. Reason: Password did not match that for the login provided. [CLIENT: server]
And sure enough i discovered a type in my password – lets fix that by dropping and recreating the db link to give it the correct password.
And now we try again (again)
select product from “master.sys.databases”@demo; select product from “master.sys.databases”@demo * ERROR at line 1: ORA-00942: table or view does not exist [FreeTDS][SQL Server]Invalid object name ‘master.sys.databases’. {42S02,NativeErr = 208}[FreeTDS][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}[FreeTDS][SQL Server]Invalid object name ‘master.sys.databases’. {42S02,NativeErr = 208}[FreeTDS][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180} ORA-02063: preceding 2 lines from DEMO
Now that’s looking much better -it connected it just doesn’t like my SQL – lets try something a bit simpler with none of that dot business going on
select * from table_i_know_exists@demo
and it works (for a few rows)
until…..
ERROR: ORA-28528: Heterogeneous Services datatype conversion error ORA-02063: preceding line from DEMO
Aaargh
Another investigation shows me its some 32/64 conversion error going on somewhere in the chain – again there is an easy fix
Another new config line in initDEMO.ora (you can see a pattern developing here right……) This time its HS_FDS_SQLLEN_INTERPRETATION=32
HS_FDS_CONNECT_INFO = DEMO HS_FDS_TRACE_LEVEL = Debug HS_FDS_TRACE_FILE_NAME = /tmp/hstrace.log HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1 HS_FDS_SQLLEN_INTERPRETATION=32 set ODBCINI=/etc/unixODBC/odbc.ini
Now with that all added it works a treat! Now i just need to switch off the debug stuff so it runs much faster!
So there you have it how to link oracle directly to SQL Server – for free! (well as long as you don’t need to buy ODBC drivers its free as this function is part of the base product from Oracle). There are further enhanced version of these kind of connections (referred to as gateways) where there is a specific extra piece of software to be installed – this is all discussed in this excellent blog note from oracle here:
https://blogs.oracle.com/db/entry/oracle_gateway_master_note
Within that it refers to a metalink ( i still refuse to call it MOS) note which explicit states the facts from a licence point of view:
https://support.oracle.com/epmos/faces/DocumentDisplay?id=232482.1
So what are you waiting for give it a try………
Now with all my (off topic) posting about SQL Server these past few weeks it was inevitable that at some point i would want to create a direct link between Oracle and SQL Server for interfacing.
Create a postgres with dg4odbc oracle dblink
dblink oracle to postgres with dg4odbc. ORA-28500: connection between ORACLE and a non-Oracle system returned this message: ORA-02063: preceding line Hi, I am creating the database link from a database of Oracle 11 g PostgreSQL with DG4ODBC and unixODBC My configured for /etc/odbc.ini [PostgreSQL] Description = Test to Postgres Driver = psqlodbc Trace = Yes Trace file = /tmp/sql.log Database = danieldb ServerName = UserName = SA Password = password Port = 5432 Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No My configured for /etc/odbcinst.ini [ODBC] CommLog = 1 Debug = 1 FileUsage = 1 Layout common = No Trace = 1 [psqlodbc] Description = PostgreSQL ODBC driver Driver=/usr/lib64/psqlodbcw.so CommLog = 1 Debug = 0 FileUsage = 1 My configured for /u01/app/oracle/product/11.2.0/xe/hs/admin/initPostgreSQL.ora HS_FDS_CONNECT_INFO = PostgreSQL HS_FDS_TRACE_LEVEL = 0 HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbcpsql.so Set ODBCINI=/etc/odbc.ini My configured for /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora Listener = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle-poc)(PORT = 1521)) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PostgreSQL) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe) (PROGRAM = dg4odbc) (ENVS=”LD_LIBRARY_PATH=/usr/lib64:/u01/app/oracle/product/11.2.0/xe/lib’) ) ) My configured for /u01/app/oracle/product/11.2.0/xe/network/admin/tnsname.ora PostgreSQL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle-poc)(PORT = 1521)) (CONNECT_DATA = (SID = PostgreSQL) ) (HS = OK) ) I’m trying to created public database link: CREATE DATABASE LINK PUBLIC ‘orapos’ CONNECT to ‘HIS’ IDENTIFIED BY ‘password’ USING ‘PostgreSQL ‘; When I used tnsping [[email protected] admin] # tnsping PostgreSQL AMT Ping utility for Linux: Version 11.2.0.2.0 – Production on May 16, 2013 20:34:19 Copyright (c) 1997, 2011, Oracle. All rights reserved. Use settings files: /U01/app/Oracle/product/11.2.0/XE/network/admin/SQLNET.ora TNSNAMES adapter used to resolve the alias Try to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle-poc)(PORT = 1521)) (CONNECT_DATA = (SID = PostgreSQL)) (HS = OK)) OK (0 msec) and finally, I try to use the database link: “SQL > select * from tabel2″@orapos “. 2; Select * from ‘tabel2″@orapos ‘. * ERROR on line 1: ORA-28500: connection between ORACLE and a non-Oracle system has sent this message: ORA-02063: preceding the line of ORAPOS What wrong with my setup? Thank you and best regards, Daniel Daniel, The problem is that you are using the ODBC Postgres driver for the HS_FDS_SHAREABLE_NAME parameter, but this must be an ODBC driver manager and not the driver ODBC Psotgres.
Go to the. http://www.unixODBC.org/ Click the ‘Download’ and follow the instructions to download the 2.3.1 pilot and make libraries and programs. Once this is done, then use the driver as parameter HS_FDS_SHAREABLE_NAME Manager, for example- HS_FDS_SHAREABLE_NAME =/home/odbc64/unixODBC/2.3.1/lib/libodbc.so Depending on where you install it. Kind regards Mike
10.2.0.4 to Informix with dg4odbc Oracle connection error We have Oracle 10.2.0.4 in RHEL 4 (x86_64). We have installed Oracle Gateway (11.1.0.6.0) in an another ORACLE_HOME to connect to databases via ODBC.
We have successfully installed and configured an ODBC connection to the SQL Server through Oracle Gateway with UnixODBC + FreeTDS. The dblinks works very well.
We are now trying to set up another connection to a server, Informix (32-bit), but we get this error:
—–
SQL > select * from [email protected]_informix;
Select * from [email protected]_informix
*
ERROR on line 1:
ORA-28500: connection between ORACLE and a non-Oracle system has sent this message:
[Informix] [Informix ODBC Driver] Driver is not capable.ORA-02063: preceding 2 lines of TEST_INFORMIX
—–
However, we are able to connect with isql
—–
[email protected] $ isql – v test_informix—————————————
| Connected!
| |
| SQL query |
| help [tablename] |
| quit smoking |
| |
—————————————
SQL > select * from tabla1;
————
| Cola |
————
| 10.
| 11.
————
SQLRowCount Returns-1
2 lines read
—–
We have set up the 3.50.FC4DE of the Informix CSDK for Linux with UnixODBC like this:
—–
odbcinst.ini
—–
[Informix]Description = Informix ODBC Driver
Driver=/usr/share/Informix/lib/CLI/libifcli.so
APILevel = 1
ConnectFunctions = YYY
DriverODBCVer = 03.51
FileUsage = 0
SQLLevel = 1
smProcessPerConnect = Y
—–
—–
HS Oracle newspaper
—–
Oracle Corporation – Monday 10 August 2009 12:40:00.373
Heterogeneous Agent release
11.1.0.6.0
Oracle Corporation – Monday 10 August 2009 12:40:00.372
Version 11.1.0.6.0
Hgogprd entries
HOSGIP to ‘HS_FDS_TRACE_LEVEL’ returned ‘4 ‘.
Hgosdip entries
default assignment of 50 HS_OPEN_CURSORS
setting HS_FDS_RECOVERY_ACCOUNT or ‘RECOVER ‘.
HS_FDS_RECOVERY_PWD layout to the default
layout HS_FDS_TRANSACTION_LOG or “HS_TRANSACTION_LOG”.
layout by default HS_FDS_TRANSACTION_ISOLATION of “READ_COMMITTED”.
layout by default «AL32UTF8» HS_NLS_NCHAR
parameter HS_FDS_TIMESTAMP_AS_DATE if there is no ‘TRUE ‘.
layout HS_RPC_FETCH_REBLOCKING failure to ‘ON ‘.
HS_FDS_FETCH_ROWS layout without ‘100 ‘.
parameter HS_FDS_RESULTSET_SUPPORT default ‘FALSE ‘.
parameter HS_FDS_PROC_IS_FUNC default ‘FALSE ‘.
parameter HS_FDS_CHARACTER_SEMANTICS default ‘FALSE ‘.
parameter HS_FDS_MAP_NCHAR if there is no ‘TRUE ‘.
setting HS_NLS_DATE_FORMAT or ‘YYYY-MM-DD HH24:MI:SS “.
parameter HS_FDS_REPORT_REAL_AS_DOUBLE default ‘FALSE ‘.
HS_LONG_PIECE_TRANSFER_SIZE layout without “65536”.
parameter HS_SQL_HANDLE_STMT_REUSE default ‘FALSE ‘.
parameter HS_FDS_QUERY_DRIVER if there is no ‘TRUE ‘.
parameter HS_FDS_SUPPORT_STATISTICS default ‘FALSE ‘.
HS_CALL_NAME_ISP layout “gtw$: SQLTables; GTW$: SQLColumns. GTW$: SQLPrimaryKeys. GTW$: SQLForeignKeys. GTW$: SQLProcedures. “gtw$: SQLStatistics.
Release of hgosdip, rc = 0
ORACLE_SID is ‘test_informix ‘.
Product information:
Port RLS / Upd:6 / 0 PrdStat:0
Agent: Oracle Database Gateway for ODBC
: Installation
Class: ODBC, ClassVsn:11.1.0.6.0_0006, Instance: test_informix
Release of hgogprd, rc = 0
Hgoinit entries
HOCXU_COMP_CSET = 1
HOCXU_DRV_CSET = 31
HOCXU_DRV_NCHAR = 873
HOCXU_DB_CSET = 31
HOCXU_SEM_VER = 102000
Entry hgolofn to 2009/08/10-12:40:00
HOSGIP to ‘HS_FDS_SHAREABLE_NAME’ returned ‘ / usr/local/lib/libodbc.so ‘.
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLAllocHandle
symbol_peflctx = 0x9893b70d
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLBindCol
symbol_peflctx = 0x9893b873
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLBindParameter
symbol_peflctx = 0x9893c2e4
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLCancel
symbol_peflctx = 0x9893dc84
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLDescribeParam
symbol_peflctx = 0x98948f10
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLDisconnect
symbol_peflctx = 0x989495c8
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLEndTran
symbol_peflctx = 0x9894c4d4
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLExecute
symbol_peflctx = 0x9894e17c
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLFetch
symbol_peflctx = 0x9894ed04
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLFreeHandle
symbol_peflctx = 0x98950fc9
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLFreeStmt
symbol_peflctx = 0x98950fec
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetData
symbol_peflctx = 0x989531dc
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetEnvAttr
symbol_peflctx = 0x98956fa8
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetFunctions
symbol_peflctx = 0x989573c4
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLMoreResults
symbol_peflctx = 0x98959b28
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLNumResultCols
symbol_peflctx = 0x9895aad8
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLParamData
symbol_peflctx = 0x9895aedc
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLPutData
symbol_peflctx = 0x9895d908
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLRowCount
symbol_peflctx = 0x9895de78
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLSetEnvAttr
symbol_peflctx = 0 x 98960458
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLSetDescRec
symbol_peflctx = 0 x 98960230
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLColAttribute
symbol_peflctx = 0x9893e4ec
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLColumns
symbol_peflctx = 0x989406e4
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLConnect
symbol_peflctx = 0 x 98946014
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLDescribeCol
symbol_peflctx = 0x989484f0
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLDriverConnect
symbol_peflctx = 0x9894a337
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLExecDirect
symbol_peflctx = 0x9894d9e2
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLForeignKeys
symbol_peflctx = 0x9894fbdc
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetConnectAttr
symbol_peflctx = 0x989514ab
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetDiagField
symbol_peflctx = 0x989557f3
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetDiagRec
symbol_peflctx = 0x989566e5
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetInfo
symbol_peflctx = 0 x 98958083
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetStmtAttr
symbol_peflctx = 0x989583e3
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLGetTypeInfo
symbol_peflctx = 0 x 98959548
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLPrepare
symbol_peflctx = 0x9895b9c6
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLPrimaryKeys
symbol_peflctx = 0x9895c13e
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLProcedureColumns
symbol_peflctx = 0x9895c938
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLProcedures
symbol_peflctx = 0x9895d19a
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLSetConnectAttr
symbol_peflctx = 0x9895e1fc
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLSetStmtAttr
symbol_peflctx = 0x989624a8
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLSetDescField
symbol_peflctx = 0x9895fe5a
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLStatistics
symbol_peflctx = 0x98964ed6
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Entry hgolofns to 2009/08/10-12:40:00
LIBNAME=/usr/local/lib/libodbc.so, funcname is SQLTables
symbol_peflctx = 0 x 98966014
hoaerr:0
Out of hgolofns at 2009/08/10-12:40:00
Out of hgolofn, rc = 0 to 2009/08/10-12:40:00
HOSGIP to ‘HS_OPEN_CURSORS’ returned ’50 ‘.
HOSGIP to ‘HS_FDS_FETCH_ROWS’ returned ‘100 ‘.
HOSGIP for “HS_LONG_PIECE_TRANSFER_SIZE” returned “65536”.
HOSGIP to ‘HS_NLS_NUMERIC_CHARACTER’ returned ‘. ”
Out of hgoinit, rc = 0 to 2009/08/10-12:40:00
Entry hgolgon to 2009/08/10-12:40:00
Reco:0, name: informix, tflag:0
Entry hgosuec to 2009/08/10-12:40:00
Out of hgosuec, rc = 0 to 2009/08/10-12:40:00
HOSGIP to ‘HS_FDS_RECOVERY_ACCOUNT’ returned ‘RECOVER ‘.
HOSGIP to ‘HS_FDS_TRANSACTION_LOG’ returns “”HS_TRANSACTION_LOG”
HOSGIP for “HS_FDS_TIMESTAMP_AS_DATE” returns ‘TRUE ‘.
HOSGIP to ‘HS_FDS_CHARACTER_SEMANTICS’ returned ‘FALSE ‘.
HOSGIP for “HS_FDS_MAP_NCHAR” returns ‘TRUE ‘.
HOSGIP to ‘HS_FDS_RESULT_SET_SUPPORT’ returned ‘FALSE ‘.
HOSGIP to ‘HS_FDS_PROC_IS_FUNC’ returned ‘FALSE ‘.
HOSGIP to ‘HS_FDS_REPORT_REAL_AS_DOUBLE’ returned ‘FALSE ‘.
using informix as a default value to “HS_FDS_DEFAULT_OWNER”.
HOSGIP to ‘HS_SQL_HANDLE_STMT_REUSE’ returned ‘FALSE ‘.
Entry hgocont to 2009/08/10-12:40:00
HS_FDS_CONNECT_INFO = “test_informix”.
RC =-1 of HOSGIP for ‘HS_FDS_CONNECT_STRING ‘.
Entry hgogenconstr to 2009/08/10-12:40:00
DSN:test_informix, name: informix
OPTN:
# > (len = 42) connection settings < #. # DSN = test_informix; #! UID = informix; #! PWD = *. Out of hgogenconstr, rc = 0 to 2009/08/10-12:40:00 DriverName:iclis09b.so, DriverVer: 3.50.0000 3.50.U DBMS name: Informix, DBMS Version: 07.31.0000 UD5 Out of hgocont, rc = 0 to 2009/08/10-12:40:00 SQLGetInfo Returns Y for SQL_CATALOG_NAME SQLGetInfo returns 18 for SQL_MAX_CATALOG_NAME_LEN Out of hgolgon, rc = 0 to 2009/08/10-12:40:00 Entry hgoulcp to 2009/08/10-12:40:00 Entry hgowlst to 2009/08/10-12:40:00 Out of hgowlst, rc = 0 to 2009/08/10-12:40:00 SQLGetInfo returns for SQL_IDENTIFIER_QUOTE_CHAR SQLGetInfo returns N for SQL_COLUMN_ALIAS Out of hgoulcp, rc = 0 to 2009/08/10-12:40:00 Entry hgouldt to 2009/08/10-12:40:00 Out of hgouldt, rc = 0 to 2009/08/10-12:40:00 Entry hgobegn to 2009/08/10-12:40:00 tflag:0, original: 1 Hoi:0xbfffe728, ttid (len 24) is... 00: 54534554 3135352E 36616133 31312E37 [TEST.5513aa67.11] 10: 2E35332E 38303131 [. 35.1108] tbid (len 10) is... 0: 0023000B 00000454 0104 [.. #.] T.....] Entry hgopoer to 2009/08/10-12:40:00 hgopoer, line 159: got error native-11092 and sqlstate HYC00; message follows... [Informix] [Informix ODBC Driver] Driver is not capable. Out of hgopoer, rc = 0 to 2009/08/10-12:40:00 hgobegn, line 176: calling SQLEndTran obtained sqlstate HYC00 Out of hgobegn, rc = 28500 to 2009/08/10-12:40:00 with error ptr FILE: hgobegn.c LINE: 176 FUNCTION: hgobegn() call ID:SqlEndTran Entry hgolgof to 2009/08/10-12: 40:51 tflag:1 Out of hgolgof, rc = 0 to 2009/08/10-12: 40:51 Entry hgoexit to 2009/08/10-12: 40:51 Out of hgoexit, rc = 0 to 2009/08/10-12: 40:51 ----- Any ideas? Thank you! DataDirect offered in the past a driver suitable for Informix 7.3. Maybe you should get in touch with their support on a driver. Now for the problem of the Transaction: DG4ODBC usually opens a transaction because it allows to the commit or rollback, a update/insert/delete. When the Informix database is nolog mode the open transaction fails. You can enable logging on the Informix database, but it might cause reduced performance on the Informix db. Another approach is a patch generated for DG4IFMX (7417128), which can also be used for DG4ODBC well after the re-establishment of links then customer and the DG4ODBC: genagtsh $ORACLE_HOME/lib/libagtsh.so 1.0 do idg4odbc $ORACLE_HOME/rdbms/lib/ins_rdbms.mk f Check out Metalink if she is available for your platform and set the parameter as described in the readme file. He has worked in the past with of Datadirect ODBC drivers. Unfortunately it failed for some Informix drivers. Rather than buy the Datadirect ODBC driver, you may also think of the use of the DG4IFMX. He is certified with 7.31 Informix. error with DG4ODBC implementing connectivity to oracle for IBM iSeries AS400 version V7R1 Hello I have linux Enterprise 64-bit database hosting Oracle 11 GR 2 64-bit (11.2.0.1). I have access to IBM iSeries AS400 version V7R1. I'm trying to connect to IBM iSeries of Oracle database with ODBC connectivity using the database link. Here's what I did. Host (Linux) database installed iSeriesAccess - 7.1.0 - 1.0.x86_64.rpm provided by IBM. My odbcinst.ini file has the following entries: [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 [iSeries Access ODBC Driver] Description = iSeries Access for Linux ODBC Driver Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so Note 1 = if you use unixODBC-2.2.11 or later and you want ODBC 32 and 64-bit DSN, pilots to share Note 2 = the following Driver64/Setup64 keywords provide which support. Driver64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so Thread = 2 DontDLClose = 1 UsageCount = 1 [iSeries Access ODBC Driver 64-bit] Description = iSeries Access for Linux 64 - bit ODBC Driver Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so Thread = 2 DontDLClose = 1 UsageCount = 1 The odbc.ini contains the following entries: [ODBC data sources] dg4odbc = connection to db2 [dg4odbc] Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Description = iSeries Access for Linux ODBC Driver LogonID = Password = Address = (IBM host, IP address) location = Vm520 noprompt = true System = (IBM host, IP address) UNICODE = UTF-8 Naming = 0 ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 0 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar = 0 ForceTranslation = 0 Trace = 0 made sure I was able to connect via ODBC and DSN using the following command: isql dg4odbc oracle oracle1 - v +---------------------------------------+ | Connected! | | | | SQL query | | help [tablename] | | quit | | | +---------------------------------------+ SQL > SQLRowCount Returns-1 600 lines read SQL > could query the table in a library on AS400. The $ORACLE_HOME/hs/admin/initdg4odbc.ora includes the following: # This is an example of initialization file of the agent that contains the HS settings # necessary for the database to ODBC gateway # # HS init parameters # HS_FDS_CONNECT_INFO = dg4odbc HS_FDS_TRACE_LEVEL = off HS_FDS_SHAREABLE_NAME=/etc/newlib/libodbc.so HS_FDS_TRACE_LEVEL = 255 HS_FDS_SUPPORT_STATISTICS = FALSE # # ODBC specific environment variables # Set ODBCINI=/etc/odbc.ini # # Required for the non-Oracle system environment variables # The listener entries are as follows: (SID_DESC = (SID_NAME = dg4odbc) (ORACLE_HOME = opt/oracle/dbs/product/11.2.0/dbhome_1) (PROGRAM = dg4odbc) ) Stopped and started the listener. The TNS entry is as follows: armcdb2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = vmw – dev – rmsdb.xxx.vmc)(PORT = 1521)) (CONNECT_DATA = (SID = dg4odbc) ) (HS = OK) ) Pourriez tnsping: Tnsping armcdb2 [email protected][/opt/Oracle/DBs/product/11.2.0/dbhome_1/network/admin]$ AMT Ping utility for Linux: Version 11.2.0.1.0 – Production on July 11, 2013 16:01:23 Copyright (c) 1997, 2009, Oracle. All rights reserved. Use settings files: /opt/Oracle/DBs/product/11.2.0/dbhome_1/network/admin/SQLNET.ora TNSNAMES adapter used to resolve the alias Try to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = vmw – dev – rmsdb.xxx.vmc)(PORT = 1521)) (CONNECT_DATA = (SID = dg4odbc)) (HS = OK)) OK (0 msec) create a link from public database as follows: SQL > create database link samplink connect to ‘oracle’ identified by ‘oracle1’ with ‘armcdb2 ‘; Database link created. When I run a select query I get as follows: SQL > select * from mdiaz. [email protected]; Select * from mdiaz. [email protected] * ERROR on line 1: ORA-28500: connection between ORACLE and a non-Oracle system has sent this message: 408 Here is a sample track of dg4odbc: Oracle Corporation – Thursday 11 July 2013 16:06:03.627 Heterogeneous Agent release 11.2.0.1.0 Oracle Corporation – Thursday 11 July 2013 16:06:03.627 Version 11.2.0.1.0 Hgogprd entries HOSGIP to ‘HS_FDS_TRACE_LEVEL’ returned ‘255 ‘. Hgosdip entries default assignment of 50 HS_OPEN_CURSORS setting HS_FDS_RECOVERY_ACCOUNT or ‘RECOVER ‘. HS_FDS_RECOVERY_PWD layout to the default default HS_FDS_TRANSACTION_LOG of HS_TRANSACTION_LOG layout HS_IDLE_TIMEOUT layout to the default 0 value layout by default HS_FDS_TRANSACTION_ISOLATION of “READ_COMMITTED”. layout by default «AL32UTF8» HS_NLS_NCHAR layout HS_FDS_TIMESTAMP_MAPPING default ‘DATE ‘. layout HS_FDS_DATE_MAPPING default ‘DATE ‘. layout HS_RPC_FETCH_REBLOCKING failure to ‘ON ‘. HS_FDS_FETCH_ROWS layout without ‘100 ‘. parameter HS_FDS_RESULTSET_SUPPORT default ‘FALSE ‘. parameter HS_FDS_RSET_RETURN_ROWCOUNT default ‘FALSE ‘. parameter HS_FDS_PROC_IS_FUNC default ‘FALSE ‘. parameter HS_FDS_CHARACTER_SEMANTICS default ‘FALSE ‘. parameter HS_FDS_MAP_NCHAR if there is no ‘TRUE ‘. setting HS_NLS_DATE_FORMAT or ‘YYYY-MM-DD HH24:MI:SS “. parameter HS_FDS_REPORT_REAL_AS_DOUBLE default ‘FALSE ‘. HS_LONG_PIECE_TRANSFER_SIZE layout without “65536”. parameter HS_SQL_HANDLE_STMT_REUSE default ‘FALSE ‘. parameter HS_FDS_QUERY_DRIVER if there is no ‘TRUE ‘. HOSGIP returned the value ‘FALSE’ to HS_FDS_SUPPORT_STATISTICS The HS_FDS_QUOTE_IDENTIFIER parameter is not defined setting in HS_KEEP_REMOTE_COLUMN_SIZE if ‘OFF ‘. parameter HS_FDS_GRAPHIC_TO_MBCS default ‘FALSE ‘. parameter HS_FDS_MBCS_TO_GRAPHIC default ‘FALSE ‘. Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION HS_CALL_NAME_ISP layout “gtw$: SQLTables; GTW$: SQLColumns. GTW$: SQLPrimaryKeys. GTW$: SQLForeignKeys. GTW$: SQLProcedures. GTW$: SQLStatistics; “gtw$: SQLGetInfo. parameter HS_FDS_DELAYED_OPEN if there is no ‘TRUE ‘. HS_FDS_WORKAROUNDS layout by default “0”. Release of hgosdip, rc = 0 ORACLE_SID is “dg4odbc. Product information: Port RLS / Upd:1 / 0 PrdStat:0 Agent: Oracle Database Gateway for ODBC : Installation Class: ODBC, ClassVsn:11.2.0.1.0_0008, Instance: dg4odbc Release of hgogprd, rc = 0 hostmstr: 0: HOA after hoagprd hostmstr: 0: HOA before hoainit Hgoinit entries HOCXU_COMP_CSET = 1 HOCXU_DRV_CSET = 871 HOCXU_DRV_NCHAR = 873 HOCXU_DB_CSET = 871 HOCXU_SEM_VER = 112000 Entry hgolofn to 2013/07/11-16: 06:03 HOSGIP to ‘HS_FDS_SHAREABLE_NAME’ returned ‘ / etc/newlib/libodbc.so ‘. Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLAllocHandle symbol_peflctx = 0xaab7c2f0 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLBindCol symbol_peflctx = 0xaab7c9d0 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLBindParameter symbol_peflctx = 0xaab7cb6c hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLCancel symbol_peflctx = 0xaab7d416 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLDescribeParam symbol_peflctx = 0xaab7f7dc hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLDisconnect symbol_peflctx = 0xaab7f978 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLEndTran symbol_peflctx = 0xaab7fe42 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLExecute symbol_peflctx = 0xaab808ac hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLFetch symbol_peflctx = 0xaab80b5c hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLFreeHandle symbol_peflctx = 0xaab816aa hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLFreeStmt symbol_peflctx = 0xaab82144 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetData symbol_peflctx = 0xaab83ad8 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetEnvAttr symbol_peflctx = 0xaab84e42 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetFunctions symbol_peflctx = 0xaab84fce hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLMoreResults symbol_peflctx = 0xaab85a0a hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLNumResultCols symbol_peflctx = 0xaab85fba hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLParamData symbol_peflctx = 0xaab86102 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLPutData symbol_peflctx = 0xaab871fc hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLRowCount symbol_peflctx = 0xaab87364 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLSetEnvAttr symbol_peflctx = 0xaab89054 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLSetDescRec symbol_peflctx = 0xaab88e20 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLColAttributeW symbol_peflctx = 0xaab7d6ba hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLColumnsW symbol_peflctx = 0xaab7e264 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLConnectW symbol_peflctx = 0xaab7e6b4 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLDescribeColW symbol_peflctx = 0xaab7f39e hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLDriverConnectW symbol_peflctx = 0xaab7fa9a hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLExecDirectW symbol_peflctx = 0xaab805e6 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLForeignKeysW symbol_peflctx = 0xaab80de6 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetConnectAttrW symbol_peflctx = 0xaab82714 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetDescFieldW symbol_peflctx = 0xaab83c76 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetDescRecW symbol_peflctx = 0xaab83fbe hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetDiagFieldW symbol_peflctx = 0xaab8448a hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetDiagRecW symbol_peflctx = 0xaab84916 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetInfoW symbol_peflctx = 0xaab85136 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetStmtAttrW symbol_peflctx = 0xaab85456 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLGetTypeInfoW symbol_peflctx = 0xaab8576e hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLPrepareW symbol_peflctx = 0xaab863b0 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLPrimaryKeysW symbol_peflctx = 0xaab8667c hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLProcedureColumnsW symbol_peflctx = 0xaab86a14 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLProceduresW symbol_peflctx = 0xaab86e64 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLSetConnectAttrW symbol_peflctx = 0xaab874ac hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLSetStmtAttrW symbol_peflctx = 0xaab896c8 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLSetDescFieldW symbol_peflctx = 0xaab88b00 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLStatisticsW symbol_peflctx = 0xaab89e64 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Entry hgolofns to 2013/07/11-16: 06:03 LIBNAME=/etc/newlib/libodbc.so, funcname is SQLTablesW symbol_peflctx = 0xaab8a668 hoaerr:0 Out of hgolofns to 2013/07/11-16: 06:03 Release of hgolofn, rc = 0 to 2013/07/11-16: 06:03 HOSGIP to ‘HS_OPEN_CURSORS’ returned ’50 ‘. HOSGIP to ‘HS_FDS_FETCH_ROWS’ returned ‘100 ‘. HOSGIP for “HS_LONG_PIECE_TRANSFER_SIZE” returned “65536”. HOSGIP to ‘HS_NLS_NUMERIC_CHARACTER’ returned ‘. ” HOSGIP to ‘HS_KEEP_REMOTE_COLUMN_SIZE’ returned ‘OFF ‘. HOSGIP for “HS_FDS_DELAYED_OPEN” returns ‘TRUE ‘. HOSGIP to ‘HS_FDS_WORKAROUNDS’ returned ‘0 ‘. HOSGIP to ‘HS_FDS_MBCS_TO_GRAPHIC’ returned ‘FALSE ‘. HOSGIP to ‘HS_FDS_GRAPHIC_TO_MBCS’ returned ‘FALSE ‘. Invalid value of 64 for HS_FDS_SQLLEN_INTERPRETATION treat_SQLLEN_as_compiled = 1 Release of hgoinit, rc = 0 to 2013/07/11-16: 06:03 hostmstr: 0: HOA after hoainit hostmstr: 0: HOA before hoalgon Entry hgolgon to 2013/07/11-16: 06:03 name: oracle, reco:0, tflag:0 Entry hgosuec to 2013/07/11-16: 06:03 Release of hgosuec, rc = 0 to 2013/07/11-16: 06:03 Entry hgopoer to 2013/07/11-16: 06:03 hgopoer, line 233: had native error 408 and sqlstate 410; message follows… 408 Release of hgopoer, rc = 0 to 2013/07/11-16: 06:03 hgolgon, line 193: calling SQLSetConnectAttr obtained sqlstate 410 Out of hgolgon, rc = 28500 to 2013/07/11-16: 06:03 with the ptr error FILE: hgolgon.c LINE: 193 FUNCTION: hgolgon() ID:Connection attribute: TRACE hostmstr: 0: HOA after hoalgon The RPC nscontrol (0), rc = 0 hostmstr: 0: CPP before release Agent hostmstr: 0: HOA before hoaexit Entry hgoexit to 2013/07/11-16: 06:03 Release of hgoexit, rc = 0 hostmstr: 0: HOA after hoaexit hostmstr: 0: CPP after release Agent I have looked up on the forums of Oracle errors and could not do any help anywhere. Can someone kindly help where I’m wrong? Thank you RAM. You have activated the gateway trace level 255 (HS_FDS_TRACE_LEVEL = 255) which includes also ODBC calls but there is no reference in your file odbc.ini to trace odbc library and it seems that the trace ODBC lib is not found in the ODBC driver manager lib directory. Test without bridge tracing turned on (just remove the parameter HS_FDS_TRACE_LEVEL = 255). In addition, I recommend to add to your gateway init file: HS_FDS_FETCH_ROWS = 1 (as the iSeries ODBC is not supported in bulk pick) and HS_NLS_NCHAR = UCS2 -Klaus
Create a table with all kinds of oracle data types? Hello
who can give me a small example to create a table with all kinds of oracle data types? and the example to insert it?
Thank you
Roy Hello Read the fine manual. It contains examples at the end of the chapter. http://download.Oracle.com/docs/CD/B19306_01/server.102/b14200/statements_7002.htm I don’t know if you know that you can also create your own data types using ‘create a type ‘. So look for examples that are of your interest and not for all types of data. Concerning Published by: skvaish1 on February 16, 2010 15:33
SSRS for lack of outer join with the Oracle data source It seems to be a problem with the Oracle driver used in the Reporting SERVICES query designer. When you use an Oracle data source, if I create an outer join in the graphic designer, it automatically inserts ‘{OJ’ before the join and ‘} ‘ after her. This is an incorrect syntax for Oracle and refuses to start. The curly braces and the JO editable in designer text, but if I go back to the graphic designer and immediately to reintegrate them. Only, this has started to happen a year or two ago – before that it worked, but with the old (+) syntax. Can it not be healed? It makes things very difficult. -Geoff Hi Geoff, Thanks for posting in the Microsoft Community. However, the question you posted would be better suited in the Forums of the Oracle Support; We recommend that you post your query in Oracle Support Forums to get help: https://forums.Oracle.com/forums/main.jspa;JSESSIONID=8d92100c30d8fb401bcbd10b46c38c9ddf1a3242549a.e34SbxmSbNyKai0Lc3mPbhmSc3aNe0? CategoryID = 84 If you have any other questions or you need Windows guru, do not hesitate to post your questions and we will be happy to help you.
IMP-00017: statement failed with error ORACLE 1658: # imp system/pass fromuser = touser = file=/disk1/Downloads/dmp/MI61015.dmp databaseName databaseName Import: Release 11.2.0.2.0 – Production on Sat Oct 10 09:29:32 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11 g Express Edition Release 11.2.0.2.0 – 64 bit Production Export file created by EXPORT: V11.02.00 by conventional means import performed AL32UTF8 and AL16UTF16 NCHAR character set Customer export uses the (possible character set conversion) US7ASCII character set . imported objects from databaseName databaseName . . import of table ‘ACCOUNTS’ 12 rows imported . . table import ‘AGREEMENTS’ 6 imported lines . . importing table “ASSIGNEDDEPT” 0 rows imported . . import of 2713 lines imported from the table ‘BULKSAVEDCVS ‘. . . import of table “CERTIFICATION” 7 lines imported . . importing table “COMMONDOCS” 0 rows imported . . table import ‘COUNTRY’ 256 imported lines . . importing table “CVCATEGORIES” 6 imported lines . . table ‘CVCERTIFICATION’ import 92 lines imported . . importing table “CVCHECKAGAIN” 56 imported lines . . importing table “CVDETAILS”. IMP-00058: ORACLE error 1653 ORA-01653: unable to extend table databaseName.CVDETAILS 8192 in the SYSTEM tablespace IMP-00028: partial import of the restored previous table: 20960 restored lines . . table ‘CVLICENSE’ import 756 lines imported . . importing table “CVPROPERTIES” 69752 imported lines . . rows in table ‘CVSPECIALTY’ import imported 6159 . . import of 1701 lines imported from the table ‘CVVIEWS ‘. . . “DEPT” table import 2 lines imported IMP-00017: statement failed with error ORACLE 1658: ‘ CREATE TABLE ‘DETAILRESUME’ (“D_ID” (14: 0), THE NUMBER OF ‘CV_ID’ (14: 0), “”). “NUMBER OF ‘CAT_ID’ (14: 0), ‘DETAILRESUME’ CLOB) INITRANS PCTUSED 40 PCTFREE 10. 1 MAXTRANS 255′ STORAGE ‘ (INITIALS 67108864 THEN 1048576 MINEXTENTS 1 FREELIST). “S 1 FREELIST GROUPS 1 DEFAULT USER_TABLES) TABLESPACE ‘SYSTEM’ LOGGING NOCO. “COMPRESS LOB (“DETAILRESUME”) AS STORE BASICFILE (TABLESPACE ‘SYSTEM’ ENABLE ‘. “CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE (INITIAL 6” ONLINE STORAGE “. “THE NEXT 5536 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 USER_TABLES OF.” “FAULT)). IMP-00003: ORACLE error 1658 ORA-01658: unable to create the INITIAL extent for segment in tablespace SYSTEM . . importing table “DOCCATEGORIES” 0 rows imported . . table ‘EMPLOYERORAGENT’ import 62 lines imported . . table ‘FAQ’ import 4 lines imported . . importing table “FOLDERCVS” 6 imported lines . . table import ‘FOLDERS’ 3 imported lines . . “JOBDETAILS” table import 84 lines imported . . table ‘JOBKEYWORDS’ import 190 lines imported . . table ‘JOBPOSTINGS’ import 84 lines imported . . import of table ‘JOBPROPERTIES’ 89 imported lines . . table ‘JOBRESPONSES’ import 64019 lines imported . . table import “LICENSE” 20 imported lines . . import of table ‘MESSAGES’ 0 rows imported . . table import ‘NEWS’ 0 rows imported . . table import “SPECIALTY” 301 lines imported . . table import “STAFF” 12 rows imported . . table import ‘TICKET’ 0 rows imported . . importing table “TICKETCATEGORY” 0 rows imported . . importing table “TICKETTEMPLATES” 0 rows imported . . import of rows in table ‘USERS’ 4410 imported About to activate the constraints… Import completed successfully with warnings. # Please advise. Thank you in anticipation Christy H. wrote: How can I increase its space? That drive you some people to knowledge, but you can’t make them think. http://www.lmgtfy.com/?q=Oracle+increase+tablespace+size
Is it possible to create a shuttle component in Oracle ADF, where the available and selected lists are tables of the adf? Hi all
We use JDeveloper Studio Edition Version 12.1.3.0.0 and deployed on GlassFish Server Open Source Edition 3.1.2.2 (build 5) and connect to the SQLServer database.
Is it possible to create a shuttle component in Oracle ADF, where the available and selected lists are tables of the adf?
I did a POC sample on it. I can share with you. I can’t put in my dropbox because dropbox is blocked in my network. Share your email. I’ll send the POC through
Feature line with key oracle.jbo.key is not found I’ve seen similar issues posted here but no go in enough detail to help me solve the problem I have just started using Oracle ADF a few hours ago. I have connected to our oracle successfully database and set up the display of an entity based on a base table which seems to have worked very well. When I run AppModule I see all the fields of the fine table, but when I change a content of columns to a valid value, and then click validation I get this error: “line entity with key oracle.jbo.key [all fields in table] is not found in the table” even though I don’t know why, because it is without a doubt. The base table is a table of configuration when a new record is added manually a sequence is triggered to autopopulate the column id of the table. I read that this trigger could be the problem but I’m not sure why, as I’m only an update on an existing id, not create new ones? User, tell us your version of jdev, please! The framework must be a primary key defined on a table that you want to update. It will be weird if your doe not table a PK. define a pk in the table (if you cannot change the db, you can define the pk in the framework and try again. Timo
srvrmgr syntax: How can I create subsystem named with the name and Description of the values? Looking through the library, he did discuss are of syntax that allows you to include the value of name and the named value of the Description of a subsystem/Profile Configuration. In the screenshot, the circled values were created with the server online order Manager. On the other hand, pouvez create a definition of the element with a name (full name) and a Description. For CompDef, it works:
create the CompDefTest1_enu component definition for the type of component AppObjMgr component fins group run mode interactive full name ‘Test Comp Def Test 1’ description ‘Test 1 CompDef Manager object. For named Subsytem, it does NOT work:
create named subsystem Test5 subsystem EAITransportDataHandlingSubsys full name ‘Test 5’ description ‘Test 5 Description’ Someone can tell me if there is a good for a named subsystem, syntax to include the name and Description of the values in the command line, or is the only way to create it manually in the UI? Hello I spent reviewing aid to create the order in srvrmgr, it does not give the full name and description as parameters for the creation of subsystem. However, as you noted these settings are available for creating components definition: srvrmgr > help to create Create {component group | compgrp} [full name: ] [{description | desc} ] create {definition component: compdef} for {component type | comptype} {Component group | compgrp} run in mode {batch | interactive | background} [full name: ] [{description | desc} ] [with [ param = [, = …]]] [[fixparam = [,…]]] create the subsystem named for subsystem with = [,…] Shelf also has an example of creation of subsystem that doesn’t include no description, name and first name: http://docs.Oracle.com/CD/E14004_01/books/StoreFwdMsg/StoreFwdMsg_InstallConfig14.html#wp1351472 In this case I suggest that allows you to create a ticket on My Oracle Support to confirm this srvrmgr does not support the creation of a new subsystem with the full name and description settings and request an enhancement for these settings include request in create statement for new subsystems when using srvrmgr. It will be useful, WSiebel
Can u create a tablespace with these settings? I use 12.1 DB. I need to create a tablespace with 1 data file (say abc.dbf), initial size is 10 MB, but I need grow no more than 1 GB. I tried the user guide. You can give the initial size of the DB using SIZE 10 M, but I couldn’t find a way to give an upper limit for the tablespace. There are 2 settings in the DBA_TABLESPACES view. Maximum default MAX_EXTENTS NUMBER of extensions Maximum default size of max_size NUMBER of segments (in Oracle block) There is no clause in measure Network Management of the TABLESPACE CREATE & segment management of the sous-clauses to give a maximum number. Is how Oracle works is like, if you create a tablespace with a data file of 1 G, with autoextend NO, then it will grow to 1 G and then stops? If so, what did MAX_EXTENTS & MAX_SIZE really means? The physical limitations of the database for 12 c gives this information: Blocks of database Maximum per data file Load platform; generally 222 – 1 blocks So, if my block size is 8 k, then the maximum size for the data file is just 8192) /(1024*1024*1024) ((2^22-1) * = 32 GB, which is very low for a single file of data?) SQL > create tablespace foo 2 datafile ‘c:\temp\foo.dbf’ size 10 m autoextend on maxsize 1 g; Created tablespace.
Issue by creating OPSS schema with UCR. Hello There is a problem in creating the OPSS schema in oracle DB 11.2.0.3.0 even if the UCR (Oracle Fusion Middleware repository creation Utility 11 g (11.1.2.1.0) ) it finished without error with status of the schema opss success at the end of the create operation.
But the opss schema validation is getting does not, as evidenced by this query! I have the security configuration of the OPSS of this Doc store refferenced SQL > jps_dn desc; ERROR: ORA-04043: jps_dn of the object does not exist There is no error in the log of the RCU and opss.log as well. Also NO problem to utter the other schema of OIM, OAAM, OAM Wonder what I’m missing here that preventing the shema not reflecting only or no Validation of it put failed in the database. Also, I tried changing this value sec_case_sensitive_logon to false to true in the comic book, but without result. in both cases the OPSS is getting failed schema validation. Greately appreciate any suggestion. Please see the following summary of the operation of the remote control Repository creation utility: create – completion summary Information on the database: Host name: ebs.oracle.com Port: 1521 Service name: IAM. ORACLE.COM Logged in as: sys Prefix for schema owners (prefixable): DEV RCU Logfile: /data/Rootdownloads/rcuHome/rcu/log/logdir.2013-09-25_04-57/rcu.log Of component schemas that you created: The Logfile /data/Rootdownloads/rcuHome/rcu/log/logdir.2013-09-25_04-57/opss.log component status Oracle Platform Security Services Success Please suggest. Thank you Priya Hi Priya; This scheme is activated? If please check below step 1 link part and compare it with your steps SOA11g: Data Base as a policy store. RedStack Respect of HELIOS
How to create the table with the description of the table Hello I would like to create the array with the description of the table (such as the creation of package or procedure with comments). Is it possible to achieve thanks to the oracle, if possible please help me achieve this goal. Thank you and best regards, Ibrahim Sayyed. > create table test (col1 number); > comment table test is “about a comment ‘; > select comments from user_tab_comments where table_name = ‘TEST ‘; COMMENTS
____________________________________________________________________
This is a comment
Shannon’s JD Edwards CNC Blog: Using heterogeneous database services to connect to AS
There are a heap of instructions of what you need to change if you change the IP address of your weblogic server, but I find they are not co…
Connector/ODBC
I am using MYSQL CONNECTOR as a driver for ODBC connection to a MYSQL database.
It is generally working nicecly, but I recently encountered an unexpected problem when the program runs on certain computers.
I am aware of the problem by getting a message from the server that indicates a SQL syntax error. The message is truncated, so I cannot see enough to really see what the error is.
From some investigation I have found this pattern:
If I generate a SQL query and issue it as a command, this seems to work on any computer.
Example (always works) ——————————-
dim query as string
Dim cmd As New ADODB.Command
cmd.ActiveConnection = conn (valid working connection)
query = “UPDATE TABLENAME SET FIELDNAME = ‘SOMETHING’ WHERE OTHERFIELD = ‘x’;
cmd.CommandText = query
cmd.Execute
Example (doesn’t work on some compuers) ————
Set recset = New ADODB.Recordset
query = “SELECT * FROM TABLENAME;”
recset.Open query, conn, adOpenDynamic, adLockOptimistic
recset.fields(“FIELDNAME”) = “SOMETHING”
recset.update
recset.close
It seems to me that the ODBC recordset is converting the action into a MYSQL query and sending it to the database, and hence the error comes up as a syntax problem. However, when I send the SQL query directly as a command, it doesn’t cause this problem.
I have some suspicion that the problem may relate to a language or locale setting, but the different computers seem to be the same as far as I can tell.
Does anyone know how I can see the actual SQL query that the recordset object is sending to the server? Or know how the recordset (update) method works to send differently from the command.execute method?
I may be forced to rewrite my code to use only the command route, but the recordset methodology is much more convenient and, (I was hoping) more efficient.
In case it helps, the connection to the MYSQL server is like this:
constring = “DRIVER=MySQL ODBC 8.0 Unicode Driver;”
constring = constring & “PORT=3306;SERVER=xxxxxx;”
constring = constring & “database=defschema”
Thanks in advance for any insights…
키워드에 대한 정보 hs gateway null connection context at exit
다음은 Bing에서 hs gateway null connection context at exit 주제에 대한 검색 결과입니다. 필요한 경우 더 읽을 수 있습니다.
이 기사는 인터넷의 다양한 출처에서 편집되었습니다. 이 기사가 유용했기를 바랍니다. 이 기사가 유용하다고 생각되면 공유하십시오. 매우 감사합니다!
사람들이 주제에 대해 자주 검색하는 키워드 #33 Connect Sql Server Database in Oracle | Heterogeneous Service in Oracle |Oracle Database Gateway
- heterogeneous service in oracle
- connect to microsoft sql server database in oracle
- sql server in oracle
- connect with sql server in oracle
- oracle database gateway
- odbc and oracle
- oracle
- oracle19c
- oracle dba
- sql
- sql server
- ms sql server
- connect ms sql server and oracle
- connect sql server and oracle
- how to connect ms sql in oracle
#33 #Connect #Sql #Server #Database #in #Oracle #| #Heterogeneous #Service #in #Oracle #|Oracle #Database #Gateway
YouTube에서 hs gateway null connection context at exit 주제의 다른 동영상 보기
주제에 대한 기사를 시청해 주셔서 감사합니다 #33 Connect Sql Server Database in Oracle | Heterogeneous Service in Oracle |Oracle Database Gateway | hs gateway null connection context at exit, 이 기사가 유용하다고 생각되면 공유하십시오, 매우 감사합니다.
