Category Archives: Oracle

ORA-01950: No privileges on tablespace ‘USERS’

The user who owns the tables should be given privileges on user tablespace. Run the following command with DBA rights to resolve the issue: GRANT UNLIMITED TABLESPACE TO <username>; Reference: http://dba-oracle.com/bk_no_privileges_tablespace_users.htm Advertisements

Posted in Oracle | Tagged

WTRN0037W: The transaction service encountered an error on an xa_recover operation. Error code is: XAER_RMERR

Exception in SystemOut.log: [3/26/14 0:50:24:065 GST] 00000006 XARecoveryDat A WTRN0151I: Preparing to call xa recover on XAResource: wpdbDS_jcr [3/26/14 0:50:24:333 GST] 00000006 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null. [3/26/14 0:50:24:334 GST] … Continue reading

Posted in Oracle, WebSphere Application Server, WebSphere Portal | Tagged , , , ,

Oracle commands

ps -ef | grep pmon (List active instances) cat /etc/oratab (List instance installed) ORACLE_SID=INST1 sqlplus “/ as sysdba” (Connect to the instance) ORACLE_SID=INST1 sqlplus “/as sysdba” @/tmp/grantrights.sql shutdown immediate; startup SELECT username from dba_users (List all the schemas in a … Continue reading

Posted in AIX, Linux, Oracle | Tagged , ,

DSRA9350E: Operation Connection.commit is not allowed during a global transaction

I was getting this exception while code was trying to commit the transaction in a EJB web service. Exception [EclipseLink-4002] (Eclipse Persistence Services – 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction. Error … Continue reading

Posted in Eclipse, Oracle, websphere, WebSphere Application Server

Install Oracle 11g, Error file not found /oracle/product/11.2.0/dbhome_1/oc4j/j2ee/oc4j_applications/applications/em.ear

You need to extract both¬† downloaded zipped files (For windows they are win32_11gR2_database_1of2.zip & win32_11gR2_database_2of2.zip) into the same directory such as C:oracle or /opt/oracle. For rest of the procedure to install the oracle please follow the link: http://st-curriculum.oracle.com/obe/db/11g/r2/2day_dba/install/install.htm References: 1. … Continue reading

Posted in Oracle | 1 Comment