|
|
IOTN :: Field Book :: ORACLE 
|
|
oracle db link for mssql
|
|
최길호
[LIST]
|
2016-09-02 18:10:35, 조회 : 20,583 |
initmssql.ora
HS_FDS_CONNECT_INFO = mssql
HS_FDS_TRACE_LEVEL = 4 # 저장 바로 적용
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = mssql)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\product\gw11g )
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = mssql )
(ORACLE_HOME = C:\oracle\product\gw11g )
(PROGRAM = dg4odbc)
)
)
tnsnames.ora
mssql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = mssql )
)
(HS=OK)
)
ADR_BASE_LISTENER = C:\oracle\product\gw11g
c:\windows\sysWOW64\odbcad32.exe
c:\windows\system32\odbcad32.exe
사용 방법
drop database link mssql;
drop public database link mssql;
create public database link mssql connect to sa identified by pwd using 'mssql';
select * from dbo.class@mssql;
관련 오류
[ 시스템 DNS [0] ]
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-02063: preceding line from mssql
//
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: 부적당한 사용법 [ ODBC 사용자 DNS [x] -> 시스템 DNS [0] ]
Network error 2: NCR-00002: NCR: Invalid usage
HS Gateway: NULL connection context at exit
[ HS_DB_NAME 제거 ]
ORA-28536: error in processing Heterogeneous Services initialization parameters
ORA-28508: invalid value mssql for Heterogeneous Services initialization parameter HS_DB_NAME [ HS_DB_NAME 제거 ]
ORA-02063: preceding 2 lines from mssql
//
Default value of 32 assumed for HS_FDS_SQLLEN_INTERPRETATION
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
setting HS_FDS_DELAYED_OPEN to default of "TRUE"
setting HS_FDS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
ORACLE_SID is "mssql"
Product-Info:
Port Rls/Upd:1/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:mssql
Exiting hgogprd, rc=0
HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: 읽기 오류.
Entered hgoexit
HS Gateway: NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:109 ID:Connection context
추가
Entered hgodtab at 2016/09/06-10:48:36
count:1
table: DBO.LOAD
Allocate hoada[0] @ 018435B8
Free hoada[0] @ 018435B8
Entered hgopdsc at 2016/09/06-10:48:37
Describing procedure DBO.LOAD
Output hoada
hgopdsc, line 1426: NO hoada to print
Exiting hgopdsc, rc=942 at 2016/09/06-10:48:37
The hoada for table DBO.LOAD follows...
hgodtab, line 904: NO hoada to print
Exiting hgodtab, rc=0 at 2016/09/06-10:48:38
Entered hgopars, cursor id 1 at 2016/09/06-10:48:38
type:0
SQL text from hgopars, id=1, len=26 ...
00: 53454C45 4354202A 2046524F 4D202244 [SELECT * FROM "D]
10: 424F222E 224C4F41 4422 [BO"."LOAD"]
Entered hgopoer at 2016/09/06-10:48:38
hgopoer, line 233: got native error 208 and sqlstate 42S02; message follows...
[Microsoft][ODBC SQL Server Driver][SQL Server]개체 이름 'DBO.LOAD'이(가) 잘못되었습니다. {42S02,NativeErr = 208}[Microsoft][ODBC SQL Server Driver][SQL Server]문을 준비할 수 없습니다. {42000,NativeErr = 8180}
Exiting hgopoer, rc=0 at 2016/09/06-10:48:38
hgopars, line 526: calling SQLNumResultCols got sqlstate 42S02
Exiting hgopars, rc=942 at 2016/09/06-10:48:38
>>ODBC DB NAME 추가
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC SQL Server Driver][SQL Server]로그인에서 요청한 데이터베이스
"ASRS"을(를) 열 수 없습니다. 로그인이 실패했습니다. {42000,NativeErr = 4060}
ORA-02063: preceding 2 lines from DAEDOO_SERVER
>> ASRS DB연결 오류 [ dblink 암호가 다름 ]
dblink excel
http://e-ammar.net/Oracle_TIPS/HS/configuring_generic_database_con.htm
|
3.239.112.140
|
|
|
|
|
|
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC ë“œë¼ì´ë²„ 관리ìž] ì§€ì •ëœ DSNì€ ë“œë¼ì´ë²„와 ì‘ìš© 프로그램 ê°„ 아키í…처 불ì¼ì¹˜ë¥¼ í¬í•¨í•©ë‹ˆë‹¤.
{IM014} ORA-02063: preceding 2 lines from MSSQL
영어로 보이게 하려면?
윈도우 서버에서 확인 또는 윈도우 서버 sqlplus 로그인해서 확인
HS_FDS_TRACE_LEVEL = 4
C:oracleproduct11.2.0dbhome_1hstracemssql_agt_2616.trc
hgopoer, line 231: got native error 0 and sqlstate IM014; message follows...
[Microsoft][ODBC 드라이버 관리자] 지정된 DSN은 드라이버와 응용 프로그램 간 아키텍처 불일치를 포함합니다. {IM014}
Exiting hgopoer, rc=0 at 2021/06/30-22:38:14
hgocont, line 2831: calling SqlDriverConnect got sqlstate IM014
Exiting hgocont, rc=28500 at 2021/06/30-22:38:14 with error ptr FILE:hgocont.c LINE:2851 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2021/06/30-22:38:14 with error ptr FILE:hgolgon.c LINE:806 ID:Calling hgocont
Entered hgoexit at 2021/06/30-22:38:14
Exiting hgoexit, rc=0 |
2021-06-30
22:53:55
|
|
|
|
|
윈도우 서버에서 sqlplus ....
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC 드라이버 관리자] 지정된 DSN은 드라이버와 응용 프로그램 간아키텍처 불일치를 포함합니다.
{IM014} ORA-02063: preceding 2 lines from MSSQL
=> 제어판\모든 제어판 항목 / 우측상단 찾기 : odbc
[ ODBC (64bit) / ODBC (32bit) ] 각각 실행 가능
=> windows cmd> lsnrctl status [ 32-bit 확인되면 32bit odbc로 다시 ] |
2021-06-30
23:05:28
|
|
Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
11/23 