Techgoeasy

How to install Oracle Database Cloud Backup Module

Oracle Database Cloud Backup Module How to download the Oracle Database Cloud Backup Module Download the Oracle Database Cloud Backup Module from Oracle Technology Network (OTN):https://www.oracle.com/database/technologies/oracle-cloud-backup-downloads.html Accept the license agreement, click All Supported Platforms, and provide your OTN username and password when prompted. Then download the ZIP file that contains the installer (opc_installer.zip) to your […]

How to install Oracle Database Cloud Backup Module Read More »

Difference between Essbase 11g and Essbase 21c

hyperion, Oracle

What is Essbase Oracle Essbase is a multidimensional database management system (MDBMS) providing a multidimensional business analytics platform. It is commonly used for budgeting, forecasting, and planning in enterprise environments. What is Essbase 11g Essbase 11g is the old version of Oracle Essbase where the latest patchset is 11.1.2.4This is the latest On-Prem Essbase version

Difference between Essbase 11g and Essbase 21c Read More »

How to use Oracle LISTAGG Function

Oracle, Oracle Sql

This is part of the Oracle SQL tutorial and has good examples and explanations of the Oracle LISTAGG Function. Oracle LISTAGG function Oracle LISTAGG function is an analytical function that allows us to concatenate the strings for measure_column for each GROUP based on the order_by_clause. This is present in Oracle from 11gR2 The syntax for the LISTAGG

How to use Oracle LISTAGG Function Read More »

Snapshot standby database in Oracle

Oracle, Oracle Database

We already know about standby databases i.e. dataguard. Here we will learn about snapshot standby database in Oracle What is the snapshot standby database in Oracle? With 11gR, we can convert the physical standby database into a read-write database for some time and later again convert it back into physical standby mode using the snapshot

Snapshot standby database in Oracle Read More »

Must Read Top 100 Hyperion Essbase Interview Questions

hyperion, Oracle

We are bringing here a compilation from Must Read Top 100 Hyperion Essbase Interview Questions. 1) What is Essbase? Answer Essbase stands for Extended Spreadsheet Database. Essbase is a multidimensional database Management System(MDBMS) that provides a multidimensional database platform upon which to build Analytical Applications. Essbase products provide companies with the ability to deliver critical business

Must Read Top 100 Hyperion Essbase Interview Questions Read More »

10 Things you must know about EBS R12.2

Oracle, Oracle Ebuisness Suite

(1) Adop uses SID_patch service_name to connect to database (2) Adop Connects to other nodes in a multi-node setup via SSH and applies the patch ( similar to RAC patchings). It is executed by the user on the master node.It is important to enable the ssh from master node to other nodes If a node

10 Things you must know about EBS R12.2 Read More »