Home » RDBMS Server » Server Administration » ORA -12541:TNS: No Listener.
ORA -12541:TNS: No Listener. [message #57982] Wed, 23 July 2003 12:31 Go to next message
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 #57983 is a reply to message #57982] Wed, 23 July 2003 14:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
start your listener. from the command prompt issue 
lsnrctl start -- will start your default listener
lsnrctl start < listener_name > -- will start the specific listener

Re: ORA -12541:TNS: No Listener. [message #57984 is a reply to message #57983] Wed, 23 July 2003 16:34 Go to previous messageGo to next message
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 #58003 is a reply to message #57984] Thu, 24 July 2003 06:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your listener configuration is not correct.
please post your listener.ora
Re: ORA -12541:TNS: No Listener. [message #58006 is a reply to message #58003] Thu, 24 July 2003 11:07 Go to previous messageGo to next message
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 #58007 is a reply to message #58006] Thu, 24 July 2003 12:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
[code]the following is a sample listener.ora file.
in your posting, it seems that listner is trying to use all tcp/ipc/spx pipes.
I beleive, u need only tcp .
so configure your listner like this sample.
the listener name is LISTENER.
i would start this listener as

> start lsnrctl listener
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = itloaner1)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:OracleOra81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = local)
      (ORACLE_HOME = C:OracleOra81)
      (SID_NAME = local)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = clone)
      (ORACLE_HOME = C:OracleOra81)
      (SID_NAME = clone)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = sample)
      (ORACLE_HOME = C:OracleOra81)
      (SID_NAME = sample)
    )
  )

Re: ORA -12541:TNS: No Listener. [message #58012 is a reply to message #58007] Fri, 25 July 2003 01:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ORA -12541:TNS: No Listener. [message #58018 is a reply to message #58012] Fri, 25 July 2003 07:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
nothing is wrong.
everything is behaving as expected.

1. oracle and forms should be in different ORACLE_HOME.
   Any oracle client ( sqlplus or forms or reports or anyother tools like discoverer) uses its own tnsnames.ora to connect to oracle.
   so every $ORACLE_HOME/network/admin/tnsnames.ora in every home should have the same entries.

2. if you have an oracle client and oracle server,
   in the same machine, you no need to have a connect string.
   you can connect with username/passcode.
   if you have multiple databases in the same machine need to set oracle_sid every time to connect to a particular database. to avoid that, we use connectstrings so that
    username/passcode@string1 connects to db1
    usernmae/passcode@string2 connnects to db2
but username/passcode      will connect to whatver database is left as default, defined by oracle_sid.
if you use connectstring, then u should have proper entries in your tnsnames.ora and have a listener properly configured.
  
3. ODBC for oracle uses tnsconnecstring.
   it will work fine>~
    

Hi Mahesh, Good Explanation....... [message #58019 is a reply to message #58018] Fri, 25 July 2003 08:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
did u solve it [message #58108 is a reply to message #58023] Thu, 31 July 2003 06:41 Go to previous message
Shiv
Messages: 20
Registered: May 2002
Junior Member
Hi
Is u r problem solved??
Previous Topic: oracle.exe
Next Topic: last analyzed
Goto Forum:
  


Current Time: Fri Sep 20 06:31:50 CDT 2024