Hello All
I have installed Oracle XE 11gR2 (by running as Administrator)as part of Oracle Soa installation but database is not coming up.
I have tried most of the steps i got from OTN forums and various post on Google but still it is not working, my whole work is stopped as DB is not getting working.Initially XE TNS listener was not running.So i edited the environment variables.
Added ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server
ORACLE_SID=XE
Path=G:\oraclexe\app\oracle\product\11.2.0\server\bin;F:\Installation\Java\jdk1.7.0_79\bin;C:\Program Files (x86)\Lenovo\FusionEngine;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin
My TNSListener is up but on connecting to Oracle ,I am getting an idle instance.
Here are results of the various commands I have run from SQLPLUS
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'G:\oraclexe\app\oracle\product\11.2.0\serv
er\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
From command prompt here are the results for the commands
C:\windows\system32>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Ritu\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=RITU-LENOVO-PC
ComSpec=C:\windows\system32\cmd.exe
configsetroot=C:\windows\ConfigSetRoot
easyplussdk="C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin"
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\Ritu
JAVA_HOME=F:\Installation\Java\jdk1.7.0_79
LOCALAPPDATA=C:\Users\Ritu\AppData\Local
LOGONSERVER=\\RITU-LENOVO-PC
NUMBER_OF_PROCESSORS=4
ORACLE_HOME=G:\oraclexe\app\oracle\product\11.2.0\server
OS=Windows_NT
Path=G:\oraclexe\app\oracle\product\11.2.0\server\bin;F:\Installation\Java\jdk1.
7.0_79\bin;C:\Program Files (x86)\Lenovo\FusionEngine;C:\Program Files (x86)\Int
el\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\windows\system32;C:\windo
ws;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Progr
am Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Intel\Intel
(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Manag
ement Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Co
mponents\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\
IPT;C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 61 Stepping 4, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=3d04
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
SystemDrive=C:
SystemRoot=C:\windows
TEMP=C:\Users\Ritu\AppData\Local\Temp
TMP=C:\Users\Ritu\AppData\Local\Temp
USERDOMAIN=Ritu-Lenovo-PC
USERDOMAIN_ROAMINGPROFILE=Ritu-Lenovo-PC
USERNAME=Ritu
USERPROFILE=C:\Users\Ritu
windir=C:\windows
C:\windows\system32>lsnrctl service
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2015 19:36
:09
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
C:\windows\system32>lsnrctl service
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2015 19:37
:17
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
C:\windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2015 19:38
:13
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 12-OCT-2015 19:32:46
Uptime 0 days 0 hr. 5 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File G:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File G:\oraclexe\app\oracle\diag\tnslsnr\Ritu-Lenovo-PC\lis
tener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ritu-Lenovo-PC)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
I have also added few lines in listener.ora to include XE as suggested in some posts.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Ritu-Lenovo-PC)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
and the tnsnames.ora reads as below:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Ritu-Lenovo-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
Request you to help as DB is a major block.
Regards,
Ritu