Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008

    Unanswered: TNS Listener does not know of service...


    I recently installed Oracle 10g on my Windows XP laptop. The thing is, whenever the laptop is restarted and I try to connect to the db through Toad, it says:

    ORA-12514: TNS Listener does not currently know of the service requested in the connect descriptor.
    I then have to re-configure the listener and then it works.

    NOTE: Upon checking services, I can see that the listener service is 'Started' and startup type is 'Automatic'.

    Any ideas?


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >I then have to re-configure the listener and then it works.
    what ever you do manually to fix the problem should be added to the DB startup script
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2008

    Basically, when I restart the windows xp machine, the listener doesn't start automatically. When I go into services.msc, the listener service shows as stopping. Upon refreshing services, it shows stopped. I can restart the service from services.msc and then reconfigure the db service in Local Net Service Name configuration in the Net Confguration Assitant, I am then able to connect to the db.

    Don't know why it's not starting up automatically even though the startup type is automatic.

    DB startup script in windows?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts