US7ASCII supports 7 bit characters. For US English users in the United States, this could suffice. If you are going anywhere other try WE8ISO8859P1 character set it supports most Europeen languages. This is the Oracle default character set and can support 8 bit characters.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 1:14 PM To: [email protected] Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Carin, A quick query shows: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 So, what values should we set for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET to support UNICODE? Thanks, Eric On Wed, 6 Sep 2006 10:47:48 -0500, Sinclair, Carin <[EMAIL PROTECTED]> wrote: >Eric, > >Make sure your oracle db character set is set for Unicode > >select * from v$nls_parameters where parameter in >('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); > >If not set it and then try the install >Carin > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang >Sent: Wednesday, September 06, 2006 10: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
