Skip to Content
avatar image
Former Member

Backup failed: connect to database instance failed

Hi Experts,

The backup in our quality system is getting failed with the following error.

BR0301E SQL error -12705 at location BrDbConnect-2

ORA-12705: invalid or unknown NLS parameter valuespecified

BR0310E Connect to database instance QAS failed

Please help me on this.

Regards,

Surendra.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 28, 2009 at 11:10 AM

    Hi,

    Please refer OSS Note 393620 - Problems through incorrect ORA_NLS33.

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Surendra,

      Please refer this [SAP Note 602843 - Environment settings for R/3/Oracle on UNIX|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=602843].

      The client communicates the information defined by NLS_LANG to the server when it connects to the database server. It just sets the local and territory settings.The ora-12705 error is just due to the wrong setting for this variable or a mismatch of character-set.

      The problem is caused by the path missing of NLS messeages in Oracle 9.2.0.8. A new variable ORA_NLS33 should be set in the system environment.

      e.g.

      $ export NLS_LANG=AMERICAN_AMERICA.UTF8
      $ export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

      I hope this information will be useful.

      Regards,

      Bhavik G. Shroff

  • avatar image
    Former Member
    Oct 28, 2009 at 09:37 AM

    Check environment variables of the user who is running brbackup; values will depend on your Oracle version.

    But first make sure you are using the correct operating system user, ora<sid> in case of Unix, or <sid>adm in case of Windows.

    Add comment
    10|10000 characters needed characters exceeded