AWS Oracle
SleakOps facilitates the integration of Oracle databases through Amazon RDS (Relational Database Service). Amazon RDS for Oracle is a fully managed service that simplifies database setup, operation, and scaling. By leveraging SleakOps for this integration, you can efficiently manage Oracle databases within your EKS (Elastic Kubernetes Service) environment, ensuring robust, scalable, and reliable data storage solutions for your applications.
FAQs
License
When creating an Oracle DB using Sleakops License Included (LI). Currently Bring Your Own License (BYOL) is not supported, however, contact support for more information.
How does SleakOps manage Oracle credentials?
When you create an Oracle dependency in SleakOps, it automatically generates a Vargroup for your database. This Variable Group securely stores the Oracle credentials and other important configuration details, such as the database endpoint and user access information. You'll be able of manage them from Vargroups section.
What is Multi-AZ deployment and should I enable it?
Multi-AZ (Availability Zone) deployment ensures high availability and failover support by replicating your database in another availability zone. It's recommended for production environments to prevent downtime. Keep in mind that it increases costs.
Can I change the Oracle version after the database is deployed?
No, the database engine version cannot be changed after deployment. You would need to create a new Oracle instance with the desired version and migrate your data. Or change it manually into the AWS Console.
What happens if I need more storage for my Oracle database?
You can adjust the storage size when configuring your database. If you need more storage after deployment, you can scale modifying the settings in AWS as at the moment SleakOps does not support it.
How do I create a Oracle database dump?
The client is only available for x86-64 Linux distributions.
Follow this link to install the client
To create a dump of your Oracle database, use the following command:
exp ${ORACLE_USERNAME}/${ORACLE_PASSWORD}@${ORACLE_ENDPOINT}/${ORACLE_NAME} FILE=exp_file.dmp LOG=exp_file.log
Replace ORACLE_USERNAME, ORACLE_ENDPOINT, ORACLE_NAME and ORACLE_PASSWORD with the appropriate values.
For additional information on creating an Oracle dump, refer to the official Oracle documentation .
Another option is creating it directly from the AWS Console and then import it. See Restoring to a DB instance.
How do I import an existent dump ?
The client is only available for x86-64 Linux distributions.
Follow this link to install the client
You can use a Oracle client installed on your local machine to import the dump.
imp ${ORACLE_USERNAME}/${ORACLE_PASSWORD}@${ORACLE_ENDPOINT}/${ORACLE_NAME} FROMUSER=cust_schema TOUSER=cust_schema FILE=exp_file.dmp LOG=imp_file.log
Replace ORACLE_USERNAME, ORACLE_ENDPOINT, ORACLE_NAME and ORACLE_PASSWORD with the appropriate values.
For additional information on importing an Oracle dump, refer to the official Oracle documentation .
Another option is creating it directly from the AWS Console and then import it. See Restoring to a DB instance.
What should I do if I encounter connection issues with my Oracle database?
- Ensure the database endpoint, username, and password are correct.
- Verify that your security groups and firewall rules allow access.
- Ensure the database is running and has enough resources (CPU, memory). Otherwise, contact us.
AWS documentation: Amazon RDS Oracle Documentation
Set up your Oracle
1. Add Oracle as a Dependency
To integrate Oracle with SleakOps:
- In the SleakOps console, go to the "Dependencies" section
- Choose "Oracle" from the list of available dependency types. For more detail see Dependencies: Integrating Databases, Caching, and Messaging Services.
2. Set up your Oracle.
You will access the following form:
Here the parameters that SleakOps allows you to customize during the creation:
| Attribute | Description |
|---|---|
| Database Engine Version | Select the specific version of the Oracle database engine you wish to use. This ensures compatibility with your application requirements. Example: 19.0.0.0.ru-2024-01.rur-2024-01.r1 |
| Database Instance Class | Define the instance class that specifies the hardware configuration for your Oracle database. This controls CPU, memory, and network performance. Example: db.m6g.large, db.t3.medium. See AWS detail. |
| Database Storage | Specify the amount of storage allocated for the database. Example: 100 GB, 500 GB. |
| Username | Provide the master username for the Oracle database. This is the main user with administrative privileges. Example: admin, root. |
| Password | Password for the master user to access the database. |
| Multi-Availability Zone | Enable or disable Multi-AZ deployment. This ensures high availability and failover support by replicating the database across multiple availability zones. Recommended for production environments. |
| Automated Backup | Configure automated backups for the Oracle database. This ensures data protection by enabling daily snapshots and transaction log backups. Set up the Backup Retention Period and the Backup Window. Recommended for production environments. |
| Backup Retention Period | Set the number of days to retain automated backups. |
| Backup Window | Period of time while the backup will be done. |
3. Customize your variable's name for your Oracle data base.
As explained, when a dependency is created, SleakOps generates a vargroup to hold all the needed attributes. In this step you can change the name of the attributes in case it is needed. SleakOps completes the values automatically. After this step, your dependency is created.
