Category Archives: ORA Database Error Messages

ORA-32767: No server connection for this operation

oracle

ORA-32767: No server connection for this operation
Cause: The client side sql or plsql function operation requires a connection to the server, but currently no client/server connection existed
Action: Establish a client/server connection

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32766: instr with negative offset: use varchar semantics on LOBs

oracle

ORA-32766: instr with negative offset: use varchar semantics on LOBs
Cause: The current varchar behavior is different. e.g. instr('abcd', 'cd', -2, 1) returns 3, whereas instr(to_clob('abcd'), 'cd', -2, 1) returns 0, (i.e. no match), because the reverse search starts from offset -2, which points to 'c' and moving backward, i.e. 'd' is ignored. This is symmetric to instr('dcba','dc',2,1), which returns 0
Action: ORACLE uses the same varchar semantics on LOBs (instr). Using the same example, instr(to_clob('abcd'), 'cd', -2, 1) will return 3 as in the varchar case

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32763: Turn off N-Pass Temp LOB cleanup

oracle

ORA-32763: Turn off N-Pass Temp LOB cleanup
Cause: None
Action: Facilitate debugging and testing //////////////////////////// SQL function on LOBs Error numbers 32766 to 32770 are reserved for SQL function on LOBs ////////////////////////////

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32762: Turn on Temp LOB Ref Count Tracing

oracle

ORA-32762: Turn on Temp LOB Ref Count Tracing
Cause: None
Action: Check Trace file for debug info

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32761: Turn off Temp LOB Ref Count Feature

oracle

ORA-32761: Turn off Temp LOB Ref Count Feature
Cause: None
Action: Turn off the whole temp lob ref count feature

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32743: command cannot be executed on remote instance

oracle

ORA-32743: command cannot be executed on remote instance
Cause: The database was not mounted in SHARED mode
Action: Mount the database in SHARED mode

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32742: Hang analysis initialize failed

oracle

ORA-32742: Hang analysis initialize failed
Cause: Hang analyzer was not able to allocate memory to initialize
Action: Check the trace files

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32741: Hang analysis already going on

oracle

ORA-32741: Hang analysis already going on
Cause: Hang analysis was already in process globally or for the instance
Action: Wait for the current operation to complete and re-run the command

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32740: The requested operation cannot be proceeded

oracle

ORA-32740: The requested operation cannot be proceeded
Cause: Operation was aborted because instance termination was in progress
Action: Retry later after restarting the instance

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32739: Hang analysis aborted due to failed heap re-grow

oracle

ORA-32739: Hang analysis aborted due to failed heap re-grow
Cause: DIAG couldn't re-grow the heap for wait-for-graphs
Action: Check DIAG trace files for errors

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/