MYSQL – Create CSV File With Fieldnames For Headers

Recently, I went to dump a MYSQL table into a CSV file, with the fieldnames in the first line of the file.

MYSQL Logo

 

This simple enough in Oracle’s SQLPLUS, so I did some internet searches to determine the syntax.

Instead of the simple MYSQL syntax, I found a number of relatively complex solutions. Some involved MYSQL scripts, and others utilized Unix string parsing commands.

However, I came up with a much simpler solution using one simple MYSQL command:

Installing Gephi On 64 bit Machines

The instructions for installing Gephi can be found at:

https://gephi.org/users/install/

They seem simple enough. But I found out that on a 64 bit server, it’s really important that you have a full 64/64/64 bit combination. That represents the operating system, Java, and Gephi. Here are some hints to get it right.

Java:

Be sure to download the right java file.  

Installing OBIEE on 64 Bit Redhat Linux 5.5 The Big Picture

Unfortunately, installing OBIEE on 64 bit Redhat Linux 5.5 is neither simple or straightforward. It is a complex multistep process. Usually requiring that you read dozens of documents and webpages, sometimes for one detail alone.

Here is the big picture, or  high level steps on what to do. And some detail, on a few of the gotchas I had.

For more gory details, you can see:

Oracle’s online document:
http://docs.oracle.com/cd/E14571_01/doc.1111/e14770/biee.htm

And, the 120 page installation document from Oracle: e10539.pdf
Oracle Fusion Middleware
Installation Guide for Oracle Business Intelligence
11g Release 1 (11.1.1)
E10539-02

And the many other links referenced below.

—

Prerequisites:

A Linux server, with lots of memory, disk space, and CPU power
Redhat Linux 5.5 installed on the server. Install -every- package on the DVD.

—

Steps:

Read the OBIEE certification matrix
Download the appropriate software
Double check that the Linux installation has the required packages
Install the Oracle database software, if it is not installed already
Install Java JDK, 64 bit
Create a database for the repository
Run the Repository Creation Utility (RCU)
Install WebLogic with generic .jar
Install OBIEE as “software only”
Run configuration assistant to configure OBIEE
Write scripts to start and stop OBIEE

—

First, check the OBIEE certification matrix, and compare it to your environment. This can keep you busy for a while. I used: bi-11gr1certmatrix-166168.xls

What Version of Weblogic Is It?

Ever wonder what version of weblogic is on your server? Here is how to find out.

————-

First, set the environment variables in $DOMAIN_HOME

Firefox, Oracle Apps, Java plugins, on 64 Bit Redhat 5.5

When using Firefox on Linux, have you ever got the aggravating message concerning oaj2se.exe, or NPX_PLUGIN_PATH? Here is the solution.

From what I have read, on Linux, using the Firefox browser for Oracle Forms is not certified. At least it wasn’t in the past. Bizarre.

———–

Symptom:

On Redhat Linux, you try working with an app such as Oracle Apps, and navigate to where the software takes you. But you suddenly get the error message:

In order to access this application, you must install the J2SE Plugin version 1.6.0_07 on your client and NPX_PLUGIN_PATH environment variable is set before starting Netscape. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

———–

The problem is, oaj2se.exe is an executable that only works on Windows.

Oracle Apps R12 Install on Redhat 64 – The Big Picture

Ever notice how installing almost any Oracle product has not dozens, but hundreds of pages of detailed documentation? The installation guide for R12, Oracle Applications Installation Guide: Using Rapid Install, 120oaig.pdf, is 150 pages long!

Unfortunately, most of the time, Oracle docs do not give the big picture. In a few hundred words or less, what’s involved? What’s the procedure? What’s the order of operations?

Blogs and forums I find to be much better written, and much more useful.

Recently at home, I installed Oracle Apps R12 on a single Redhat Linux 5.5 64 bit server. Here is what I would describe as the big picture, or the high level. Refer to other docs, blogs and forums for the remainder of the very many gory details.

Oracle Apps – Analysis of the Files and Filesystems

Continuing my analysis of Oracle Apps R12.  This time, the actual files on the server.  There are over 1/2 million files in APPL_TOP and COMMON_TOP!  Wow!

—————-

On my installation of Apps R12, there is:

APPL_TOP
/oapps/applmgr/VIS/apps/apps_st/appl

COMMON_TOP
/oapps/applmgr/VIS/apps/apps_st/comn/

ORACLE_HOME
/oapps/oracle/VIS/db/tech_st/11.1.0

—————-

The top parts of the directory structure:

find /oapps  -maxdepth 5 -type d