9 Reinstall FCC Studio

If the installation of FCC Studio is unsuccessful, you must reinstall the application after performing the required cleanup tasks.

To reinstall FCC Studio, follow these steps:

1. Navigate to the <Studio_Installation_Path>/bin directory.

2. Create a backup for the existing config.sh file.

3. Delete the <Studio_Installation_Path> directory.

4. Download and extract the FCC Studio installer archive file. For more information, see Download the Installer Kit.

5. Perform the database cleanup for the following schemas:

Table 17: Required File Structure

Schema	Applicable for FCC Studio with OFSAA	Applicable for FCC Studio without OFSAA
Clean up for Studio Schema	Yes	Yes
Cleanup for BD or ECM Atomic Schema	Yes	No
Cleanup for BD or ECM Config Schema	Yes	No

6. Reinstall FCC Studio.

Topics:

Clean up for Studio Schema

To clean up the Studio schema, follow these steps:

1. Drop the existing Studio schema and create a new Studio schema.

NOTE	The username and password credentials of the Studio Schema in the wallet files must be updated accordingly. (If applicable)

2. Grant the following permissions to the newly created Oracle Database Schema:

§ GRANT create session TO <Schema User>;

§ GRANT create table TO <Schema User>;

§ GRANT create view TO <Schema User>;

§ GRANT create any trigger TO <Schema User>;

§ GRANT create any procedure TO <Schema User>;

§ GRANT create sequence TO <Schema User>;

§ GRANT execute on dbms_rls TO <Schema User>;

§ GRANT execute on sys.dbms_session TO <Schema User>;

§ ALTER USER <Schema User> QUOTA 100M ON users;

§ GRANT create sequence TO <Schema User>;

§ GRANT create SYNONYM TO <Schema User>;

§ GRANT ALL privileges TO <Studio Schema User>;

NOTE	If dropping the schema is not an option, drop the tables and sequences as mentioned in the Appendix A - Tables and Sequences section.

To clean up the BD or ECM Atomic schema, follow these steps:

1. Login to the BD or ECM Atomic Schema.

2. Truncate the DATABASECHANGELOG and DATABASECHANGELOGLOCK tables using the following command:

TRUNCATE TABLE DATABASECHANGELOGLOCK;

TRUNCATE TABLE DATABASECHANGELOG;

To clean up the BD or ECM Config schema, follow these steps:

1. Login to the BD or ECM Config Schema.

2. Truncate the DATABASECHANGELOG and DATABASECHANGELOGLOCK tables using the following command:

TRUNCATE TABLE DATABASECHANGELOGLOCK;

TRUNCATE TABLE DATABASECHANGELOG;