Website Will Not Open Server Error In '/' Application No TNS Listener

Products

• CA Business Service Insight

Issue/Introduction

Description:

This Document was created as a guide to explain how to troubleshoot the error no tns listener when trying to open bsi.

Website will not open server error in '/' application.

Solution:

TNS:no listener

Purpose: This Document was created as a guide to explain how to troubleshoot the error no tns listener when trying to open bsi.

<Please see attached file for image>

Solution and Prevention:

Firstly, check your windows services to see if the tns listener is started and set to automatic.

If not start it and retry opening the bsi application.

<Please see attached file for image>

If you still get the error no tns listener then you may have a corrupt tnsnames.ora and should recreate the listener and bsi service:

1. First open start menu and open net configuration manager.
   
   

   <Please see attached file for image>

   
   
   
2. Choose listener configuration first. We want to delete the current listener.
   
   

   <Please see attached file for image>

   
   
   
3. Select delete
   
   

   <Please see attached file for image>

   
   
   
4. Select the current bsi listener and delete it.
   
   

   <Please see attached file for image>

   
   
   
5. Add a new listener
   
   

   <Please see attached file for image>

   
   
   
6. Click next
   
   

   <Please see attached file for image>

   
   
   
7. Create a name for listener
   
   

   <Please see attached file for image>

   
   
   
8. Click next to finish
   
   

   <Please see attached file for image>

   
   
   
9. Now delete the old service name
   
   

   <Please see attached file for image>

   
   
   
10. Select delete
    
    

    <Please see attached file for image>

    
    
    
11. Select your bsi service name and click next to delete
    
    

    <Please see attached file for image>

    
    
    
12. Now add a service name for BSI
    
    

    <Please see attached file for image>

    
    
    
13. Create a name
    
    

    <Please see attached file for image>

    
    
    
14. Click next
    
    

    <Please see attached file for image>

    
    
    
15. Add your host name and click next to finish
    
    

    <Please see attached file for image>

    

After completion of these steps you should have test that you can tnsping your new service name in cmd.

Open cmd and execute: tnsping bsi (Or whatever you named the service name)

If you can connect the error should go away.

Environment

Release:
Component: OBLCRE