Home > References > Checking if Oracle Listener is running on Windows

Checking if Oracle Listener is running on Windows

I recently found out how to check if an Oracle database is up and running.
On the server where oracle is installed:

  1. Open a command window.
  2. Type lsnrctl
  3. You will get a prompt the reads LSNRCTL>
  4. Type status
  5. If you see the xe* listeners in READY your database is up and running

lsnrct

If you can´t see the listeners on READY.  You need to start the database.

The following steps explain how to startup the database (be adviced this is an Oracle course configuration with no password).

  1. Open a command window
  2. Type sqlplus /nolog. You´ll get a SQLPLUS> prompt.
  3. Type conn / as ssysdba
  4. Type startup
Advertisements
Categories: References Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: