Installation of Oracle 11 Release 2 on Windows 7 64-bit

I never had so much trouble installing an Oracle version on a Windows OS as I had with installation of Oracle 11R2 on Windows 7 (64-bit). The issues I faced were twofold:

  1. First I got messages (during installation of the software) that files could not be found in the target oracle folder
  2. Second, after finding the solution for the first annoyance, I spent two hours finding out why everything installed correctly, I could create a database, but could not start a Listener. I am an Administrator on my laptop. The errors I got at starting a listener were ORA-12560 and ORA-12541.

Regarding 1:

It appeared to be very simple: when you download Oracle 11 R2, there are two zip files. Make sure to extract both zip files into the same folder and not into two separate folders (like a Disk1 and Disk2 folder). After extracting both zip files into the same folder, the installation went smooth without errors.

Regarding 2:

After a fresh installation and creation of a database, I am used to open a Command prompt, start LSNRCTL, and execute a START to start the default listener. If a Windows Service does not exist yet, LSNRCTL throws some errors around that but as part of this it creates the Windows Service. But not this time. I kept on getting the result:

C:\>lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MRT-2011 21:48:56
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Starten van tnslsnr: Even geduld a.u.b.
TNS-12560: TNS: fout bij protocoladapter.
 TNS-00530: Fout in protocoladapter.

and a LSNRCTL status gave me:

C:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MRT-2011 21:52:02
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Verbinding wordt gemaakt met (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.1)(PORT=1521))).
TNS-12541: TNS: geen listener.
 TNS-12560: TNS: fout bij protocoladapter.
  TNS-00511: Geen listener
   64-bit Windows Error: 61: Unknown error
C:\>

But no listener got created. The Oracle support site, nor any forum or blog pointed me in the correct direction. The only thought I had was: I know Windows requires the Listener to be present as a Service, so as long as that is not the case, it will not start. So here is what I tried: I created the service myself using the Windows “sc” command. Now a first attempt gave an Access Denied, but after storing the command in a Batch file and executing the batch file to “Run as Administrator” (right-click the command file and choose that option), the service got created!

The SC command used was: sc create OracleOraDb11g_home1TNSListener binPath= “C:\app\toine\product\11.2.0\dbhome_1\BIN\TNSLSNR.exe” (take care of the space after binPath= !)

And after starting it using the Service Control Panel, LSNRCTL gave me a good status:

C:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MRT-2011 21:57:57
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Verbinding wordt gemaakt met (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.1)(PORT=1521))).
STATUS van LISTENER
------------------------
Alias                            LISTENER
Versie                           TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Startdatum                       18-MRT-2011 21:57:48
Ingeschakeld                     0 dagen 0 uren 0 minuten 9 seconden
Traceerniveau                    support
Beveiliging                      ON: Local OS Authentication
SNMP                             OFF
Parameterbestand van listener   C:\app\toine\product\11.2.0\dbhome_1\network\admin\listener.ora.
Log van listener            c:\app\toine\product\11.2.0\dbhome_1\log\diag\tnslsnr\mypc\listener\alert\log.xml
Traceerbestand van listener c:\app\toine\product\11.2.0\dbhome_1\log\diag\tnslsnr\mypc\listener\trace\ora_6728_7012.trc
Overzicht beluisteren eindpunten...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.1.1.1)(PORT=1521)))
Overzicht van services...
Service "ONTW112. MYPC.MYDOMAIN.NL" heeft 1 instance(s).
  Instance "ONTW112", toestand UNKNOWN, heeft 1 handler(s) voor deze service...
Uitvoeren van opdracht is geslaagd.
 

and I could login using Oracle Net 🙂
The problem appeared to be Administrative privileges. Which was not obvious to me at first. I wondered why the installer could create all necessary services, whereas LSNRCTL was not able to create the Listener service. I stopped and deleted the service again (using “sc delete”) and started LSNRCTL.EXE as Administrator (go to the Oracle\bin folder and right click LSNRCTL.EXE. That lead to the same result: a START within that LSNRCTL session created the Windows Service as I am used to from other Oracle installations on Windows I did many times.

After all it is probably a logical error on Windows 7.  What bugs me is that I did not read it somewhere and that the errors did not point me to the problem. They pointed me towards some network problem. I almost wonder whether I missed some guideline. Still, it may help others, who have the same trouble.

16 thoughts on “Installation of Oracle 11 Release 2 on Windows 7 64-bit

  1. Thank you so much!
    I had exactly the same problem and, after reading dozens of unuseful posts on oracle forums around all the web, I had the luck to find yours.
    Anyone else searching for a solution: stop wasting time searching around and apply this one.
    Works like a charm!

  2. love u guys…after 4 hrs of raoming around in google finally i got the solution here…me too was hving issue with admin privilege

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s