tnsping tests only Oracle listener not database. one can create temporary file: set head off connect scott/tiger@mydb select 'mydb is available' from dual; exit run it with sqlplus -s /nolog @test.sql and analyze sqlplus output. but the best solution of course dbi