Hi, my name is John Eisbrener and I am a Database Administrator drawing my experience from a wide variety of sectors. I’ve been lucky enough to be part of myriad projects including creating OLTP and OLAP solutions from the ground up, creating DR strategies, performance tuning, various database compliance auditing, implementing database solutions in clustered, distributed, and virtualized environments, data center migrations, very large database maintenance, etc. I’m versed in both Microsoft SQL Server and Oracle RDBMS solutions, but continuously find that I have much more to learn about both technologies. For a full breakdown of my skill set, feel free to peek at my LinkedIn profile, found here.
Your soup to nuts on the oracle 11g client is absolutely the best on the web.
We are truly struggling trying to install the 11g cleint on a Windows 2008 r2 Server.
I spent hours gleaning all the post. Your document is really great to sum up all that I found and more. Thank you very much.
That said, we installed a fresh Windows 2008r2 Server and followed the instructions. The TNSPing gets an error. And, it still failed after we set folder properties to read/write to set up some ORA files.
I found a post where people had the same issue with the TNSPing.
Several of them reported that even with the Windows Firewall turned off, They had to manually open a port.
My goal is to set up a SQL Server 2008 R2 Linked Server to Oracle DB.
The SQL Linked Server scripts are something I have done with DB other than Oracle. Was told that setting up the Oracle 11g Client was the best way to get that ODBC connectivity for SQL Server.
If you have suggestions, please let me know.
Thanks again for your great articles.
I’ll reach out to you via email for more information. This sounds like a good future post.
Just an FYI, about Oracles perception to get ODBC working on a Windows 2008 Server. Your article was gold!