I have already mentioned how to create a linked server that will connect to Oracle in the article named “How To Create a Linked Server To Connect To Oracle“.
This linked server can sometimes be very dangerous.
If you use sql comment comments — in oracle query in linked query and allow in process enable, sql server service crash.
If it crashes like this, you will get errors like the following screen shot.
To avoid this error, you should put your comments in the linked server query between /* */ instead of – – or remove the comment.