After creating a heterogenous database link from Oracle database to MSSQL Server, getting error message “ORA-28500”
SQL>select sysdate from dual@DBLINK_MSSQL;
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host
Name and Port Number. {08001}
ORA-02063: preceding 2 lines from MSSQL_INTG
Reason
$ telnet MSSQLDB 1433
MSSQLDB/1433: Name or service not known
$ telnet 10.x.x.x 1433
Trying 10.x.x.x…
Connected to 10.x.x.x (10.x.x.x).
Escape character is ‘^]’.
^]
telnet> logout
^CConnection closed by foreign host.
I am able to telnet to MSSQL database Server using IP address , but cannot telnet to MSSQL server using hostname
SQL>select sysdate from dual@DBLINK_MSSQL;
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host
Name and Port Number. {08001}
ORA-02063: preceding 2 lines from MSSQL_INTG
Reason
$ telnet MSSQLDB 1433
MSSQLDB/1433: Name or service not known
$ telnet 10.x.x.x 1433
Trying 10.x.x.x…
Connected to 10.x.x.x (10.x.x.x).
Escape character is ‘^]’.
^]
telnet> logout
^CConnection closed by foreign host.
I am able to telnet to MSSQL database Server using IP address , but cannot telnet to MSSQL server using hostname
Solution
Contact your Network admin to allow access to 1433 using Servername (MSSQLDB)
(or)
Change the below configuration
1. Set Oracle Home to point to your Gateway Oracle HOME
2. Navigate to $ORACLE_HOME/dg4msql/admin
Change below values in initdg4msql.ora
changed HS_FDS_CONNECT_INFO from MSSQLDB to IP address
#
HS_FDS_CONNECT_INFO=10.x.x.x:1433//wfcdb
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
3. Restart the listener in Gateway Oracle HOME
4. Verify the database link is working fine.
SQL>select sysdate from dual@DBLINK_MSSQL;
==>Above Query should return current system date.
It’s a pity you don’t have a donate button! I’d most certainly donate to this brilliant blog! I guess for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will talk about this site with my Facebook group. Talk soon!
Thank you for your articles. I find them very helpful. Could you help me with something?
very informative articles or reviews at this time.
We stumbled over here coming from a different web page and thought I might check things out. I like what I see so now i’m following you.Look forward to finding out about your web page yet again. http://www.kayswell.com
Aw, this was a very nice post. Taking the time and actual effort to create a great article… but what can I say… I hesitate a whole lot and never seem to get nearly anything done. http://www.kayswell.com
It’s genuinely very difficult in this busy life to listen news on Television, so I just use world wide web for that reason, and take the most up-to-date news. http://www.kayswell.com
Hello my loved one! I wish to say that this post is amazing, great written and include approximately all significant infos. I would like to peer extra posts like this . http://www.kayswell.com
I’m curious to find out what blog system you have been using? I’m experiencing some small security issues with my latest blog and I’d like to find something more safe. Do you have any suggestions? http://www.hairstylesvip.com
I’m extremely impressed with your writing skills as well as with the layout on your weblog. Is this a paid theme or did you customize it yourself? Anyway keep up the excellent quality writing,it is rare to see a nice blog like this one today. http://www.kayswell.com
Ahaa, its fastidious discussion on the topic of this article at this place at this website, I have read all that, so now me also commenting at this place. http://www.kayswell.com
I’m not sure if this is a format issue or something to do with internet browser compatibility but I figured I’d post to let you know. The style and design look great though! Hope you get the issue fixed soon. Many thanks http://www.kayswell.com
This is a topic that’s near to my heart… Many thanks! http://www.kayswell.com Where are your contact details though?
I’ve been surfing online more than 3 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. Personally, if all webmasters and bloggers made good content as you did, the web will be much more useful than ever before. http://www.kayswell.com
Everyday consumption of weight reduction capsules can offer a number of physical benefits, consisting of enhanced cravings guideline and improved metabolic activity. http://www.kayswell.com These effects might add to a lot more efficient fat oxidation and continual energy throughout the day. In addition, some formulas support immune health and wellness and supply antioxidant benefits, which can be valuable during weight decrease efforts,
Hello, I enjoy reading all of your post. I wanted to write a little comment to support you. http://www.kayswell.com
I’m really enjoying the design and layout of your website.It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? http://www.kayswell.com
Now I am ready to do my breakfast, once having my breakfast coming over again to read more news http://www.kayswell.com
Do you mind if I quote a few of your articles as long as I provide credit and sources back to your website? My website is in the exact same area of interest as yours and my visitors would definitely benefit from some of the information you provide here. http://www.kayswell.com
Ahaa, its good dialogue regarding this article at this place at this website, I have read all that, so at this time me also commenting here. http://www.kayswell.com
Thank you for any other fantastic article. The place else may anyone get that type of info in such an ideal means of writing? I have a presentation subsequent week, and I’m at the search for such information. http://www.hairstylesvip.com
That is a very good tip especially to those new to the blogosphere. Short but very accurate information… Many thanks for sharing this one. A must read article! http://www.hairstylesvip.com
I am genuinely thankful to the owner of this web page who has shared this fantastic post at here. http://www.ifashionstyles.com