Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?
A.
The database must be in read-write mode.
B.
The database must have no external files.
C.
The database must open in read-only mode.
D.
The database must be mounted but not opened.
“This function checks whether a database can be transported to a target platform. It tests whether transport is supported at all for a given source and destination platform, and whether the database is currently in the correct state for transport.
…
Open database read-only and retry.”
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_tdb.htm#BDCJHJIC
This example illustrates the use of CHECK_DB with a database that is open read-write:
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
db_ready BOOLEAN;
BEGIN
db_ready := DBMS_TDB.CHECK_DB(‘Microsoft Windows IA (32-bit)’);
END;
/
Database is not open READ ONLY. Please open database READ ONLY and retry.
PL/SQL procedure successfully completed.