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.
Robert Jackson's Latest Posts
SP2-0714: invalid combination of STARTUP options
I was recently carrying out an Oracle database 9i to 10g upgrade. It was version 9.2.0.8 and I was upgrading to 10.2.0.4. I was completing the upgrade on a Windows server which already had an Oracle 9i software installation on it, so it was dual homed. On Windows boxes there is an environment variable called ‘PATH’ […]
SPFILE, INIT File & PFILE
All of the above are common names which all refer to a configuration file used by the Oracle database to set values for parameters used to start and manage the database instance. Let’s look at them in a little more detail and compare them. Server Parameter File – SPFILE The Oracle Server Parameter File (SPFILE) […]
Oracle Background Processes
The Oracle background processes are there to maximize performance. The idea being that common tasks which each user process would normally have to complete can be done by one Oracle background process with greater efficiency. There are some core background processes and others which only run when you have certain optional, additional set-ups configured in […]
ORA-01925: maximum of 30 enabled roles exceeded
If you are maintaining a large number of users within your database, you will probably be making use of roles to manage user privileges. If you aren’t, you should be! Creating a large number of roles as the same user can lead to issues, because the creator of the role gets the role granted to […]
ORA-01000: maximum open cursors exceeded
The Problem You are using the NID command to change the ID of your DB and you have issued the following command: D:\oracle\product\11.2.0\dbhome_11\bin\nid target=sys/password dbname=TEST setname=YES You then get the following errors message: NID-00111: Oracle error reported from target database while executing begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end; ORA-01000: maximum open cursors exceeded The […]
PL/SQL: ORA-00942: table or view does not exist
The problem I was compiling a package with a SQL query embedded within the package body. I really couldn’t understand why the package was not compiling because the query, when run outside of the package and as the same user, was running successfully. The error that I was getting was a generic and usually very […]
How to use Large Pages in Oracle on Windows
Background Large pages on Windows was implemented in Oracle 10g release 1. To put it simply, the idea behind it is to allocate larger chunks of memory for the buffer cache so there is lower overhead when the CPUs are accessing large amounts of memory, resulting in the RAM being accessed more quickly. With a […]
ORA-31403: change table already contains a column
Imagine the scenario: You have a change set and your Change Data Capture (CDC) configuration has been running smoothly for a few weeks now. Your boss tells you that there is an upgrade planned soon and that the provisional changes included adding columns to the source tables that you have based your change tables on. […]
ORA-31514: change set %s disabled due to capture error
Whenever you come across this error, the first place to look is in the view DBA_APPLY_ERROR. This view will show you the error message causing the problem. You may also find it in a trace file and/or the alert log for the DB. If you set up the change capture so that the STOP_ON_DDL parameter was set toTRUE, […]
ORA-01372: Insufficient processes for specified LogMiner operation
The Problem When using CDC which interfaces with Streams and LogMiner to replicate changes from a source to target destinations, I received serveral errors. There were trace files generated for the DB where the capture process was running. In the trace file for the capture process, I got this: Error 1372 : ORA-01372: Insufficient processes […]
