Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12542: TNS:address already in use

user10243788Dec 25 2010 — edited Dec 27 2010
Hi,
I have restored the image of my Win XP having Oracle 11g database onto a vm ware virtual disk on another PC.
When i try to start the listener i am getting the error TNS-12541: TNS:no listener,starting the listener is giving the error TNS-12542: TNS:address already in use

I am able to login to database by typing 'conn / as sysdba' but i need the listener to be up as i have to use an applicuation that requires the listener to be up.

I have deleted the listener.ora and tnsnames.ora and recreated then using netca
Used parameter files:
D:\app\Ahmed\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.113.128)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = edwdev))
)
TNS-12541: TNS:no listener

D:\app\Ahmed\product\11.2.0\dbhome_1\BIN>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 25-DEC-2010 16:40
:11

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\app\Ahmed\product\11.2.0\dbhome_1\network\admin\list
ener.ora
Log messages written to d:\app\ahmed\diag\tnslsnr\home-9e3bae43d0\listener\alert
\log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(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...
Listener.ora file
EDWDEV =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = home-9e3bae43d0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_EDWDEV = D:\app\Ahmed

SID_LIST_EDWDEV =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Ahmed\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Ahmed\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )
Tnsnames.ora
EDWDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.113.128)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = edwdev)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )
SQLNET.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
I have googled one of the solutions is
http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm
1) Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
On the Edit menu, click Add Value, and then add the following registry value:
Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534

Valid Range: 5000-65534 (decimal) Default: 0x1388 (5000 decimal)

I do not find add value in my edit of registry

can someone help me solve this error
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2011
Added on Dec 25 2010
17 comments
14,796 views