OS환경 : Oracle Linux 7.6, Windows Server 2012 (64bit)
DB 환경 : Oracle Database 12.1.0.2, SQL Server 2012
에러 : ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535
Oracle Linux 7.6 에 12c R1에서 Windows Server 2012 에 SQL Server 2012 로 db 링크 시도 시 발생한 메세지
1 2 3 4 5 6 | SQL> select * from table_1@msserver * 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 MSSERVER |
해결 방법 : tnsnames.ora 파일 수정
tnsnames.ora 파일 확인
1 2 3 4 5 6 7 8 9 10 | $ cat tnsnames.ora # tnsnames.ora Network Configuration File: /app/oracle/product/121/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ms2012 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SID_NAME = ms2012)) (HS = OK) ) |
SID_NAME 부분을 SID로 변경
1 2 3 4 5 6 7 8 9 10 | $ cat tnsnames.ora # tnsnames.ora Network Configuration File: /app/oracle/product/121/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ms2012 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SID = ms2012)) (HS = OK) ) |
db 링크 조회 재시도
1 2 3 4 5 | SQL> select * from table_1@msserver * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from MSSERVER |
기존 에러는 발생하지 않지만 다른 에러가 발생함
원인 : tnsnames.ora 파일의 오타 문제
tnsnames.ora 파일의 오타 문제
참조 : https://positivemh.tistory.com/626
https://stackoverflow.com/questions/58082868/oracle-xe-dg4odbc-connecting-to-sql-server-doesnt-work