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
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
In this post, I’m installing the Oracle Database 11g Release 2 (188.8.131.52) 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
I hit the following problem with a 184.108.40.206 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
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 of all, thanks to
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 (220.127.116.11) installation which consists of two OMSes, running on Linux x86-64 (RHEL5) which uses an 18.104.22.168 database management repository.
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 disk space being used.
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 this new “pluggable databases” feature in
In this post, I’m installing the Oracle Database 12c Release 1 (22.214.171.124.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 you start, make sure your Linux server meets the minimum
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 comes to JPI versions, and it will only run with the