Oracle EDQ: A Step-by-Step Installation Guide on Linux with WebLogic Fusion Middleware and 19cRAC DB
*Disclaimer:* This video is created for educational and learning purposes only. It demonstrates the step-by-step installation of Oracle Enterprise Data Quality (EDQ) with WebLogic Fusion Middleware on Linux, integrating with an Oracle 19c RAC database.
All product names, logos, and brands are property of their respective owners. Oracle, WebLogic, and other Oracle product names are trademarks of Oracle and/or its affiliates. The use of these names, trademarks, and brands does not imply endorsement by Oracle Corporation.
This content is not affiliated with, endorsed by, sponsored by, or specifically approved by Oracle Corporation. The views and opinions expressed in this video are solely those of the creator and do not necessarily reflect the official policy or position of Oracle Corporation. While every effort has been made to ensure the accuracy of the information provided, the creator assumes no responsibility for errors or omissions, or for the results obtained from the use of this information. Viewers are encouraged to consult official Oracle documentation for definitive information.
Phase 1: Pre-Installation & System Preparation
System Requirements:
Verify that the Linux OS (e.g., Oracle Linux, RHEL) meets the minimum hardware and software requirements for Oracle EDQ, WebLogic, and Oracle 19c RAC.
This includes checking CPU, RAM, disk space, and necessary kernel parameters.
OS Configuration:
Create dedicated OS users and groups for both the Oracle Database (typically oracle and dba) and the Oracle Fusion Middleware components (e.g., weblogic).
Set appropriate resource limits (ulimit) in /etc/security/limits.conf to prevent "too many open files" errors.
Disable the firewall or open the necessary ports for WebLogic and the database.
Software Downloads:
Download the installation files for Java Development Kit (JDK) 8, Oracle Fusion Middleware Infrastructure (which includes WebLogic), Oracle EDQ, and the Oracle 19c RAC Database software from the Oracle Technology Network (OTN) or Oracle Software Delivery Cloud.
Phase 2: Database Setup (19c RAC) - Skip if you alreday have any DB
Install Oracle 19c RAC:
Follow this video-
• Oracle RAC 19C Database Step by Step Insta...
Install the Oracle Grid Infrastructure (GI) software on all nodes of the RAC cluster.
Run the database installer to install the Oracle Database 19c binaries on each node.
Use the Database Configuration Assistant (DBCA) to create a new Oracle 19c RAC database.
Run Repository Creation Utility (RCU):
Navigate to the RCU home directory within your Fusion Middleware installation.
Start RCU (./rcu) in graphical mode.
Create the necessary schemas for Oracle EDQ, which include the _EDQ_CONFIG and _EDQ_RESULTS schemas, in the newly created 19c RAC database. RCU will automatically select the required dependencies, like Oracle Platform Security Services (OPSS).
Phase 3: Middleware and EDQ Installation
Install Fusion Middleware Infrastructure:
#java -jar fusionmiddilwareinstaller
Use the downloaded WebLogic installer to install the Fusion Middleware Infrastructure.
This will set up the ORACLE_HOME for your middleware.
Install Oracle EDQ:
Run the Oracle EDQ installer.
#java -jar edqinstaller.jar
When prompted, install the EDQ software into the same ORACLE_HOME as your Fusion Middleware Infrastructure.
Domain Creation:
Launch the WebLogic Domain Configuration Wizard (config.sh).
Choose to create a new domain.
Select the Oracle EDQ template, along with any other required templates (e.g., Oracle JRF), which are typically selected automatically.
Configure the domain by specifying the domain location, administrator credentials, and the JDK to use.
Database Connection:
In the Configuration Wizard, provide the connection details for your Oracle 19c RAC database.
The wizard will prompt you to connect to the database and bind the schemas created by RCU.
Finalize Configuration:
Complete the wizard, which will create the domain directories and files.
After creation, you may need to perform additional post-installation tasks, such as creating a boot.properties file for the WebLogic Admin Server.
Phase 4: Post-Installation and Validation
Start Services:
Start the WebLogic Admin Server using the startWebLogic.sh script.
Access the WebLogic Administration Console to ensure the domain is running correctly.
EDQ Configuration:
Start the EDQ server. The EDQ application will deploy itself to the WebLogic instance.
Access the EDQ Launchpad (e.g., http://hostname:port/edq) and launch the Director application.
Log in using the credentials you defined during the domain creation.
Validation:
Perform a simple test in the EDQ Director, such as creating a new project or running a job, to confirm that all components—EDQ, WebLogic, and the 19c RAC database—are communicating properly.