:

The Latest Oracle Posts

Create Tablespace Oracle

Create Tablespace Oracle

The Oracle create tablespace statement can be quite complex if you look at it in the Oracle documentation. In this article I would like to try and break down the create tablespace command in to simpler terminology. There are three main types of Oracle tablespace: Normal – CREATE TABLESPACE TEMPORARY - CREATE TEMPORARY TABLESPACE UNDO – [...]

Continue Reading

ORA-16014 No Available Destinations

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

Continue Reading

Oracle SQL

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

Continue Reading

ORA-01019: unable to allocate memory in the user side

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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: [...]

Continue Reading

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

Continue Reading