4 Import Data

This topic describes the process of importing data for installation.

1. Start Oracle FLEXCUBE Universal Installer.
   The Oracle FLEXCUBE Universal Installer is displayed.

   Figure 4-1 Oracle FLEXCUBE Universal Installer

   
   

   
   Description of "Figure 4-1 Oracle FLEXCUBE Universal Installer"

   
   
2. On Oracle FLEXCUBE Universal Installer screen, enter the following details.
   Refer to the table for JDK and Oracle Home path.

   Table 4-1 JDK and Oracle Home path

   Field	Description
   JDK Path	Provide Home folder path of JDK1.8.
   Oracle Home	Provide home folder path of Oracle Client or Database.
   Application Server Home	Provide home folder path of Application Server.
   Application Server Location	Select location of the application server either local or remote.

3. Click Next to select the option for installation.
4. Select Oracle FLEXCUBE Investor Servicing from the lists of Oracle FLEXCUBE options.
   The available options for installation are displayed.

   Figure 4-2 Option for Installation

   
   

   
   Description of "Figure 4-2 Option for Installation"

   
   
5. Click Next to choose Oracle FLEXCUBE component for installation.
6. Choose Database.

   Figure 4-3 Choose Database

   
   

   
   Description of "Figure 4-3 Choose Database"

   
   
7. Choose installation option from the Installation Type.
   The Oracle FLEXCUBE Universal Installer supports Custom Installation of Oracle FLEXCUBE in two methods.
   • Compile objects.
   • Load data.
8. Select Import Data under Custom Installation and click Next.
   The following screen is displayed.

   Figure 4-4 Custom Installation_Load Data_Import Data

   
   

   
   Description of "Figure 4-4 Custom Installation_Load Data_Import Data"

   
   
9. Specify schema details.
   Refer to the table for Schema details.

   Table 4-2 Schema details

   Field	Description
   User Name	Specify the user name to access the schema.
   Password	Enter the schema password.
   Service Name	Provide service name of Database.
   TNS Connect Descriptor	Specify a valid connect string that contains the details for database connectivity.
   IP Address	Specify the IP address of the system where the database schema is installed.
   Port	Specify the port number.

   Figure 4-5 Schema Details

   
   

   
   Description of "Figure 4-5 Schema Details"

   
   
10. 9. Click Test Connection to test the connection with the Application server.
    If the connection is established, the installer displays the message Connection Successful.

    Figure 4-6 Information Message on Successful Connection

    
    

    
    Description of "Figure 4-6 Information Message on Successful Connection"

    
    
11. Click Next after testing the connection successfully.
    This screen displays the parameter details of the database. This is for information purpose and you cannot modify the parameters from this screen.

    Figure 4-7 Parameter Table

    
    

    
    Description of "Figure 4-7 Parameter Table"

    
    
12. Click Next.
    If object compilation is required and the privilege is not given, then you can find that out from this screen.
    The screen displays the grants provided to the schema. This is for information purpose only.

    Figure 4-8 Grant Previlege Details

    
    

    
    Description of "Figure 4-8 Grant Previlege Details"

    
    
13. Click Next to include PAR File.

    Figure 4-9 Include PAR File

    
    

    
    Description of "Figure 4-9 Include PAR File"

    
    
14. Specify the PAR File details.
    Refer to the PAR File details table.

    Table 4-3 PAR File Details

    Field	Description
    Include PAR File	Check this box to include the PAR file. If you check this box, you need to specify the PAR file name. PAR file stands for Parameter File. A PAR file is a text file that contains all valid parameters and their respective values. Maintaining the parameters in text format enables you to modify or reuse them easily.
    PAR File Name	Specify the PAR file name if you have checked the box Include PAR File.

15. Specify the Oracle directory name. Ensure that the Oracle Directory Name mentioned is created in the server.
    This is the directory in the server machine where the import file is located.

    Figure 4-10 Oracle Directory Name

    
    

    
    Description of "Figure 4-10 Oracle Directory Name"

    
    
16. Click Next after you have specified the Oracle directory details.
    The following screen is displayed.

    Figure 4-11 Export Schema Name and Tablespace

    
    

    
    Description of "Figure 4-11 Export Schema Name and Tablespace"

    
    
17. For Export Data Dump Parameters, specify the following details.
    Refer to the table of Export Data Dump Parameters.

    Table 4-4 Export Data Dump Parameters

    Field	Description
    Dump File Name	Specify the import file name.
    Export Schema Name	Specify the export schema name from which the import file is imported.
    Export Schema Tablespace	Specify the export schema tablespace from which the import file is imported.

18. Click Next after you have specified the above details.
    The following screen is displayed.

    Figure 4-12 Import Schema Name and Tablespace

    
    

    
    Description of "Figure 4-12 Import Schema Name and Tablespace"

    
    
19. For Import Data Dump Parameters, specify the following details.
    Refer to the table of Import Data Dump Parameters.

    Table 4-5 Import Data Dump Parameters

    Field	Description
    Import Schema Name	Specify the import schema name to which the import file is loaded.
    Import Schema Tablespace	Specify the import schema tablespace to which the import file is loaded.

20. Click Next and you can view the status of data imported.
    The following screen is displayed.

    Figure 4-13 Status of Data imported

    
    

    
    Description of "Figure 4-13 Status of Data imported"

    
    
21. You can optionally import the objects, data or full set by using Import Objects, Import Data or Full Import buttons respectively.
    This triggers the import operation.