Creating non-cdb database in OCI exacs using dbaasapi


Oracle's Exadata Cloud Service (ExaCS) in Oracle Cloud Infrastructure (OCI) has undergone changes in database version support, specifically for older versions like Oracle Database 11g, 12c and 19c non-container database. These versions are no longer visible or available for provisioning new databases in the OCI console for Exadata Cloud Service.

In Oracle Database 19c, CDB (Container Database) architecture is the default and recommended configuration. However, Oracle still allows creating non-CDB 19c databases under certain conditions for backwards compatibility, though this is not recommended.

Since Oracle recommends transitioning to CDB, and non-CDB architecture is officially desupported starting with Oracle 21c, if you still need to create a non-CDB in Oracle 19c on Exadata Cloud Service (ExaCS), you can follow these steps manually.

Oracle does not recommend creating non-CDBs for any new applications. If you need to use a non-CDB, you may need to do so through manual steps as below.

Make sure the oracle 19c binaries is installed on server, in our example we have 19.24 installed on the server already, so we will be using the same binaries and creating non-cdb database.


Create a json file as below, you can see we are explicitly saying no to cdb.


[oracle@exadevdb working]$ cat /home/oracle/working/create_non_cdb.json
{
"object": "db",
"action": "start",
"operation": "createdb",
"params": {
"nodelist": "",
"cdb": "no",
"bp": "JUL2024",
"dbname": "MYPOC",
"edition": "EE_EP",
"version": "19.24.0.0.0",
"adminPassword": "**********",
"charset": "AL32UTF8",
"ncharset": "AL16UTF16",
"backupDestination": "NONE"
},
"outputfile": "/home/oracle/working/createnoncdb.out",
"FLAGS": ""
}

Now, switch to opc user and run the dbaasapi command as below with the json input file "create_non_cdb.json""


[opc@exadevdb working]$ sudo dbaasapi -i /home/oracle/working/create_non_cdb.json

[opc@exadevdb working]$ cat createnoncdb.out

{
"object" : "db",
"recovery" : "",
"status" : "Starting",
"workflow_id" : "",
"dbname" : "",
"outputfile" : "/home/oracle/working/createnoncdb.out",
"workflow_enabled" : "0",
"pid" : "",
"id" : "9b61bfc5-b960-46ab-8e8f-93161cdd4a21",
"operation" : "createdb",
"logfile" : "/var/opt/oracle/log/MYPOC/dbaasapi/db/createdb/9b61bfc5-b960-46ab-8e8f-93161cdd4a21.log",
"msg" : "For security please remove your input file.",
"exceptionErrorCodes" : "",
"ts" : "20240826 18:01:31",
"progress" : "0",
"errmsg" : "",
"infofile_content" : "",
"perl_proxy_pid" : "",
"dgObserverResponseDetails" : "",
"host" : "",
"jobSpecificDetailsJson" : "",
"resourceId" : "",
"action" : "start",
"creation" : "",
"start" : ""
}


And now you can see the non-container database is created successfully.


SQL> show pdbs;
SQL>
SQL> select name,dbid,con_dbid,cdb,con_id from gv$database;

NAME DBID CON_DBID CDB CON_ID
--------- ---------- ---------- --- ----------
MYPOC 1539656098 1539656098 NO 0
MYPOC 1539656098 1539656098 NO 0

SQL>

Comments

Post a Comment

Popular posts from this blog

Multi-Domain Support in OCI Load Balancer: Host-Based Routing Explained

Image
Managing multiple environments, like development, testing, and staging, can often lead to unnecessary complexity and infrastructure sprawl. By utilizing a single OCI Load Balancer to manage multiple domains (e.g., dev.example.com, test.example.com), businesses can significantly reduce the need for separate load balancers or compute instances. This consolidation translates into lower infrastructure costs, simplified SSL certificate management, and easier ongoing maintenance. At Eclipsys Solutions, we help organizations design and implement scalable, secure, and cost-effective OCI architectures. Our experience in OCI Load Balancer configurations, multi-domain routing, and best practices in backend optimization allows clients to realize faster time-to-value while maintaining operational excellence.   In this guide, we’ll walk through how you can configure an OCI Load Balancer to route traffic based on the domain name, allowing multiple DNS records (e.g., dev.example.com, test.exa...
Read more

Zero-Click Cert Rotation on Oracle Cloud: CertifyTheWeb + OpenSSL + OCI CLI

Image
Certificates expire, weekends don’t. This post shows how we eliminated manual renewals by scripting the entire path— CertifyTheWeb → OpenSSL → OCI CLI —including temporary Port 80 open/close , issuer auto-detect (R10–R13) , PFX export , and a clean push to OCI Certificates . The result: fewer outages, faster audits, and a repeatable pipeline your ops team can trust. Goal: Fully automate Let's Encrypt renewals on Windows and update OCI Certificates programmatically. Pattern: CertifyTheWeb renews → OpenSSL extracts keys/chain → OCI CLI updates the certificate resource. Security: Temporarily open Port 80 only for ACME HTTP-01, then auto-close. Outcome: Zero-click rotation, audit-friendly logs, and consistent results. Architecture at a Glance Please find the attached script here. https://drive.google.com/file/d/1ojvDTS3zemaxuEAv8by7R-r4ruDgfSma/view?usp=drive_link Flow 1. CertifyTheWeb renews via ACME HTTP-01. 2. Script opens Port 80 on the OCI Security List (short window). 3. Export n...
Read more

OCI Migration Case Study: Seamlessly Moving Oracle EBS 11i and 11g Database to the Cloud

Image
  Introduction Many legacy enterprise systems still operate on aging infrastructure and unsupported platforms. In this scenario, the production Oracle E-Business Suite (EBS) 11.5.10.2 and Oracle Database 11.2.0.4 Enterprise Edition are hosted together on a single physical on-premises server running Oracle Linux 5.11 (64-bit). While this setup has supported critical business operations, it presents challenges such as hardware limitations, lack of vendor support, and upgrade constraints. As a first step toward modernization, the entire environment is being migrated “as-is” to Oracle Cloud Infrastructure (OCI), using a custom Oracle Compute VM with Oracle Linux 5.11. This approach enables a seamless lift-and-shift migration with minimal downtime and no immediate application changes. ⚠️ Important to note: Although Oracle Linux 5.11 is out of support, moving to OCI provides the customer with flexibility and safety to later upgrade the OS and application stack at their own pace. We stron...
Read more