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: arslist@ARSLIST.ORG >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