Oracle Flex Cluster: Leaf Node Failover

0
1
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… … Read more

Running Siebel CRM on Non-Standard Versions of Internet Explorer

1
0
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… … Read more

Siebel CRM Part 12: Upgrading a Non-Development Database

0
0
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 →Read more

Siebel CRM Part 11: Performing the Siebel incremental Repository Merge

0
1
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 →Read more

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility

0
0
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 →Read more

Siebel CRM Part 10: Upgrading the Siebel Database

0
0
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 →Read more

Siebel CRM Part 9: Upgrading the Application Servers for 8.1.1.X Deployments

0
0
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 →Read more

Automatic Big Table Caching in RAC

0
0
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 →Read more

Siebel CRM Part 8:- Configuring and Starting the Siebel Sandbox

0
0
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 →Read more

XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions

0
0
This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked about XPath, Oracle’s implementation of XQuery, and FLWOR. This article won’t be taking on anything so meaty; I just want to clear up some odds and ends that I think are important, but I wasn’t able to shoehorn into any… Continue Reading →Read more

Siebel CRM Part 7: Installation of the Siebel Application Software

0
0
As mentioned in the last article in this series, we have completed all the tasks necessary to create the Siebel Sandbox environment, except for the installation of the Siebel Application software itself. Up to now we have completed the following tasks: Setup of an Amazon Instance with 3 servers. Setup of Java and IIS. Setup and configuration of the Oracle… Continue Reading →Read more

Massive Deletes – Part 3

0
0
In the previous installment of this series we looked at methods for seeing the pattern of the changes that would appear in a table and its indexes after a large delete. In this installment we move on to the workload implied by different patterns, then think about strategies or, indeed, the need for strategies for reducing that workload at the… Continue Reading →Read more

Siebel CRM Part 6: Configuring the Siebel Database

0
0
The final step before we can start the Siebel Server installation is to configure the database server. In the last article in this series we completed the following tasks: Installation of the Oracle Database server on the Amazon server called Siebel Database Server. Creation of an Oracle Database called “SiebelDB”. Installation of the Oracle Client on all the servers. Before… Continue Reading →Read more

Siebel CRM Part 5: The Ancillary Software

0
0
Before we can start installing the Siebel Application software we have a few more steps to complete. Just to recap the steps we have completed so far, we have: Set up a 3-server instance using Amazon AWS. We have downloaded all the installation software. We have extracted the software for the Database Server and the Siebel application. We have created… Continue Reading →Read more

Siebel CRM Part 3: The Download of the Siebel Installation and Ancillary Application Files

0
0
This article requires that you have an Amazon AWS instance set up, as detailed in the previous article in this series. Downloading installation files should be something which is fairly simple, however in the Oracle scheme of things, the simplest of things can sometimes be the toughest. The first thing which needs to be done before the download is to… Continue Reading →Read more

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

0
0
In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery and are looking to dip their toes into its world. If that’s you, hi, nice to meetcha. Or rather, nice to meetcha again. This is the second article in the series; go back and read the first if you haven’t… Continue Reading →Read more

Siebel CRM Part 2: Initial Upgrade and Setup of an Amazon Instance

0
1
A Siebel CRM upgrade project typically consists of numerous iterations even before the actual development and bug fixes take effect. It is wise to follow the age old adage “measure twice, cut once”. It makes practical sense not to upgrade the development instance until the upgrade team is absolutely sure of the upgrade process itself, since there will be slight… Continue Reading →Read more