:

RSSUpgrades

ORA-07445 exception encountered: core dump ACCESS_VIOLATION

While upgrading an Oracle database from 9i to 10g, I got the  following error message. This was completed after having just restored the 9i  database from an RMAN backup. The database was started using the STARTUP UPGRADE option.  This error was seen when running the catupgrd.sql script and taken from the  alert log. ORA-07445: exception […]

Continue Reading

What’s Holding a Lock on my Oracle dll Processes?

You are probably familiar with the scenario; you’re applying an Oracle interim patch using the Oracle OPatch utility and you’ve followed the instructions to the letter. You run the next step, opatch apply. You are then greeted with an error message stating that OPatch was unable to overwrite some Oracle dll files because you other processes […]

Continue Reading

SP2-0714: invalid combination of STARTUP options

I was recently carrying out an Oracle database 9i to 10g  upgrade. It was version 9.2.0.8 and I was upgrading to 10.2.0.4. I was completing the upgrade on a Windows server which already had an Oracle 9i software installation on it, so it was dual homed. On  Windows boxes there is an environment variable called ‘PATH’ […]

Continue Reading

Prerequisite check “CheckActiveFilesAndExecutables” failed

Prerequisite check “CheckActiveFilesAndExecutables” failed

Oracle Database: 11.2.0.3 Platform: Windows Server 2003, Sp2 The Problem When using Opatch utility 11.2.0.1.3, and attempting to patch an Oracle 11g home, I got the following: Verifying environment and performing prerequisite checks… Prerequisite check “CheckActiveFilesAndExecutables” failed. The details are: Following files are active : D:\oracle\product\11.2.0\dbhome_1\bin\oraclient11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orageneric11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orapls11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oracommon11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oci.dll D:\oracle\product\11.2.0\dbhome_1\bin\orahasgen11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocr11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocrb11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocrutl11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oran11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orantcp11.dll […]

Continue Reading