Skip to Main Content
  • Questions
  • "ORA-03150: end-of-file on communication channel for database link ORA-02063: preceding line from SAP_INCR_LINK"

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Chanakya.

Asked: June 25, 2020 - 7:04 am UTC

Last updated: March 11, 2022 - 4:04 pm UTC

Version: Oracle 12 c

Viewed 10K+ times! This question is

You Asked

DB Link is failing with some connection issue when procedure is running.

and Connor said...

Check the alert log on the remote instance. If the remote session crashed, that is where the details will be found.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

PanditB, March 10, 2022 - 1:05 pm UTC

ORA-03150: end-of-file on communication channel for database link
ORA-02063: preceding line from db_link


receiving above command and the target database is open in read only mode. not creashed
Chris Saxon
March 11, 2022 - 4:04 pm UTC

We're not saying the whole database has crashed, just the session the database link has connected to.

In any case, the advice is the same: check the alert log on the remote database.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database