Results 1 to 5 of 5

Thread: ORA-12541: TNS:no listener

  1. 06-26-2007 #1
    Geek_Guest
    Guest

    ORA-12541: TNS:no listener

    Hi friends,

    When I am trying to connect oracle database from Toad, I am getting the following error.

    ORA-12541: TNS:no listener
    SID_NAME = DB01
    oracle version = 9.2.0.1.0
    OS = windows xp sp2

    I would appreciate if anybody can help me to resolve this issue.
    Thanks in advance..

    - venky

    Question asked by visitor venka

    Reply With Quote Reply With Quote
  2. 06-27-2007 #2
    Innila
    Innila is offline
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: ORA-12541: TNS:no listener

    Hi,

    Probably the listener was not running.
    Start the listener using "lsnrctl start" command in Unix and if its Windows OS start the listener service.
    If the listener is running & still u have problems, check the Host name & port in the listener.ora file.

    *** Innila ***
    Reply With Quote Reply With Quote
  3. 06-27-2007 #3
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas ORA-12541: TNS:no listener

    Re: ORA-12541: TNS:no listener

    kindly check if the oracle 9i TNSlistener is running or not .

    Reply With Quote Reply With Quote
  4. 06-28-2007 #4
    samarendra_78
    samarendra_78 is offline
    Junior Member
    Join Date
    Apr 2007
    Answers
    11

    Re: ORA-12541: TNS:no listener

    hi
    first check that in sqlplus,it is workin or not.
    if yes then

    r u sure that it is correct databse name ,for toad .

    Reply With Quote Reply With Quote
  5. 07-12-2007 #5
    sunilmenedal
    sunilmenedal is offline
    Junior Member
    Join Date
    May 2007
    Answers
    1

    Re: ORA-12541: TNS:no listener

    The Oracle server is down

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact