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.
SQL Developer can connect to Oracle databases without Oracle client and tnsnames.ora.
More details you can read at the above url.