Eric:
If you are staying within English, then the language MIGHT BE en_US.UTF8. If you want to use other languages, you will have to set the database up for 16 bit UTF. I don't know if 32 bit UTF is supported or not.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 9:00 AM
To: [email protected]
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
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
