oracle_fdw caches Oracle database connections, and this error means that something dropped the connection. You should examine the Oracle and network setup if there is something misconfigured. Looking at the Oracle server log would also shed light on the matter.
Normally, if such an error occurs at the start of a transaction, oracle_fdw will automatically reconnect to Oracle.
For further diagnosis, I would need more context information.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…