1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-12541: TNS: no Listener

Discussion in 'Installation - Windows' started by LucaSap, Aug 10, 2011.

  1. LucaSap

    LucaSap Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I have created a local DB (name "test"). Now I need to create a Listner and and a service.
    First I created a listner called LISTNER with protocol TCP/IP, Host 127.0.0.1 and port 1521. After I created a service with this parameters:I used the TCP/IP protocol, host 127.0.0.1,port 1521 service name the same of my DB (test). When I check the service I have this error:


    ORA-12541: TNS: no listner.

    Do I need to start first my listner? If yes, what I can start him? I use windows 7

    Thansk a lot
    Best regards
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The listener service should have been started by the OUI at installation with a call to the Net Configuration Assistant (NetCA). You can always run this manually:

    Start->All Programs->Oracle Database ...->configuration and migration tools-> net configuration assistant

    This will create, configure and start your LISTENER service.