Oracle Express -=- Change default HTTP / FTP ports

Hi

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 10.1.0.2.0 - 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 10.2.0.1.0 - 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.

Signs of the times...

Hahaha!

Check theses signs of the times at Signs of the times...

Yann

EDI -=- Sample query to select and move transactions

Hi

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

Hi!

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

Have a look at this site http://www.robelle.com/smugbook/regexpr.html

Yann

Linux -=- Gunzip all the files recursively

Hi!

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 http://www.bloomberg.com/markets/stocks/movers/dow/

Mazda 3 2007 -=- How to change spark plugs

Here's a good how to that explains how to change spark plugs on a Mazda 3 2007.

http://www.mazda3forums.com/index.php?topic=177283.0

Have fun!

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.