TNS Ping & SQLPLUS

tnsping is a utility to test your various oracle connections in tnsnames.ora.

it comes with your oracle.

Run the following tests once u install Oracle:

1)Start --> Run --> cmd

2) at the command prompt type in

tnsping

ex: if your tns entry is :

SRGTDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cmc8asff2.ny.jpmorgan.com)(PORT = 10005))
)
(CONNECT_DATA =
(SERVICE_NAME = APPRDEV)
)
)

type in :

tnsping SRGTDEV

YOU SHUD SEE THE FOLLOWING SCREEN




ALSO YOU CAN TYPE IN sqlplus at the command prompt to make sure ur oracle is properly installed. In that case you will see the following: