Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Oracle (Linux) › Configuring the agent.cfg and sbt.cfg Files › Set the NLS_LANG Parameter

Set the NLS_LANG Parameter

When the Arcserve Backup Agent for Oracle calls the SQL*Plus to get the JPN datafile name from the oracle database. Sometimes it gives garbage characters "???.dbf" and the Arcserve database fails to catalog the tablespace name.The Agent fails to catalog the tablespace when the client character set is unable to identify the character set of the oracle databases.

You can avoid this by setting the NLS_LANG variable before performing a backup or restore operation, since the commented NLS_LANG is written to the agent.cfg file of the Agent. You must also uncomment the NLS_LANG parameter and set the value and then restart the common agent to perform the backup and restore operations as shown in the following examples:

Example 1

After you configure the Agent by running the orasetup script, the following line appears in the agent.cfg file:

#ENV NLS_LANG=American

To enable this parameter, you should uncomment it by changing the content after “=”. Now set the value of your choice and run the caagent update to sync the content with the common agent.

Example 2

To set the NLS_LANG parameter for Oracle in JAPANESE environment

1. Select the Oracle server character setting using the SQL*Plus, and ensure that the server character is using AL32UTF8.
2. You can then add the following setting to the Agent.cfg file for the Agent.

   NLS_LANG=AMERICAN_AMERICA.AL32UTF8
   

3. Now call the caagent update to refresh the setting.

   The parameter is set.

More information:

The agent.cfg Configuration File