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