Execute the Schema Creator Utility in Offline Mode

Execute the Schema Creator utility in the offline mode.

In the Offline mode, the schema creator utility generates an SQL script with all the required DDLs for Users, Objects, and Grants. This script must be executed by the DBA on the appropriate database identified for OFSAA usage. If you do not have the SYSDBA privileges, you can execute the Schema Creator Utility in Offline mode and generate the script file that contains the Schemas, Objects, and Grants information. Subsequently, an SYSDBA user can execute the script file manually. To run the OFSAA Application Pack installer in Silent mode, it is mandatory to execute the schema creator utility with -s option.

To execute the utility in Offline mode, you must be a database user with the following GRANTS (alternatively, you can also connect as a user with SYSDBA privileges):

  • SELECT ON DBA_ROLES
  • SELECT ON DBA_USERS
  • SELECT ON DBA_DIRECTORIES
  • SELECT ON DBA_TABLESPACES
  • CREATE SESSION

Note:

Explicit Grants to the users are required. Grants assigned through Roles are not supported.

To execute the schema creator utility in the offline mode:

  1. Log in to the system as a non-root user.
  2. Navigate to the path: OFS_<APP_PACK>_PACK/schema_creator/bin
  3. Execute the osc.sh file using the command: ./osc.sh -s -o
    The following message is displayed:
    You have chosen OFFLINE mode. Triggering the utility in OFFLINE mode will generate the script. Do you wish to proceed? (Y/y or N/n).
  4. Enter Y to proceed.
  5. Enter the DB Username with SELECT privileges.
  6. Enter the User Password.

    Figure 7-3 Schema Creation in Offline Mode


    Schema Creation in Offline Mode

  7. The console runs the initial validation checks and displays the following message:
    You have chosen to install this Application Pack on <Name of the Atomic Schema> ATOMIC schema. Do you want to proceed? (Y or N).

    Figure 7-4 Schema Creation in Offline Mode Script Generation


    Schema Creation in Offline Mode Script Generation

  8. Enter Y to start the script generation. The following message is displayed:
    You have chosen to install this Application Pack on <Name of the Infodom>. Do you want to proceed? (Y or N).

    Figure 7-5 Schema Creation in Offline Mode Successful


    Schema Creation in Offline Mode Successful

    On successful execution of the schema creator utility, the console displays the following status message:

    Schema Creator executed successfully. Please execute scratch/ofsaaapp/OFS_LRS_PACK/schema_creator/sysdba_output_scripts.sql before proceeding with the installation.

    Additionally, if you have configured the <<APP PACK>>_SCHEMA_BIGDATA_ IN.xml file, a file called hive_output_scripts.hql is also created in the /scratch/ofsaaapp/OFS_AAAI_PACK/schema_creator directory.

    Note:

    If there are any errors during the SQL script execution, reconfigure the <PACK>_SCHEMA_IN.xml and/or <APP_PACK>_SCHEMA_ BIGDATA_IN.xml files and repeat steps in this procedure to execute the utility. This regenerates the scripts with the correct information.

    Note:

    If there are any errors during the SQL script execution, reconfigure the OFS_LRS_SCHEMA_IN.xml, and repeat steps in this procedure to execute the utility. This regenerates the scripts with the correct information.
  9. Navigate to the OFS_AAAI_PACK/schema_creator OFS_LRS_PACK/schema_creator directory.
  10. Log in to SQLPLUS as a user having SYSDBA Privileges.

    Figure 7-6 Schema Creation in Offline Mode – Execute sysdba_output_scripts.sql


    Schema Creation in Offline Mode – Execute sysdba_output_scripts.sql

  11. Execute the sysdba_output_scripts.sql file using the following command:
    SQL>@sysdba_output_scripts.sql

    Alternatively, you can copy the sysdba_output_scripts.sql file and SQLScripts directory to a remote server and execute the sysdba_output_scripts.sql file, after providing appropriate execute permissions.

  12. Make a TNS entry for the new users created. For details, see unresolvable-reference.html#GUID-41D9A9B0-501B-43DE-9BF6-BD51CBD8FA70.

    Note:

    See the sysdba_output_scripts.log file for execution status. If there are any errors, contact My Oracle Support. If there are no errors in the execution, the log file is empty.

The result of this task is that the <PACK> _SCHEMA_OUT.XML file is generated. Do not modify this file.

As a result of this task the OFS_LRS_SCHEMA_OUTPUT.XML file is generated. Do not modify this file.

After creating the schema, proceed to Configure the OFSAAI_InstallConfig.xml File section.