ORA-03106: fatal two-task communication protocol error

ORA-03106: fatal two-task communication protocol error

Post by Youichi Tamu » Tue, 11 Oct 1994 20:51:09



We're encountering a number of problems running PL/SQL programs accessing
tables and other objects in a remote database.  ORA-3106 is one of them.

I am ...
Connected to:                                
ORACLE7 Server Release 7.0.15.4.2 - Production
With the procedural and distributed options  
PL/SQL Release 2.0.17.1.0 - Production        
SQL*Plus: Release 3.1.2.3.1 - Production on Mon Oct 10 20:46:45 1994

To simplify the problem, I would run a dummy PL/SQL block as follows:
____________________________________________________________________________
  1  declare                                          
  2  currec today%rowtype;                            
  3  cursor cur is                                    
  4  select '' from today;                            
  5  begin                                            
  6  open cur;                                        
  7  fetch cur into currec;                          
  8  close cur;                                      
  9* end;                                            
20:22:47 SQL> /                                      
declare                                              
 *                                                    
ERROR at line 1:                                      
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from BT1TOOL                
ORA-06512: at line 7                                  
____________________________________________________________________________

'today' is a remote table.  BT1TOOL is a database link name.  What is the
nature of this error ORA-3106?  Where should we start looking for a cure?
Looks like FETCHing '' from a remote table is causing this error; is this a
known problem?

In any case, I substitute null for '' and run the same script:
____________________________________________________________________________
  1  declare                                                                  
  2  currec today%rowtype;                                                    
  3  cursor cur is                                                            
  4  select null from today;                                                  
  5  begin                                                                    
  6  open cur;                                                                
  7  fetch cur into currec;                                                  
  8  close cur;                                                              
  9* end;                                                                    
declare                                                                      
 *                                                                            
ERROR at line 1:                                                              
ORA-06501: PL/SQL: internal error 74806, arguments: [], [], [], [], [], [], []
____________________________________________________________________________

Is this a known bug?

I am ...
Disconnected from ORACLE7 Server Release 7.0.15.4.2 - Production
With the procedural and distributed options                    
PL/SQL Release 2.0.17.1.0 - Production                          

Thank you for any help.
--
                                                        Yoichi Tamura

 
 
 

1. ORA-3106: TWO-TASK ERROR

Hi everybody,

I wrote an embed SQL program in
   HP-UX 9000/400, HP-UX 9000/200
   OS 10.01 and OS 10.01
   Oracle version 7.2.3

From time to time I got ORA-3106: TWO-TASK ERROR.
I did set TWO_TASK variable to the ORACLE_SID. It didn't solve
my problem.

Thank you in advance for any help.

2. Printer recommendation for S7 please

3. Two-task communication error

4. MAC Address Retrieval

5. Help: Two-task protocol error connecting to server

6. posts

7. ORA-3107 (fatal 2-task error) in Novell

8. HP1100C

9. ORA-03106 alt. ORA-01008

10. Windows 32-bit Two-Task driver unable to spawn new ORACLE task

11. Windows NT Two-Task driver unable to spawn new Oracle task?

12. ORA-9368: Windows 3.1 Two Task Driver error with Personal Oracle 7

13. ORA-09368 Windows 3.1 Two-Task driver unable to spawn Oracle.