Since 1.0.3:
--------------------
New features:
1- bin/ubguard.sh (bin/ubguard.bat for Windows) has been added to manage ubGuard.
2- bin/environment.sh (bin/environment.bat for Windows) has been added
   to set environment variables.
3- Windows service has been added.
4- New parameters: 
    ssh.port.client: Defines local(outgoing) SSH port. Value 0 means random port.
    database.instance.alias: Defines ubGuard instance as an alias.
    database.instance.parent.alias: Defines ubGuard parent instance aliases.
5- Renamed parameters:
    ssh.port to ssh.port.server.
6- Removed parameters:
    database.instance.parent.host
    database.instance.parent.instance

1.1.2:
-------------------
New features:
1- database.standby.archivelog.retention.time definition has changed.
   Archivelogs on standby are deleted if they are older than standby
   database time by this parameter. 

Improvements:
1- Database instance alias name is not required to be case sensitive.
2- Numbers of SQLs running on Primary have been reduced.
3- Archivelogs are deleted by RMAN.
4- Unnecessary privileges have been revoked from UBGUARD_ROLE role.

Bugs:
1- While running OS commands, Runtime Exceptions could not be caught.
2- If parameter database.instance.alias is not upper case,
   Oracle directories UBGUARD_ASM_* and UBGUARD_TMP_* are recreated unnecessarily.
3- Wrong file separator used for ASM on Windows.
4- bin/ directory is included in ubGuard.jar unnecessarily.
5- bin/ubguard.sh and bin/environment.sh are in DOS format.

1.1.3:
-------------------
Bug:
1- Unable to catalog archivelogs on Windows.

 * 1.0.0:
 * -------------------
 * New features:
 * 1- ubGuard is installed in standby severs instead of primary servers.
 * 2- Cascaded standby: A standby gets archivelogs from another standby.
 * 3- The content of conf/setup.properties changed.
 * 4- Applied archivelog can be deleted from standby server with time delay.
 * 5- SSH connect timeout added.
 * 6- Single ubGuard home can bee used for multiple local standby databases.
 * 7- conf/message.properties file added.
 *
 * 1.0.1:
 * -------------------
 * Bug:
 * 1- Archivelogs moved from ASM to primary TMP directory not deleted.
 *
 * 1.0.2:
 * -------------------
 * Bug:
 * 1- Windows not identified.
 *
 *
 * 1.0.3:
 * -------------------
 * Bugs:
 * 1- Unable to get ORACLE_HOME environment variable in Windows.
 * 2- Existing archivelog in standby is retransffered in Windows.

       - Bug: Cursor number changed to String type.
       - itp-05 [1] removed.
       - itp-05 [6] removed.
       - Bug: Calculating statement length in PARSE ERROR line fixed.
       - Bug: Wrong number of "UN-KNOWN statements" in "TRACE FILE STATISTICS" output.
       - Bug: Wrong number of "Unique statements" in "TRACE FILE STATISTICS" output.

* 0.2.3:
 * -------------------
 * 1- SSH compression has been added.
 *    The parameter: ssh.compression.level
 *    No compression:0, Max compression:9, Default compression:-1(that is 6)
 *
 * 0.3.0:
 * -------------------
 * New Features:
 * 1- Forcing archivelog generation in each archivelog transfer period has been removed.
 *    Use Oracle ARCHIVE_LAG_TARGET initialization parameter instead.
 * 2- The changed messages:
 *    old: ubGuard-1 [<returnCode>]: Unable to acquire lock by DBMS_LOCK.REQUEST().
 *    new: ubGuard-1 [<taskID>,<returnCode>]: Unable to acquire task lock.
 *
 *    old: ubGuard-2 [<returnCode>]: Unable to release lock by DBMS_LOCK.RELEASE().
 *    new: ubGuard-2 [<taskID>,<returnCode>]: Unable to release task lock.
 *
 *    old: ubGuard-5 No UBGUARD_TMP_ARCHIVE directory found in ALL_DIRECTORIES.
 *    new: ubGuard-5 Oracle directory UBGUARD_TMP_ARCHIVE not defined.
 *
 *    old: ubGuard-4 No standby found.
 *    new: ubGuard-4 Standby not defined.
 *
 * 3- The removed messages:
 *    ubGuard-3: <message>
 *    ubGuard-6: Archivelog transfer period not defined.
 *
 * Bugs:
 * 1- Time portion of ERROR_LOG.ERROR_DATE column is lost.
 * 2- If an Oracle RAC thread reopened, it transfers archivelogs which are already in-transmit in another node.
 *
 *
 * 0.3.1d3:
 * -------------------
 * Bug:
 * 1- File name separator on standby windows is not handled correctly.
 *
 * 0.3.1d5:
 * -------------------
 * Bug:
 * 1- Recover SCN of standby database computed wrong after removing forcing archivelog generation
 *    which is introduced in ubGuard 0.3.0.
 *
 * 0.3.1d6:
 * -------------------
 * New features:
 * 1- Setting up mail.transport.user and mail.transport.password parameters are optional.
 *    SMTP authentication is forced only if both parameters are set.
 * 2- Java Mail debug is set to diagnose a problem.
 *
 * 0.3.1d7:
 * -------------------
 * Bug:
 * 1- Recovery start SCN is wrong if datafile is older than controlfile.
 *
 * 0.3.2:
 * -------------------
 * New feature:
 * 1- Unhandled exceptions are written to log/ubGuard.log.
 *
 * Bug:
 * 1- Already deleted archivedlogs are tried to be deleted again.

1- Cursor number changed to double type.
2- Binds fixed for Oracle 10g and Oracle 11g.
3- Execution plan exclusive statistics fixed for Oracle 11g.
4- All response time in output changed to elapsed time.
5- SQL Hash and SQLID added.
6- Tuning advice calculation fixed when dependent event cost is less than tuning advice limit.

1- MERGE(ub_view) hint added to query as a top level hint when UB_PARALLEL used.
2- The following messages are not printed when an error occured before:
   - "No data found to unload."
   - "ubSQL-4 [34] Wrong UB_PARALLEL object count found."

1- SELECT ON DBA_OBJECTS privilege is required for "No data found to unload" message even if there are rows to unload.

1- OCI_SUCCESS_WITH_INFO allowed in unload fetch for Oracle error:
  "ORA-24347: Warning of a NULL column in an aggregate function"
2- New error code: "ubSQL-3 [26] Unable to parse UB_PARALLEL. All data not entered correctly."
3- New error code: "ubSQL-10 [13] Wrong UB_PARALLEL parse."
4- New error code: "ubSQL-3 [27] Unable to parse UB_PARALLEL. Maximum object count exceeded."
5- Removed error code: "ubSQL-4 [18] THREAD_SETS parameter greater than rowid ranges."
6- New error code: "ubSQL-10 [14] UB_PARALLEL degree greater than rowid ranges."
7- Message changed.
   old: "ubSQL-4 [17] THREAD_SETS parameter greater than rowid ranges."
   new: "ubSQL-4 [17] UB_PARALLEL degree greater than rowid ranges."
8- New error code: "ubSQL-10 [15] Wrong UB_PARALLEL parse."
9- ubSQL-3 [34] Unable to parse UB_PARALLEL. Negative degree entered.
10- ubSQL-4 [34] Wrong UB_PARALLEL object count found.
11- New error code: "ubSQL-3 [29] Unable to parse UB_PARALLEL. Right parenthesis not entered."
12- New error code: "ubSQL-3 [30] Unable to parse UB_PARALLEL. Maximum degree exceeded."
13- New error code: "ubSQL-3 [28] Unable to parse UB_PARALLEL. Maximum multiple degree exceeded."
14- New error code: "ubSQL-3 [31] Unable to parse UB_PARALLEL. Object already used."
15- New error code: "ubSQL-3 [32] Unable to parse UB_PARALLEL. All data not entered correctly."
16- New error code: "ubSQL-3 [33] Unable to parse UB_PARALLEL. Object split level not entered correctly."
17- Removed parameters: THREAD_SETS,TABLE_SPLIT_LEVEL.
18- Removed error code: "ubSQL-4 [31] WRONG PARAMETER VALUE"
19- Message changed.
    old: "ubSQL-10 [26] UNABLE TO IDENTIFY TABLE SPLIT LEVEL"
    new: "ubSQL-10 [26] UNABLE TO IDENTIFY OBJECT SPLIT LEVEL"
20- New error code: "ubSQL-10 [16] Wrong UB_PARALLEL parse."
21- SHOW PARAMETERS doesn't show LICENSE_KEY parameter.
22- New error code: "ubSQL-11 [0] Unable to create OCI environment."
23- New error code: "ubSQL-11 [1] Unable to create OCI environment."
24- New error code: "ubSQL-11 [2] Unable to allocate OCI error handle."
25- Requirement fo SELECT ON DBA_OBJECTS privileges removed.

1- Elapsed time calculation changed from second to microsecond.
2- Message changed.
   old: "ubSQL-4 [18] FETCH_THREADS parameter greater than rowid ranges."
   new: "ubSQL-4 [18] THREAD_SETS parameter greater than rowid ranges."
3- Message changed.
   old: "ubSQL-4 [17] FETCH_THREADS parameter greater than rowid ranges."
   new: "ubSQL-4 [17] THREAD_SETS parameter greater than rowid ranges."
4- BUG: OCI_NODATA returned from getOwnerObject() while unloading from partition/subpartion table of different schema when THREAD_SETS>1.
   CAUSE: ALL_OBJECTS doesn't include partition data of different schema.
   FIX: DBA_OBJECTS used.
5- O_RDWR replaced with O_WRONLY in OSDWriterThread(),OSDOpenWrite().
6- O_DSYNC removed from OSDWriterThread(),OSDOpenWrite().
7- posix_fadvise(,,,POSIX_FADV_DONTNEED) added to OSDWriterThread().
8- New error code: "ubSQL-1 [11] UNABLE TO SET FILE ADVICE"
9- Unused remoteSessions,semBufferSetDB fields removed from struct sUserInterface.
10- setMultipleParameter() renamed to checkMultipleParameters().
11-Message changed.
   old: "ubSQL-4 [16] OUTPUT_FILE_NAMES MAX COUNT EXCEEDED"
   new: "ubSQL-4 [16] MULTIPLE PARAMETER VALUE MAX COUNT EXCEEDED"
12- freeFile() added in cleanUp.c
13- New error code: "ubSQL-10 [10] WRONG OUTPUT FILE NAME COUNT
14- createOutputFDArray() renamed to openOutputFiles().
15- Memory leaks in openOutputFiles(),connectOperation() removed.
16- New error code: "ubSQL-2 [1] UNABLE TO GET FILE STATUS"
17- Warning removed from OSDClose(): "perror("OSD WARNING(ignorable for PIPES)""
18- New error code: "ubSQL-2 [9] UNABLE TO FLUSH TO FILE"
19- exit(EXIT_FAILURE) added to OSDClose() for any OSD failures.
20- Message changed. 
    old: "ubSQL-7 [8] WRONG PRE-LICENSE KEY."
    new: "ubSQL-10 [11] Invalid Base64 string length."
21- New error code: "ubSQL-7 [8] Wrong encoded string."
22- New error code: "ubSQL-3 [23] Wrong encoded password."
23- New error code: "ubSQL-10 [12] Invalid Base64 string length."
24- New error code: "ubSQL-7 [15] Wrong encoded string."
25- New error code: "ubSQL-3 [25] Wrong TNS alias."
26- ENCODE statement added.
27- Encoded password in CONNECT statement added.
28- Whitespace characters allowed and trimmed in username and password.

1- INPUT_BUFFER_COUNT parameter added; but not used.
2- USER_INTERFACE_PARAMETER_COUNT constant set to the available parameter count.
3- New parameter: OUTPUT_FILE_FORMAT; Values: TEXT, BINARY.
4- New error code: ubSQL-4 [32] "WRONG PARAMETER VALUE".
5- sColumnsInfo.isPiecedColumn commented out in ubSQL.h,OCIUtils.c,unload.c.
6- if columnDelimiterSize==1, column delimiter assigned directly, instead of memcpy().
7- sColumnsInfo.columnMaxSize renamed to sColumnsInfo.defineSize.
8- setDefineVariablesText() and setDefineVariablesBinary() added.
9- New error code: "ubSQL-8 [1] Unsupported column type"
10- New error code: "ubSQL-8 [2] Unsupported column type"
11- Message changed:
   old: printf("Data type of column %i....: UN-KNOWN\n",i);
        printf("External data type code...: %i\n",pUserInterface->columnsInfo->columnType[i-1]);
   new: printf("Column name.....: %s\n",&pUserInterface->columnsInfo->columnName[i*(COLUMN_NAME_SIZE+1)]);
        printf("Column type code: %i\n",pUserInterface->columnsInfo->columnType[i]);
12- Printing "Wait time" after unload removed.
13- Thread statistics added.
14- MIN_OUTPUT_FILE_SIZE of 512 defined.
15- New error code: "ubSQL-10 [0] WRONG FETCHED DATA SIZE"
16- New error code: "ubSQL-10 [1] FETCHED DATA SIZE OF NULL VALUE NOT ZERO"
17- New error code: "ubSQL-10 [2] WRONG FETCHED DATA SIZE"
18- New error code: "ubSQL-10 [3] WRONG FETCHED DATA SIZE"
19- New error code: "ubSQL-10 [4] UNKNOWN FETCHED DATA TYPE"
20- TextWriter renamed to writerThread.
21- Memory leaks in isSqlloaderControlFileOperation(),setMultipleParameter() resolved.
22- oracleLoader.c added.
23- New error code: ubSQL-2 [16] ddlFileName
24- Separate Environment Handle created for each ThreadSet.
25- indexOfString(),indexOfNoCaseString(),convertIntToCharArray(),findCharSize() added to utils.c.
26- New error code: "ubSQL-2 [17] WRONG LOCATION NAME"
27- New error code: "ubSQL-2 [18] WRONG LOCATION NAME"
28- New error code: "ubSQL-3 [0] DATA keyword in ACCESS PARAMETERS reserved"
29- New error code: "ubSQL-3 [1] CHARACTERSET keyword in ACCESS PARAMETERS reserved"
30- New error code: "ubSQL-3 [2] FIELDS keyword in ACCESS PARAMETERS reserved"
31- New error code: "ubSQL-3 [3] RECORDS keyword in ACCESS PARAMETERS reserved"
32- New error code: "ubSQL-3 [4] LANGUAGE keyword in ACCESS PARAMETERS reserved"
33- New error code: "ubSQL-9 [2] UNKNOWN ENDIANNESS"
34- New error code: "ubSQL-3 [7] TERRITORY keyword in ACCESS PARAMETERS reserved"
35- New error code: "ubSQL-3 [10] BYTEORDERMARK keyword in ACCESS PARAMETERS reserved"
36- New error code: "ubSQL-3 [16] STRING keyword in ACCESS PARAMETERS reserved"
37- BUG: If there are multiple OUTPUT_FILE_NAMES and last fetched rows are not equal to ARRAY_FETCH_ROW_COUNT, output buffer is overwritten.
38- New error code: "ubSQL-10 [5] FETCHED DATA SIZE OF NULL VALUE NOT ZERO"
39- New error code: "ubSQL-9 [2] Unsupported character set form"
40- New error code: "ubSQL-3 [17] CHARACTERSET keyword in PARAMETERS reserved"
41- New error code: "ubSQL-3 [20] BYTEORDERMARK keyword in PARAMETERS reserved"
42- New error code: "ubSQL-3 [19] BYTEORDER keyword in PARAMETERS reserved
43- New error code: "ubSQL-3 [18] LENGTH keyword in PARAMETERS reserved"
44- New error code: "ubSQL-3 [17] CHARACTERSET keyword in PARAMETERS reserved"
45- New error code: "ubSQL-3 [21] FIELDS keyword in PARAMETERS reserved"
46- New error code: "ubSQL-3 [22] No LOAD or CONTINUE_LOAD keyword found in PARAMETERS"
47- New error code: "ubSQL-2 [19] PARAMETERS truncated"
48- New error code: "ubSQL-10 [6] DATA keyword not found"
49- cleanUp.c added.
50- Message changed.
   old: "ubSQL-4 [18] THREADS_PER_OBJECT GREATER THAN ROWID RANGES."
   new: "ubSQL-4 [18] FETCH_THREADS parameter greater than rowid ranges."
51- Message changed.
   old: "ubSQL-4 [17] THREADS_PER_OBJECT GREATER THAN ROWID RANGES."
   new: "ubSQL-4 [17] FETCH_THREADS parameter greater than rowid ranges."
52- New error code: "ubSQL-4 [33] "Wrong REJECT LIMIT value."
53- M_PRINT_LOADER_COMMENTS added.
54- sqlldr.c renamed to sqlLoader.c
55- Removed error code: ubSQL-4 [10] "PARAMETER VALUE TOO BIG"
56- Parameter FETCH_THREADS renamed to THREAD_SETS.
57- sem_trywait() removed from M_OSD_SEM_TIMED_WAIT.
58- New error code: "ubSQL-10 [7] Wrong DATE size"
59- SQLT_TIMESTAMP_LTZ column type support removed.
60- New error code: "ubSQL-10 [8] WRONG OUTPUT BUFFER OFFSET"
61- New error code: "ubSQL-10 [9] WRONG OUTPUT BUFFER OFFSET"
62- New error code: "ubSQL-1 [8] UNABLE TO GET PAGESIZE"
63- New error code: "ubSQL-1 [9] REQUESTED MEMORY SIZE TOO LARGE"
64- New error code: "ubSQL-1 [10] UNABLE TO ALLOCATE ALLIGNED MEMORY"
65- New error code: "ubSQL-2 [0] UNABLE TO CHANGE FILE STATUS FLAGS"
66- New parameter: BYPASS_FILE_SYSTEM_CACHE; Type: Boolean
67- New error code: "ubSQL-2 [7] ubSQL not compiled with DIRECT-IO"
68- New error code: "ubSQL-2 [20] <fileName>"
69- New error code: "ubSQL-2 [24] UNEXPECTED WRITE ENCOUNTERED"

1- Memory allocation for columnName variable in getColumnsInfo() removed.
2- "startup ubSHM" removed.

1- "startup ubSHM" added.
2- New error code: ubSQL-3 [16] "WRONG <parameter> TEXT".
3- New error code: ubSQL-3 [17] "WRONG <ubSHM> TEXT".
4- ubSHM.h created.
5- New error code: ubSQL-1 [8] "UNABLE TO OPEN ubDBC LIBRARY".
6- OCI_SUCCESS_WITH_INFO in checkError() returns TRUE.
7- MAX_MESSAGE_SIZE=512 defined for checkError().
8- setSessionParameters() in connectToDatabase does not return value.
9- ubSQL-6 [1] and ubSQL-6 [2] modified.
   old: "FETCHED DATA TRUNCATED OR NULL".
   new: "FETCHED DATA TRUNCATED".
10- MAX_SQL_TEXT_SIZE changed from UB1MAXVAL*30 to UB2MAXVAL.