ORA-01410 – Invalid rowid

One of the reason why invalid rowid can occur is if there is a truncate that occurs in between when an existing SQL is running. Sample: 1) Sample table x with one column of datatype NUMBER. SQL> select * FROM ajaffer.test; X ———- 1000 1000 1000 1000 1000 1000 1000 7 rows selected. 2) Long running query which has a sleep for 60 seconds before … Continue reading ORA-01410 – Invalid rowid

How to force a trace file to be created when an ORA error occurs?

There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message in the database alert log that there oracle couldn’t extend temporary tablespace and we couldn’t find the cause and user who ran into the issue. So turning on event for the error oracle will create a trace file which will contain user, machine, os, SQL … Continue reading How to force a trace file to be created when an ORA error occurs?

ORA-01031: insufficient privileges

Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not part of the “dba” group when one tries to connect as sysdba, so it’s required user oracle is part of the “dba” group As you see in the following example below: $ sqlplus “/as sysdba” SQL*Plus: Release – Production on Sun Apr 5 16:26:06 … Continue reading ORA-01031: insufficient privileges