This is the way our instance was built.
SQL> select * from v$nls_parameters where parameter in
2 ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
PARAMETER VALUE
----------------------- -----
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
Axton Grams
On 9/6/06, Eric Zhang <[EMAIL PROTECTED]> wrote:
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: arslist@ARSLIST.ORG
>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: 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
>>=======================================================================
>>==
>
>__________________________________________________________________________
__
>___
>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
