connecting developer 2000 to existing database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • julietmachiwa
    New Member
    • Oct 2007
    • 14
    #1

    connecting developer 2000 to existing database

    I have an existing database 8i . I just installed Developer 2000 for Windows NT
    I am failing to connect to the database.

    How should I configure it?

    I tried using SQL Net Easy Configuration and Also changed tnsnames.ora

    but I am getting error "invalid or unknown NLS parameter value specified" when connecting to SQL PLUS 3.3 or Forms

    Please help
    Tags: None
    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358
      #2
      Originally posted by julietmachiwa
      I have an existing database 8i . I just installed Developer 2000 for Windows NT
      I am failing to connect to the database.

      How should I configure it?

      I tried using SQL Net Easy Configuration and Also changed tnsnames.ora

      but I am getting error "invalid or unknown NLS parameter value specified" when connecting to SQL PLUS 3.3 or Forms

      Please help
      It's likely a missing NLS-LANG setting in your Windows PC client registry. The NLS_LANG variable is in the Home0 directory in the Windows registry is not the only NLS_LANG, and you need to locate the Oracle directory in the registry and find NLS_LANG. This variable may be set to "NA", and a change to AMERICAN_AMERIC A.WE8ISO8859P15 may fix your connectivity issue.

      Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

      Action: Check the syntax of the ALTER SESSION statement and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.

      Follow the below steps:

      1. Go to regedit
      2. Go to path /HKEY_LOCAL_MACH INE/SOFTWARE/ORACLE/HOME0
      3. Change the variable NLS_LANG as mentioned above (either to NA or AMERICAN_AMERIC A.WE8ISO8859P15 )

      This should help!!

        Comment

        • julietmachiwa
          New Member
          • Oct 2007
          • 14
          #3
          connecting developer 2000 to existing database

          Tried changing redit Still its giving same error

            Comment

            • julietmachiwa
              New Member
              • Oct 2007
              • 14
              #4
              Originally posted by amitpatel66
              It's likely a missing NLS-LANG setting in your Windows PC client registry. The NLS_LANG variable is in the Home0 directory in the Windows registry is not the only NLS_LANG, and you need to locate the Oracle directory in the registry and find NLS_LANG. This variable may be set to "NA", and a change to AMERICAN_AMERIC A.WE8ISO8859P15 may fix your connectivity issue.

              Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

              Action: Check the syntax of the ALTER SESSION statement and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.

              Follow the below steps:

              1. Go to regedit
              2. Go to path /HKEY_LOCAL_MACH INE/SOFTWARE/ORACLE/HOME0
              3. Change the variable NLS_LANG as mentioned above (either to NA or AMERICAN_AMERIC A.WE8ISO8859P15 )

              This should help!!
              Still giving same error after having done the above

                Comment

                • amitpatel66
                  Recognized Expert Top Contributor
                  • Mar 2007
                  • 2358
                  #5
                  Check here for more details

                    Comment

                    • amitpatel66
                      Recognized Expert Top Contributor
                      • Mar 2007
                      • 2358
                      #6
                      What to consider when setting NLS_LANG:

                      a) The variable needs to be in Uppercase on Unix Systems.

                      b) If there is any mistake in the value setting of this variable (eg: a spelling mistake), you may encounter the ORA-12705.
                      For a list of valid languages, territories and character sets the relevant
                      National Language Support Guide for your version should be consulted.

                      c) Completely unsetting the NLS_LANG will use the default value, that is AMERICAN_AMERIC A.US7ASCII.
                      This should always fix the ORA-12705, however we strongly advice to set the NLS_LANG,
                      because we are only dealing correctly with characters that can be represented completely with 7 bits.
                      As soon as special characters (usually stored using the 8th bit) are used, this will result in conversion problems.

                      Format of NLS_LANG:

                      LANGUAGE_TERRIT ORY.CHARACTERSE T

                        Comment

                        • debasisdas
                          Recognized Expert Expert
                          • Dec 2006
                          • 8119
                          #7
                          Both the threads are merged for better management of the forum.

                            Comment

                            Previous template Next
                            Working...