ORACLE Database Listener Check (WINDOWS OS)

1.  To open a command window, select Start --> Run --> cmd.

2.  To check the ORACLE Database Listener, type:

>tnsping mstore

For example:

Used TNSNAMES adapter to resolve the alias.

Attempting to contact (description= (address= (protocol=ipc) (key=mst1)) (connect_data=(sid=mst1)(srvr=dedicated)))

OK (10 msec)

3.  If OK does not appear, try to restart the Listener. Type:

>lsnrctl stop

>lsnrctl start

4.  Repeat the test.

If the test still fails, contact Customer Service.