Category: Oracle
-
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…
-
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…
-
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…
-
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…
-
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…
-
Oracle Enterprise Manager DB Console Unavailable
We had this problem a good few weeks ago – we were happily using OEM DB Console and then all of a sudden it was unavailable! The URL was the same and there was nothing that had changed to our knowledge. Several of us here spent some time and looked around to no avail. It…
-
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…