brgdotnet
asked on
How to test a connection to Oracle
I am within my company firewall, and need to determine if I can connect to an Oracle database on a server within the firewall. How can I test the connection from my laptop to the server which has the Oracle database on it (A.K.A the Host).
Is there something I can do from the command line, or an application I can download that will perform the test?
Is there something I can do from the command line, or an application I can download that will perform the test?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Developer is here, if you elect that path (Oracle has updated their front page and made it harder to find): http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>Use TNSPING to test connection to Oracle,
TNSPING doesn't test connectivity to the database. It only tests connectivity to the listener. Same with telnet.
TNSPING doesn't test connectivity to the database. It only tests connectivity to the listener. Same with telnet.