junlapong

-- connect as system
C:\>sqlplus / as sysdba

-- reset system password
ALTER USER system IDENTIFIED BY *password*;

-- unlock user
ALTER USER username ACCOUNT UNLOCK IDENTIFIED BY *password*;

-- create user/schema

junlapong

-- D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

junlapong

:: D:\grails\setenv.bat
-------------------------------------------------------------------------------
@echo off

SET GRAILS_HOME=D:\grails\grails-1.3.9
:: SET GRAILS_HOME=D:\grails\grails-2.1.0

SET PATH=%GRAILS_HOME%\bin;D:\grails;%PATH%

:: GRAILS COMMAND ::

junlapong

LoadModule jk_module modules/mod_jk.so

JkWorkersFile conf/custom/workers.properties
JkMountFile conf/custom/uriworkermap.properties

# AUTO RELOAD uriworkermap.properties
JkMountFileReload 0

JkLogFile "logs/mod_jk.log"
JkLogLevel warn

junlapong

-- DBA define dump directory for remote and local db --
C:\>sqlplus system/password@tns_name as sysdba
SQL> CREATE DIRECTORY data_dump_dir AS 'D:\oraclexe\dump';
SQL> GRANT read,write ON DIRECTORY data_dump_dir TO username;
SQL> SELECT directory_name, directory_path FROM dba_directories;

--- EXPORT FROM REMOTE DB ---
C:\>expdp username/password@tns_name DIRECTORY=data_dump_dir DUMPFILE=database.dmp SCHEMAS=database LOGFILE=database.log
C:\>expdp username/password@tns_name DIRECTORY=data_dump_dir DUMPFILE=database.dmp TABLES=table_user,table_product LOGFILE=database.log

junlapong

key1=value1&key2=value2+space

junlapong

-- REF: http://docs.oracle.com/cd/B12037_01/server.101/b10739/undo.htm

-- SELECT * FROM DBA_DATA_FILES;

SELECT A.TABLESPACE_NAME
     , A.FILE_NAME
     , A.BYTES / (1024 * 1024) AS ALLOCATED_MB
     , B.FREE_BYTES / (1024 * 1024) AS FREE_MB
  FROM DBA_DATA_FILES A
     , (

junlapong

NGINX

/etc/init.d/nginx start|restart|reload

CONFIG

/ect/nginx/nginx.conf

junlapong

@echo off
cls

pushd
setlocal EnableDelayedExpansion

%~d0
cd %~dp0

:: ===========================================================================

junlapong

/**
 * Luhn algorithm in JavaScript: validate credit card number supplied as string of numbers
 * @author ShirtlessKirk. Copyright (c) 2012.
 * @license WTFPL (http://www.wtfpl.net/txt/copying)
 */
var luhnChk = (function (arr) {
    return function (ccNum) {
        var 
            len = ccNum.length,
            bit = 1,