ora-12541 :tns :no listener [message #399539] |
Wed, 22 April 2009 18:54 |
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 #399542 is a reply to message #399539] |
Wed, 22 April 2009 19:14 |
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 |
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 #399730 is a reply to message #399724] |
Thu, 23 April 2009 14:42 |
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
|
|
|
|