Toggling the database in OBIEE 11g at runtime

We have a replication and the primary database server. Replicating the data takes some time so the replication server is usually a few mins behind the primary server. The requirement for one of the report was to get the data from the primary server if the replication is lagging by over 1 min. This blog talks about a method to implement this business use case.

In my project, we have a table that tells us (more...)

Oracle VM file sharing with Windows host

This article talks about the process to share files between Oracle VM and windows host.


Open the VM and navigate to System -> Preferences -> Personal File Sharing as shown below.


















Check the Share public files on network check box as shown below.



















Open the Network as shown below.



















Navigate to the following path
(more...)

A Startup is Like Making a Trip to Each Continent

Maybe you realize how difficult it is to go from an idea to a successful company.  Maybe you've attempted one (or more) yourself.  Is the American dream a startup?  It is for some, but not all.  If you start a company and you're the only employee and you don't get paid, is your business a startup?  Is it successful?  Beauty and success are in the eye of beholder.  You might hear people suggest you set (more...)

Check Seleced Rows

This small example is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding:

https://apex.oracle.com/pls/apex/f?p=93000:806

Switch Panes in Page Designer

This is definitely worth of mentioning. Go here and download this plugin for Firefox or Chrome. You will like it. It switches the panes in the Page Designer so you can much easier access the properties of the selected elements. Congrats Filip. This is a cool feature. Thanks.

Add Color to your SQL

Topic: this post is about some simple techniques to add color to SQL scripts and their terminal output using ANSI escape codes.

Colors can be used to improve the output of command line tools. This is common practice, for example with the (bash) shell. Colors can also be very useful to improve the quality of the output of SQL scripts. In my experience this is not used frequently, probably because of the the need of (more...)

Oracle Priority Support Infogram for 27-AUG-2015


RDBMS


Migration IBM AIX ==> SPARC Solaris with Data Guard, from Upgrade your Database - NOW!


Coding Oracle


WebLogic

Worrying about the 4th Bullet?

I love analogies that are very meaningful and get the point across.  I often hear businesses talking about different subjects that concern them.  You could say this is similar to the days of the old west where people carried their weapons on their belt and used them at will.  Back then, did people worry about the 4th bullet in the gun?  Of course not.  They worried about the 1st bullet.

So why is it that (more...)

Web Pages Not Databases – Part 2: Fail2ban, Apache, IP Addresses, Linux, SELinux

August 23, 2015 (Back to the Previous Article in this Series) I started using Linux in 1999, specifically Red Hat Linux 6.0, and I recall upgrading to Red Hat Linux 6.1 after downloading the files over a 56k modem – the good old days.  I was a little more wise when I upgraded to another […]

OpenAM: Forcing user to reset password on next login.

Overview

A very common use case, when implementing ForgeRock’s OpenAM, is forcing a user to reset their password the next time they login. Seems easy enough right? … next time a particular user authenticates in they should be prompted to change their password before continuing on to the resource (web page) that they had originally requested.

The documentation does mention a setting, in section 8.3, to enable this:

Force Change Password on Next (more...)

Formatting Rich Text Comments in BI Publisher

In the last years, BI Publisher has become the go to tool to cover most reporting needs in PeopleSoft, replacing other technologies such as Crystal Reports and SQR in many scenarios.



The basic concept behind many reporting tools is separating data and presentation logic, so report designers can work in parallel with developers who know the data model in detail. BI Publisher is the PeopleSoft reporting tool that achieves this separation in a more (more...)

Messed-Up App of the Day: Crux CCH-01W

Today’s Messed-Up App of the Day is the “Crux CCH-01W rear-view camera for select 2007-up Jeep Wrangler models.”

A rear-view camera is an especially good idea in the Jeep Wrangler, because it is very difficult to see behind the vehicle. The rear seat headrests, the wiper motor housing, the spare tire, and the center brake light all conspire to obstruct much of what little view the window had given you to begin with.

Oracle Priority Support Infogram for 20-AUG-2015


RDBMS


OVM

Oracle VM Windows PV Drivers 3.2.3 Signed by Microsoft, from Oracle’s Virtualization Blog.

From the same source:


Ops Center

Editing or Disabling Analytics, from the Ops Center blog.

OIM

Release of BP02 for Oracle Identity Manager 11.1.2.3, from Proactive Support - Identity Management.

The Future of IT Staffing- People vs. Robots

Image and video hosting by TinyPic

The Increasing Complexity of the IT Tech Stack Will Drive the Need for Robotic Automation

I’ve been involved in database technologies for 20 years now. During that time, I have read numerous prognostications from various industry pundits proclaiming that the next release of so-and-so database would be so simple to administer that the product would no longer require DBAs for support.  Replace “database” with any technology, and you’ll find that the same industry mantra occurs.

(more...)

Automation for DBA – Vagrant part 1

Vagrant is an open source tool for building a virtual environment. It is based on text based configuration file and concept of prebuilt OS boxes.
One can find a lot of boxes on Atlas webpage (https://atlas.hashicorp.com/boxes/search), ready to download and use.  Although if there are any security concerns about using a OS from 3rd party webpage, I published a blog post about creating a new Vagrant box using Oracle Linux (more...)

Map Reduce: File compression and Processing cost

| Aug 18, 2015

Recently while working with a customer we ran into an interesting situation concerning file compression and processing time. For a system like Hadoop, file compression has been always a good way to save on space, especially when Hadoop replicates the data multiple times.

All Hadoop compression algorithms exhibit a space/time trade-off: faster compression and decompression speeds usually come at the expense of space savings.  For more details about how compression is used, see https://documentation.altiscale. (more...)

Convert CSV file to Apache Parquet… with Drill

Read this article on my new blog A very common use case when working with Hadoop is to store and query simple files (CSV, TSV, ...); then to get better performance and efficient storage convert these files into more efficient format, for example Apache Parquet. Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem. Apache Parquet has the following

OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract

When creating the GoldenGate Integrated Extract why do I get the message "ENABLE_GOLDENGATE_REPLICATION is not set to true"?

The post OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract appeared first on VitalSoftTech.

John King in Cleveland CTOWN for September meeting

For our September 18 friday afternoon quarterly meeting Northeast Ohio Oracle Users Group is lucky to have a great speaker Oracle Ace Director John King presenting.  It's the usual networking and free lunch beginning at noon at the Rockside Oracle offices followed by quick business meeting and presentations starting at 1 pm.

Full details on NEOOUG Sept 2015 presentations

November meeting we have Daniel Morgan woo hoo!

Hyper-Extended Oracle Performance Monitor 7.0 Beta

August 16, 2015 Three and a half years ago I offered the Hyper-Extended Oracle Performance 6.0 Beta for download – that Beta version expired a year later.  This program has been somewhat of a pet project for the last 13 years (almost 10 years at the time of the previous Beta offering), so I was […]