Author: John
-
Installing the Adventure Works 2012 sample database
After installing SQL Server 2012, it is a good idea to download and add the sample database to your SQL Server instance. To get the datafile, browse to the Microsoft SQL Server Samples page on CodePlex and take the AdventureWorks2012 Data File. Once the download has completed, it is advisable to copy the data file to…
-
Value cannot be null
After issues with my laptop not being able to find critical files this morning I managed to boot to the last know good configuration. This seemed to have got me past all the errors I previously had, however, I noticed that things weren’t quite right. When attempting to open SQL Server Management Studio (SSMS) 2012…
-
ORA-00333: redo log read error block XXXX count XXXX
ORA-00333: redo log read error block XXXX count XXXX I encountered this Oracle error when connecting to my database after my laptop lost power and subsequently had some severe Blue Screen issues. According to Oracle, ORA-00333 is caused by an IO error while reading the log described in the accompanying error. The resolution is to restore accessibility to…
-
Excluding WMI system properties with Powershell
When using Windows Management Instrumentation (WMI) in your Powershell script you will see a load of system properties returned. These are indicated by a preceding “__” (double underscore) as seen below when issuing get-wmiobject -class “Win32_Processor”: An obvious attempt to prevent these system properties from being returned would be to use the -ExcludeProperty switch…
-
SQL Server Central Management Server (CMS) Intro
Introduction Central Management Server (CMS) was first introduced in SQL Server 2008, it enables simplified management of multiple MS SQL database servers and instances. My screenshots are taken from SQL Server 2012 but should be relevant in SQL 2008 and 2008 R2 as well. If you are managing more than a couple of SQL instances…
-
ORA-00257: archiver error. Connect internal only, until freed.
When connecting to a database via SQL*Plus (similar error would be displayed via other products) the following error is thrown: SQL*Plus: Release 10.2.0.3.0 – Production on Fri Nov 16 10:15:15 2012 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-00257: archiver error. Connect internal only, until freed. Cause: The area used as the Archive…
-
ORA-29280: invalid directory path
Having migrated to a new database server, I encountered this error. After some investigation I checked the system parameter utl_file_path. This lists the directories where files can be created from Oracle. During migration I had set this parameter to a location where part of our system generates files which are then FTP’d to a different…
-
Configuring and Running Apache on Solaris
The Apache web server comes with the Solaris 10 operating system but needs some configuration before it can be used. These steps can assist you in getting Apache up and running…. Step 1 Log in as the root user, or another user with root privileges. Step 2: Check the current status of Apache svcs -a…
-
Ubuntu One on Peppermint
Having used my eee PC 901 a fair bit for development work, it suddenly struck me that if I lost my netbook or if it had a technical failure I would be able to get the files back. While there are plenty of resources like Dropbox I decided to pursue Ubuntu One (U1) as I…
-
ORA-00600: internal error code
When shutting down the database, I encountered the following: SQL> shutdown immediate Database closed. Database dismounted. ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [] CAUSE. The cause of the error is that there are still objects in the library cache when the database shutdowns. The database is fine; there is…