ORA -12541:TNS: No Listener. [message #57982] |
Wed, 23 July 2003 12:31 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
When attempting to startup a database, I keep getting this error ORA -12541:TNS: No Listener. How do I resolve this? Please help! Thanks in advance.
~ Meenakshi
|
|
|
|
Re: ORA -12541:TNS: No Listener. [message #57984 is a reply to message #57983] |
Wed, 23 July 2003 16:34 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
Hi Mahesh,
Thanks. I tried both opening a specific listener and the default listener. Here's the errors that I got. Could you please help?
Thanks in advance.
~ Meenakshi.
-------------------------------------------------------
While starting default listener:
C:>lsnrctl start
LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 23-JUL-2003 13:54:
04
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
System parameter file is e:orantnetworkadminlistener.ora
Log messages written to e:orantnetworkloglistener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dabba)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dabba)(PORT=2484)))
Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=SPX)(SERVICE=DABBA_lsnr)
))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
TNS-00508: No such protocol adapter
------------------------------------------------------
While starting specific listener:
Microsoft Windows 2000 [[Version 5.00.2195]]
(C) Copyright 1985-1999 Microsoft Corp.
C:>lsnrctl start listerner
LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 23-JUL-2003 15:09:23
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service <OracleHomeTNSListenerlisterner>, error 1060.
TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
System parameter file is e:orantnetworkadminlistener.ora
Log messages written to e:orantnetworkloglisterner.log
TNS-01151: Missing listener name, listerner, in LISTENER.ORA
|
|
|
|
Re: ORA -12541:TNS: No Listener. [message #58006 is a reply to message #58003] |
Thu, 24 July 2003 11:07 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
Hi Mahesh,
This is a copy of my listener.ora. Thanks.
~Meenakshi.
-------------------------------------------------------
# LISTENER.ORA Network Configuration File: e:orantnetworkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dabba)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = dabba)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = SPX)(SERVICE = DABBA_lsnr))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = DABBA)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = GANGA))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dabba)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = dabba)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = SPX)(SERVICE = DABBA_lsnr))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = DABBA)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = YAMUNA))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:orant)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Ganga)
(ORACLE_HOME = e:orant)
(SID_NAME = Ganga)
)
(SID_DESC =
(GLOBAL_DBNAME = Bramhaputra)
(ORACLE_HOME = e:orant)
(SID_NAME = Brahmaputra)
)
(SID_DESC =
(GLOBAL_DBNAME = Yamuna)
(ORACLE_HOME = e:orant)
(SID_NAME = Yamuna)
)
)
|
|
|
|
Re: ORA -12541:TNS: No Listener. [message #58012 is a reply to message #58007] |
Fri, 25 July 2003 01:45 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
Hello,
I believe I may have a bigger problem than I initially suspected, because Forms and Reports have started connecting to the DB at random. I documented the following issues.
(1) Forms is installed in the 'C' drive, while the database (ora_home) was created in the 'E' drive. Even after opening the database, and testing database connectivity using Net8 Assistant, Forms still did not connect to the database. So I copied tnsnames.ora to the Forms 60 folder in 'C' drive, and it initially seemed successfully and actually connected to the database. To make sure this connectivity had been permanently established, I shut down and restarted the computer and the database, only to find that Forms was again not connecting to the database.
(2) Attempting to connect to SQLPLUS using the icon in Programs-Oracle for Windows NT route allows connect only if database connect string is not mentioned. If it is mentioned, it immediately claims ORA-12541: TNS: no listener error! This is inspite of the fact that I reconfigured and manually started the Listener using the Net8 Assistant. Windows Taskbar also shows that the TNSLSNR.exe process is running.
(3) ODBC driver exists and connects to database.
I understand that this is a very tall order, and I would be very grateful if you could shed some light on what exactly is going on here.
Thanks for your time.
~ Meenakshi
|
|
|
Re: ORA -12541:TNS: No Listener. [message #58014 is a reply to message #58003] |
Fri, 25 July 2003 05:13 |
Shiv
Messages: 20 Registered: May 2002
|
Junior Member |
|
|
Hi
Your listener file is correct, YOU HAVE 3 DATABASE ,
which database or you connecting to..
your oracle will not connect if oracle forms library and database library maps each other in the same drive,
Understand which home you r connecting , remove all others in you listener file and now start the Re start the listener,
It works ,
SHIV
|
|
|
|
Hi Mahesh, Good Explanation....... [message #58019 is a reply to message #58018] |
Fri, 25 July 2003 08:46 |
Shiv
Messages: 20 Registered: May 2002
|
Junior Member |
|
|
Hi Mahesh,
Iam shiv, I HAVE SEEN YOR RATEING IN THE BOARD , YOU SEEM TO BE VERY OCCUPIED AND HELPING MANY PEOPLES,
IAM A 9I OCP,AND DATABASE ENGG FOR GOLBYTES, IAM ALSO IN WARE HOUSE,
sivakumar@globytes.com., PL let me know your contact.
Regards
Shiv
|
|
|
Hi! [message #58022 is a reply to message #58019] |
Fri, 25 July 2003 17:18 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
Please bear with me. I'm new to this, and I'm throughly confused. My worry now is that Forms and Reports and SQLPLUS connect to Oracle only SOME of the time. So when I want to work on these applications, I spend ages "tinkering" around until I'm able to get them to connect. One option is leaving the PC on 24/7 so the "connecting" version is available all the time, but that is a bad way of solving this problem. Why does this happen? I've done everything I'm supposed to. Of the 3 databases, I've deleted 2, so now have only 1. Let's call the database "Yamuna". All the DBA applications - DBA studios, Net 8 Configuration, and so on connect to Yamuna without a problem. Then I move over to Forms and try to connect to Yamuna, only to get TNS: Unable to resolve service name, or Unable to connect to database errors.
I have copied the copy of tnsnames.ora from the 'E' drive where Yamuna was installed, to the 'C' drive where Forms was installed. But Forms still does not connect immediately to the database.
Added to this, my computer does not have the Control Panel - ODBC Administrator icon! ODBC test also sometimes passes and sometimes fails. What exactly am I doing wrong? Please bear with me, I'm still in the learning stage.
Thanks again.
|
|
|
Re: Hi! [message #58023 is a reply to message #58022] |
Fri, 25 July 2003 21:10 |
Shiv
Messages: 20 Registered: May 2002
|
Junior Member |
|
|
Now i assume this is configration.
DATABASE:YAMUNA,
DRIVE : c:oracle.
Forms : Installed in the same drive.(c:oracleforms).
Is your system in Network, -- It will not work.(you will get error .Tns names error)]]
If its in stantalone -- It works-perfect
Pl check and revert back.
|
|
|
Re: Hi! [message #58025 is a reply to message #58023] |
Sat, 26 July 2003 01:57 |
Meenakshi
Messages: 28 Registered: December 2001
|
Junior Member |
|
|
Hi,
These are the details:
DATABASE: YAMUNA,
Installed in: E:orant.
Forms installed in: C:orantforms60
Reports installed in: C:orantreports60
TNSNAMES.ora: Identical copies of file available in the following directories:
e:orantnetworkadmin,
c:orantnetworkadmin,
c:orantbin
c:orantforms60
c:orantreports60
Do I have TOO MANY copies of the tnsnames.ora files? This is a home pc, so it is not in a network.
Thanx
~Meenakshi
|
|
|
Re: Hi! [message #58035 is a reply to message #58023] |
Mon, 28 July 2003 02:26 |
Shiv
Messages: 20 Registered: May 2002
|
Junior Member |
|
|
This should not give a problem,
while connecting to the database, DO not pass the sid, It takes the default database :YAMUNA.
In forms :
Open the forms Click----> Start-->Connect
Pass the usrname ,Password (do not pass the sid)
This configures the default Database :Yamuna.
now if you shutdown your computer . The forms is configured to the same database when you startup you will not have problem.
PL do not shutdown the database. If you shutdown ,again do the above task ..
So now you can pefectly work with forms with a dedicated system without any hazles.
Good Luck
Bye
|
|
|
|