:

Robert Jackson

Having studied a generic Business Computing degree at university, I was fortunate to do my work placement as an Oracle DBA. I enjoyed the challenges of the job and found that my skills were suited to it, also.
Since graduating with a 1st class honours degree in Computing - Database Systems, I have worked my way up from a Junior Oracle DBA to a DBA Team Leader.

rss feed Author's Website

Robert Jackson's Latest Posts

Essential Expert Oracle Books You Must Read

Essential Expert Oracle Books You Must Read

Would you consider yourself an Oracle expert? Good, because that means you are serious about your career and that will always reap rewards. My personal belief is that experience trumps certifications. It’s often the case that you learn the most when you absolutely have to. In that sink of swim moment, when your production database is […]

Continue Reading

Oracle 11g

Oracle 11g

In this article I would like to give a high level overview about what the Oracle Relational Database Management System (RDBMS) is; its history, what the Oracle database does, when the Oracle 11g database was released and the kinds of administrative tasks that a database administrator can expect to perform when using an the database. […]

Continue Reading

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