Eric:
I don't know, but think you will have to export all of the data in the database, recreate it and then import the data back in so that it will be converted to UNICODE.
James Mckenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:32 AM
To: [email protected]
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Thanks, James!
But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database?
Thanks,
Eric
On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
>Eric:
>
>The initial database instance MUST be created allowing for unicode
>support or the database might no have the proper support. I would
>consult the Oracle Installation Guide for further information. ARS can
>only use what the database provides it.
>
>James McKenzie
>
>
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:[email protected]] On Behalf Of Eric Zhang
>Sent: Wednesday, September 06, 2006 11:07 AM
>To: [email protected]
>Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
>
>Axton,
>
>Does it matter how you create your initial database when you use those
>environment vars for installation?
>
>Thanks,
>Eric
>
>On Wed, 6 Sep 2006 12:29:29 -0400, Axton <[EMAIL PROTECTED]> wrote:
>
>>I used the following env vars for the 7.0 installer on solaris 9 with
>>Oracle. This allowed me to do the install with the single-byte and
>>multi-byte support data (message catalog, etc.).
>>
>>NLS_LANG=american
>>LANG=en_US.UTF-8
>>LC_ALL=en_US.UTF-8
>>
>>Axton Grams
>>
>>On 9/6/06, Eric Zhang <[EMAIL PROTECTED]> wrote:
>>> James,
>>> English is the base language.
>>> Thanks,
>>> Eric
>>>
>>> On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
>>> HQISEC/L3 <[EMAIL PROTECTED]> wrote:
>>>
>>> >Eric:
>>> >
>>> >What language are you using as the base language? I may have a
>>> suggestion.
>>> >
>>> >James McKenzie
>>> >
>>> >
>>> >-----Original Message-----
>>> >From: Action Request System discussion list(ARSList)
>>> >[mailto:[email protected]] On Behalf Of Eric Zhang
>>> >Sent: Wednesday, September 06, 2006 8:36 AM
>>> >To: [email protected]
>>> >Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
>>> >
>>> >Hello, All!
>>> >
>>> >I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am
>>> having a
>>> >couple of issues:
>>> >
>>> >1. If we don't get ARSystem table space created prior to the
>installation,
>>> >we get the following error:
>>> >
>>> >"An unknown Oracle error has been detected.
>>> >Please resolve this error and re-try the installation.
>>> >Refer to /tmp/arDBErrorLog for the Oracle error information."
>>> >
>>> >I checked /tmp/arDBErrorLog, it only has a time stamp, no other
>>> >error details.
>>> >
>>> >After the DBA created ARSystem table space, we were able to move on
>with
>>> the
>>> >installation. Remedy Tech Support recommends not to create
>>> >ARSystem
>prior
>>> >to installation. If you have done ARS 7 installation with Oracle
>10gR2,
>>> did
>>> >you have to create ARSystem table space prior to installation?
>>> >If you didn't create ARSystem table first, what's the default table
>space
>>> >for ARAdmin?
>>> >
>>> >
>>> >2. We got the following after we chose to use UNICODE:
>>> >
>>> >"Selecting UNICODE to create or overwrite an existing Oracle
>>> >tablespace REQUIRES that the database already be configured to
>>> >support the
>AL32UTF-8
>>> >UNICODE character set.
>>> >
>>> >If you are upgrading an existing database to use UNICODE, the
>>> >database
>>> must
>>> >already be configured to support the UNICODE character set.
>>> >
>>> >Do you want to use the UNICODE character set? [n] y
>>> >
>>> >*** Your current locale (C) is not Unicode and you are asking for
>>> >*** a Unicode install. Please adjust your LANG and LC_ALL variables.
>>> >
>>> >*** You can either change your UNICODE option or abort the
>>> >*** installation to adjust your LANG and LC_ALL variables.
>>> >Do you want to abort the installation? [n]"
>>> >
>>> >I couldn't move on with the installation because it keeps asking
>>> >the
>same
>>> >question as above if I choose not to abort the installation. I had
>>> >to
>>> abort
>>> >installation.
>>> >
>>> >I discussed this with my DBA and he sent me the database creation
>>> >SQL statement as following:
>>> >
>>> >CREATE DATABASE "rmdytst1"
>>> >MAXINSTANCES 8
>>> >MAXLOGHISTORY 1
>>> >MAXLOGFILES 16
>>> >MAXLOGMEMBERS 3
>>> >MAXDATAFILES 100
>>> >DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M
>>> >REUSE
>>> EXTENT
>>> >MANAGEMENT LOCAL SYSAUX
>>> DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
>>> >SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP
>>> >TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE
>>> >SMALLFILE
>UNDO
>>> >TABLESPACE "UNDOTBS1"
>>> >DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M
>>> >REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
>>> >
>>> >Is character set specified in the SQL statement correct for UNICODE?
>If
>>> >not, what's the right SQL statement? My DBA thinks that AL32UTF-8
>>> >is a subset of UTF8, but should he change it to AL32UTF-8 during
>>> >the initial database creation?
>>> >
>>> >
>>> >Thanks in advance for your help.
>>> >
>>> >Eric Zhang
>>> >Entergy Services, Inc.
>>> >501-377-5815
>>> >
>>>
>>______________________________________________________________________
>>_
>>___
>>> __
>>> >___
>>> >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>> >
>>>
>>______________________________________________________________________
>>_
>>___
>>> _____
>>> >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>> >
>>>
>>>
>_______________________________________________________________________
>___
_
>____
>>> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>>
>>
>>______________________________________________________________________
>>_
>>___
>_____
>>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>======================================================================
>>=
>>==
>
>_______________________________________________________________________
>___
__
>___
>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>_______________________________________________________________________
>___
_____
>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
