Perform the following prerequisites before you migrate an on-premises database to Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database.

• Prerequisites to Migrate an On-Premises Database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) Database for Oracle Reports
  Perform the following prerequisites before you migrate an on-premises database to Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database.

Perform the following premigration tasks before you migrate an on-premises database to Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database:

• Creating Credentials
  Create a database credential to authenticate between the Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database and the Oracle Cloud Infrastructure (OCI) object storage.
• Installing 14c (14.1.2.0.0) Product Binaries in Oracle Cloud Infrastructure VM
  Ensure that the 14c (14.1.2.0.0) product binaries are installed in the new ORACLE_HOME.
• Creating a Backup of the Schema Version Registry
  Use the Upgrade Assistant on the on-premises host to create a backup of the existing schema version registry on the on-premises database.

Use Oracle Data Pump to export data from an on-premises database to your Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database.

1. Set the environment variables on the on-premises database host:

   setenv ORACLE_HOME <DB_$OH>
   setenv ORACLE_SID <SID>
   setenv PATH $ORACLE_HOME/bin:$PATH

   where DB_$OH is the Oracle_Home of the database and SID is the service ID of the database.

2. Start SQL*Plus:

   sqlplus

3. Connect to the database as SYS user with the SYSDBA privilege:

   CONNECT / AS SYSDBA

4. Check the schema users for your product:

   Select username,default_tablespace, temporary_tablespace from dba_users where username like '<Schema_Prefix>%';

   Note:

   You must select the users only that are applicable to your product. Ensure that the user names have the schema prefixes that you specified when creating the schemas.
5. Unlock the schemas for the schema users and commit the changes:

   ALTER USER <Schema_Prefix_User> IDENTIFIED BY <Schema_Password> account unlock;
   commit;

   You can use the results from step 4 to determine the schemas to be unlocked.

   An example command to unlock the schemas:

   
   ALTER USER upg_stb identified by <Schema_Password> account unlock;

6. Create a new directory on the database server:

   For example, create a directory /scratch/DP/soa:

   CREATE OR REPLACE DIRECTORY test_dir AS ‘/scratch/DP/soa’;

   Note:

   Ensure that this folder structure exists on the on-premises database host.
7. Grant access to all users you identified in step 4 to the database directory:

   GRANT read, write ON DIRECTORY test_dir TO <Schema_Prefix_User>;

   For example, to grant user access to the directory for SOAINFRA, ORASDPM, IAU, MDS, OPSS, STB, and WLS schemas:

   GRANT read, write ON DIRECTORY test_dir to upg_soainfra, upg_orasdpm, upg_iau, upg_mds, upg_opss, upg_stb,
   upg_wls;

8. Exit SQL using the exit command.
9. Export all schemas at once using the expdp command.

   For example:

   expdp \"sys@<DB_SID> as sysdba\" dumpfile=soa_infra.dmp logfile=product.log directory=test_dir
   schemas = upg_orasdpm,upg_iau,upg_mds,upg_opss,upg_stb,upg_wls

   where DB_SID is the service ID of the on-premises database.

   Note:

   If the schema size is large, you can run the expdp command to export each schema individually.

   For Oracle Enterprise Scheduler (ESS), to export schemas and PROCOBJ data, you must also run this expdp command:

   expdp \"sys/<DB_SID> as sysdba\" dumpfile=<dumpfilename>.dmp logfile=product.log full=y INCLUDE=PROCOBJ\:\"LIKE \'<Schema_Prefix>\%\'\" INCLUDE=GRANT INCLUDE=ROLE_GRANT directory=test_dir

#Set the environment variables and connect to the database as SYS user using sqlplus,
and then select the users that are applicable to Oracle Forms product. Refer steps 1 to 4.

ALTER USER abc identified by <Schema_Password> account unlock;
GRANT read,write on DIRECTORY test_dir to abc;
commit;
# Export the schemas using expdp
expdp system/<SYS_PWD>@<DB_SID> schemas=abc directory=test_dir dumpfile=abc_meta.dmp logfile=abc1.log

Use the Domain Template Builder to create a custom domain template.

1. Start the Domain Template Builder on the on-premises domain host:

   ORACLE_HOME/oracle_common/common/bin/config_builder.sh

2. On the Create Domain Template screen:
   1. Select Create Domain Template, and then select Use Domain as a Source.
   2. In the Source Location field, specify the location of the source domain directory, or browse to select the location of an existing domain directory, from which you want to create a domain template.
   3. In the Template Location field, specify the JAR file name and the location, or browse to select an existing domain directory in which the template is located, to create the new template.
   4. Click Next.
3. On the Template Information screen, review the information, and click Next.
4. On the Template Summary screen, review the information, and click Next.
5. The Configuration Progress screen displays the progress of template creation. After the configuration process is complete, click Next, and then click Finish to end the configuration.
6. Copy this domain template you created to the Oracle Cloud Infrastructure (OCI) domain host.

Use this task to create a new storage bucket and upload the export files to it.

1. Open a supported browser, and sign in to the Oracle Cloud Infrastructure Console.
2. Click the navigation menu , then under Object Storage, click Object Storage.
3. In the Compartment drop-down list, under the root tenancy, select the compartment in which to upload the dump file and template.
4. Click Create Bucket and enter the bucket name.

   For example, in this case, enter wcc_ins_db_migration.

5. Keep the default encryption options and click Create.
6. Click the bucket name that you created, in this case, wcc_ins_db_migration.
7. Click Upload, and choose the dump file, <dumpfilename>.dmp, downloaded in the test_dir folder in your on-premises machine, and upload the file.
8. In the list of objects, locate the uploaded dump file, click , and then click View Object Details to copy the URL Path.
9. Repeat step 8 and step 9 to upload the domain template you created for an on-premises domain to the bucket, wcc_ins_db_migration, where you uploaded the dump file. See Creating a Domain Template for an On-Premises Domain.

Use Oracle Instant Client to create users and tablespaces.

1. Set the following environment variables in the OCI VM:

   export LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib:$LD_LIBRARY_PATH
   export PATH=/usr/lib/oracle/18.5/client64/bin:$PATH
   export TNS_ADMIN=/home/opc/idm
   export ORACLE_SID=FMWATPDedic2 (Optional)

   where, TNS_ADMIN is the location where you downloaded the database wallet on your OCI host and and ORACLE_SID is the Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database name.

2. Go to the directory where Oracle Instant Client is installed:

   cd /usr/lib/oracle/18.5/client64/bin

3. Connect to sqlplus:

   connect admin/<admin_password>@<database_service_name_found_in_tnsnames.ora>

   For example:

   connect ADMIN/<admin_password>@fmwatpdedic2_tp

4. Create the tablespaces on your Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database

   You can use the results from step 4 in Exporting an On-Premises Database to a Data Dump File to determine the tablespaces to be created.

   An example command to create tablespaces:

   CREATE TABLESPACE "MIG2_IAS_WEBCENTER"
   CREATE TABLESPACE "MIG2_IAS_PORTLET"

5. Create the users on your Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database:

   Note:

   The users should be created based on the product.

   You can use the results from step 4 in Exporting an On-Premises Database to a Data Dump File to determine the users to be created.

   An example command to create users:

   Create user MIG2_WEBCENTER identified by <user_password> DEFAULT TABLESPACE MIG2_IAS_WEBCENTER TEMPORARY TABLESPACE MIG2_IAS_TEMP ;
   Create user MIG2_PORTLET identified by <user_password>  DEFAULT TABLESPACE MIG2_IAS_PORTLET TEMPORARY TABLESPACE MIG2_IAS_TEMP;

6. Grant unlimited amount of disk space in the tablespaces to all users:

   You can use the results from step 4 to determine the users to grant unlimited disk space in the tablesapces.

   For example, to grant unlimited tablespace to MIG2_WEBCENTER user:

   (Optional) ALTER USER MIG2_WEBCENTER IDENTIFIED BY <password>;
   GRANT UNLIMITED TABLESPACE to MIG2_WEBCENTER;

7. Grant privileges that allows all users to create objects in the schema:

   GRANT CONNECT, create view, create table, create procedure, create trigger, create synonym, create sequence, create type to <user_name>;

   For example, to grant privileges to WCS_WLS_RUNTIME user:

   GRANT CONNECT, create view, create table, create procedure, create trigger, create synonym, create sequence, create type to WCS_WLS_RUNTIME;

   For Oracle Enterprise Scheduler (ESS) users, you must also grant the following privileges:

   grant execute on DBMS_LOCK to <Schema_Prefix_User>;
   grant execute on UTL_FILE to <Schema_Prefix_User>;
   grant execute on UTL_RAW to <Schema_Prefix_User>;
   grant execute on DBMS_LOB to <Schema_Prefix_User>;
   grant execute on DBMS_SCHEDULER to <Schema_Prefix_User>;
   grant execute on DBMS_XMLDOM to <Schema_Prefix_User>;
   grant execute on DBMS_APPLICATION_INFO to <Schema_Prefix_User>;
   grant execute on DBMS_UTILITY to <Schema_Prefix_User>;
   grant execute on DBMS_SESSION to <Schema_Prefix_User>;
   grant execute on DBMS_OUTPUT to <Schema_Prefix_User>;
   grant execute on SYS.DBMS_ASSERT to <Schema_Prefix_User>;
   
   grant select on sys.v_$instance to <Schema_Prefix_User>;
   grant select on sys.gv_$instance to <Schema_Prefix_User>;
   grant select on sys.v_$session to <Schema_Prefix_User>;
   grant select on sys.gv_$session to <Schema_Prefix_User>;
   grant select on sys.v_$parameter to <Schema_Prefix_User>;
   
   grant create any job to <Schema_Prefix_User>;
   grant create job to <Schema_Prefix_User>;
   grant manage scheduler to <Schema_Prefix_User>;
   
   grant select on dba_scheduler_jobs to <Schema_Prefix_User>;
   grant select on dba_scheduler_job_run_details to <Schema_Prefix_User>;
   grant select on dba_scheduler_running_jobs to <Schema_Prefix_User>;
   grant select on dba_scheduler_job_classes to <Schema_Prefix_User>;

   Note:

   Ensure that you create the same ESS user that was created in the on-premises database and execute all the required grants to the user, postmigration to the ATP-D database.

Use this task to import the data for the schemas.

1. Set the following environment variables on the Oracle Cloud Infrastructure (OCI) host:

   export LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib:$LD_LIBRARY_PATH
   export PATH=/usr/lib/oracle/18.5/client64/bin:$PATH
   export TNS_ADMIN=<path_of_the_wallet_files>
   export ORACLE_SID=<Database_name> (Optional)

   where, TNS_ADMIN is the location where you downloaded the database wallet on your OCI host and ORACLE_SID is the database name.

2. Go to the directory where Oracle Instant Client is installed:

   cd /usr/lib/oracle/18.5/client64/bin

3. (Optional) Connect to sqlplus:

   Note:

   If TNS_ADMIN is already setup and you are able to connect to the database, it is not mandatory to run this command.

   connect admin/<admin_password>@<database_service_name_found_in_tnsnames.ora>

   For example:

   connect ADMIN/<admin_password>@fmwatpdedic2_tp

4. (Optional) Exit SQL using the exit command.

   Note:

   If TNS_ADMIN is already setup and you are able to connect to the database, it is not mandatory to run this command.
5. Run the following command to import the data dump file to an ATP-D database for your schemas:

   impdp admin/<password_of_admin_user_for_ATP-D_host>@<database_service_name_found_in_tnsnames.ora> credential=<credential_name> dumpfile=<schema_export_dump_file_cloud_object_storage_location exclude=user TABLE_EXISTS_ACTION=REPLACE

   Example:

   impdp admin/<password_of_admin_user_for_ATP-D_host>@fmwatpdedic2_tp credential=def_cred_name dumpfile=https://objectstorage.us-ashburn-1.oraclecloud.com/n/atpdpreview2/b/wcc_install_mig1/o/ocs.dmp exclude=user TABLE_EXISTS_ACTION=REPLACE

   For Oracle Enterprise Scheduler (ESS), when you import the data dump file to an ATP-D database, you must also run this impdp command:

   impdp admin/<password_of_admin_user_for_ATP-D_host>@<database_service_name_found_in_tnsnames.ora> credential=<credential_name> dumpfile=<PROCOBJ_schema_export_dump_file_cloud_object_storage_location> TABLE_EXISTS_ACTION=REPLACE

6. Run the following procedure to move the .log and .sql files to the Object Storage:

   BEGIN
     DBMS_CLOUD.PUT_OBJECT(
     credential_name => '<userXX_cred>',
     object_uri =>  '<the_storage_bucket_URL>/import.log',
     directory_name =>  '<data_dump_dir>',
     file_name =>  'import.log');
   END;
   /

7. Verify if there are any errors in the import.log file.

#Set the environment variables and navigate to the directory where Oracle Instant Client is installed, and then log into the database as an admin user using sqlplus. Refer steps 1
to 3.

CREATE TABLESPACE "USERS";
Create user abc identified by <Schema_Password> DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
GRANT UNLIMITED TABLESPACE to abc;
GRANT CONNECT, create view, create table, create procedure, create trigger, create synonym, create sequence, create type to abc;
commit;
#connect as abc user
connect abc/<password>@fmwatpdedic2_tp;
CREATE TABLE DEPT("DEPTNO" NUMBER(2,0),"DNAME" CHAR(14 BYTE),"LOC" CHAR(13 BYTE));
CREATE TABLE EMP("EMPNO" NUMBER(4,0),"ENAME" CHAR(10 BYTE), "JOB" CHAR(9 BYTE), "MGR" NUMBER(4,0),"HIREDATE" DATE,"SAL" NUMBER(7,2),"COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0));
commit;
# Drop the current table in the database and recreate the new table as in the dump file using impdp
impdp admin/<admin_password>@fmwatpdedic2_tp credential=DEF_CRED_NAME /
dumpfile=https://objectstorage.us-ashburn-1.oraclecloud.com/n/atpdpreview2/b/FormsInstallDBMigration/o/abc_meta.dmp /
TABLE_EXISTS_ACTION=REPLACE
 

To migrate schema version registry from an on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database, you must restore the schema version registry on your dedicated autonomous database.

1. Install the 14c (14.1.2.0.0) Oracle Fusion Middleware product distribution on the Oracle Cloud Infrastructure (OCI) VM.
2. Copy the registry.xml you created in Creating a Backup of the Schema Version Registry to oracle_common/upgrade/bin directory.
3. Navigate to the oracle_common/upgrade/bin directory.
4. Run the following command:

   ./ua -restoreRegistry
   
   Oracle Fusion Middleware Upgrade Assistant 12.2.1.4.0
   Enter location of Schema Version Registry backup file:
   /home/opc/wcc/12215/oracle_common/upgrade/bin/registry.xml
   Restoring from /home/opc/wcc/12215/oracle_common/upgrade/bin/registry.xml
   Enter prefix or * for list:
   <Schema_Prefix>
   Enter the Database Connect String:
   (host:port/service or host:port:SID or TNS connect string)
   jdbc::oracle:thin:@<TNS_alias>?TNS_ADMIN=<path of the wallet files, ojdbc.properties, and tnsnames.ora>
   # Example of Database Connect String: jdbc:oracle:thin:@fmwatpdedic2_tp?TNS_ADMIN=/home/opc
   Enter the DBA User Name: 
   <user_name>
   Enter the DBA Password:
   <password>
   Schema Version Registry restored from /home/opc/wcc/12215/oracle_common/upgrade/bin/registry.xml
   Rows removed: 0. Rows inserted: 12

   Note:

   You must enter the complete location of the registry.xml file and pass the complete database connect string.

Use the Configuration Wizard to create a new domain in your Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database Oracle Cloud Infrastructure (OCI) VM with the Domain Template you created for an on-premises domain.

1. Start the Configuration Wizard on the OCI domain host:
   ORACLE_HOME/oracle_common/common/bin/config.sh
2. On the Create Domain screen, select Create a new domain, and in the Domain Location field, specify the location of the domain, or browse to select an existing directory in which your domain is located, and then click Next.
3. On the Templates screen, select Create Domains Using Custom Templates, and in the Template Location field, browse to select the directory in which you copied or downloaded the domain template, and then click Next.
4. On the High Availability screen, click Next.
5. On the Application Location screen, in the Application Location field, specify the location of the directory or browse to select an existing directory, in which you want to store the applications that are associated with the domain, and then click Next.
6. On the Administrator Account page, specify the Name and Password, reconfirm the password, and then click Next.
7. On the Domain Mode and JDK screen, select a Domain Mode and select the JDK for the domain, and then click Next.
8. On the JDBC Data Sources screen, select the MDS schema, specify Name and Password, and the connect string using the Connection URL String option, and then click Next.

   Use the following format for the connect string:

   jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>

   In the connect string, you must pass TNS_alias as the database name found in tnsnames.ora, and TNS_ADMIN property to the location of the wallet files, ojdbc.properties, and tnsnames.ora.

   Note:

   This step is applicable only for Oracle WebCenter Content.
9. On the JDBC Data Sources Test screen, select the data source, mds-WCCUIMDSREPO and click Test Selected Connections. Ensure that the test is successful, and then click Next.

   Note:

   This step is applicable only for Oracle WebCenter Content.
10. On the Database Configuration Type screen, specify Schema Owner, Schema Password and the connect string using the Connection URL String option.

    Use the following format for the connect string:

    jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>

    In the connect string, you must pass TNS_alias as the database name found in tnsnames.ora, and TNS_ADMIN property to the location of the wallet files, ojdbc.properties, and tnsnames.ora.

11. On the JDBC Component Schema screen, specify Schema Owner, Schema Password and the connect string for each of the data sources, and click Next.

    Use the following format for the connect string:

    jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>

    In the connect string, you must pass TNS_alias as the database name found in tnsnames.ora, and TNS_ADMIN property to the location of the wallet files, ojdbc.properties, and tnsnames.ora.

12. On the JDBC Component Schema Test screen, select all the JDBC component schemas, click Test Selected Connections. Ensure that the test is successful, and then click Next.
13. On the Advanced Configuration screen, select Administration Server, Node Manager, Topology, and then click Next.
14. On the Administration Server screen,  select a value for the Listen Address, and click Next.
15. On the Node Manager screen, review the information, and click Next.
16. On the Managed Servers screen, select a value for the Listen Address for each managed server and click Next.
17. Continue to click Next until you reach the Machines screen.
18. On the Machines screen, select a value for the Node Manager Listen Address and click Next.
19. Continue to click Next until you reach the Configuration Summary screen.

    In case of Oracle Forms, the Oracle Forms application should be deployed on Forms Managed Servers only.

20. On the Configuration Summary page, click Create.
21. The Configuration Progress screen displays the progress of domain creation. After the configuration process is complete, click Next, and then click Finish to end the configuration.

Follow the steps in this section to update the config.xml configuration file, and the Oracle Platform Security Services (OPSS) configuration files, jps-config.xml and jps-config-jse.xml files in the Oracle Cloud Infrastructure (OCI) domain host.

1. To update the config.xml file:
   1. Navigate to the directory, DOMAINHOME/config on the OCI domain host.
   2. If the RDBMS security store is enabled in the on-premises domain, update the config.xml file in one of the following ways:
      • In the WebLogic Remote Console, navigate to Security > Realms, click RDBMS Security Store, and update the RDBMS connection configuration.
      • Use the WebLogic Scripting Tool (WLST).

        Note:

        For sec:connection-url, update jdbc:oracle:thin:@@//dbserver:listener_port/DB_ServiceName with the new database location, jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>.

        Example command to update the config.xml file:

        store = realm.getRDBMSSecurityStore()
        store.setUsername('<Db_SchemaUser>')
        store.setPassword('<Db_SchemaPassword>')
        store.setConnectionURL('jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>')
        store.setDriverName('<driverName>')

        Example of config.xml after update:

        <sec:rdbms-security-store>
            <sec:username><Db_SchemaUser></sec:username>
            <sec:password-encrypted><Db_SchemaPassword></sec:password-encrypted>
            <sec:connection-url>jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>
            <sec:driver-name><driverName></sec:driver-name>
        </sec:rdbms-security-store>

2. To update the jps-config.xml and jps-config-jse.xml files:
   1. Navigate to the directory, DOMAINHOME/config/fmwconfig on the OCI domain host.
   2. In the jps-config.xml file, for the jdbc.url property, update the connect string with the new database location, jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>.

      For example, update:

      <property name="jdbc.url" value="jdbc:oracle:thin:@//dbserver:listener_port/DB_ServiceName"/>

      To:

      <property name="jdbc.url" value="jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>"/>

   3. In the jps-config-jse.xml, for the jdbc.url and the audit.loader.jdbc.string property, update the connect string with the new database location, jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>.

      For example, update:

      <property name="jdbc.url" value="jdbc:oracle:thin:@//dbserver:listener_port/DB_ServiceName"/>
      <property name="audit.loader.jdbc.string" value="jdbc:oracle:thin:@//dbserver:listener_port/DB_ServiceName"/>

      To:

      <property name="jdbc.url" value="jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>"/>
      <property name="audit.loader.jdbc.string" value="jdbc:oracle:thin:@TNS_alias?TNS_ADMIN=<path_of_the_wallet_files, ojdbc.properties, and tnsnames.ora>"/>

   Note:

   During migration, if you have changed the OPSS password in your dedicated autonomous database (ATP-D), execute the following WebLogic Scripting Tool (WLST) commands in offline mode:

   cd <Domain_Home>/oracle_common/common/bin
   ./wlst.sh
   
   Initializing WebLogic Scripting Tool (WLST) ...Jython scans all the jar files it can find at first startup.
   Depending on the system, this process may take a few minutes to complete, and WLST may not return a prompt right away.
   Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands
   
   modifyBootStrapCredential(jpsConfigFile="<Domain_Home>/config/fmwconfig/jps-config-jse.xml",
   username="<Prefix>_OPSS", password="<New_Password>")

Perform the following steps after migrating an on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database for Oracle WebCenter Sites:

1. Copy the contents of {DOMAIN_HOME}/wcsites directory from on-premises to the same location in the Oracle Cloud Infrastructure (OCI) VM.
2. Locate the following files to be updated in the wcsites folder. Open these files in a text editor, and update the on-premises hostname and the domain home entries with the OCI VM name and the domain home in the ATP-D VM respectively:

   Note:

   You can use the command, grep -rnw . -e 'mystring' to search files containing the string: mystring.

   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/bootstrap/search/SearchEngineMetaDataConfig.html${MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/bin/grant-opss-permission.py
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/satelliteserver/config/wcs_satelliteserver_properties_bootstrap.ini
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/satelliteserver/config/wcs_properties.json
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/satelliteserver/config/SSOConfig.xml
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/visitorservices/config/visitors.properties
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/sitecapture/config/wcs_properties.json
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/sitecapture/config/spring/root-context.xml
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/sitecapture/config/wcs_sitecapture_properties_bootstrap.ini
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/Shared/bootstrap/fsii/webroot/WebRoot.html
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/host.properties
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/cas.properties
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/jbossTicketCacheReplicationConfig.xml
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/wcs_properties.json
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/deployerConfigContext.xml
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/wcs_properties_bootstrap.ini
   {MW_HOME}/user_projects/domains/${DOMAIN_NAME}/wcsites/wcsites/config/customBeans.xml

3. Set the number of open files limit using the following commands:

   1. Open the file /etc/security/limits.conf in vi editor.

   2. Add the following lines at the end of the file:

      *        hard     nofile     500000
      *        soft     nofile     500000
      root     hard     nofile     500000
      root     soft     nofile     500000
      

4. In the wcs_properties.json file, set the value for the properties cc.security and cs.session to true.
5. Update all files with on-premises datasource connection strings to ATP-D connection string. See Connection Credentials for ATP-D Database.
6. Run the following SQL command to change the current schema of the session:

   ALTER SESSION SET CURRENT_SCHEMA = <Schema_Prefix>_WCSITES;

7. Run the following SQL commands to update the tables:

   UPDATE SYSTEMSATELLITE SET HOST=REPLACE(host,'<on-premises_hostname>','<oci_hostname>');
   UPDATE WEBROOT SET ROOTURL=REPLACE(rooturl,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_VIEW SET SRCURL=REPLACE(srcurl,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_APPLICATION SET ICONURL=REPLACE(iconurl,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_APPLICATION SET LAYOUTURL=REPLACE(layouturl,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_APPLICATION SET ICONURLCLICK=REPLACE(iconurlclick,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_APPLICATION SET ICONURLHOVER=REPLACE(iconurlhover,'<on-premises_hostname>','<oci_hostname>');
   UPDATE FW_APPLICATION SET ICONURLACTIVE=REPLACE(iconurlactive,'<on-premises_hostname>','<oci_hostname>');

8. In SearchEngineMetaDataConfig table, update the WORKINGFOLDER column.

   For example:

   UPDATE <Schema_Prefix>_WCSITES.SearchEngineMetaDataConfig set workingfolder='<location_of_lucene_in_oci>';

9. In SystemInfo table, update the location of shared folder.

   For example:

   UPDATE <Schema_Prefix>_WCSITES.SystemInfo set defdir = replace(defdir, '<location_of_shared_directory_in_on-premises>', '<location_of_shared_directory_in_oci>');

10. In SystemInfo table, update the domain location.

    For example:

    UPDATE <Schema_Prefix>_WCSITES.SystemInfo set defdir = replace(defdir, '<location_of_domain_in_on-premises>', '<location_of_domain_in_oci>');

Perform the following steps after migrating on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database for Oracle Enterprise Content Management Suite (ECM):

1. Follow steps described in Copy WebCenter Content Directory to the New Host to Verify that Everything Works in Migrating Oracle WebCenter Content.
2. If the IPM server does not start after you log in to the OCI VM, run the following command to create an Imaging connection:

   UPDATE <Schema_Prefix>_IPM.connection_details set detailvalue='<oci_vmhost>:4444' where detailkey='repository.secondaries';

3. Import users from the WebLogic console to the Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database OCI VM.

After migrating an on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database for Oracle WebCenter Content, perform the steps described in Migrating Oracle WebCenter Content.

For more information, see Migrating Oracle WebCenter Content.

To configure full-text search, you must rebuild indexes using the Repository Manager. For more information, see Enable Full-Text Search in Administering Oracle WebCenter Content.

Perform the following steps after migrating an on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database for Oracle WebCenter Portal:

1. Run the following WLST command to update the host and port for the WebCenter Content Server connection:

   setContentServerConnection (appName='webcenter', name=‘<existing_connection_name>',
   serverHost=‘<new_host_name>', serverPort=‘<new_port_number>', isPrimary='true’)

2. Run the following WLST command to update the host name for the discussion server connection.

   setDiscussionForumConnection(appName='webcenter', name='<existing_connection_name>',
   url=‘<new_host_url>’, default=1)

3. Restart the managed servers, WC_Spaces and WC_Collaboration.

Perform the following steps after migrating on-premises database to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database for Oracle Forms and Oracle Reports.

After the migration of your on-premises to an Oracle Autonomous Transaction Processing-Dedicated (ATP-D) database, restart all processes and servers, including the Administration Server and any Managed Servers.

See Starting and Stopping Administration and Managed Servers and Node Manager in Administering Oracle Fusion Middleware.