:

The Latest Oracle Posts

ORA-01919: role ‘PLUSTRACE’ does not exist

The Problem You and/or another DBA/Developer want to use the plustrace role to trace SQL queries from within a session. You have found that you need to grant this role to your user but you get the error message below. SQL> grant plustrace to user; grant plustrace to user * ERROR at line 1: ORA-01919: […]

Continue Reading

ORA-01031 insufficient privileges on startup

The background to this is that the database went down in the night because something happened on the SAN which caused it to crash – fortunately it was on one of the not used much DEV SANs. I checked over the DBs and noticed that one of them had not come back up on its […]

Continue Reading

ORA-01031 Insufficient Privileges

The Problem When attempting to create a logon trigger for a user, you are faced with this error message: ERROR at line 1: ORA-01031: insufficient privileges The statement that you are running is: CREATE OR REPLACE TRIGGER sys.user1_param_trigger AFTER LOGON ON DATABASE BEGIN IF (USER = ‘USER1’) THEN execute immediate ‘alter session set optimizer_mode=”ALL_ROWS”’; execute […]

Continue Reading

ORA-39041: Filter “INCLUDE” either identifies all object types or no object types

Data Pump is a very powerful tool and a great improvement over the original export and import utilities in early versions of Oracle. With the 10g version of data pump, you can filter objects to very specific levels, stating what you want to include and exclude within your export and import. For example, you can […]

Continue Reading

The value (30) of MAXTRANS parameter ignored

I came across the valu (30) MAXTRANS parameter ignored error Oracle error when using datapump to import data into my 11g database. It is covered in Metalink note ID: 455021.1. The short of it is that a table is trying to be created like this: create table testing (col1 number) initrans 10 maxtrans 30; The parameter […]

Continue Reading

Error – Real Application Testing option is not available

The Problem You want to make use of Real Application Testing (RAT) in your 10g DB (this may apply to 11g as well but I haven’t had the same issue there), but it is not available in Enterprise Manager. You can check this by going to the targets -> Database -> Software and Support -> Database Reply […]

Continue Reading

Real Application Testing option is not available

The Problem You want to use Real Application Testing to capture and replay load against your Oracle database to test the effect of changes that you make. In the Enterprise manager you go to the “Software and Support” tab and click on “Database Replay” under the “Real Application Testing” header and you receive the following […]

Continue Reading

ORA-32012: SPFILE format is inconsistent with value of COMPATIBLE parameter

The Problem I was using Real Application Testing and I had just finished capturing a workload on a test database, while also having created a restore point. After capturing the workload, I attempted to run a query but it failed because the instance was down. I re-started the instance and then tried the query again […]

Continue Reading

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

The Problem 11:16:06 SQL> startup ORA-01078: failure in processing system parameters ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0 The Cause The parameters were not configured correctly for Automatic Memory Management. Ensure that your SGA_TARGET and SGA_MAX_SIZE parameters are configured correctly and appropriately for the server. In addition, check values for SHARED_POOL_SIZE, DB_CACHE_SIZE, etc. Make […]

Continue Reading

ORA-04031 unable to allocate XXX bytes of shared memory

I was using an init.ora file (pfile) and attempting to start my database instance. I received many errors relating to the size of the SGA and the _SHARED_POOL_RESERVED_MIN_ALLOC parameter. Some of the errors that I received can be seen below: ORA-04031 unable to allocate 1128992 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(4,0)”,”KEWS sesst at […]

Continue Reading