Oracle Database 11g XE Installer Error

Oracle 11g XE Installer

Finally, I got to install Oracle Database 11g Express Edition (XE) tonight. Unfortunately, I ran into an error during the installation. A quick Google search landed me in the forum, where it gave me the impression it wouldn’t work on Windows 7, 64-bit. However, I’m tenacious with problems like this. Here’s the screenshot for the error:

The text from the image is noted below to help folks find the solution.

The installer is unable to instantiate the file C:\Users\McLAUGH~1\AppData\Local\Temp\{078E83D7-3FCC-4A72-903B-995C7CE44681}\KEY_XE.reg. The file does not appear to exist.

The physical file isn’t missing, what failed to happen was that the installer didn’t write a Registry Key’s Data value. You can add the missing registry key’s Data value, and then click OK on the Error dialog box to continue the installation. (Replying to Andrea, I’ve provided screen shots on editing the Registry in a comment below.) It will succeed, at least it succeeded for me on Windows 7 64-bit. Rather than use abbreviations like the forum entry, the missing key is found here in the Windows Registry:

- HKEY_CLASSES_ROOT\Installer\Products\266B7A503A089BE4EAD1986A429434C1\SourceList\Media

A screenshot shows that the Data value of the key wasn’t populated by the MSI (Microsoft Software Installer), the arguments remain for a script to populate:

You need to add the message value from your Error dialog as Data value of the Name entry 1, like this screenshot shows:

Since I believe the only things that should change are your Administrator’s hostname and the key value (type in the one that shows in the your dialog box), here’s the text you’ll need to enter:

C:\Users\hostname\AppData\Local\Temp\{078E83D7-3FCC-4A72-903B-995C7CE44681}\

This fix worked for me, and I hope the same holds true for you.

Written by maclochlainn

September 13th, 2011 at 12:51 am

Posted in Oracle,Oracle APEX,Oracle Installer,Oracle XE,Windows7

Tagged with install oracle 11g release xe, key_xe.reg, trouble shoot oracle 11g xe install

59 Responses to 'Oracle 11g XE Installer'

Subscribe to comments with RSS or TrackBack to 'Oracle 11g XE Installer'.

[...] step-by-step installation [...]

Oracle Database 11g XE Install Instructions

13 Sep 11 at 11:07 am
Kris Rice did tweet that a Win 64 bit version of XE “is in the works”

Gary

14 Sep 11 at 4:48 am
Good job man!!

it’s worked for me.

Regards

Savior

14 Sep 11 at 11:22 am
Hi,

It’s true, this method will solve the bug, but the home page hasn’t shown yet.

Maybe the ports not good (because of the TNS Service doesn’t run). How can I change the ports under the installation?

Regards,
mig8

mig8

15 Sep 11 at 3:06 am
Updated the post to ensure everyone knows that the key value can differ and you need to type in the one shown in your error message dialog box.

maclochlainn

18 Sep 11 at 10:29 am
You can check Step #7 in this post. I’d suggest you uninstall and re-install. Also, make sure that you enter the key value from your error message. They can differ.

maclochlainn

18 Sep 11 at 12:03 pm
Works great. Thanks for posting this. I was tearing my hair out trying to solve it.

Jimmy

9 Oct 11 at 3:58 am
Great Tip, It worked for me

Mike

10 Oct 11 at 6:07 pm
Great tip. Works like a charm.

MKS

17 Oct 11 at 2:38 am
Thanks it works!

Anders

18 Oct 11 at 10:10 am
Hi,
I am also getting the same issue pop up(The installer is unable to instantiate the file C:\Users\SAMRAT\AppData\Local\Temp\{some value..}\KEY_XE.reg), so according to this blog I went to the path mentioned in the error pop up but could not find out the file “KEY_XE.reg” where I will set up the key data value.I am also installing in Windows7 64 bit.The DB installation file is “OracleXE112_Win32″.Please help me in resolving this issue.Thanks

Samrat

23 Oct 11 at 12:51 am
Hi,
Those who have successfully resolved the above issue please let me know the step by step procedure how you have successfully set up this value after getting the error pop up.Thanks.

Samrat

23 Oct 11 at 12:55 am
You make the change in the registry. Use regedit to edit the registry.

maclochlainn

24 Oct 11 at 12:43 pm

I have Windows 7 x64 and a got the problem about the KEY_XE.reg not fount. I have tried a lot of configurations I have finally solved.

We need do some thinks:

1. Start the installer ‘Setup.exe’. Wait until asked about the path.
2. Do not press next. Open with Windows Explorer the folder like this:

C:\Users\\AppData\Local\Temp{60712028-B7B0-4EC3-9C28-663111EC954A}

3. There will be a file OracleMTSRecoveryService.reg. Make a copy and rename the copy to KEY_REG.reg
4. Go to the installer and go ahead with the installation.

You will not see any error about the KEY_XE.reg not found.

Now, you need check your hostname and localhost. Open the file C:\Windows\System32\drivers\etc\hosts and check if you have something like this:

127.0.0.1 localhost
192.168.1.20 your_pc_hostname

The second line is your IP, this one is an example. Try to stop and start the Oracle Express by the shortcut at the start menu. To check if all Oracle services are running, use this command:

C:\Oracle\oraclexe\app\oracle\product\11.2.0\server\bin&gt;lsnrctl status

The result:

LSNRCTL FOR 32-bit Windows: Version 11.2.0.2.0 - Production ON 26-OUT-2011 00:09:03
 
Copyright (c) 1991, 2010, Oracle. ALL rights reserved.
 
Connection WITH (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER STATUS
NICK LISTENER
Version TNSLSNR FOR 32-bit Windows: Version 11.2.0.2.0 - Production
Initial DATE 25-OUT-2011 23:36:53
Running 0 dias 0 hr. 32 MIN. 14 seg
Analysis level off
Security ON: LOCAL OS Authentication
SNMP OFF
DEFAULT Service XE
Listener param. D:\Oracle\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Log Listener D:\Oracle\oraclexe\app\oracle\diag\tnslsnr\\listener\alert\log.xml
Resume...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.20)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zetared-pc)(PORT=8080))(Presentation=HTTP)(SESSION=RAW))
Services...
O service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", STATUS UNKNOWN, has 1 handler(s) FOR this service...
O service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", STATUS UNKNOWN, has 1 handler(s) FOR this service..
O Service "XEXDB" tem 1 Instance(s).
Instance "xe", STATUS READY, has 1 handler(s) FOR this service...
O service "xe" has 1 Instance(s).
Instance "xe", STATUS READY, has 1 handler(s) FOR this service...

You cannot see the services “xe”, so you need do fix the listener.ora at

D:\Oracle\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora

If your hostname or localhost didn’t work, so put your PC IP, like this:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\Oracle\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
 
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)

Maybe can be necessary fix the D:\Oracle\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\sample\LISTENER.ORA, put the IP too. Like this:

# LISTENER =
# (ADDRESS_LIST=
# (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.20)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

If you try open the apex by the Windows start menu and get the error http://127.0.0.1:%HTTPPORT%/apex/f?p=4950. It is easy:

Go to D:\Oracle\oraclexe\app\oracle\product\11.2.0\server and click over the file Get_Started and choose properties, there change the %HTTPPORT% for you port, usually 8080, will be like this:

http://127.0.0.1:8080/apex/f?p=4950

Pay attention, I have installed Oracle Express 11g at D:\Oracle.

Eder

25 Oct 11 at 8:30 pm

I cannot follow what I need to do here. I’m so confused!

Andrea

31 Oct 11 at 3:12 pm
Where exactly do I edit in regedit? Where do I find this – HKEY_CLASSES_ROOT\Installer\Products\266B7A503A089BE4EAD1986A429434C1\SourceList\Media?

I can’t find anything remotely similar to that

Andrea

31 Oct 11 at 5:06 pm
Here’s how you open regedit.exe from Windows:

maclochlainn

1 Nov 11 at 1:22 am
I can get to regedit but the rest I have no clue what to do.

Andrea

1 Nov 11 at 4:10 am
Andrea,

You should see the following when you launch the Windows 7 Registry:

Click on the arrow symbol to the left of the HKEY_CLASSES_ROOT node to expand the node tree. Scroll down until you find the Installer node and click the arrow symbol to expand the node tree another level. Repeat the process for the Product, Product Key Value, and SourceList nodes, as displayed below.

Click on the Media node, which is a leaf node in the Registry tree. Click on the Name 1 and then click the Edit menu option. Within the drop down menu, click on the Modify… option to edit the Data value.

Enter the fully qualified Value data value, which should include the key value provided in the error dialog from the Oracle Installer.

I hope this helps you fix your installation problem.

maclochlainn

2 Nov 11 at 12:35 am
See! Nothing to it. This is how installers should work, right?

Oracle’s installer, what a humorless joke…

Bill Kuhn

23 Nov 11 at 3:07 pm
Your fix by filling in the key worked like a champ for me. I filled it in using Regedit while the error message was still up, then had to hit enter twice to get beyond the error message. Installation took a while to finish but once it was done I can get to my Getting Started page w/o problem.

Thanks!

Oracle’s install is still a monumental fail, as it is.

Bill Kuhn

23 Nov 11 at 3:49 pm
Thank you. It worked for me too.

Pegah

25 Nov 11 at 3:09 am
After fixing this issue, I was having a lot of problems starting the database and connecting to http://localhost:8080/apex url… Until I realized that I was installing the Oracle 11g XE on a 64 bit using a 32 bit installer. When I tried installing on the 32 bit system, I no longer got this error message.

Pegah

28 Nov 11 at 4:49 am
Thank you so much, the installation worked just perfect.
Now my alert log fills rapidly with
“OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified”
As per Oracle:
nstalled 32-bit Oracle database software on a 64-bit MS Windows OS which is not supported.

And yes, it is 32-bit db on 64-bit os. Any idea how to resolve the error or at least to suppress it?

Thanks!

Mila

15 Dec 11 at 2:37 pm
Hey everyone
Let me give you a senario about my installation of Oracle XE11g 32-bit in my laptop:

Actully, I am having Win7 OS but it’s 64-bit ! ! !
I install XE11g 32-bit on it and I got the error mentioned above but it did not harm anything. In fact installation went on successfully. Then I installed Oracle Developer6i along with it to run my applicatioin and it works also fine…
I dump few data using export import steps and that also went perfect so when i start running the application it works fine….now the proplem occur when i run the report… the system hangs where I am using same application with same XE11g 32-bit in Win XP with no problem at all! ! ! !
anyone has faced this propblem????

Nasser

20 Dec 11 at 11:53 pm
Nice article..!
Really helpful. Resolved the issue.

@Eder : Thanks so much for step by step explanation for 64bit windows

Gopi

22 Dec 11 at 8:27 pm
Nice Article, really helpful in resolving XE installation issue.

@Eder: Thank you for the step by step, just one change in my case – For Step 3. There will be a file OracleMTSRecoveryService.reg. Make a copy and rename the copy to KEY_XE.reg instead of KEY_REG.reg.

Vipul

29 Dec 11 at 8:46 pm

Nice Article, like Vipul I’d to rename the file at step3 to KEY_REG.reg to avoid the error message.

However i cannot get the XE to launch.

I’m missing:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zetared-pc)(PORT=8080))(Presentation=HTTP)(SESSION=RAW))

And

O Service "XEXDB" tem 1 Instance(s).
Instance "xe", STATUS READY, has 1 handler(s) FOR this service...
O service "xe" has 1 Instance(s).
Instance "xe", STATUS READY, has 1 handler(s) FOR this service...</code>

My lsnrctl status look like this:

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 17-JANV.-2012 11:52:19
 
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date                17-JANV.-2012 11:52:11
Uptime                    0 days 0 hr. 0 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   D:\tools\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File         D:\tools\oraclexe\app\oracle\diag\tnslsnr\FR-35-01-11-021\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(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...
The command completed successfully

Even after editing the listener.ora. My host file only has: 127.0..0.1 localhost

WilliamB

17 Jan 12 at 4:00 am

What’s in your C:\Windows\System32\drivers\etc\hosts file?

maclochlainn

17 Jan 12 at 9:08 am

Thanks for answering

My Hists file:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host
 
# localhost name resolution is handled within DNS itself.
#	127.0.0.1       localhost
#	::1             localhost
 
 
127.0.0.1       localhost

So not much.

WilliamB

18 Jan 12 at 3:13 am

Try the following, and make sure your listener.ora and tnsnames.ora use zetard-pc.
1 2 3
127.0.0.1 localhost ::1 localhost 127.0.0.1 zetard-pc zetard-pc.domain
You may also find these Windows 7 pre-configuration steps helpful.
maclochlainn

18 Jan 12 at 2:06 pm
[...] similar al tuyo que el usuario consigue solucionar y hacerlo correr, incluso en W7 64 bits: Oracle Database 11g XE Installer Error | MacLochlainns Weblog Espero te sirva, [...]

Error al instalar oracle database11g

26 Jan 12 at 6:52 am
great tip…worked very well…no need of renaming the reg file.

rOY

31 Jan 12 at 4:33 pm
Hi,
I have installed successfully without modifying reg. It went fine after clicking OK without modifying error message. Does it mean, I am ok with the installation. Or do i need to uninstall and reinstall with registry fix. is it the last registry to be edited among all the entries for products in the list. Please let me know.

Neel

2 Feb 12 at 10:00 am
Sometimes, it does work. Most times, it doesn’t. It appears you’re lucky.

maclochlainn

2 Feb 12 at 10:14 am
Thanks for the quick feedback. I was not able to find our the right key to edit. After clicking ok, I was not able to stop the installer in order to enter the key. I got successful installation message at the end. I am assuming that, everything if fine with my installation. Let me know if i need to reinstall the software.

Neel

2 Feb 12 at 10:20 am
Windoze 7 64 bitzzz. Followed the registry key manual edit by copying the error message I got… the installer ended successfully (that’s what it reported), then hangs. I’m stuck, installation won’t end, step 7 of the installation will never fire up. Oracle XE 11g => FAIL.

snadeau

7 Feb 12 at 1:18 pm
You can try it again, or you can install Oracle Database 11g R2. The latter works well.

maclochlainn

7 Feb 12 at 3:05 pm
I have the same issue as William (posted on 17 Jan). My DB and listener are up and running but my Get Started page does not come up. I even tried installing Oracle 11g R2 but getting war file and ear file missing errors and not able to complete installation. Any suggestions? I have Windows 7 64 bit. I have tried lot of options for more that 4 days now.

Veena

10 Feb 12 at 9:29 am
Did you save a copy of your Windows registry before you attempted the Oracle Database 11g XE installation? If so, did you recover to that registry before attempting to install Oracle Database 11g? If the answers to either of these is no, that’s most likely the problem.

You typically have three options after a failed Oracle Database installation, recover to a saved registry state, manually cleanup the registry and file system, or re-install the Windows operating system. The get started page is a link and editable. Dependent on what you did, you can edit the file. My guess is you’ll be fine if you edit it since everything else is working. You can do that by right clicking on the menu option, then choose properties. I’ve got a hunch that the link is looking for Oracle Database 11g XE not what you’ve got installed.

maclochlainn

10 Feb 12 at 10:42 am

I have had the same issues. I’ve worked through the rededit fix but I don’t have any “xe” services showing. Does that mean the regedit fix did’t work? What does a functional listener.ora look like? Does it have the “xe” services in it?

I can successfully tnsping my listener with HOSTNAME, LOCALHOST, and IPs for HOSTNAME and LOCALHOST. I’m confident my listener is working. I’m missing the default services I think but I’m not sure what they are.

LSNRCTL STATUS (output)
 
LSNRCTL FOR 32-bit Windows: Version 11.2.0.2.0 - Production ON 10-FEB-2012 12:13:50
 
Copyright (c) 1991, 2010, Oracle.  ALL rights reserved.
 
Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS OF the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR FOR 32-bit Windows: Version 11.2.0.2.0 - Production
START DATE                10-FEB-2012 11:33:50
Uptime                    0 days 0 hr. 40 MIN. 0 sec
Trace Level               off
Security                  ON: LOCAL OS Authentication
SNMP                      OFF
DEFAULT Service           XE
Listener Parameter File   D:\oracle\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File         D:\oracle\app\oracle\diag\tnslsnr\\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(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...
The command completed successfully

Brett

10 Feb 12 at 11:17 am

Looks like the listener is up and running, the networking files are in the %ORACLE_HOME%/network/admin directory. You can check for a working service by opening a command shell and typing the following (it’s easier than posting the navigation steps that change by version of Windows):
```
C:\> services.msc
```
I’ve posted this a few times trying to help folks creating their own Windows 7 service. It’s done with the ORADIM utility. ORADIM creates, maintains, and deletes Windows services for the database.

Create an instance by specifying the following options:
```
ORADIM -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
```
Edit an instance by specifying the following options:
```
ORADIM -EDIT -SID sid | -ASMSID sid [-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE] [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
```
Delete instances by specifying the following options:
```
ORADIM -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
```
Startup services and instance by specifying the following options:
```
ORADIM -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
```
Shutdown service and instance by specifying the following options:
```
ORADIM -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
```
Query for help by specifying the following parameters:
```
ORADIM -? | -h | -help
```
I just Google’d to see if there was a page with some additional definitions for folks. You can also find additional information here.
maclochlainn

10 Feb 12 at 12:23 pm
[...] Once I downloaded it I merely ran the Disk1setup.exe file. It was mostly straightforward, but I ran into a little hitch during the installation. It is possibly because I am installing a 32 bit Oracle database onto a 64 bit Windows 2008 R2 server. Luckily I found the work around at this link: http://blog.mclaughlinsoftware.com/2011/09/13/oracle-11g-xe-installer/ [...]

Installing the Oracle Database Express Edition 11g « WriteBTL (Write Between the Lines)

10 Feb 12 at 12:39 pm
Hi,
What is the good free GUI client to work with 11g xe installed on windows 7 64bit syste.

Neel

11 Feb 12 at 1:41 pm
Oracle SQL Developer is free and available in a 64-bit version.

maclochlainn

11 Feb 12 at 5:51 pm
Bingo!

I followed your instructions to a “T” and it worked perfectly!

Thank you for you efforts!!!

It’s people like you that save people like me from getting a headache :>

Robert V.

Robert Vignato

15 Feb 12 at 10:48 am
Thank you so much just wasted 4 hours trying to figure this out adn it finally worked afer a uninstall and deleting the old install directory then following above.
thanks
thanks
thanks
Chris W

CHRIS WILCOX

17 Feb 12 at 4:01 pm

I followed the instructions for install and installed correctly but couldn’t connect via sqlplus to xe, then I did a trawl of the web and found problems related to the Windows Event viewer (Windows Event Log service not started). I then did another trawl and managed to the get event log service running by modifying the permissions on eventlog folder, re-booting, then uninstalled xe and removed oraclexe folder, then I re-installed updated by listener.ora to this:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)      
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = WGC1W7GJQB65J.warley.ford.com)(PORT = 1521))
      (ADDRESS=  (PROTOCOL = tcp)(HOST = 127.0.0.1)                    (PORT = 8080))
    )
  )
 
DEFAULT_SERVICE_LISTENER = (XE)

I then ensured my tnsnames.ora matched the host name like this:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = WGC1W7GJQB65J.warley.ford.com)(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) 
    ) 
  )

I then stopped and re-started the listener via lsnrctl.exe and I was able to connect to XE via sqlplus and via sqldeveloper. However I still cannot connect to the web front-end (apex), but I am a lot happier than I was 2 days ago when this suddenly stopped working.

Sid Sewell

24 Feb 12 at 5:24 am

At the end I succeeded, works fine!!
Thanks!

Cristina

12 Mar 12 at 4:41 am
i found a problem in oracle 11g xpress edition installation….it shows messag
```
appdata/local/temp{165FCD36-DD30-49D3-A420-3D1A6A70A7C6}\KEY_XE.REG does not appear.........
```
can anybody help me to resolve this problem…..thanking you
deep

2 Apr 12 at 6:31 am
The solution for me was the one maclochlainn provided. Thank you.

1) All I had to do was just double click the Oracle setup.exe file, but don’t do anything. Don’t cliect next yet.

2) The setup program will create 2 additional temp directories initially in C:\Users\V252112\AppData\Local\Temp\{….}

- What you need to look for is one of the three directories that look like {5ECC178F-4652-4BB1-9256-8C836685EED6} as an example. Not exactly this number.

- In one of them, the installer will create a file called “OracleMTSRecoveryService.reg”, just make a copy of this file in the same directory and name it KEY_XE.reg.

3) Continue with your installation.

4) Finish

THAT IS IT.

It should work.

Thank you for the solution.

Yassin

4 Apr 12 at 2:58 pm
Hello!

Thank you! I think it works! Nice advice!

Florin

5 Apr 12 at 12:17 am
Yeah, that worked for me, thank u! =D

André

6 Apr 12 at 11:05 am
I followed this workaround and the installation appeared to work but cannot log in to Apex (http://localhost:8087/apex). It is saying invalid credentials. I know the password I set up is correct. Any ideas?

And I did not add the KEY_XE.reg to the end of the path for the key value in the registry. Could that be the problem? I did not add that because in your screenshots you did not appear to add it to yours.

treytuck

17 Apr 12 at 8:45 am
On my Win 2008R2 it was enough to copy OracleMTSRecoveryService.reg into KEY_XE.reg and proceed with installation.

Ilya Oussov

22 Apr 12 at 8:58 am
Hi, its works fine i think no corupted file in db and so, but when u install patch for apex, its look like flash chart not work fine. There is some problem with XML parser. Did anyone get same problem?

newen

23 Apr 12 at 6:42 am
Hi,

You can try this for the Silent Installation of Oracle XE 11g on windows 64bits :
http://www.samuel-delsol.com/installation-silencieuse-oracle-xe-11g-windows-64bits-silent-installation-of-oracle-xe-11g-windows-64-bits/
It’s my website in French but the procedure is easy !
Good Luck !

Samuel Delsol

26 Apr 12 at 8:10 am
Merci, heureusement je peux lire le français …

maclochlainn

26 Apr 12 at 1:25 pm

my listener.ora file working now please see below is the correct one.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)      
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xyz.americas.dellcorp.net)(PORT = 1521))
      (ADDRESS=  (PROTOCOL = tcp)(HOST = 127.0.0.1)                    (PORT = 8080))
    )
  )
 
DEFAULT_SERVICE_LISTENER = (XE)

chiranjeevi

1 May 12 at 3:15 pm

MacLochlainns Weblog

Oracle 11g XE Installer

59 Responses to 'Oracle 11g XE Installer'

Leave a Reply

Recent Posts

Pages

Blogroll

Archives