:

The Latest Oracle 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’ […]

Continue Reading

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

Continue Reading

Oracle Background Processes

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading