You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.
Open Command prompt.
Write tnsping < SID for the database connectivity you want to check >
If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.
If you get “TNS-03505: Failed to resolve name” message then tnsping utility is not able to resolve the service name and you need to check the SQLNET.ora and TNSNAMES.ora files on your machine.
Editorial Team at Geekinterview is a team of HR and Career Advice members led by Chandra Vennapoosa.
Editorial Team – who has written 1033 posts on Online Learning.