Home » Infrastructure » Windows » ora-12541 :tns :no listener (database 10g)
ora-12541 :tns :no listener [message #399341] Tue, 21 April 2009 13:24 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))
    )
  )


how to solve this?

thanks
jillu
Re: ora-12541 :tns :no listener [message #399345 is a reply to message #399341] Tue, 21 April 2009 13:53 Go to previous messageGo to next message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
>how to solve this?
Call in Ghost Busters.
Re: ora-12541 :tns :no listener [message #399352 is a reply to message #399341] Tue, 21 April 2009 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT crosspost your questions.

Regards
Michel
Re: ora-12541 :tns :no listener [message #399369 is a reply to message #399352] Tue, 21 April 2009 18:57 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
sorry. i didnot see topic before. i again posted in other topic
Re: ora-12541 :tns :no listener [message #399370 is a reply to message #399369] Tue, 21 April 2009 19:03 Go to previous message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
nastyjillu wrote on Tue, 21 April 2009 16:57
sorry. i didnot see topic before. i again posted in other topic


Did not see?
You posted it!
http://www.orafaq.com/forum/m/399163/136107/#msg_399163
Previous Topic: Printing Issue
Next Topic: Oracle 10g R2 Installation fails on XP SP3
Goto Forum:
  


Current Time: Sat Aug 23 03:04:33 CDT 2014

Total time taken to generate the page: 0.09596 seconds