ORA-25352: no current transaction

Cause : The user session is not attached to any transaction.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Do not attempt to detach when there is no current transaction.

update : 29-06-2017

ORA-25352 - no current transaction
ORA-25352 - no current transaction

  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-30659 : too many locations specified for external table
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-12912 : Dictionary managed tablespace specified as temporary tablespace
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • ora-30466 : can not find the specified workload string
  • ora-27031 : mirror resilvering functions not supported
  • ora-10577 : Can not invoke test recovery for managed standby database recovery
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-12626 : TNS:bad event type
  • ora-31499 : null value specified for required parameter string
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • ora-16168 : LGWR network server could not switch to blocking mode
  • ora-27464 : invalid schedule type string
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-22613 : buflen does not match the size of the scalar
  • ora-06540 : PL/SQL: compilation error
  • ora-30767 : OID type mismatch
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-38739 : Flashback log file is more recent than control file.
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-24318 : call not allowed for scalar data types
  • ora-00356 : inconsistent lengths in change description
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-38307 : object not in RECYCLE BIN
  • ora-22308 : operation not allowed on evolved type
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.