http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª­. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [69]
02.File Book
File ÀÚ·á½Ç [95]
Site Link [18]
°³ÀÎÆú´õ [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
±âŸÁ¤º¸ [150]
¿î¿µÃ¼Á¦ [577]
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, Á¶È¸ : 18,332

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.235.78.122


ÃÖ±æÈ£
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 134
Troubleshoot  DDE: Problem Key 'ORA 600 [13310]' was completely flood controlled (0x6)    ÃÖ±æÈ£ 2022/06/29 2
Oracle GoldenGate  Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.    ÃÖ±æÈ£ 2022/06/25 12
Admin  ORA-14452: attempt to create, alter or drop an index on temporary table already in use    ÃÖ±æÈ£ 2022/06/24 6
Admin  external table expdp    ÃÖ±æÈ£ 2022/06/18 26
Admin  clob to file / file to clob / clob_to_file / file_to_clob    ÃÖ±æÈ£ 2022/06/17 24
Troubleshoot  ORA-13203: failed to read USER_SDO_GEOM_METADATA view    ÃÖ±æÈ£ 2022/06/14 18
Troubleshoot  ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table    ÃÖ±æÈ£ 2022/06/13 22
Troubleshoot  Exception in kzam_upd_props, 942:ORA-00942: table or view does not exist    ÃÖ±æÈ£ 2022/06/11 21
Install and Config  Rocky Linux 8.6 Oracle 11.2    ÃÖ±æÈ£ 2022/06/03 29
Admin  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time    ÃÖ±æÈ£ 2022/06/02 31
Admin  http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm    ÃÖ±æÈ£ 2022/05/30 22
Admin  ÇÑ±Û ÆÄÀÏ ORA-22288: ÆÄÀÏ ¶Ç´Â LOB FILEOPEN ÀÛ¾÷ÀÌ ½ÇÆÐµÇ¾ú½À´Ï´Ù    ÃÖ±æÈ£ 2022/05/26 36
Admin  ORA-00001: unique constraint (SCOTT.TEST_PK) violated    ÃÖ±æÈ£ 2022/05/06 212
Troubleshoot  windows ORA-01031: insufficient privileges    ÃÖ±æÈ£ 2022/04/22 56
Admin  impdp ORA-01400: cannot insert NULL into , ORA-01449: column contains NULL    ÃÖ±æÈ£ 2022/04/19 52

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 1 [2][3][4][5][6][7][8][9][10]..[145]   [´ÙÀ½ 10°³]
       

Copyright 1999-2022 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 ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by ÃÖ±æÈ£
06/25
[ORACLE]
Replication may not be valid i....
by ÃÖ±æÈ£
06/22
[¿î¿µÃ¼Á¦]
CentOS7 ȨÆäÀÌÁö Migration ¸Þ¸ð.
by ÃÖ±æÈ£