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 – 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 Destination is out of space. […]

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 server. This worked fine. The […]

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 | grep -i http This […]

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 had previously set up an […]

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 no damage to or problem […]

Determine Processor and Memory Information in Solaris

How can I find out how much RAM is installed in my Solaris server? How do I know how many CPUs/cores are in my Solaris server? These are two questions you may have asked yourself maybe out of curiosity or perhaps to provide information to colleagues. Well, you’ll be relieved to hear that it is quite simple with Solaris (I’m […]

SnipIT No 3: Using “find” in Solaris: Part 1

SnipIT is a series of short blogs containing useful information in an easily digestible format. find is a useful command in Solaris although it may not always be a straight forward matter using it to get what you want. I have two examples which I use¬†regularly¬†and thought I’d share them with you… 1) List the files in the current directory […]

Creating an Oracle Scheduler Job

I had a requirement recently to truncate a table as our applicaition provider had identified this as the cause of an issue some of our users were experiencing. Fine, but this had to be done when the system was not being used and unfortunately, as much as I love doing what I do, I didn’t fancy staying that late! With […]