ORA-01012: Not Logged On Process ID remote connection (Doc ID 1641869.1)

Last updated on APRIL 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

There are two databases: "local" and "remote".
 
There is a working database link "dblink1" in "local" database
connecting to "remote" database.
 
When start selecting from big "remote" table, for example:
SELECT * FROM DUAL
*
ERROR at line 1:
ORA-1012: not logged on
 

Example messages in the database alert log file

Tue Mar 18 16:22:02 2014
Error 28 trapped in 2PC on transaction 77.4.382071. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 77.4.382071 rolled back, some remote DBs may be in-doubt
ORA-00028: your session has been killed
ORA-02063: preceding line from DBLINK_NAME


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms