ORA-01012: Not Logged On Process ID remote connection
Last updated on APRIL 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 9.2 to 11.2]
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms