Database Creation – Oracle Server

This page helps you with the prerequisites and the process to setup database in Oracle Server.

• Prerequisites for Database Creation
• There are two ways to setup database. Click any of the below link as per your preferred method:
  • AssistEdge Database Installer: AssistEdge Database Installer is a graphical tool that enables you to create database, and create objects in existing database.
  • Database Creation Scripts: Database Creation Scripts enables you to create database manually using Oracle scripts.

NOTE:

Before proceeding further, ensure that you have AssistEdge RPA compatible Oracle Server version installed on your system and along with that you have access privileges for the database creation.

 

Creating Database using AssistEdge Database Installer

This section describes the step by step instructions to create the database using AssistEdge Database Installer in the Oracle Server.

 

To create database in Oracle Server:

1. Navigate to $ > Database > Installer folder.

 

2. Find EV.AE.DatabaseDeployer.exe file and double click to launch AssistEdge Database Installer. The AssistEdge Database Installer dialog box appears.
    

 

3. In the Database Providers section, select Oracle.
3. In the Database Options section, you have three choices available. Click any of the below link to choose the preferred option based upon your requirement:

• Create New Database: Select this option, if you want to setup a new AssistEdge database in Oracle server.
• Create Objects in Existing Database: Select this option, only if oracle database administrator has already created a tablespace explicitly for AssistEdge database creation along with schema user credentials and database permissions.

Creating New Database

This section explains you about how to create a new database in Oracle Server.

 

NOTE:

Before proceeding, ensure that you have admin privileges to create a new database. The database name should be unique. For Oracle 12 C: while creating the database using Database Configuration Assistant> Creation Mode step> deselect Create as Container Database checkbox.

 

To create new database:

1. In the AssistEdge Database Installer dialog box:
   
   
   
   1. In the Database Providers section, select Oracle.
   2. In the Database Options  section, select Create New Database.
2. Click NEXT. The Oracle Server page appears as shown below.

 

 

3. In the SYS Admin UserName, enter database Username with SYS Admin privileges for a new user.

 

NOTE:

Enter the details of the database SYS Admin user. The database name should be unique.

 

4. In the SYS Admin Password, enter database Password with SYS Admin privileges to be used to access the database.
4. In the Server Name/IP Address, enter Server Name or IP Address of the Oracle server.
4. In the Port, enter Port number to connect to the database. The default port is 1521; if required, change the port.
4. In the Connection Method, select the preferred Connection method.
4. SID: Enter the instance name (SID) on which the user schema is to be created to connect the database.
4. Service Name: Enter Service Name on which the user schema is to be created to connect the database.
4. Click TEST CONNECTION to validate, if the connection to the specified Oracle server is established.
   
   

    

   • If the connection to the specified Oracle server is established then, a popup message appears as Test connection established successfully.
   • If the test connection to the specified Oracle server fails, check your entries, make any needed corrections, and try again.
   • Then, click OK. The pop-up message closes.

NOTE:

Do not proceed unless the test connection is successful.

 

11. Click NEXT to proceed. A New Database Details page appears as shown below.
    
    

 

This page enables you to create a new database user where details of the new tablespace are required to enter. These details exist in the Oracle server under the earlier specified service name.

12. In the Tablespace Name, enter the name of the new tablespace being created under the specified Service/SID.
12. In the User/Schema Name, enter User or Schema Name with DBA privileges on the schema.
12. In the Password, enter the Password of the mentioned user.
12. In the Confirm Password, re-enter the Password to confirm.
12. Click NEXT. Admin User Details page appears as shown below.
    
    

 

17. In the Admin User Details page, you can create a super admin user who will have Admin access to AE Site Admin module and client tools of AE RPA Module. There are two ways to create Admin user, you can choose any of the option as per your preference.
    Default: By default, you can select an existing user from the active directory and assign the user as Admin user. 
    • In Unique ID field, enter the active directory username and then click   Search . The details in this field are auto-filled. On selecting active directory username, a “Success Message” appears next to the search icon.
    • System auto fills the Display Name and Email ID details of the Admin user.
      
      

Manual:  Select Manual checkbox, if you can create super admin user manually. Enter the required details manually in the following fields.

• In the Unique ID field, enter a unique identifier for the AssistEdge Admin user.
• In the First Name field, enter the first name for the AssistEdge Admin user.
• In the Last Name  field, enter the last name for the AssistEdge Admin user.
• In the Display Name field, enter the name that you wish to display for the AssistEdge Admin user.
• In the Email ID field, enter a valid email ID of the AssistEdge Admin user.
  
  

18. Click INSTALL. The progress page appears that shows the database creation progress.
    
    
19. The Installation Completed page appears. Upon successful set-up of database, a success message as “Schema <name of the database> created successfully” appears. You can also check the logs and perform validation of database created before finishing the process:
    
    
    • Click VIEW LOGS to view the application log details. The log details contain information such as Log Time Stamp, UM Loader Constructor, dll, and so on.
      
      
    • Click VALIDATE to view the validation results after completion of the installation process.
      
      
      
      A popup window with Validation Results appears. Ensure that you get a success message for both listed items and close the dialog box.
20. Click FINISH to exit the application. 
    
    
    
    A popup window with DatabaseDetails.xml file appears. Click OK.
21. An export file is created at $\Database\Installer\Export\DatabaseDetails.xml in the installer’s folder.
    
    

 

The New Database - Oracle is created successfully and you can start utilizing database for AE RPA /Engage installation process.

 

Creating Objects in Existing Database

This section describes how to use an existing empty database already available in the Oracle server.

 

NOTE:

Before proceeding, ensure that the Oracle Database Administrator has created a tablespace explicitly for the AE database set-up. Also, ensure that you have credentials of schema user and also database administrator permissions. The database name should be unique.

 

To create objects in existing database:

1. In the AssistEdge Database Installer dialog box:
   
   
   1. In the Database Providers section, select Oracle.
   2. In the Database Options section, select Create Objects in Existing Database.
2. Click NEXT to proceed.
   
   

The Oracle Server page appears.

3. In the Server Name/IP Address field, enter name of the server or IP Address of the Oracle server.
3. In the Port field, enter port number to connect the database.
3. In the Connection Method section, select the preferred connection method. Possible values are:
   SID: Enter SID name to connect to the database. 
   Service Name: Enter Service Name used to connect to the database.
3. Click NEXT to proceed. The Database Details page appears.
   
   
7. In the User/Schema Name field, enter the name of the existing user or name of the existing schema created for the tablespace user.
7. In the Password field, enter the password created for the tablespace user.
7. Click TEST CONNECTION to validate if the connection to the specified Oracle server instance is established.
   
   
   • If the connection is established a popup message appears as “Test Connection Successful”.
   • If the connection fails, make sure you are entering the right credentials and try again.
   • Click OK. The pop-up message closes.
7.  Click NEXT. The Admin User Details page appears as shown below.
   
   
11. In the Admin User Details page, you can create a super admin user who will have Admin access to AE Site Admin module and client tools of AE RPA /Engage Module. There are two ways to create Admin user, you can choose any of the option as per your preference.
    Default: By default, you can select an existing user from the active directory and assign the user as Admin user. 
    11. In Unique ID field, enter the active directory username and then click  Search . The details in this field are auto-filled. On selecting active directory username, a “Success Message” appears next to the search icon.
    11. System auto fills the Display Name and Email ID details of the Admin user.
        
        

Manual:  Select Manual checkbox, if you can create super admin user manually. Enter the required details manually in the following fields.

• In the Unique ID field, enter a unique identifier for the AssistEdge Admin user.
• In the First Name field, enter the first name for the AssistEdge Admin user.
• In the Last Name field, enter the last name for the AssistEdge Admin user.
• In the Display Name field, enter the name that you wish to display for the AssistEdge Admin user.
• In the Email ID field, enter a valid email ID of the AssistEdge Admin user.
  
  
  

12. Click INSTALL to finish the database installation process. The progress page appears which shows the database installation progress.
    
    

13. The Installation Completed page appears. Upon successful set-up of database, a success message as “Schema ‘<name of the schema>’ updated successfully” appears. You can also check the logs and perform validation of database created before finishing the process:
    
    

 

Click VIEW LOGS to view the application log details. The log details contain information such as Log Time Stamp, UM Loader Constructor, dll, and so on.

 

Click VALIDATE to view the validation results after completion of the database creation process.

 

A popup window with Validation Results appears. Ensure that you get a success message for both listed items and close the dialog box.

14. Click FINISH to exit the application. 

 

A popup window with DatabaseDetails.xml file appears.

Click OK.

15. An export file is created at $\Database\Installer\Export\DatabaseDetails.xml in the installer’s folder.
    
    

The objects for AE RPA database are successfully created in the selected database.