How to drop an Oracle database without DBCA

If, when you come to remove an Oracle database, you find that DBCA is not available perhaps due to some installation issue or missing files then do not fret as it is still possible to remove the database by following these steps… 1 – Set the Oracle SID D:\Oracle\product\11.2.0\dbhome_1\BIN>set ORACLE_SID=TESTDB 2 – Connect to the database and verify the name D:\Oracle\product\11.2.0\dbhome_1\BIN>sqlplus […]

Using Powershell to access Oracle

Before trying to access an Oracle database with Powershell it is necessary to have the Oracle Data Provide for .Net available, the most common way to get this is to install the Oracle client. If you are already interacting with Oracle databases then you will likely have a version of the client installed, if not use the link below to […]

How to Enable/Disable Archive Log Mode in Oracle 11g

It is advisable to backup your database before either enabling or disabling archive log mode as a precaution. Enabling archive log mode Verify the current archive log mode. We can see that database log mode is “No Archive Mode”. Also worth noting is the destination used for archiving. In order to see where that location is mapped to we can […]

SQLTools: “OCI8: Cannot allocate OCI handle” when starting

When starting SQLTools, a colleague was getting an error message “OCI8: Cannot allocate OCI handle”. Helping to investigate this, I found some guidance on the web with suggestions such as: Run the app with Administrator privileges Delete the OCI.DLL Oracle DLL from the Windows directory Neither of the above worked (the OCI.DLL wasn’t even present in my Windows folder), or any others […]

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