PD AWS Oracle for WHMCS

PD AWS Oracle lets a hosting company sell managed Oracle databases as its own product. Your customer orders in your WHMCS cart, a dedicated Oracle Standard Edition 2 instance is built on Amazon RDS in your AWS account, and your customer manages it from your client area: connection details, usage graphs, snapshots and a firewall, with no AWS console and no AWS login. The Oracle licence is included in the AWS price, so there is no separate licence to buy. You set the price, AWS bills you its cost, and the difference is your margin.

It is built for hosts whose customers run Oracle-based business software and need a database they can order like any other service, without an Oracle DBA on your payroll or a database server to look after.

Why hosts choose PD AWS Oracle

No Oracle licence to buy. Every order is Oracle Standard Edition 2 on the License-Included model. Enterprise Edition and bring-your-own-licence are not offered, which keeps every product you sell on one simple, predictable cost line.

Four sizes, priced by you. One click generates the four documented plans: db.t3.small and db.t3.medium for light workloads, db.m5.large and db.m5.xlarge for more, together with a storage choice that starts at 20 GB. Every option starts at no extra charge and you set the prices.

Built for the wait. An Oracle instance takes about 15 to 25 minutes to build, which is normal for the engine. The customer's page says it is being set up and fills in with the connection details on its own once AWS reports the database ready, so nobody needs to refresh or ask.

Encrypted at rest. Database storage is encrypted at rest. Connections use Oracle's standard port 1521, and the firewall decides who can reach it.

Any region AWS runs Oracle SE2 in. The Region list shows every AWS region, so check that Oracle SE2 is offered in the region you choose before you sell it there.

Every customer is isolated. Each order gets its own instance, master credentials and firewall group. Nothing is shared, even with another installation using the same AWS account, and the module refuses to take over a database it did not create.

Changes made safely. A snapshot is taken before a plan or storage change is applied, so a restore point exists. Storage is only ever grown, online.

How it works

1. Connect your AWS account. Add an access key once on a WHMCS server record. The secret is stored encrypted and never reaches a customer page. Test Connection makes one read-only call and creates nothing.
2. Create your product. Add a WHMCS product, choose the module on its Module Settings tab and switch on automatic setup. Set region, plan and storage, then press Generate plans to offer the sizes at checkout.
3. Your customer orders. The instance is built in the region they chose. The customer's page keeps them informed until the database is ready.
4. You get paid, they manage it. WHMCS keeps billing as usual. Suspend, unsuspend and terminate follow your normal billing.

What you get in WHMCS

Selling and pricing

• Cart options generated for you: region, plan, storage, high availability and public access, linked to the product
• Prices set by you under WHMCS's Configurable Options
• A "High availability (Multi-AZ)" choice that gives the customer a standby in a second zone
• A public-access choice; left off, the database is reachable only inside the AWS network
• Sync with AWS hides options AWS has retired and adds new ones, without touching prices or existing customers
• Billing stays yours: the service is charged at the prices of the product and its options, and nothing is metered into WHMCS

Provisioning you can trust

• A paid order provisions with no admin step once automatic setup is on
• Plan upgrades resize the instance in place and keep its data
• A change that cannot be applied in place is reported to you as not applied
• Failed setups are recorded with the real reason for you, and running setup twice never creates a second instance
• Suspend stops the database and keeps it stopped, even though AWS restarts stopped databases after seven days
• Terminating deletes the instance with its backups, snapshots and firewall group straight away; a host who wants a copy keeps one in the AWS console first

Running it day to day

• Clients & Databases lists every database with its service, plan, region, endpoint and live state
• An activity log of provisioning, resizes, snapshots and password resets across every service
• A report that checks your licence, the AWS SDK and how many credential sets and databases you have
• Read-only assistant tools that report a service's database state and recent provisioning activity, with no way to create, resize, delete or restore anything

What your customers get

• Connection details with one-click copy: host, port 1521, SID ORCL and user pdmaster, with a ready-to-paste sqlplus command and the password masked until revealed
• Start, stop and reboot, and a stopped database keeps its data
• Password reset with the rules stated on the form (8 to 30 characters), and a weak password refused before anything is queued
• A firewall of allowed IPv4 addresses and ranges for port 1521, applied on the next scheduled run
• Usage graphs for CPU, connections, freeable memory and free storage over the last 24 hours, from AWS's own metrics
• Snapshots they take and delete themselves, with the automated daily backups, kept seven days, listed beside them
• Activity in plain words, with the time and outcome of each action

Snapshots, Firewall, Connection details and Usage graphs are each a switch on the product. Turn one off and it disappears from the customer's page, and the request is refused however it is made. The pages render natively on WHMCS's Six, Twenty-One and Nexus themes, and every word can be translated or reworded with override files that survive updates. Customers see only your brand.

Security built in

• Your AWS keys live on the WHMCS server record, stored encrypted, and never appear on a customer page, in a message or in a log.
• Database passwords are stored encrypted on the service, including one the customer sets with Reset password.
• Only port 1521 is opened, and only to the addresses the customer lists.
• Customer data goes only to your own AWS account. We receive licence, module and version information, nothing else.
• Restores stay with you: customers take and delete snapshots, and you restore from the AWS console when asked.

One product, every feature

PD AWS Oracle is one paid module with everything included, bought on its own as an add-on to your PD Modules licence. There are no tiers and no per-database fee from us: you pay AWS at cost, licence included, and keep the margin. Oracle costs more to run than MySQL or MariaDB, so price accordingly. Each order creates a real, billable AWS resource, so there is no free trial.

If your subscription ever lapses, customers' databases are never touched or deleted. You get a 14-day grace period with everything working and a renewal reminder, then admin management locks while customers keep being served, and only after that do customer features pause behind a neutral "temporarily unavailable, please contact support" message. Renewing restores everything at once.

Requirements

• WHMCS 9 or later on PHP 8.2 or later, with the ionCube Loader
• An AWS account and an access key with the Amazon RDS permissions we list, plus the security group permissions every order needs
• PD Modules, the free control panel every PD module installs into