I have downloaded oracle sql developer to access Remote database. After downloading i couldn't connect to the database. I don't have tns.ora file installed in my system neither do i have oracle_home. Do I need to install oracle database too in order to have tns.ora file in my system.

  • You don't need tnsnames.ora or an oracle_home to connect to a remote server. What exactly is the error you get? – a_horse_with_no_name Jul 29 '19 at 12:30

SQL Developer can connect to Oracle databases without Oracle client and tnsnames.ora.

Creating a Database Connection Using SQL Developer

enter image description here

More details you can read at the above url.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.