Oracle 11gr2: Receiving ORA-12801 and ORA-01031 errors since upgrading to 11gR2

Since upgrading my database from 10gR2 (10.2.0.4) to 11gR2 (11.2.0.1.1), I am receiving the following errors:
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001
ORA-01031: insufficient privileges
ORA-06512: at "MDMINT1.PKG_MRA", line 1378
ORA-06512: at line 1

These errors are appearing when I run a ksh script. Before the upgrade, this ksh script was running successfully, and without any parallel query server errors.

The errors started immediately after I upgraded my database to 11.2.0.1.1

Anyone else have issues like this? or any ideas of things I could try to resolve this?

Oracle several errors during bulk add (ORA-13199, ORA-12801, ORA-01652, ORA-01653)

In a batch process I use a parallel bulk add to insert several millions of triples in an RDF model.At some point, an insert failed with this message : ORA-13199: Failed in DDL_same_rdf_indexes call:ORA-13199: step_num=6 SQLERRM=ORA-12801: error signaled in parallel query server P020ORA-01652: unable ...

Oracle Report Error ORA-12801 / ORA-01741 caused from one tiny change.

I have a report page containing 3 report regions.1st - displays New Orders2nd - displays In Progress Orders3rd - displays Orders completed with in last 24 hours.The first 2 regions are fine and the 3rd was fine until I added a filter in the where clause to limit data to the last 24 hours using sysda ...

Oracle configuring some database parameters because of error:ORA-12801 & ORA-01652

I have a configuration issue that I really need some help because I don’t understand almost anything about oracle database management and I’m getting the errors:ORA-12801:error signaled in parallel query server P0XX ORA-01652:unable to extend temp segment by 128 in tablespace TEMPO1 I have a ser ...

Oracle ORA-12801 + ORA-08103 + ORA-06512

Sun OSOracle 9.2.0.8Today our statistics job has failed due to the below error, DBMS_STATS package is present in the DB but don’t know about the failure reason. If it’s an oracle bug does anyone know the patch number/metalink doc id ? MYDB> BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'MY ...

Oracle Installing 10g getting 12638 and 01031 errors

Luckily for me I have landed the job of installing Oracle.When creating a default database the install program comes up with ...ORA-12638 Credential retrieval failed.Looking through the forums the fix is to change the setting (sqlnet.ora) toSQLNET.AUTHENTICATION_SERVICES = (NONE)The install then rep ...

Oracle ORA- 03113 AND ORA-01031 Errors

Please help when i login through remote login with sysdba and i try to change the password for users I am getting this error ORA- 03113: end-of-file on communication channalOn another database i cannot login through INTERNAL user getting error ORA- 01031: Insufficient privilages. Please help ...

Oracle Strange ORA-01031 errors

Howdy all,I did a quick search of the forums and was unable to find anyone else that suffered from a similar problem, so here goes:I have created a view as one user (let's call it user A) and have granted SELECT access on it to another(user B). I have gone so far as to add a public synonym, but this ...

Oracle List of FRM and ORA errors

I'm currently enrolled in a course named Applied Database Techniquesat Purdue University Calumet.I'm looking for a compact list of error messages (FRM and ORA). Our book is "A Guide to Oracle8" by Morrison. I'll be using this book for the next two courses.I have been compiling a short list oferrors ...

Ora-01031 Errors

How could i remove this BUG? (BUG no.265300) Application Developer 5.0 (forms& reports) Here, while executing one forms i got following errors(ORA-01031), OCTSPSL is my main user having all privileges like connect,resource,execute any procedure etc. Even i tried to give priv. to OCTSPSL as DBA t ...

Oracle ctxsys.context index creation :ORA-01031: insufficient privileges on sys.XMLType

in the following enviroment:Oracle9i Enterprise Edition Release 9.0.1.1.1 - ProductionWith the Partitioning optionJServer Release 9.0.1.1.1 - ProductionOn an MS 2K boxI experience the following problem:if I create a tablecreate table test(c type);where type is varchar2 o clob I then succesfully issu ...

Oracle ORA-12801: error signalled in parallel query server

A client of ours is using our reporting tool, Impromptu 6, to report from an Oracle 8.1.6 database connecting with Net8. He has built a simple report which displays a single item from a single table but it fails with:-Query Server Error"ORA-12801: error signalled in parallel query server"Error numbe ...

Oracle Errors ORA-29902, ORA-13357, ORA-06512 SDO_INDEX_9I ligne 232

I have a table 'SP_LINES_INDEX' with geometry column 'GEOM'in Oracle 9i spatial version 9.0.1.1, and filled it with about 1300 rows of MultilineString (all have GTYPE=3006). The geometry is defined as 3-D in millimetres (null srid). Correct entry is made in Spatial metaTable as follows:DELETE FROM U ...

Oracle How do I lookup ORA-XXXXX errors?

I vaguely recall a webpage on the OTN that would letyou type in a ORA-XXXXX error number and it would give you useful information ... does anyone know of thewebpage I am talkinga about and what's its URL? ...

Oracle Cannot connect/ as sysdba (ORA-01031 insufficient privileges)

I'm attempting to creat a database using scripts and not the DBCA in a windows 2000 server running Oracle 9i. I execute oradim correctly, set the ORACLE_SID parameter (set ORACLE_SID=XXX).Then as i try to log into sqlplus through DOS window(SQLPLUS /NOLOG) CONNECT / AS SYSDBA i get ORA-01031.I've se ...

Oracle virtual private database error ora-01031

I am connected with user sys.and executing dbms_session.set_context('sai','buuddh',23071975);now error Ora-01031insufficiant privilage. now what I do? with regardsSiddharth Singhsinghsiddh@yahoo.comssingh@intecinfocom.com ...

Oracle Materialized view ORA-12801

i am trying to create a mat.view based upon another mat. view, joined with some other tables, but ik keep getting this error.queryCREATE MATERIALIZED VIEW LOG_MV_COUNTRY_INTERMbuild IMMEDIATEREFRESH FORCESTART WITH SYSDATENEXT SYSDATE+7AS ( SELECT IP,OBJECT_SIZE,SITENAAM, GETCOUNTRY(DISTINCT_IP) AS ...

Oracle Scheduled Batch jobs error : ora-01031 insufficient privileges

I have created a batch job that runs my database backups on a windows 2000 server. This job works perfect from the command line with the following syntax:coldbackup.bat PRODI have tried to schedule this backup to run every evening as follows:at 01:00 /every:M,T,W,Th,F,S C:\coldbackup.bat PRODThe bat ...

Oracle ORA-12154 ORA-01031 Installing 10g

I'm trying to install the 10g Oracle version downloaded from www.oracle.com but I get the following error messages where creating a database:ORA-12154: TNS:Could not resolve the connect identifier specifiedAfter ignoring this message I get:ORA-01031:insufficient privilegesAnd these messages are repe ...

Oracle ORA-01190, ORA-06023 errors

Hi, I've been trying to do some RMAN testing and I've run into a problem trying to do a full restore. I dropped a tablespace and now I'm trying to restore it. On the restore I get the error RMAN-06026: some targets not found - aborting restore andRMAN-06023: no backup or copy of datafile 8 found to ...

Oracle Error ORA-12801: error signaled in parallel query server P005

am running parallel query on the server, which throws me the following errror. Is there anyway to solve it?Error ORA-12801: error signaled in parallel query server P005ORA-29903: error in executing ODCIIndexFetch() routineORA-20000: Oracle Text error:DRG-50857: oracle error in drekrgm (one piece lob ...

Oracle Error ORA-12801: error signaled in parallel query server P005

I am running parallel query on the server, which throws me the following errror. Is there anyway to solve it?Error ORA-12801: error signaled in parallel query server P005ORA-29903: error in executing ODCIIndexFetch() routineORA-20000: Oracle Text error:DRG-50857: oracle error in drekrgm (one piece l ...

Oracle ORA-06512/ORA-21000 errors encountered.

I work on Oracle 9i on Sun OS.The problem I'm encountering right now is an 'ORA-21000: error number argument to raise_application_error of -1 out of range' with an 'ORA-06512: at "<Application-Package Name>", line <so-and-so>.To be more clear, the application works perfectly fine from th ...

Oracle Very odd Procedure creation ORA-01031 Insufficent privileges

I am trying to create a procedure STUDENT.ADD_INSTRUCTOR but all i am getting is ORA-01031 Insufficent privileges. I look up STUDENT.USER_OBJECTS and i find ADD_INSTRUCTOR this must mean STUDENT owns the object and yes STUDENT does have CREATE PROCEDURE privilege. So then i try and drop the procedur ...

Oracle Remote login as sysdba, ORA-01031

I am trying to connect to a remote database which is installed on HP-UX from Windows-XP machine, as sysdba. 1. When I try to login from sqlplus system does not prompt for the password and gives following error:SQL> connect sys@dcoemrep as sysdbaERROR:ORA-01031: insufficient privileges2. When I tr ...

Oracle ORA-12801: error signaled in parallel query server P002

When I do this: Select * from xxx , I have a msg error:ORA-12801: error signaled in parallel query server P002What's happen ?? ...

Oracle problem with startup and ORA-01031

I just have installed Oracle 9i for windows. At the end of the installation, i gave the same password for SYS and SYSTEM when it asked me to.I don't understand why i can now log into sqlplus with this password under the user SYSTEM but not SYS.With SYSTEM , i can't do anything. It says that I am not ...

Question Oracle 9i Streams Errors ORA-00600 ORA-07445 ORA-00604 ORA-04031

I implement Oracle 9i 9.2.0.6 streams in Solaris 5.8 and got the following error.Production:Errors in file /u01/app/oracle/admin/OWLPI/bdump/owlpi_cp01_11186.trc:ORA-25448: rule STRMADMIN.F091112770 has errorsORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","select /*+ index( ...

Oracle Error creating materialized view : ORA-01031: insufficient privileges

I am trying to create a materialized view using following script.create materialized view sw_device_vbuild immediaterefreshcomplete with rowidon demandenable query rewriteasselect customer_id cust_id, b.techgeo techgeo,rtrim(segment1,' ') device_id,rtrim(a.process,' ')process from apps.cmfcst_bom_ge ...

Oracle Versioned, List Partitioned Table ORA-00600 errors

I have just version-enabled a table that was list partitioned. Prior to versioning we had no problems querying through the 5 million rows. Now that the table is versioned we are unable to query certain values of the partition key. In 2 partions, all values return an error. In a 3rd partition, only s ...