eMarcel.com

Oracle Database, Fusion Middleware, Linux

Oracle Database

Creating Oracle Database Cloud Service (DBaaS)

Previously we were looking at How to get 30 days Free Oracle Cloud Subscription Plan PaaS IaaS. Now let’s take a look at the Oracle Database Public Cloud Services and one of its offerings: Oracle Database Cloud Service (DBaaS). We will create brand new 12c Database instance, enable remote access and using Oracle SQL developer we will connect from […]

, ,

Data Redaction in Oracle Database 12c flaws or security gaps?

I’ve been working on proof of concept project for Data Redaction in Oracle Database 12c. Hard to say but POC has proven that data redaction has couple of flaws or according to Oracle “constraints”. Therefore before we could continue with implementation we would have to find solutions to below findings. Any feedback from the readers would be much […]

, , , ,

Oracle Data Redaction in Oracle Database 12c

Data Redaction provides a way to define masking policies for an application. Oracle Data Redaction provides functionality to mask (redact) data that is returned from user SELECT queries. The masking takes place in real time. The difference between Oracle Data Masking and Data Redaction is that Data Redaction doesn’t alter underlying data in the database; it […]

, , ,

Oracle Live SQL is live. Code SQL in a Web Browser

Oracle Live SQL is a free online tool to learn and code SQL & PL/SQL in Oracle Database. Learn and share SQL, for free. source: oracle.com Get instant access to the Oracle Database and learn from a collection of community scripts and structured tutorials. Save and share SQL sessions with others! Oracle Live SQL exists to provide the […]

, , , , ,

How to enable Oracle Enterprise Manager Express 12c

Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database 12c. It enables users to perform basic administrative tasks such as managing users, managing database initialization parameters, memory or storage. You can also view performance and SQL Tuning Advisor information, check status information about your database and pluggable databases. In Oracle Database 12c Release 1, […]

, , , , , ,

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 […]

, ,

Fix for ORA-03113: end-of-file on communication channel

Oracle Database Server 12c Here is how to fix ORA-03113: end-of-file on communication channel Cause: I issued shutdown immediate command in a running database instance. The database was busy and it took ages to shut it down. I was impatient and I did kill a virtual machine server. After virtual machine restart, the database did not start any more, throwing ORA-03113 […]

, ,

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 […]

, , ,

Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2

In previous tutorial of this topic, we covered installation of Oracle Database 12c R1 on Linux 6 with ASM version 12.1.0.1.0. Now it’s the time to upgrade our database to version  12.1.0.2.0 which introduces long awaited “In-Memory Aggregation” and “In-Memory Column store” features. There is obviously much more – full description of Oracle Database 12c R1 (12.1.0.2) New […]

, , , ,

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 […]

, , , , ,

Previous Posts

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