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
