{"id":2612,"date":"2012-07-10T13:15:55","date_gmt":"2012-07-10T17:15:55","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/07\/10\/database-tns-listener-not-working\/"},"modified":"2017-07-28T13:33:04","modified_gmt":"2017-07-28T17:33:04","slug":"database-tns-listener-not-working","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/07\/10\/database-tns-listener-not-working\/","title":{"rendered":"Database TNS Listener Not Working"},"content":{"rendered":"

If you try to log into PITSS.CON in Windows and you are unable to log in (not being able to go beyond the login screen) despite the fact you entered the correct credentials and the correct database, you should check to see if the TNS Listener is currently running.<\/p>\n

1. Test to see if you can ping your database by using the tnsping command in Command Prompt (cmd.exe).<\/p>\n

\"clip_image002\"<\/a><\/p>\n

If you receive the message \u201cTNS-12541: TNS:no listener\u201d or anything similar, then your database listener is currently stopped.<\/p>\n

\"clip_image004\"<\/a><\/p>\n

2. To turn on your TNS Listener, go to the Control Panel \u2013> Administrative Tools \u2013> Services<\/p>\n

\"clip_image006\"<\/a><\/p>\n

\"clip_image008\"<\/a><\/p>\n

3. Locate the TNS Listener associated with your database as shown here. Once you find it, click \u201cStart\u201d where it says \u201cStart the service\u201d. Notice how the word \u201cStarted\u201d isn\u2019t currently stated for the TNS Listener.<\/p>\n

\"clip_image010\"<\/a><\/p>\n

When the TNS Listener has started, you should see the screen below:<\/p>\n

\"clip_image012\"<\/a><\/p>\n

4. Test to see if you can ping your database again using tnsping inside Command Prompt.<\/p>\n

\"clip_image014\"<\/a><\/p>\n

As you can see above, we were able to successfully reach the database!<\/p>\n

5. You should now be able to log into PITSS.CON. If you reach the main menu after logging in as shown below, the TNS Listener is running and PITSS.CON can communicate with the database.<\/p>\n

\"image\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

If you try to log into PITSS.CON in Windows and you are unable to log in (not being able to go beyond the login screen) despite the fact you entered the correct credentials and the correct database, you should check to see if the TNS Listener is currently running. 1. Test to see if you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[95,6,14,10],"tags":[12,27,7],"class_list":["post-2612","post","type-post","status-publish","format-standard","hentry","category-database","category-pitss-con","category-resolve-issues","category-windows","tag-error","tag-oracle-database","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":5,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"predecessor-version":[{"id":9841,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2612\/revisions\/9841"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}