Monday, May 27, 2013

Successfully Installing Oracle 11g Release 2 on Windows 7

The installation document is finished, including screen shots and all!  The document covers the installation of the Oracle11g Release 2 11.2.0.3 database and software installation on Windows 7 and any manual Database Control configuration afterwards. Database Control - the standalone Enterprise Manager interface - allows for easy database management and maintenance operations and simplifies DBA tasks dramatically by allowing automation of most common jobs done (such as performance measurement, backup & recovery, storage management, etc.).

Major hurdles during the installation - as outlined in this document - were the inability to manage the Oracle related system services due to lack of privileges and the failure of the Enterprise Manager configuration during the initial software installation. For more experienced DBAs apart from these problems the installation is relatively straight-forward.

The document explains all steps for a so-called advanced installation of the Oracle11g Release 2 Enterprise Edition (the most complex installation type) including an explanation on what the various installation screens contain and what kinds of selections can be made all along the installation. A so-called typical installation is left out as this is a very simple type of installation with minimal user input.

Future documents will include more detailed information on managing an Oracle RDBMS environment on Windows type systems.

Leave a comment or mail me at mvweb@ziggo.nl to discuss how to purchase this document (cost: EUR 2.50 or $ 3,-).

Wednesday, May 22, 2013

Installing Oracle11g Release 2 on Microsoft Windows 7 - finished

After seeing many questions and/or problems with an Oracle RDBMS installation on Microsoft Windows 7 I decided to start this blog to get people up to speed.

The blog efforts will in the end result in a document with clear steps on how to properly install the Oracle 11g Release 2 software on 64-bit Windows 7. The individual flavors of Windows (Ultimate, Enterprise, or Professional - other versions are not supported - or 32-bit vs. 64-bit Windows) do not matter that much. However, it is important to adhere to the requirements found in chapter 2 of the Oracle Installation Guide (available at http://docs.oracle.com).

Step 1 in the whole process is to install Microsoft Windows and be able to administer the system with the Administrator account (or an account with equal privileges). Administration privileges are required to be able to start and stop the database instance.

After installation of Windows 7 the blog will continue with the database installation itself.

May 27th update: I made a new post (http://mverheij.blogspot.com/2013/05/successfully-installing-oracle-11g.html), detailing more information on how to obtain the installation information from me.

OCP 11g is obtained; preparing for OCM

Finally some time again to update my blog.

The OCP 11g is obtained, with a passing score of 98%! There was a lot to study, but as experiene helped a lot and with the help of the Kaplan text exam in the end 1.5 weeks of study proved to be sufficient.

For the moment preparing some virtual machines to check out RAC and Data Guard. The next hurdle will be OCM 11g.