5 Replies Latest reply: May 3, 2012 3:36 AM by Dude! RSS

    Installing Oracle 11g Express edition

    928569
      Hi All,

      Once I try to install oracle 11g xe in my machine its taking nls parameters by default. I need to customize it before creating the DB using express editon. Please help.

      Thanks,
      Uday
        • 1. Re: Installing Oracle 11g Express edition
          sb92075
          Oracle wrote:
          Hi All,

          Once I try to install oracle 11g xe in my machine its taking nls parameters by default. I need to customize it before creating the DB using express editon. Please help.
          WHY?

          Why can't NLS get changed after the installation has completed?
          • 2. Re: Installing Oracle 11g Express edition
            928569
            As per my understanding this should be setup during the creation of deployment.. I need to reset the NLS_DATABASE_PARAMETER NLS_LENGTH_SEMANTICS TO CHAR instead of BYTE by default. Please help me on the same.

            Edited by: Oracle on May 2, 2012 3:24 PM
            • 3. Re: Installing Oracle 11g Express edition
              Mark Malakanov (user11181920)
              Hey Oracle, according to your nick you should know all better than anybody here. ;)
              • 4. Re: Installing Oracle 11g Express edition
                Tubby
                Oracle wrote:
                As per my understanding this should be setup during the creation of deployment.. I need to reset the NLS_DATABASE_PARAMETER NLS_LENGTH_SEMANTICS TO CHAR instead of BYTE by default. Please help me on the same.

                Edited by: Oracle on May 2, 2012 3:24 PM
                http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG235

                "
                Caution:
                Oracle strongly recommends that you do NOT set the NLS_LENGTH_SEMANTICS parameter to CHAR in the instance or server parameter file. This may cause many existing installation scripts to unexpectedly create columns with character length semantics, resulting in runtime errors, including buffer overflows.
                "
                • 5. Re: Installing Oracle 11g Express edition
                  Dude!
                  What are you trying to accomplish?

                  Changing the database character set for an existing database is called character set migration. Oracle Database XE is available only in Universal multi-language character set AL32UTF8, which is suitable for global data in any language.