So we are trying to use read-only physical standby (Primary database Oracle Enterprise edition 12.2 RAC, with single instance standby) for BI publisher reports. Some reports works and some run into the following error:
ORA-01157: cannot identify/lock data file 1039 - see DBWR trace file
ORA-01110: data file 1039: '/u02/c2mprd/c2mprd/tempfile/temp.339.1026736315'
01157. 00000 - "cannot identify/lock data file %s - see DBWR trace file"
*Cause: The background process was either unable to find one of the data
files or failed to lock it because the file was already in use.
The database will prohibit access to this file but other files will
be unaffected. However the first instance to open the database will
need to access all online data files. Accompanying error from the
operating system describes why the file could not be identified.
*Action: Have operating system make file available to database. Then either
open the database or do ALTER SYSTEM CHECK DATAFILES.
Am I supposed to create those temporary files?
Also, it sounds like for physical standby (read-only) to use for BI-publisher, I should be doing:
https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-E8D272CF-6863-489C-BE8F-448C11882C09.htm#standby_db_event_poll
http://blog.umairmansoob.com/configure-oracle-obiee-with-standby-database/
Has anyone run into the same issue and how you resolved it? Thank you!