6.4.1 Execute the Schema Creator Utility in Offline Mode
In the Offline mode, the 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.
- SELECT ON DBA_ROLES
- SELECT ON DBA_USERS
- SELECT ON DBA_DIRECTORIES
- SELECT ON DBA_TABLESPACES
- CREATE SESSION
Note:
Explicit Grants to the user are required. Grants assigned through Roles are not supported.- Log in to the system as a non-root user.
- Navigate to the following path:
OFS_HM_PACK/schema_creator/bin
. - Execute the
osc.sh
file using the following command:
The following message is displayed:./osc.sh -s -o
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).
- Enter
Y
to proceed. - Enter the DB Username with SELECT privileges.
- Enter the User Password.
- 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).
- 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).
On successful execution of the schema creator utility, the console displays the following status message:
Schema Creator executed successfully. Please execute
scratch/ofsaaapp/OFS_HM_PACK/schema_creator/sysdba_output_scripts.sql
before proceeding with the installation.Note:
If there are any errors during the SQL script execution, reconfigure theOFS_HM_SCHEMA_IN.xml
, and repeat steps in this procedure to execute the utility. This regenerates the scripts with the correct information. - Navigate to the
OFS_HM_PACK/schema_creator
directory. - Log in to SQLPLUS as a user having SYSDBA Privileges.
- 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 thesysdba_output_scripts.sql
file, after providing appropriate execute permissions. - Make a TNS entry for the new users created. For details, see Add
the TNS entries in TNSNAMES.ORA file section.
Note:
See thesysdba_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.As a result of this task, the
OFS_HM_SCHEMA_OUTPUT.XML
file is generated. Do not modify this file.After creating the schema, proceed to Configure the OFSAAI_InstallConfig.xml File section.