The ability to deploy Java inside the Oracle database led somebody to conclude that the source isn’t visible in the data catalog. Then, that person found that they were wrong because the Java source is visible when you use a DDL command to
COMPILE the Java source. This post discloses how to find the Java source and how to prevent it from being stored in the data catalog.
For example, (more...)
Oracle 184.108.40.206 Patch 17694377 for Linux and Solaris has been released on Metalink and edelivery a few minutes ago. Happy upgrading!
The post Oracle Database 12c Release 1 [220.127.116.11] Patch Released appeared first on VitalSoftTech.
Replicating data can be a time consuming process to setup. Fortunately, Oracle GoldenGate provide a few tools to help ease the complexity of setup. One of these tools is the “macro”. Macros are used to simplify and automate the work associated with setting up and replicating data. So what exactly is a macro? Oracle defines a macro as:
A macro is a built-in automation tool that enables you to call a stored set of processing (more...)
Currently the 18.104.22.168.0 is available for:
- Linux 64bit
- Solaris SPARC
- Solaris Intel 64bit
Happy download :-)
Recently, I’ve been doing some work with a client where tokens need to be used. It came to my attention that the basic usage of tokens is misunderstood. Let’s see if I can clear this up a bit for people reading.
The JOB record is a the heart of HCM. It is both effective-dated and effective sequenced. I will use it (more...)
Wither you use a single OEM and migrating to a new OEM or have multiple OEMs, the need to move templates between environments will arise. I had this exact problem come up recently at a customer site between an OEM 11g and OEM 12c. In order to move the templates, I needed to export the multiple monitoring templates using EMCLI. The command that I used to do individual exports was the following:
./emcli export_template -name="<template (more...)
I left to chance where students would attempt to place their external files in a Linux or Unix implementation. As frequently occurs, they choose a location in their
student user’s home directory. Any attempt to read an external table based on a file in this type of directory fails because it’s not accessible by the Oracle user. You can’t simply
chown the directory and files in the directory.
The failure returns the following result:
A call to a
PRICE_S1 sequence in a query with an
ORDER BY clause is disallowed. Any attempt raises the following exception:
SELECT price_s1.NEXTVAL AS price_id * ERROR at line 1: ORA-02287: SEQUENCE NUMBER NOT allowed here
You need to remove the
ORDER BY clause to eliminate the error.
Sometimes my students find new errors that I’ve never seen. One student did that this week by including an
ORDER BY clause in a subquery that feeds an
INSERT statement. It raises an
ORA-00907 exception, like:
ORA-00907: missing right parenthesis
You can’t include a subquery with an
ORDER BY clause because it generates an error. The reason is simple. A subquery can’t perform a sort operation inside a subquery. Here’s a quick (more...)
Enkitec folks have been beta testing the Oracle Database 12c In-Memory Option over the past months and recently the Oracle guys interviewed Kerry Osborne, Cary Millsap and me to get our opinions. In short, this thing rocks!
We can’t talk much about the technical details before Oracle 22.214.171.124 is officially out in July, but here’s the recorded interview that got published at Oracle website as part of the In-Memory launch today:
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c. Related Articles • Oracle 12c: Data Redaction Unified Auditing Extended SHA-2 […]
It’s seldom that Oracle makes an effort to give an Oracle Press book away for free, but they’ve done it. You can download the Getting Started with Oracle NoSQL Database book from Oracle Press for free.
Getting Started with Oracle NoSQL Database
- Overview of Oracle NoSQL Database and Big Data
- Introducing Oracle NoSQL Database
- Oracle NoSQL Database Architecture
- Oracle NoSQL Database Installation and Configuration
- Getting Started with Oracle NoSQL Database Development
- Reading and Writing Data
Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox
If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.
DBMS_OUTPUT.PUT_LINE is always a bit of a problem when you have strings longer than 80 characters in length, which occurs more frequently with Oracle Database 12c. An example of managing output occurs when you want to print a string with embedded line breaks. My solution is the following
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 (more...)
In Oracle 12c, a new interesting much needed feature, has been introduced which controls the maximum amount of the PGA memory consumed by the user processes. The PGA_AGGREGATE_LIMIT parameter limits the amount of memory used by processes in the PGA.
The post Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c appeared first on VitalSoftTech.
DBA’s, Developer’s and SYS Admin’s require test environments to perform testing such as OS/Database patching, upgrades, new features, etc. before performing these tasks on the Production environments. They are not always successful in finding a place to test these changes and at other times it takes too long to get the environment provisioned. Many of […]
The post Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.
Presentation of Information Lifecycle Management (ILM) With data volume growing, finding adapted storage solutions to storage costs and performance objectives is a real challenge for IT department in large companies. Information Lifecycle management is about managing the data all along its useful life while offering the best performance and storage cost as low as possible. The [...]