You can manually specify the properties for the log files by editing the configuration properties in the agent installation folder.

You can perform this task for all the logs except the Windows events.

1. If you want to apply the properties on specific patterns and / or log sources, then make a note of the pattern ID and the source ID. Open the config xml file under the agent installation folder agent_inst/state/laStorage/os_file/os_file.xml.

   • Pattern ID example: <Pattern id="495071102827757094" name="/tmp/w*.mgr" include="true">
   • Source ID example: <LogSource id="-2574377491167724513" name="SS Concurrent Manager Logs" sourceType="os_file"/>

   The agent installation folder location varies depending on the source type. For example, the location is agent_inst/state/laStorage/database_sql/database_sql.xml for SQL Database.

2. Edit the properties file emd.properties in the location agent_inst/config/emd.properties and add the following property to override the default configuration of Oracle Logging Analytics:

   loganalytics.src.override_config=true
       

3. Specify the time zone tz and character encoding enc properties in the file emd.properties by selecting from one of the following examples:

   • Apply the properties for all the sources and patterns:

     loganalytics.src.addl_src_ptn_configs=tz=UTC,enc=EUC-JP

   • Apply the properties only for specific log sources:

     loganalytics.src.addl_src_ptn_configs=srcid=-2574377491167724513,tz=UTC,enc=EUC-JP;srcid=-2574377491167724512,enc=UTF-8

     In this example, the time zone UTC and character encoding EUC-JP properties are applied for the source -2574377491167724513, and character encoding property UTF-8 is applied for the source -2574377491167724512.

   • Apply the properties only for specific patterns:

     loganalytics.src.addl_src_ptn_configs=ptnid=495071102827757094,tz=UTC,enc=EUC-JP;ptnid=495071102827757095,enc=UTF-8

     In this example, the time zone UTC and character encoding EUC-JP properties are applied for the pattern 495071102827757094, and character encoding property UTF-8 is applied for the pattern 495071102827757095.

   • Apply the properties only for a combination of specific patterns and sources:

     loganalytics.src.addl_src_ptn_configs=srcid=-2574377491167724513,ptnid=495071102827757094,tz=UTC,enc=EUC-JP;srcid=-2574377491167724513,ptnid=495071102827757095,enc=UTF-8

     In this example, the time zone UTC and character encoding EUC-JP properties are applied for logs with the pattern 495071102827757094 and the source -2574377491167724513, and character encoding property UTF-8 is applied for logs with the pattern 495071102827757095 and the source -2574377491167724513.

You can customize the SQL collection schedule for each of your database log sources by specifying the periodicity in a CSV file in the format specified below.

1. Navigate to the Management Agent or Oracle Cloud Agent install directory on your database host, for example agent_inst. Create a directory laconfig in the agent install directory.

2. In laconfig directory, create a CSV file logan_schedule_database_sql_*.csv. This is the schedule configuration file.

3. In the schedule configuration file, provide the details of the source schedule in the following format:

   NAME,RECURRENCE_PATTERN_UNIT,RECURRENCE_PATTERN_VALUE,START_HOUR
   <Source-Name>,DAY,1,1

   The header row must have the prescribed content: NAME,RECURRENCE_PATTERN_UNIT,RECURRENCE_PATTERN_VALUE,START_HOUR

   In the subsequent rows, specify the schedule for each source, one per row.

   The header row parameters and their values:

   Header Row Parameter	Description	Allowed Values
   NAME	The name of the database log source defined in Oracle Logging Analytics.	Any
   RECURRENCE_PATTERN_UNIT	This is the unit of cadence of SQL collection, for example, minutes or days. WEEK and MONTH can have multiple values separated by :	MIN: minutes HOUR: hours DAY: days WEEK: weeks MONTH: months
   RECURRENCE_PATTERN_VALUE	The value of the pattern unit you selected.	MIN: interval 5 min, 15 min HOUR: interval 1 hour DAY: daily running at 1, or 12 WEEK: SUN, MON, TUE, WED, THU, FRI, SAT MONTH: date 1-31, LAST day of the month
   START_HOUR	The start hour for SQL collection, for example, 0100 hrs or 1200 hrs. If this value is not specified, then the SQL collection begins immediately after source-entity association. Note that, even if the value is not specified, the preceding comma must be present in the row for the schedule to be valid.	1 or 12.

4. After saving the CSV file, restart the agent.

Some of the example values for the schedule configuration:

By default, when you collect logs by using Management Agent, the collection is not enabled from folders having more than 10000 files. However, you can enable it by making the following configuration changes.

You can manually edit the configuration property loganalytics.enable_large_dir to true in the agent installation folder to enable the collection of logs from folders having more than 10000 files. By default, the property value is false.

Edit the properties file emd.properties in the location agent_inst/config/emd.properties and add the following property to override the default configuration of Oracle Logging Analytics:

loganalytics.enable_large_dir=true

Restart the management agent after editing the file emd.properties.

Use the ignore-case macro (?i) in the log file path pattern to interpret it in the case-insensitive form. This is applicable for log file path pattern provided in log sources of the type File .

The macro (?i) will be applied only when it is in the start of the element of the path.

Consider the example:

/tmp/(?i)FOO/*.log

In the above example, the element of the path which follows the macro is FOO. This is interpreted in the case-insensitive form.