Re: ora12541: tns no listener

Did you configur a listener.ora file? It should be located in <ORACLE_HOME>\network\admin. I don't have 10g, but with 9i, a shake-it-out-of-the-box install would have ORACLE_HOME at c:\oracle\ora92 . . . thus your listener.ora file would be at c:\oracle\ora92\network\admin

On Fri, 14 May 2004 15:01:39 -0400, " - Dan -" <dan_at_domain.com> wrote:

>thanks Ed!
>
>I'm using 10g on windows xp pro. my listenerservice won't start and fails
>when I try to start it. what do you think? do I have to reinstall
>something?
>
>
>"Ed Stevens" <nospam_at_noway.nohow> wrote in message
>news:56u9a0hbvhkl4ptpd9v0d7st018cu9kr18_at_4ax.com...
>> On Fri, 14 May 2004 11:16:48 -0400, " - Dan -" <dan_at_domain.com> wrote:
>>
>> >I just installed oracle 10g db and client tools on my machine. I then
>try
>> >to connect to a database and I get the error ORA-12541: TNS: No listener.
>> >
>> >What does that mean and how do i fix it? I am new and inexperienced,
>sorry.
>> >
>>
>> When the client requests a connection to a database, sqlnet actually
>> puts that request to a listener process. The listener then takes care
>> of setting up a process to connect the client to the database. This
>> error means the listener is not running.
>>
>> What OS is the db on? If Windows, go to the services panel and look
>> for a service with a name something like OracleListener (or some
>> variation on that). You can start the listener by either starting
>> that service from the control panel, or from a dos prompt issuing the
>> command 'lsnrctl start'. If on *nix, do a 'ps -ef | grep ora' and see
>> if you have a listener process. Again, it can be started with
>> 'lsnrctl start'
>>
>> And if you go to tahiti.oracle.com and sign up for a free OTN account,
>> you'll have searchable, online access to the entire set of Oracle
>> docs, including an error code lookup facility. At that point you
>> could do a lookup of 'ORA-12541' . . .
>
Received on Fri May 14 2004 - 15:33:04 CDT