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

In an earlier article, I discussed Automatic big table cache (ABTC) which is a new feature introduced in Oracle Database 12.1.0.2c. Automatic big table cache is an optional section of the buffer cache reserved for storing large objects. It tracks only big tables and automatically caches scanned big objects in big table cache thereby avoiding direct path reads. It caches… Continue Reading →

12c, All Things Oracle Full Articles

In the last article in this series, we completed the installation of all of the Siebel components for our sandbox. In this article we will configure all those components so that we can start the Siebel application up. Siebel has to be configured in a specific sequence: Create a Gateway Name Server. Configure an enterprise in the Gateway Name Server…. Continue Reading →

All Things Oracle Full Articles