JDBC Application Fails With java.sql.SQLException: Io exception: Broken pipe After Setting System Change Number SCN Parameters in the Database
(Doc ID 1573520.1)
Last updated on JUNE 05, 2023
Applies to:
JDBC - Version 10.1.0.4 to 12.1.0.2.0 [Release 10.1 to 12.1]Information in this document applies to any platform.
Symptoms
After setting the following parameters for System Change Number (SCN) in an an Oracle Database 11g Enterprise Edition Release 11.2.0.2.0:
Changes
The statements:
ALTER SYSTEM SET "_external_scn_rejection_threshold_hours"=24 scope=spfile;
ALTER SYSTEM SET "_external_scn_logging_threshold_seconds"=3052 SCOPE=spfile;
were executed in the database to fix error: ORA-19706: invalid SCN error.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |