Heterogenous database link between Oracle database and MSSQL was created using the below command.
SQL> create public database link mssql connect to “integration” identified by “*****” using ‘dg4msql’;
Database link created.
Error Message
SQL> select sysdate from dual@mssql
2 ;
select sysdate from dual@mssql
*
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 MSSQL
LISTENER_GTWY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclegtwy.dmn)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
)
)
(SID_NAME=dg4msql)
(ORACLE_HOME=/orabin/gateway_mssql/product/12.1.0/tghome_1)
(ENV=”LD_LIBRARY_PATH=/orabin/gateway_mssql/product/12.1.0/tghome_1/dg4msql/driver/lib:/orabin/gateway_mssql/product/12.1.0/tghome_1/lib”)
(PROGRAM=dg4msql)
SQL> create public database link mssql connect to “integration” identified by “*****” using ‘dg4msql’;
Database link created.
Error Message
SQL> select sysdate from dual@mssql
2 ;
select sysdate from dual@mssql
*
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 MSSQL
LISTENER_GTWY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclegtwy.dmn)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
)
)
(SID_NAME=dg4msql)
(ORACLE_HOME=/orabin/gateway_mssql/product/12.1.0/tghome_1)
(ENV=”LD_LIBRARY_PATH=/orabin/gateway_mssql/product/12.1.0/tghome_1/dg4msql/driver/lib:/orabin/gateway_mssql/product/12.1.0/tghome_1/lib”)
(PROGRAM=dg4msql)
Resolution
Listener file on the Oracle Database gateway server should look like below
LISTENER_GTWY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =oraclegtwy.dmn)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
)
)
SID_LIST_LISTENER_GTWY =————————>Missing
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=/orabin/gateway_mssql/product/12.1.0/tghome_1)
(ENV=”LD_LIBRARY_PATH=/orabin/gateway_mssql/product/12.1.0/tghome_1/dg4msql/driver/lib:/orabin/gateway_mssql/product/12.1.0/tghome_1/lib”)
(PROGRAM=dg4msql)
)
)
Hi, Neat post. There’s a problem with your site in internet explorer, would check this?IE still is the market leader and a big portion of people will miss your excellent writing because of this problem.
Great post. I was checking constantly this blog and I am impressed! Extremely useful information particularly the last part 🙂 I care for such information much. I was looking for this particular information for a very long time. Thank you and best of luck.
Your articles are very helpful to me. May I request more information? http://www.kayswell.com
Great content! Super high-quality! Keep it up! http://www.hairstylesvip.com
Thank you, I have recently been looking for info about this subject for ages and yours is the greatest I’ve discovered so far. But, what about the bottom line? Are you sure about the source?
Thanks for your help and for writing this post. It’s been great. http://www.kayswell.com
Good web site! I truly love how it is easy on my eyes and the data are well written. http://www.kayswell.com I am wondering how I could be notified whenever a new post has been made. I’ve subscribed to your RSS which must do the trick! Have a nice day!
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post
You’re so awesome! I don’t believe I have read a single thing like that before. So great to find someone with some original thoughts on this topic. Really.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!
Thank you for writing this article. I appreciate the subject too. http://www.kayswell.com
Good post! We will be linking to this particularly great post on our site. Keep up the great writing
I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
naturally like your web site however you need to take a look at the spelling on several of your posts. A number of them are rife with spelling problems and I find it very bothersome to tell the truth on the other hand I will surely come again again.