See
http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics#Fresh_Install_Message_Catalog_Data_Import_Failure
for another issue with solaris/oracle install issues if you plan to do
a fresh install with all language packs.
Axton Grams
On 9/6/06, Axton <[EMAIL PROTECTED]> wrote:
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: [email protected]
> >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: [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
> >
> >__________________________________________________________________________
> _____
> >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
