tempfile 不足时，增加tempfile报错，可以忽略，初步估计在一个node增加时第二个node还没有更新。

Symptoms

Customers encounter the ORA-01187 and ORA-01110 errors, indicating they are unable to read from a file due to verification issues with the data file '<PATH>/temp.2748.1173954671'.

ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 1234: '<PATH>/temp.2748.1173954671'
 

Changes

 No changes are made.

Cause

The cause of the error is attributed to one of the following reasons:

The TEMP tablespace is offline.
The '<PATH>/temp.2748.1173954671.dbf' file is damaged or corrupted.
Issues with the physical disk, controller, or data file blocks.

Solution

The following steps to resolve the problem:

Create a new TEMP tablespace of the desired size. For example:

create temporary tablespace TEMP1 tempfile '<PATH>/temp01.dbf' size 100M extent management local uniform size 128K;

If the original tablespace is the default temporary tablespace, set the new tablespace as the default for all users:

alter database default temporary tablespace TEMP1;

 Drop the old tablespace:

drop tablespace temp including contents;

Run hardware diagnostics to investigate physical components, including controllers, disks, and cables, as suggested by your hardware vendor.
This step is recommended to prevent future occurrences.
These steps should resolve the immediate issue, and further diagnostics can be performed to ensure system stability.