We're here to help!

ERR-9027 and ERR-9085 in replicate log files

Follow

Read our docs Explain what ERR-9027 and ERR-9085 means


Problem Details

Problem Statement

Explain what ERR-9027 and ERR-9085 means

Applicable Error Code

ERR-9027, ERR-9085

Affected Versions

2.9

Affected Platforms

Linux & Windows 


Description

Explain what ERR-9027 and ERR-9085 means and its impact on Replication.

2018/04/23 12:35:21 INFO> Replicate job Delete old records from DBRSCOMMON_ERRORLOG submitted as job 24487.
2018/04/24 00:46:33 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320002 not found at SCN 437357229904 at mine.
2018/04/24 00:46:33 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320002 does not exist, cannot unprepare.
2018/04/24 00:46:41 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320003 not found at SCN 437357233376 at mine.
2018/04/24 00:46:41 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320003 does not exist, cannot unprepare.
2018/04/24 00:47:12 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320004 not found at SCN 437357240830 at mine.
2018/04/24 00:47:12 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320004 does not exist, cannot unprepare.
2018/04/24 00:47:12 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320005 not found at SCN 437357240960 at mine.

Solution

These SYS.ORA_TEMP_1_DS_% temporary tables are used when Oracle computes statistics during the gathering of statistics.
Because they are used for the internal purpose of gathering statistics (internal usage of dbms_stats package), they are created in SYS schema. These tables can be then referenced in user schema when replication is active.

Having said that, these messages are ignorable.

Have more questions? Submit a request

Comments