Suraj RameshProsurajramesh.com·Jul 3, 2024Automating Database Role Transitions in a Manual Data Guard with OCI Full Stack DRIntroduction When you create any of the supported DR plans using OCI Full Stack DR, OCI Full Stack DR provides built-in modules for the Oracle Database PaaS listed below, as long as Data Guard was set up using the Cloud automation available from thos...Discuss·222 readsOCI Full Stack DROracle
Bruno Cardosocardoso.hashnode.dev·Jun 10, 2024APEX Tip: Standardize and Simplify REST Calls Using Substitution StringsIntroduction I decided to write this article because it's not uncommon to see code with excessive boilerplate, which can become a headache every time a parameter needs to be changed. This article aims to introduce you to Substitution Strings and demo...Discuss·3 likes·323 readsOracle
Tomas Kucharzykkuchatom.hashnode.dev·May 27, 2024Exploring Oracle Database 23ai: A First Look at JSON-Relational Duality ViewsOne of the new features in Oracle Database 23ai is JSON-Relational Duality Views that will allow you to use JSON representation of your relational model. You can create hierarchical JSON documents and use it to modify data in tables and many more. If...Discussduality views
Suraj RameshProsurajramesh.com·May 23, 2024How to Install Oracle Database 23ai Free Container Image on MacBook Pro***TLDR:***Oracle Database 23ai, rebranded from 23c, introduces over 300 new features focused on AI, development, and mission-critical data. This guide explains how to install and connect to Oracle Database 23ai using a free container image on a MacB...Discuss·300 readsOracle Database 23aiOracle 23ai
Richmondmachiavelli.hashnode.dev·May 9, 2024Securing SaaS Data with Oracle VPD A Comprehensive OverviewIn the realm of Software as a Service (SaaS), where businesses entrust their critical data to cloud-based applications, security is paramount. As organizations increasingly adopt cloud solutions for their operations, ensuring the confidentiality, int...Discuss·1 like·73 reads#oracle-apex
Heuristic Informaticsenterprisedigitaltransformation.hashnode.dev·Apr 8, 2024Simplifying Database Management with Oracle Exadata Cloud ServicePerformance, dependability, and efficiency are critical for data management. Oracle, a top supplier of database systems, has completely changed the market with its Exadata Cloud Service. Using advanced technology, Exadata Cloud Service simplifies dat...DiscussOracle Cloud
Ryan Williamsora-wtf.com·Mar 29, 2024Oracle Database 23ai + Oracle Apex with Docker ComposeOracle's latest long-term release now has a developer-focused version available. Hopefully, our pleads for simplicity for the new setup are starting to show. Note: The ORDS docker image is using ORDS 24.1 but with Apex 23.2. You can build your own im...Discuss·57 reads#oracle-db-23ai
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 7, 2024Enable Archive LogConnect as DBA. [oracle@orcl ~]$ sql / as sysdba Disconnect all users. Shutdown and startup mount (!Caution). SQL> SHTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT ORACLE instance star...Discuss·36 readsArchive LogArchive Log
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 6, 2024Disable Archive LogCheck Status and Parameters. Shutdown and startup mount (!Caution). [oracle@orcl ~]$ sqlplus / as sysdba SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. ...DiscussArchive LogArchive Log
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 5, 2024Basic ADRCI CommandsGet and Set ADR_BASE location. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:08:45 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show bas...DiscussAutomatic Diagnostic Repository (ADR)adrci