Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
Соединение с Access.
Oracle 11.1.0.6.0 на windows 2003 32bit

tnsnames.ora
APO_GW =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = XX.XX.XX.XX)
(PORT = 1541)
)
(CONNECT_DATA =
(SID = APO_GW)
)
(HS = OK)
)

listener.ora
LIST_ODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1541))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1541))
)
)

SID_LIST_LIST_ODBC =
(SID_LIST =
(SID_DESC =
(SID_NAME = APO_GW)
(ORACLE_HOME = D:\ORA\GATEWAYS)
(PROGRAM = dg4odbc)
)

)

initAPO_GW.ora

HS_FDS_CONNECT_INFO = APO2
HS_FDS_TARACE_LEVEL = 4

tnsping
D:\ORA\DB_SERVER\BIN>tnsping APO_Gw

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 14-МАР-2
008 16:20:17

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Использованы файлы параметров:
D:\ORA\DB_SERVER\network\admin\sqlnet.ora


Использован адаптер TNSNAMES для разрешения псевдонима
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xx.xx.x
x.xx) (PORT = 1541)) (CONNECT_DATA = (SID = APO_GW)) (HS = OK))
OK (30 мсек)

test database link
*********************************************************************
Link Name : "APO_GW"
Connection : Successful
*********************************************************************

SQL> select 1 from dual@apo_gw;

1
----------
1

А вот теперь проблема:
SQL> select * from v_ch17@apo_gw;
select * from v_ch17@apo_gw
*
ошибка в строке 1:
ORA-28500: соединение ORACLE с посторонней системой выдало сообщение:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
ORA-02063: предшествующий 2 lines из APO_GW

В чем может быть затык? Насколько я понимаю ODBC отбивает запрос из за того что чего-то не поддерживает ODBC microsoft. Понять бы что...
Помогите...
14 мар 08, 16:56    [5412530]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
На 10 все абсолютно тоже самое работает!
14 мар 08, 16:57    [5412545]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
aardwark
Guest
М.б. из-за наличия блобов в таблице.
Попробуйте выбрать отдельное поле.
15 мар 08, 12:03    [5414009]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
не блобов там нет. Пробовал и явно указывать поле и другую таблицу - тоже самое.
17 мар 08, 12:31    [5417922]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
не блобов там нет. Пробовал и явно указывать поле и другую таблицу - тоже самое.
17 мар 08, 12:43    [5418064]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
вот еще трейс от HSагента.

Oracle Corporation --- ВТОРНИК МАР 18 2008 00:47:46.521


Heterogeneous Agent Release
11.1.0.6.0




Oracle Corporation --- ВТОРНИК МАР 18 2008 00:47:46.521

Version 11.1.0.6.0

Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "12"
Entered hgosdip
setting HS_OPEN_CURSORS to default of 50
setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
setting HS_FDS_RECOVERY_PWD to default value
setting HS_FDS_TRANSACTION_LOG to default of "HS_TRANSACTION_LOG"
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "AL16UTF16"
setting HS_FDS_TIMESTAMP_AS_DATE to default of "TRUE"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
setting HS_FDS_FETCH_ROWS to default of "100"
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
setting HS_FDS_MAP_NCHAR to default of "TRUE"
setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
setting HS_FDS_QUERY_DRIVER to default of "TRUE"
setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics"
Exiting hgosdip, rc=0
ORACLE_SID is "APO"
Product-Info:
Port Rls/Upd:6/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:11.1.0.6.0_0006, Instance:APO
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=171
HOCXU_DRV_NCHAR=2000
HOCXU_DB_CSET=171
HOCXU_SEM_VER=110000
Entered hgolofn at 2008/03/18-00:47:46
Exiting hgolofn, rc=0 at 2008/03/18-00:47:46
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
Exiting hgoinit, rc=0 at 2008/03/18-00:47:46
Entered hgolgon at 2008/03/18-00:47:46
reco:0, name:ORA, tflag:0
Entered hgosuec at 2008/03/18-00:47:46
Exiting hgosuec, rc=0 at 2008/03/18-00:47:46
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned ""HS_TRANSACTION_LOG""
HOSGIP for "HS_FDS_TIMESTAMP_AS_DATE" returned "TRUE"
HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULT_SET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using ORA as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2008/03/18-00:47:46
HS_FDS_CONNECT_INFO = "apo"
RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2008/03/18-00:47:46
dsn:apo, name:ORA
optn:
##>Connect Parameters (len=23)<##
## DSN=apo;
#! UID=ORA;
#! PWD=*
Exiting hgogenconstr, rc=0 at 2008/03/18-00:47:46
DriverName:ACEODBC.DLL, DriverVer:Microsoft Office 2007 Access database engine
DBMS Name:ACCESS, DBMS Version:04.00.0000
Exiting hgocont, rc=0 at 2008/03/18-00:47:46
SQLGetInfo returns Y for SQL_CATALOG_NAME
SQLGetInfo returns 260 for SQL_MAX_CATALOG_NAME_LEN
Exiting hgolgon, rc=0 at 2008/03/18-00:47:46
Entered hgoulcp at 2008/03/18-00:47:46
Entered hgowlst at 2008/03/18-00:47:46
Exiting hgowlst, rc=0 at 2008/03/18-00:47:46
SQLGetInfo returns ` for SQL_IDENTIFIER_QUOTE_CHAR
SQLGetInfo returns Y for SQL_COLUMN_ALIAS
Exiting hgoulcp, rc=0 at 2008/03/18-00:47:46
Entered hgouldt at 2008/03/18-00:47:46
Exiting hgouldt, rc=0 at 2008/03/18-00:47:46
Entered hgobegn at 2008/03/18-00:47:46
tflag:0 , initial:1
hoi:0x12f054, ttid (len 22) is ...
00: 2E534352 36393032 62363263 322E382E [RCS.2096c26b.8.2]
10: 31312E38 3031 [8.1101]
tbid (len 19) is ...
00: 5B534352 38322E38 3031312E 315B5D31 [RCS[8.28.1101][1]
10: 2E345D [.4]]
Exiting hgobegn, rc=0 at 2008/03/18-00:47:46
Entered hgodtab at 2008/03/18-00:47:46
count:1
table: V_CH17
The hoada for table V_CH17 follows...
hgodtab, line 577: NO hoada to print
Exiting hgodtab, rc=0 at 2008/03/18-00:47:46
Entered hgopars, cursor id 1 at 2008/03/18-00:47:46
type:0
SQL text from hgopars, id=1, len=22 ...
00: 454C4553 2A205443 4F524620 5622204D [SELECT * FROM "V]
10: 3148435F 3722 [_CH17"]
Exiting hgopars, rc=0 at 2008/03/18-00:47:46
Entered hgoopen, cursor id 1 at 2008/03/18-00:47:46
hgoopen, line 83: NO hoada to print
Exiting hgoopen, rc=0 at 2008/03/18-00:47:46
Entered hgodscr, cursor id 1 at 2008/03/18-00:47:46
Entered hgopcda at 2008/03/18-00:47:46
Column:1(id): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:46
Entered hgopcda at 2008/03/18-00:47:46
Column:2(date): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:46
Entered hgopcda at 2008/03/18-00:47:46
Column:3(scab): dtype:12 (VARCHAR), prc/scl:2147483598/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:46
Entered hgopcda at 2008/03/18-00:47:46
Column:4(scan): dtype:12 (VARCHAR), prc/scl:2147483598/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:46
Entered hgopcda at 2008/03/18-00:47:47
Column:5(scas): dtype:12 (VARCHAR), prc/scl:2147483598/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:6(agent_login): dtype:12 (VARCHAR), prc/scl:50/0, nullbl:1, octet:100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:7(person): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:8(reason): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:9(note): dtype:12 (VARCHAR), prc/scl:2147483598/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:10(promisedate): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
Entered hgopcda at 2008/03/18-00:47:47
Column:11(dir): dtype:12 (VARCHAR), prc/scl:2147483598/0, nullbl:1, octet:-100, sign:1, radix:0
Exiting hgopcda, rc=0 at 2008/03/18-00:47:47
hgodscr, line 521: Printing hoada @ 0369D5C8
MAX:11, ACTUAL:11, BRC:1, WHT=5
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
4 INTEGER N 4 4 0/ 0 0 0 0 id
91 DATE Y 16 16 0/ 0 0 0 0 date
-1 LONGVARCHAR Y 0 0 0/ 0 0 0 20 scab
-1 LONGVARCHAR Y 0 0 0/ 0 0 0 20 scan
-1 LONGVARCHAR Y 0 0 0/ 0 0 0 20 scas
12 VARCHAR Y 100 100 0/ 0 0 0 0 agent_login
4 INTEGER Y 4 4 0/ 0 0 0 0 person
4 INTEGER Y 4 4 0/ 0 0 0 0 reason
-1 LONGVARCHAR Y 0 0 0/ 0 0 0 20 note
91 DATE Y 16 16 0/ 0 0 0 0 promisedate
-1 LONGVARCHAR Y 0 0 0/ 0 0 0 20 dir
Exiting hgodscr, rc=0 at 2008/03/18-00:47:47
Entered hgotcis at 2008/03/18-00:47:47
Calling SQLStatistics for V_CH17
Entered hgopoer at 2008/03/18-00:47:47
hgopoer, line 159: got native error 106 and sqlstate HYC00; message follows...
[Microsoft][Драйвер ODBC Microsoft Access]Дополнительная возможность не реализована
Exiting hgopoer, rc=0 at 2008/03/18-00:47:47
hgotcis, line 384: calling SQLStatistics got sqlstate HYC00
Exiting hgotcis, rc=28500 at 2008/03/18-00:47:47 with error ptr FILE:hgotcis.c LINE:384 ID:SQLStatistics
Entered hgoclse, cursor id 1 at 2008/03/18-00:47:58
Exiting hgoclse, rc=0 at 2008/03/18-00:47:58
Entered hgodafr, cursor id 1 at 2008/03/18-00:47:58
Exiting hgodafr, rc=0 at 2008/03/18-00:47:58
Entered hgocomm at 2008/03/18-00:47:58
keepinfo:0, tflag:1
00: 2E534352 36393032 62363263 322E382E [RCS.2096c26b.8.2]
10: 31312E38 3031 [8.1101]
tbid (len 19) is ...
00: 5B534352 38322E38 3031312E 315B5D31 [RCS[8.28.1101][1]
10: 2E345D [.4]]
cmt(0):
Entered hgocpctx at 2008/03/18-00:47:58
Exiting hgocpctx, rc=0 at 2008/03/18-00:47:58
Exiting hgocomm, rc=0 at 2008/03/18-00:47:58
18 мар 08, 01:00    [5421745]     Ответить | Цитировать Сообщить модератору
 Re: Проблемы с гетерогенным сервисом в 11g  [new]
apelevin
Member

Откуда:
Сообщений: 9
Проблема решена.
В initAPO_GW.ora добавлена строчка

HS_FDS_SUPPORT_STATISTICS=FALSE
21 мар 08, 03:55    [5439666]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить