Oracle Error Ora-00155
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-00155 Error Description: Cannot perform work outside of global transaction Error Cause: The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction. Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 74 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
transaction Cause: The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction. Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set http://psoug.org/oraerror/ORA-00155.htm nolocal=f in the xa_open string or start a global transaction prior to attempting the work. Posted by Senthil kumar at 05:53 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ORA-00155, ORA-00155: cannot perform work outside of global transaction No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) http://oraerrormsgs.blogspot.com/2012/01/ora-00155-cannot-perform-work-outside.html Search This Blog Loading... Translate Blog Archive ▼ 2012 (10441) ▼ January (1747) ► Jan 02 (7) ► Jan 03 (60) ▼ Jan 04 (60) ORA-00093: %s must be between string and string ORA-00094: %s requires an integer value ORA-00096: invalid value string for parameter stri... ORA-00097: use of Oracle SQL feature not in SQL92 ... ORA-00100: no data found ORA-00101: invalid specification for system parame... ORA-00102: network protocol string cannot be used ... ORA-00103: invalid network protocol; reserved for ... ORA-00104: deadlock detected; all public servers b... ORA-00105: too many dispatcher configurations ORA-00106: cannot startup or shutdown database whe... ORA-00107: failed to connect to ORACLE listener pr... ORA-00108: failed to set up dispatcher to accept c... ORA-00109: invalid value for attribute string: str... ORA-00110: invalid value string for attribute stri... ORA-00111: invalid attribute string ORA-00112: value of string is null ORA-00113: protocol name string is too long ORA-00114: missing value for system parameter SERV... ORA-00115: connection refused; dispatcher con
Work Outside of Global Transaction Error Code ORA-00155 Description Cannot perform work outside of global transaction. Cause Possible cause of this error is, the application http://webdesignpluscode.blogspot.com/2013/03/ora-00155-cannot-perform-work-outside.html tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction. Action To fix this error, check if the application is connected http://www.orafaq.com/parms/parm2031.htm to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either oracle error set nolocal=f in the xa_open string or start a global transaction prior to attempting the work. reference See Also Posted by Waqas Ali Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ora-code, oracle No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Follow by Email Google+ Badge Flag Counter Free Tumblr Online Counter Blog Archive ► 2016 (7) ► June (3) ► February (4) ► oracle error ora-00155 2015 (1) ► April (1) ► 2014 (102) ► November (26) ► October (76) ▼ 2013 (127) ► November (5) ► October (3) ► May (9) ► April (22) ▼ March (37) ORA-00215 Must be at Least one Control File ORA-00214 Control file String Version String Incon... ORA-00213 Cannot Reuse Control File ORA-00212 Block Size String below Minimum Required... ORA-00211 Control File does not Match Previous Con... ORA-00210 Cannot Open the Specified Control File ORA-00209 Control File Blocksize Mismatch ORA-00208 Number of Control File Names Exceeds Lim... ORA-00207 Control Files are not for the Same Datab... ORA-00206 Error in Writing Block String of Control... ORA-00205 Error in Identifying Control File ORA-00204 Error in Reading Block String of Control... ORA-00203 Using the Wrong Control Files ORA-00202 Control File String ORA-00201 Control File Version String Incompatible... ORA-00200 Control File could not be Created ORA-00166 Remote or Local Nesting Level is too Dee... ORA-00165 Migratable Distributed Autonomous Transa... ORA-00164 Distributed Autonomous Transaction Disal... ORA-00163: Internal Database Name Length String is... ORA-00162 External dbid Length String is Greater t... ORA-00161 Transaction Branch Length String is Ille... ORA-00160 Global Transaction Length String is Grea... ORA-00155 Cannot Perform Work Outside of Global Tr... ORA-00154 Protocol Error in Transaction Monitor ORA-00153 Internal Error in XA Library ORA-00152 Current Session does not
concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 10.2.0: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 10.1.0: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 9.2.0: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 8.1.7: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 8.0.6: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Oracle 7.3.4: Parameter Name:transactions Description:max. number of concurrent active transactions Type:NUMBER Obsoleted:FALSE Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE Related Error Messages: ORA-00060: deadlock detected while waiting for resourceCause: Transactions deadlocked one another while waiting for resources.Action: Look at the trace file to see the transactions and resources involved. Retry if necessary. ORA-00155: cannot perform work outside of global transactionCause: The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction.Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work.// ORA-01545: rollback segment '%s' specified not availableCause: Either: 1) An attempt was made to bring a rollbac