Also, if the installer exits at this point, then it didn't complete
successfully.
#################################################
Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006
./ar_install: test: unknown operator dbVersion
#################################################
The installer dies at this point:
In the stage 6 of the install script:
12299 # Import required and selected plugins
12300 ImportPlugins
12301 ImportFlash
Now in the importFlash function:
3279 ##############################################################
3280 # ImportFlash - Upgrade and import FlashObject Forms
3281 #
3282 ##############################################################
3283 ImportFlash()
3284 {
3285 lecho "Installing Flash Objects: `date` "
3286 lecho
3287 SAMPLE_FORMS="$INSTALL_DIR/samples/en"
3288 $CD $SAMPLE_FORMS
3289
3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
3291 LoadSchemaWithRIK FlashForms "${IMPORT_MODE}"
"${UPGRD_USER}" "${UPGRD_PASS}"
3292 if [ $? -ne 0 ]; then
3293 lecho "FlashForms failed to import."
3294 lecho "Problems encountered while importing the
form FlashForms.def"
3295 lecho "Please refer to the log in
$INSTALL_DIR/Logs/ for further details."
3296 else
3297 note "FlashForms successfully installed."
3298 fi
3299 fi
From the output, I can tell that the first line of this function ran.
In the ArEnvHistory file, these are the values of the vars used in the
if statement:
DB_UPGRADE=0
ARS_VER=select dbVersion from control
Obviously the if statement can't handle the sql statement.
Below is a 'sloppy' hack to get new installs (only) to complete successfully.
[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem> diff
-u ar_install.bak ar_install
--- ar_install.bak Mon Jul 24 10:41:19 2006
+++ ar_install Mon Jul 24 21:36:28 2006
@@ -11780,6 +11785,7 @@
############################################
# Stage 6 : Set up sample forms and Demo
############################################
+ARS_VER=0; export ARS_VER
STAGE=6
LogOnly "Stage 6: `date`"
if [ $FRESH_INSTALL -eq 1 ]; then
Axton Grams
On 9/6/06, Axton <[EMAIL PROTECTED]> wrote:
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
