Scripts

ORA-16014 No Available Destinations
I arrived at work today to find a few emails in my inbox saying that one of the development environments appeared to be down. My first check was to try logging on as one of the application users, which failed with the error: ORA-00257: archiver error. Connect internal only, until freed I’ve written about this […]

Oracle SQL
SQL = Structured Query Language All relational databases, such as Oracle and SQL Server, use their own version of Structured Query Language (SQL) to allow users to interact with the data in the database. This could be adding data, deleting, updating or just viewing it. In general the SQL used in Oracle and by other […]

ORA-01019: unable to allocate memory in the user side
The Problem One of the in-house developed tools which connects to the database to allow a user to perform configuration updates was throwing an error: ORA-01019: unable to allocate memory in the user side Most of the docs that I could find online told me the same thing, namely: Cause: The user side memory allocator […]
ORA-01031: insufficient privileges
I encountered another occasion whereby I received the ORA-01031 error message. This time, though, it was not on startup; it was on logging into the database. I think I should start by giving you a little background information relating to how I got this error. Local System Account Services The database was running without error, on Windows […]
SQL Tuning – DBMS_UTILITY.CPU_TIME
Set Timing On It is very common when developing some new piece of SQL to want to know how long it takes to run. For this you can use the SET TIMING ON command within SQL Plus. It’s very handy for a quick glance at how long your query is going to take to run. Accuracy […]
ORA-00600: internal error code, arguments: opirfs.1
The Problem I came in this morning to find some issues on our Oracle Data Guard configured physical standby databases; we had an error: ORA-00600: internal error code, arguments: [opirfs.1], [], [], [], [], [], [], []~ The archived redo logs continued to be applied and there were no noticeable issues after this error but I was […]
ORA-01552: cannot use system rollback segment
The Problem When running a script into a refreshed database, I received the following error message: ORA-01552: cannot use system rollback segment for non-system tablespace ‘string’ The Cause The database was a clone of a physical standby database, and having recently “synced” to that clone to it matched the source database data exactly and required some additional post-clone steps to […]
ORA-29381: plan/consumer_group referred to by another plan and cannot be deleted
The Problem When attempting to delete a consumer group from your resource manager configuration, you receive the following error message: EXEC DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); BEGIN DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); END; * ERROR at line 1: ORA-29381: plan/consumer_group REPORTING_GROUP referred to by another plan and cannot be deleted ORA-06512: […]
ORA-00600: internal error code, arguments: [kzaxins:sqtxt]
We had a scheduled job which ran each day to delete the archive logs which we no longer required. We noticed that the same job errored intermittently with the following error message: ORA-00600: internal error code, arguments: [kzaxins:sqtxt], [], [], [], [], [], [], [] I don’t think it is specific to the command we […]
Oracle Agent Ports
To put it simply, I have found that you need to have the following ports open in order to get Oracle’s Enterprise Manager to work: Port 1754 (from OMS to DB) Port 7772 (from DB to OMS) The above refers to the Oracle Management Server (OMS), which is where the Oracle software for Enterprise Manager is […]