How to use and run Oracle Database Security Assessment Tool (2.2.2) on Oracle PDB with Wallet
Context How to use and run Oracle Database Security Assessment Tool (2.2.2) on Oracle PDB with Wallet for more details, please refer to oracle documentation oracle dbsat – documentation Environment Operating System: Oracle Linux Server 8.7 Architecture: x86-64 Oracle db: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production Only demo schema tables will be […]
Oracle REST Data Services 21.3 Installation
Oracle REST Data Services 21.3 Installation In this post, we will cover the installation and configuration of Oracle REST Data Services 21.3, create and enable some restful services to access data, store json data returned by theses services in the database and finally, we will see some use-cases of SQL/JSON Condition JSON_EXISTS in our demo. […]
Oracle Advanced Queuing (AQ) demo
Introduction: Advanced Queuing (AQ) has been available for several versions of Oracle. It provides database-integrated message queuing functionality, which is built on top of Oracle Streams and leverages the functions of Oracle Database so that messages can be stored persistently, propagated between queues on different computers and databases, and transmitted using Oracle Net Services and […]
Oracle WebLogic Server 12c: Configuring JMS Servers and Destinations
Introduction This tutorial shows how to create and configure Java Message Service (JMS) servers, queues, and topics in an instance of Oracle WebLogic Server 12c. We will use a web application to post messages to the queue and topic and the Oracle WebLogic Server 12c (12.1.1) administration console to Monitor the queue and topic. Main […]
How to use unified audit trail in oracle database19c with Splunk
How to use unified audit trail in oracle database19c with Splunk Intoduction: We will use the predefined unified audit policies provided by oracle for the current demo and will not configure unified audit trail or create any specific audit policies for our splunk demo. (The details of Unified audit trail are not part of this […]
Postfix SMTP Server installation and configuration on Centos8
About Postfix Postfix is a free and open-source mail transfer agent (MTA) that routes and delivers electronic mail. Originally written in 1997 by Wietse Venema at the IBMThomas J. Watson Research Center in New York, and first released in December 1998, Postfix continues as of 2020 to be actively developed by its creator and other contributors. The software is also known by its former names VMailer and IBM Secure […]
Fusion Middleware Managing Server Startup and Shutdown for Oracle WebLogic Server
Fusion Middleware Managing Server Startup and Shutdown for Oracle WebLogic Server If you want to start automatically weblogic server instances when you boot a windows host computer, you can create specific windows services. For each server instance for which a windows service is set, the weblogic server creates a key in the Windows Registry under […]
Use SQL Developer Command-Line (SQLcl) to run SQL-scripts
SQL Developer Command Line SQLcl 18.2 Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. You can, both execute in interactive or batch mode, sql and Pl/SQL. It supports all previously written SQL*Plus scripts. You can download the SQLcl 18.2 here First, we locate hr_main.sql script on our disk, […]
Store and manipulate json data in Oracle database 12.2.0.1.0
Store and manipulate json data in Oracle database 12.2.0.1.0 For the purpose of the post, I use the json-document generated in the previous post, see https://linecode-notes.com/2018/07/16/install-and-use-ords-with-oracle-database12c/ First, we create a table to store our json-document. JSON_TABLE creates a relational view of JSON data. You can query the result returned by the function as a virtual relational […]
Install and use ORDS with Oracle Database12c
Based on Oracle® REST Data Services Release 18.2 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bits SODA for REST uses the representational state transfer (REST) architectural style to implement Simple Oracle Document Access (SODA). You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can […]
About Me
Senior oracle DBA/Developer | OCI Certified | OCP | OCE Sql Certified Expert
