Home » RDBMS Server » Networking and Gateways » ora-12541 :tns :no listener (oracle 10g)
ora-12541 :tns :no listener [message #399539] Wed, 22 April 2009 18:54 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
hi, i know there are many posts on this error. but mine is something different.thats is why i had to post again.

i installed database 10g. and dev suit 10g.

and i could login into database from sqlplus. but i couldnot login using toad.

later i dont know what happend but i could login using toad also and form builder also..

again next day i tried to login but this time i couldnt login using toad,sqlplus and form builder.

why is this happening?? if there is tns or .ora files problem then it should not allow me to login anytime.

but why is it allowing me sometimes and not allowing sometimes??

database is in my laptop. iam not connecting to other servers.

my tnsnames file is given below



# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.13)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


listener is given below



# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.13)(PORT = 1521))
    )
  )

please help me solve this?

thanks
jillu
Re: ora-12541 :tns :no listener [message #399541 is a reply to message #399539] Wed, 22 April 2009 18:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
STOP multi-cross/posting the same problem or you will be banned!

http://www.orafaq.com/forum/m/399341/136107/#msg_399341

http://www.orafaq.com/forum/m/399163/136107/#msg_399163

If you do not like the quality, quantity, timeliness or tone of the responses, you are entitled to a full refund.

You can submit your refund request to /dev/null!

[Updated on: Wed, 22 April 2009 19:01]

Report message to a moderator

Re: ora-12541 :tns :no listener [message #399542 is a reply to message #399539] Wed, 22 April 2009 19:14 Go to previous messageGo to next message
user2004
Messages: 33
Registered: April 2009
Member
Quote:
again next day i tried to login but this time i couldnt login using toad,sqlplus and form builder.


Make sure a listener is running. Either use lsnrctl to start the listener or startup the appropriate Windows service
Re: ora-12541 :tns :no listener [message #399723 is a reply to message #399542] Thu, 23 April 2009 13:19 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
sorry BlackSwan,

when i first posted this topis, i posted in 'windows' forum. which was wrong. someone asked me not to post in wrong forum topic, hence i again posted in sql/plsql topics as i didnot find database topics. did i do mistake??

i didnt get proper reply in both the forum topics.

iam a new member. i joined the forum because it helps me a lot. it doesnt make sense if iam banned for silly mistakes which happens in beginning ( as iam new to this forum).

i was expecting a solution for my issue.

please dont ban me
Re: ora-12541 :tns :no listener [message #399724 is a reply to message #399539] Thu, 23 April 2009 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i was expecting a solution for my issue.
Your expectations were unreasonable.

Here is what we know.
Sometimes Oracle works for you.
Sometimes Oracle does not work for you.

I agree with the conclusion that the root cause is not listener.ora or tnsnames.ora

When Oracle is working, then there is nothing to troubleshoot.

Troubleshooting can only occur when you are getting error.
Re: ora-12541 :tns :no listener [message #399730 is a reply to message #399724] Thu, 23 April 2009 14:42 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
Ok.

but all oracle services were up. and database was in my system, not over the other server.

then how come toad connects in the morning and doesnt connect in the evening?? is this not weird??

but it shows tns error when i tried to login

thanks
jillu
Re: ora-12541 :tns :no listener [message #399731 is a reply to message #399539] Thu, 23 April 2009 14:58 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


Previous Topic: Maximum DBLink Connection
Next Topic: SHARED SERVER MODE: connection refused
Goto Forum:
  


Current Time: Thu Mar 28 14:10:47 CDT 2024