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 the file, or get another […]

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 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 […]

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 […]

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 […]

What version of Oracle is installed?

It may seem like a strange thing for a DBA to have to find out as the assumption may be that the DBA already knows or can recall all the instances and version numbers installed instantly from memory, but if one needed to find out the version of Oracle and any installed options, this may be helpful. Open a session […]

DR and Backup/Recovery

I will looking into Data Guard, RMAN and RAC amongst other things and will put any interesting findings here which may prove useful. A couple of sites that I’m reading into right now are: Setting up Oracle DataGuard for 10g by advait Creating a Physical Standby Database – Oracle Documentation

Welcome!

Hi and welcome to my blog where I will share my Adventures in DBA Land. My background is in web and Windows forms application development, I then moved into SQL Server database administration and have recently had the opportunity to take on a post as an Oracle DBA. One of my first priorities is to automate as many of the manual […]