Hi community,
During the weekend, an outage took my Windows Server 2008 R2 down and my database by the same way.
I Started the database back on but I'm having some issues starting the TNS LISTENER of my 11.0.2 database.
I tried starting the service : OracleOraDb11g_home1TNSListener
but i get the following error : The OracleOraDb11g_home1TNSListener service on Local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.
the LSNRCTL Status gives me this :
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LIPCSATT.ireq.ca)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
The lsnrctl start gives me this :
Z:\>lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-AUG-2013 07:55:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Failed to start service, error 0.
TNS-12560: TNS:protocol adapter error
Here are My ora files :
# sqlnet.ora Network Configuration File: E:\app\da2803\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, LDAP)
# tnsnames.ora Network Configuration File: E:\app\da2803\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
OROBEE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OROBEE)
)
)
LISTENER_OROBEE =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
# listener.ora Network Configuration File: E:\app\da2803\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\da2803\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\da2803\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LOGGING_LISTENER = OFF
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LIPCSATT.ireq.ca)(PORT = 1521))
)
)
ADR_BASE_LISTENER = E:\app\da2803
TRACE_LEVEL_LISTENER = OFF
my variables are as follows :
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\db4626\AppData\Roaming
BI_ORACLE_HOME=E:\app\Middleware_home\Oracle_BI1
CLIENTNAME=PCS00427
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=LIPCSATT
ComSpec=C:\Windows\system32\cmd.exe
DEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection
FP_NO_HOST_CHECK=NO
GRAILS_HOME=C:\grails-2.0.0
HOMEDRIVE=Z:
HOMEPATH=\
HOMESHARE=\\ireqhq\docireq\20032b\DB4626
JAVA_HOME=C:\PROGRA~1\Java\jdk1.6.0_26
LOCALAPPDATA=C:\Users\db4626\AppData\Local
LOGONSERVER=\\WINDSOR
NUMBER_OF_PROCESSORS=4
ORACLE_HOME=E:\app\da2803\product\11.2.0\dbhome_1
ORACLE_SID=OROBEE
OS=Windows_NT
Path=E:\app\da2803\product\11.2.0\dbhome_1\BIN;D:\oracle\product\11.2.0\client_1
\bin;E:\app\Middleware_home\Oracle_BI1\bin;E:\app\Middleware_home\Oracle_BI1;C:\
Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\Windows
PowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\PROGRA~1\Java\jdk1.6.0_26\b
in;C:\grails-2.0.0\bin;C:\Program Files\TortoiseGit\bin;E:\app\Middleware_home\O
racle_BI1\products\Essbase\EssbaseServer\bin;E:\app\Middleware_home\Oracle_BI1\b
in;E:\app\Middleware_home\Oracle_BI1\opmn\bin;E:\app\Middleware_home\Oracle_BI1\
opmn\lib;E:\app\Middleware_home\Oracle_BI1\perl\bin;C:\apps\FME\;E:\app\da2803\p
roduct\11.2.0\dbhome_1\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2c02
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=RDP-Tcp#0
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\db4626\AppData\Local\Temp\3
TMP=C:\Users\db4626\AppData\Local\Temp\3
TNS_ADMIN=E:\app\da2803\product\11.2.0\dbhome_1\NETWORK\ADMIN
USERDNSDOMAIN=IREQ.CA
USERDOMAIN=IREQHQ
USERNAME=db4626
USERPROFILE=C:\Users\db4626
VSEDEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection
windir=C:\Windows
_PENTAHO_JAVA=C:\PROGRA~2\Java\jre7\bin\javaw
_PENTAHO_JAVA_HOME=C:\PROGRA~2\Java\jre7\bin\java
PLEASE HELP ME COMMUNITY, I am out of ressources.