Problems starting Listener

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
pzuchelli
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Wed, 10 Jan 2007 8:29 pm
Location: SP




I can not start the listener. I'm using Oracle 10g. The following error occurs to try to start LINTENER.

Select all

C:\Documents and Settings\pzuchelli>lsnrctl start 
 
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-JUN-2007 19:23:39 
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved. 
 
Starting tnslsnr: please wait... 
 
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production 
System parameter file is d:\oracle10g\network\admin\listener.ora 
Log messages written to D:\oracle10g\network\log\listener.log 
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=M10-081-001-003)(PORT=1521))) 
TNS-12542: TNS:address already in use 
 TNS-12560: TNS:protocol adapter error 
  TNS-00512: Address already in use 
   32-bit Windows Error: 48: Unknown error 
 
Listener failed to start. See the error message(s) above...

Thanks for collaboration.
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

Select all

 
TNS-12542: TNS:address already in use 
TNS-12560: TNS:protocol adapter error 
TNS-00512: Address already in use 
32-bit Windows Error: 48: Unknown error 
Quite Clear Message!
has another software using the address, probably the port that the Listener uses.

Gilberto
pzuchelli
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Wed, 10 Jan 2007 8:29 pm
Location: SP

Gilberto,

The problem is that I do not know which sotware is using this door.



Att.:
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

Use the NetStat utility.

Select all

 netstat --help
pzuchelli
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Wed, 10 Jan 2007 8:29 pm
Location: SP

Gilberto,


I changed the Listener door and this solved the problem.


Att.:
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest