Best Oracle Client (free) similar to SSMS

I was using SSMS till now as I had to connect to only SQL Server DB. I now need to access Oracle DB remotely. Many websites mention it is possible to access Oracle DB via SSMS through a linked server. Assuming the linked server needs to be setup on the Oracle server machine and not on my machine (correct me if wrong), I do not see this as a possibility because of certain limitations. Are there any other free tools close to SSMS users here have experienced? Please share.
sukhoi35Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulEE Topic AdvisorCommented:
You may want to read about setting-up a linked server. You will need Oracle client software installed where SSMS is running.
e.g.
Oracle 11g to SQL 2008
http://www.itprotoday.com/microsoft-sql-server/connecting-sql-server-and-oracle-using-linked-servers

Oracle 11g to SQL 2014
https://www.mssqltips.com/sqlservertip/4396/creating-a-sql-server-2014-linked-server-for-an-oracle-11g-database/
0
Pawan KumarDatabase ExpertCommented:
>>I now need to access Oracle DB remotely. Many websites mention it is possible to access Oracle DB via SSMS through a linked server.
Yes it is possible to access the oracle DB from SQL Server. ( SSMS ) through a linked server.

Sample calling of SP from SSMS(SQL code)
DECLARE @Inout INT
SET @Inout = 10
EXEC ('BEGIN Sp_Name (?); END;', @Inout OUTPUT) AT [YourlinkedServeName]  
SELECT @Inout

Open in new window


Also note that you need to install proper drivers to make this working. Please prefer Oracle 12 client.

>>Assuming the linked server needs to be setup on the Oracle server machine and not on my machine (correct me if wrong),
No you have to set up the linked server on your MS SQL Server DB and with proper access. Once all is set we can use 4 part name to access the things
ServerName.TablName.schema.TableName

>>Are there any other free tools close to SSMS users here have experienced?
There are many tools. https://alternativeto.net/software/oracle-sql-developer/
DBeaver is free that you can try. There are others also which i have not explored.

>> My fav tools are dbForge Studio AND Toad for Oracle <<  This is an industry-standard tool for application development. >>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
While I don't work on Oracle, I hear from my friends and colleagues that Toad for Oracle is a good one and provides a reasonable degree of comfort.
0
sukhoi35Author Commented:
Thanks for your responses!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSMS

From novice to tech pro — start learning today.