:

RSSScripts

ORA-31626: job does not exist

The Problem We have a scheduled data pump job which runs every month to export an old partition of a table which we subsequently drop – it’s no longer needed in the application but we keep it as an export just in case we need to get the data back for some reason. Anyway, this […]

Continue Reading

ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’

The Problem While attempting to gather statistics within my schema, I received the following error: ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’ The Cause I was unsure what the problem was so I wanted to check that I had the basic parameters set correctly. SQL> show parameter undo NAME       […]

Continue Reading

NID-00137: All datafiles that are not dropped should be readable

The Problem You are using the DBNEWID utility (The NID command) to change the name and/or ID of your database and you receive the following error: Cannot read the header of the following datafiles: D:\ORADATA\GENERAL\TEMP01.DBF (1), error: 4 D:\ORADATA\GENERAL\TEMP02.DBF (2), error: 4 D:\ORADATA\GENERAL\TEMP03.DBF (3), error: 4 D:\ORADATA\GENERAL\TEMP04.DBF (4), error: 4 D:\ORADATA\GENERAL\TEMP05.DBF (5), error: 4 NID-00137: […]

Continue Reading

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