Creating an Oracle 23c Database in OCI
Anil Mahadev
Oracle ACE PRO ♠ |Senior Solutions Architect @ IDERA Software | Database and Cloud Family of Tools | Aspiring Product Management Leader | Multi-Cloud Architect - AWS, Azure and OCI
Follow these steps and screenshots that follow:
[Note this sample DB will be deleted upon publication of this article]
Sign in to Oracle Cloud Console: Go to the Oracle Cloud Console and sign in with your credentials.
Navigate to Database Service: Once logged in, navigate to the "Database" service. You can usually find this under the "Database" section in the main menu.
Choose the Appropriate Compartment: Ensure you're working within the correct compartment or create a new one if necessary.
Create Database: Click on "Create Autonomous Database".
Choose Database Version: In the creation wizard, select the Oracle Database version. At the time of my last update, it would be Oracle 23c.
Configure Database: Provide necessary configurations such as the database name, workload type (OLTP, DSS, or Auto-Scaling), and the amount of CPU and storage you need.
Set Administrator Credentials: Specify the username and password for the administrator account of your database.
Configure Networking: Choose your network configuration, including subnet, access control list (ACL), and Virtual Cloud Network (VCN).
Choose Backup and Recovery Options: Select your backup and recovery preferences. Oracle Cloud typically offers automated backups and point-in-time recovery options.
Review and Create: Review all the configurations you've made and then proceed to create the database service.
Wait for Deployment: Depending on the options selected and the current load on Oracle Cloud, deployment may take some time. You can monitor the progress within the Oracle Cloud Console.
Access Your Database: Once the database service is deployed successfully, you can access it using the provided connection details such as hostname, port, and service name.
[Screenshots]
Upon completion, you should be able connect to the server by using the credentials we created and add it to our tnsnames.ora file locally.
Now you will have to add the 1521 port to your Security List in order to allow connections between the VCN.
Congratulations. You have successfully created an Oracle 23c Database in OCI