brconnect problem......

[Former Member]

Im getting below error when trying to initiate backup with DB13.

BR0801I BRCONNECT 6.40 (26)

BR0805I Start of BRCONNECT processing: cduyqhtg.chk 2007-04-03 15.32.00

BR0280I BRCONNECT time stamp: 2007-04-03 15.32.00

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance QAS failed

BR0280I BRCONNECT time stamp: 2007-04-03 15.32.00

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance QAS failed

The NLS_LANG variable is set as NLS_LANG=AMERICAN_AMERICA.WE8DEC. OS is Solaris 5.9.

please help me with solution......

[Former Member]

Hi,

In your case pl check the following points.

If an error occurs when you call an SAPDBA operation from DB13 during the implicit call from SQLPLUS, this happens because the <sid>adm user is used to call SAPDBA within DB13. This is no longer possible when you use Oracle 9.2 or higher. In this case, see Note 403704 and convert DB13 to the use of BRCONNECT.

If several Oracle 9.2 or higher databases are installed on a computer and they use a different patch set, the CROCLLNK links should always indicate the installation with the lowest patch. If any of the errors nevertheless persist, set the following environment variables:

BR_ORA_NLS33 = /oracle/client/92x_<bits>/ocommon/nls/admin/data

This causes the BR tools to definitely use the NLS files of the client software and not the NLS files from an Oracle home which may not be compatible with the client software.

Note that this environment variable can only be used as of BR tools 6.20 patch level 113.

To exclude errors such as ORA-12705 to the greatest possible extent (irrespective of the actual NLS files used), you can set the following environment variables (Note 540021):

NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM

NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM

This is extracted from SAPNote 592657.

Pl dont forget to award suitable points.

Regards

[former_member618758]

Hello there,

Firstable if you have Oracle 9.2 you should try to get to to at least 9.2.0.7 or later for both database and client.

One fastest solution, you can try set the env variable:

BR_ORA_NLS33 = /oracle/client/92x_<bits>/ocommon/nls/admin/data

You can put in the dbenv or any of the start env file and restart db and sap. After this it should work.

Thanks,

George