Offline backups (also known as Cold or consistent backups) are taken when the database is in a consistent state, i.e. the database has been shut down with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. As part of a consistent shutdown, redo has been applied to the data files and the System Change number (SCN) in the data file… Continue Reading →

All Things Oracle Full Articles

As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented free space. This free space is wasted space as it is insufficient to hold new data. Moreover, it can impact performance of the database as a higher number of sparsely-populated blocks need to be visited. Oracle 11g introduced online segment… Continue Reading →

Uncategorized

For many people working with Oracle database, SCN (System Change Number) is a topic that interests them greatly – but despite that it’s a fascinating topic, it’s confusing as well. In this article we will learn the nitty-gritty of SCN: what it is, where it is used, and how it works. It’s worth mentioning that this is not and cannot… Continue Reading →

All Things Oracle Full Articles

Oracle 12c has introduced Flex Clusters which use hub-and-spoke technology, allowing the cluster to scale much beyond the pre-12c clusters as it requires: Fewer network interactions between nodes in the cluster, and : Less contention for key Clusterware resources like OCR and voting disks. A Flex Cluster has two types of nodes: Hub Nodes and Leaf Nodes. Hub Nodes These… Continue Reading →

12c, All Things Oracle Full Articles

Traditionally Siebel CRM has been heavily dependent on ActiveX controls. Oracle offers lifetime support on any Siebel version post version 8.0 (launched in February 2007). As of Siebel 15 (Innovation Pack 2015), almost all of the Active X controls have been replaced by Java scripts as a part of the Open UI enablement. New customers deploying Siebel are truly browser-independent,… Continue Reading →

All Things Oracle Full Articles

In the last two articles we covered the process of upgrading a development database. The steps involved were as follows: Upgrade the Development Database. Run the incremental merge. Resolve the conflicts. Run the post-merge utilities. Update the physical database with the custom objects. The steps above are only required to upgrade a development database. This article covers the upgrade process… Continue Reading →

All Things Oracle Full Articles

As mentioned in the last article in this series, the Siebel upgrade process is split into 3 separate parts: Upgrade the Non-Production Database (Development Database). Perform the Database Upgrade. Perform the Incremental Repository Merge and any bug fixes. Upgrade the production database (Non-Development instances). We previously covered the first part of the upgrade, which was performing the database upgrade. During… Continue Reading →

All Things Oracle Full Articles

There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or updating? You cannae do both! But as, with each passing year, XQuery got more powerful and more popular the lack of an ability to modify XML documents began to look more and more like a gaping hole. And so, in… Continue Reading →

All Things Oracle Full Articles

In the nine previous articles in this series, we have learnt how to set up a Siebel Sandbox instance for Siebel users who want to re-implement Siebel and how to upgrade the application servers for users who want to perform an in-place upgrade. This article is relevant to all users who want to perform an in place upgrade. This might… Continue Reading →

All Things Oracle Full Articles

In the first article in the series we talked about having multiple paths for a Siebel upgrade. In a nutshell: For Siebel versions 8.0.X and early 8.1 customers the best possible route is to re-implement Siebel rather than upgrade. For this purpose we had suggested that a sandbox environment be set up so that the existing business processes can be… Continue Reading →

All Things Oracle Full Articles