9i - TNS-15241 - no listener - WinXP - file contents
Hello, I am also getting the TNS-15241 and have tried most of the solutions in these forums. My database was working well until Monday when I changed the tablespace sizes and our router went down.
_______________________________
Host File is:
C:\WINDOWS\SYSTEM32\DRIVERS\ETC\HOST
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows......
#################
127.0.0.1 localhost
_______________________________
TNS Connector is when viewing Enterprise Manager is:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=FMSystem)(SID=FMSystem.fmspace.net)(SERVER=DEDICATED)))
_______________________________
The lsnrctl.exe start gives me:
LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 26-JUN-2003 16:29:30
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
System parameter file is C:\Oracle\network\admin\listener.ora
Log messages written to C:\Oracle\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmsnb12.fmspace.net)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist
Listener failed to start. See the error message(s) above...
_______________________________
LISTENER.ORA file contents:
# LISTENER.ORA Network Configuration File: C:\Oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FMSystem.fmspace.net)
(ORACLE_HOME = C:\Oracle)
(SID_NAME = FMSystem.fmspace.net)
)
(SID_DESC =
(GLOBAL_DBNAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle)
(PROGRAM = extproc)
)
)
_______________________________
SQLNET.ORA is:
# SQLNET.ORA Network Configuration File: C:\Oracle\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)
_______________________________
TNSNAMES IS:
# TNSNAMES.ORA Network Configuration File: C:\Oracle\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP.FMSPACE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fmsnb12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
FMSYSTEM.FMSPACE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FMSystem)
(SID = FMSystem.fmspace.net)
(SERVER = DEDICATED)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
_______________________________
so why does it give me one host on the TNS connector and another on lsnrctl start?
Thank you