eMarcel.com

Oracle Database, Fusion Middleware, Linux

database

Oracle SOA Suite 11g: a workaround for long running SQL queries

Oracle SOA Suite 11g (11.1.1.7) environment is connected to a database which is its dehydration store database, used to store process status data, especially for asynchronous BPEL processes. Production environments tend to produce millions of records in tables of that database. This, when not well maintained, can become a true performance bottleneck in the database and SOA Suite engine itself. Some […]

, ,

Oracle Database 12c In-Memory How To Get Started

Oracle Database In-Memory feature has been released by Oracle in recent patch set 12.1.0.2. Here is how to upgrade Oracle database to version 12.1.0.2: Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2 With the introduction of Oracle Database In-Memory, a single database can now efficiently support mixed workloads, delivering optimal performance for transactions while simultaneously supporting real-time analytics […]

, , ,

Installing Oracle Application Express in Oracle Database 12c

Oracle Application Express (Oracle APEX) is Oracle’s primary tool for developing Web applications with SQL and PL/SQL. Using only a web browser, you can develop and deploy professional Web-based applications for desktops and mobile devices. It is a fully supported, no cost option of the Oracle Database, and is installed by default in all editions […]

, , , , ,

Installing Oracle Database 11g R2 on Linux with ASM

In this guide we are going to cover Oracle Database 11g R2 installation on Linux with ASM. Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle […]

, , , , , , , , , , , , , , ,

Installing Oracle Database 11g R2 on Linux

In article Installing Oracle Linux in VMware virtual machine we covered installation of Oracle Linux 5U8 including oracle-validated package. Now, our system is ready for Oracle database installation, and no additional configuration tasks is required at this moment. Note: Most of the time we work with OS from remote locations and target servers are located […]

, , , , , , , ,

Installing Oracle Linux in VMware virtual machine

What is Oracle Linux? Oracle Linux is an open source operating system available under the GNU General Public License (GPL) and is available for free download. Oracle Linux includes two kernels: Unbreakable Enterprise Kernel, tracks mainline Linux kernel closely, and offers the latest features and tested performance and stability The Red Hat Compatible Kernel, compiled directly […]

, , , , ,

How to multiply control files in Oracle DB RAC 11g

This examle shows how to multiply control files in Oracle Database RAC 11g. An example cluster database racdb1 is up and running on two nodes (rac1 and rac2) Two database instances: [racdb11] and [racdb12] 1. SHUTDOWN the database and start an instance [racdb11] only on the first node (rac1) and check the current configuration. Next, shutdown […]

, , , ,

Creating an online Phone Book with Oracle Database and SQLDeveloper

This tutorial shows how to create an Online Phone Book with search feature using Oracle Database and SQLDeveloper. What’s needed? Oracle Database Oracle SQLDeveloper A data set – names and phone numbers. Let’s roll… 1.    First let’s prepare our data set in excel sheet. Create a dump of your phone book into an excel sheet; […]

, ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close