[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3054]
PSQL [135]
CUBRID [5]
기타정보 [158]
운영체제 [607]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

oracle db link for mssql
최길호 [LIST]   2016-09-02 18:10:35, 조회 : 21,640

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] ] 추가 [ (HS = OK) 위치 주의! ]
   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.9.151


최길호
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



  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 113
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 135
Admin  plsql run sql from column / 테이블에 저장된 SQL 실행 / print_table    최길호 2024/02/28 9
Admin  ORA-16198: LGWR received timedout error from KSR / 로그 기록    최길호 2024/02/23 8
Admin  ORA-02025: all tables in the SQL statement must be at the remote database    최길호 2024/02/20 12
Admin  (HS=OK) dblink windows listener stop/start hang    최길호 2024/02/15 6
Admin  TRIGGER ORA-00060: deadlock detected while waiting for resource / AUTONOMOUS_TRANSACTION    최길호 2024/02/14 6
Admin  PL/SQL error logging / autonomous_transaction / sqlerrm / ORA-04091    최길호 2024/02/08 20
Admin  ORA-00036: maximum number of recursive SQL levels (50) exceeded    최길호 2024/02/08 7
Admin  trigger ORA-04092: cannot COMMIT in a trigger / ORA-20000: Cannot drop object / RAISE_APPLICATION_ERROR / insert log    최길호 2024/02/07 4
Admin  IBM live migration / RAC 19c    최길호 2024/02/01 9
Troubleshoot  DDE: Problem Key 'ORA 600 [qosdExpStatRead: expcnt mismatch]' / _FIX_CONTROL / V$SYSTEM_FIX_CONTROL    최길호 2024/01/30 21
Backup and Recovery  dgmgrl / alter database activate standby database    최길호 2024/01/23 8
Admin  select CREATED,RESETLOGS_TIME,PRIOR_RESETLOGS_TIME,CONTROLFILE_CREATED,CONTROLFILE_TIME,VERSION_TIME from V$DATABASE    최길호 2024/01/23 8
Admin  recover standby database until time '2024/01/22 22:30:00';    최길호 2024/01/22 6
Admin  dgmgrl / alter database convert to snapshot standby [ flashback database ]    최길호 2024/01/22 10

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[153]   [다음 10개]
       

Copyright 1999-2024 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
03/04
[기타정보]
아두이노 wifi web test.
by 최길호
03/01
[기타정보]
아두이노 스마트하우스 V2.
by 최길호
02/28
[ORACLE]
plsql run sql from column / 테....
by 최길호