Knight Talks Tech

Year: 2012

  • 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…

  • 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…

  • 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…

  • 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…