OraFAQ Forum: Windows » ora-12541 :tns :no listener

Home » Infrastructure » Windows » ora-12541 :tns :no listener (database 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12541 :tns :no listener [message #399341]

Tue, 21 April 2009 13:24

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

Report message to a moderator