Thursday, September 29, 2011

Oracle Express -=- Change default HTTP / FTP ports


If you want to change the default HTTP and FTP ports for the Oracle Administration Web Interface (APEX) you can do the following steps. You must type this in the Windows Command Manager:

C:\WINDOWS\system32>sqlplus system@xe

SQL*Plus: Release - Production on Mi Jan 25 11:44:33 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release - Beta

SQL> -- get current status
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8080 0

To change the ports, type the following command:

SQL> begin

2 dbms_xdb.sethttpport('8888');
3 dbms_xdb.setftpport('2121');
4 end;
5 /

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8888 2121

You can now access the web interface by typing http://localhost:8888 in the your browser.

Friday, September 23, 2011

Thursday, September 22, 2011

EDI -=- Sample query to select and move transactions


If you have a bunch of EDI files, you may want to extract only specific transactions and move them to a folder. Here's a sample query. It moves all the PO (850) and the invoices (810) to the folder "MYFOLDER" in my home directory. The dot (.) in the grep represents any characters so this query will works will all delimiters.

find . -type f -exec grep -Rl 'ST.8[15]0' {} \; -exec cp -rf {} ~/MYFOLDER/ \;

Linux -=- Good reference for Regular Expression with GREP


I've found a good reference that helps to understand regular expression with GREP.


Monday, September 19, 2011

Linux -=- Gunzip all the files recursively


If you have need to gunzip all the gzipped files that were under a directory hierarchy, you can type the following command. It will return all the files to delete and gunzip them. You must go in the root directory and type this command:

find . -iname '*.gz' -exec gunzip {} \;

Stocks -=- What is a "blue chip"

According to the New York Stock Exchange, a blue chip is stock in a corporation with a national reputation for quality, reliability and the ability to operate profitably in good times and bad.[1] The most popular index which follows US blue chips is the Dow Jones Industrial Average. The Dow Jones Industrial Average is a price-weighted average of 30 blue-chip stocks that are generally the leaders in their industry. It has been a widely followed indicator of the stock market since October 1, 1928.[2]

Source: Wikipedia

You can find the list of these 30 companies at

Tuesday, September 6, 2011

Monday, September 5, 2011

Mazda 3 2007 -=- Cabin Air Filter Replacement

Here's a good tutorial that explain how to change the cabin air filter on the Mazda 3.