MYSQL – Create CSV File With Fieldnames For Headers

October 19, 2014

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

MYSQL Logo

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:

Read the rest of this entry »


Installing Gephi On 64 bit Machines

July 8, 2013

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.   Read the rest of this entry »


Installing OBIEE on 64 Bit Redhat Linux 5.5 The Big Picture

July 12, 2012

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
Read the rest of this entry »


What Version of Weblogic Is It?

January 28, 2012

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

————-

First, set the environment variables in $DOMAIN_HOME

Read the rest of this entry »


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

January 20, 2012

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.
Read the rest of this entry »


Oracle Apps R12 Install on Redhat 64 – The Big Picture

December 9, 2011

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.

Read the rest of this entry »


Oracle Apps – Analysis of the Files and Filesystems

April 14, 2011

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

Read the rest of this entry »


%d bloggers like this: