Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



Oracle on Windows Patching tips

Expert Oracle Tips by Mark Sorger.

By Mark Sorger

Tips for Doing Oracle Installs/Patches

There are several things to look for when installing and patching on Windows. Some are in the documentation, and some are not. Some tips and suggestions follow.

  • Stop all Oracle Services First

    Anything like the OracleServiceSID, Oracle Listener, and any other Oracle service needs to be stopped, or there will be open DLLs that cannot be replaced by the Installer.
  • Stop the Windows �Distributed Transaction Coordinator Service�

    This Windows service Coordinates transactions that span multiple resource managers, such as databases, message queues, and file systems, and as such may have Oracle files/dlls open.
  • Stop any Antivirus Software or backup Agents.

    This is to both improve performance of the install/upgrade as well as to keep the Antivirus or Backup Software from locking up any files/dlls.
  • If you get errors specifying open DLLs, you can find them�

    If the Oracle installer reports a specific DLL being open, you can find out what has that DLL open using the TASKLIST utility.
    Tasklist /m filename.dll

    will return all the processes that have that DLL open.

    You can then kill them using the taskkill utility if need be.
  • The ORACLE_HOME environment variable

    The ORACLE_HOME environment variable will not get reset properly by an upgrade. More likely, it will be blank, since the Oracle Installer clears it out by default. This can cause TNS Protocol Adapter errors when trying to start the Listener, ODBC datasources to fail, as well as other problems. So, it is a good practice to check this following any upgrades.

    Oracle recommends you not set ORACLE_HOME at all�.
  • The PATH environment variable

    The last Oracle Product installed will be the first thing in the PATH. You can change this with the Environment Tab in Oracle Universal Installer.
  • Use LSNRCTL to create the Listener Service

    When you first install or upgrade to a new release, you will notice there is no OracleListener Windows Service. The first time you run LSNRCTL from the command prompt, provided you have a good listener.ora file, it will create it for you.
  • Open DLLs � when all else fails�.

    If you cannot locate what is locking a dll, then set all the Oracle Services to �manual� and reboot the server.


Get the Complete
Oracle Tuning Details 

The landmark book "Oracle Tuning: The Definitive Reference Second Edition" has been updated with over 1,150 pages of expert performance tuning tips. It's packed with scripts and tools to hypercharge Oracle 11g performance and you can buy it for 40% off directly from the publisher.

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks


Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA