Which SQL Server instance is consuming all my CPU/memory?

For anyone running Windows 2008 (or above), you can simply add the “Command Line” column to the Task Manager view. From there, the instance name will follow the “-s” startup option, for example: C:\…\Binn\sqlservr.exe” –sPREPROD If you’re on Windows 2000/2003 then it’s not quite as straight forward. You can either get the Process ID from

Read More...

Moving the system databases in SQL Server 2000

The following post provides step by step instructions for moving each of the SQL Server 2000 system databases, one by one, from one location to another, on the same server.  These system databases being: master model msdb tempdb In this case, I need to move all of these system databases from E:\MSSQL\MSSQL\Data to D:\MSSQL\Data For the model and

Read More...

Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4

In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.4) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus

Read More...

OSD-04400: unable to acquire internal semaphore for process and OS 183 (Windows)

I hit the following problem with a 9.2.0.8 database running on Windows 2003 this morning (info pulled from the alert log).  The database had failed to restart after a client’s cold backup process ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for process

Read More...

Using SQL Developer to connect to SQL Server databases

Apparently, being able to use Oracle’s SQL Developer to connect to SQL Server databases has been around for a while (via third party drivers), but I only started using it today for the first time, with SQL Developer 4 EA2 after my colleague mentioned it to me this afternoon First (more...)

EM12c upgrade from 12.1.0.2 to 12.1.0.3

Now that Oracle Enterprise Manager Cloud Control 12c Release 3 (aka EM12cR3!) has been out for a few weeks, I decided to brave it and upgrade our Production stack today. In this post, I’ll be upgrading an EM12cR2 (12.1.0.2) installation which consists of two OMSes, running (more...)

Automatically purging OMS log and trace files in EM12c

Enterprise Manager Oracle Management Server (OMS) installations generate huge amounts of log and trace files under the covers these days, and although the logs are rotated out-of-the-box, they’re not automatically deleted.  Over time (as I was reminded again today ), these logs can amount to a large portion of your (more...)

Creating an Oracle 12c Pluggable Database & Container Database using DBCA

In this example, I’ve already installed the Oracle Database 12c software on one of my Linux 6.4 machines.  Using the DBCA tool (in advanced mode), I’m going to create a new container database named “cdb” and at the same time create a pluggable database named “pdb”. The idea behind (more...)

Oracle Database 12c (12.1.0.1.0) installation on Oracle Linux 6.4

In this post, I’m installing the Oracle Database 12c Release 1 (12.1.0.1.0) software on Oracle Linux 6.4.  Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before (more...)

Additional plugins are required issue in Firefox with Forms 11g

At the time of writing this post, Oracle Forms 11g installations are configured by default to work with a specific JPI (Java Plug-In) version: 1.6.0_12. You can verify this by checking your formsweb.cfg file: grep jpi-version formsweb.cfg #jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_12 Unfortunately, it seems Firefox is very particular when it (more...)