If you are getting below error while launching ORDS, follow steps mentioned to resolve the error: “ORDS was unable to make a connection to the database. The database user specified by db.username configuration setting is expired. The connection pool named: |default|lo| had the following error(s): ORA-28001: the password has expired” Solution: This error occurs when […]
ORDS Part-4: How to create Restful ORDS API for ATP database
ORDS Part-4: How to create Restful ORDS API for ATP database. In earlier posts, we have seen how to provision ATP database in OCI and how to connect ATP database from SQL developer using Wallet key. In this post, we will see how to enable ORDS for ATP database. ORDS stands for Oracle Rest Data […]
ORDS Part-5-How to Enable OAUTH2.0 for ORDS REST API
In this blog post, we will see how to enable OAUTH2.0 for ORDS REST API. Login with ORDS_TEST_USER. Navigate to Development —>REST. Click on Open. Step1: Create Role for OAUTH2.0 Navigate to Security —>Roles. Click on Create Role. Provide Role Name and Click on Create. Step2: Create Privileges Navigate to Security —> Privileges Click on […]
ORDS Part-3: Enable ORDS for Custom Schema using PLSQL
In the Last post, we have seen how to download and install ORDS with XE database. In this post, we will see how to enable ORDS for schema. Step1: Create New User/New Custom schema. Login to XE database with SYS user. Check all pluggable databases. Show pdbs; Alter session to FREEPDB1: ALTER SESSION SET CONTAINER=FREEPDB1; […]
ORDS Part-1: Introduction to ORDS
Oracle REST Data Services (ORDS) is a middleware tool provided by Oracle that enables you to easily expose Oracle Database data and logic as RESTful web services. It’s a key component for modern application development, allowing seamless integration of database functionality with web, mobile, and cloud applications. ORDS (Oracle REST Data Services) is a Java-based […]