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 {} \;

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.