Dmitry,
We have been trying to do the upgrade using the Oracle Import Tool.
We continually get errors during the stage where:
1. Oracle Unicode DB set up on new server
2. Use Oracle to import 6.3 data and forms to new Unicode Server.
3. Attempt to run the ARS installer with upgrade option - This errors
with a DB version not found error.
Can you provide more detail as to the steps you took and possible a
copy of your config setting?
We were working with Remedy support for several months on this. They
were unable to assist us and when they failed, they fell back to the
"we don't support this" line.
We followed there instructions verbatim, but cannot get beyond the
database version error.
Any further details would be greatly appreciated.
This a more detailed explanation of what we have done and the errors
we are getting: VVVVVVV
1 >> Yes, we are testing with v6.3 database schema from your
production server that has been imported to a Unicode database
REMEDY10:
SQL> l
1* select parameter, value from v$nls_parameters where parameter
like '%CHAR%'
SQL> /
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
AL32UTF8
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_NCHAR_CONV_EXCP
FALSE
SQL>
ARS 6.3:
SQL> l
1* select parameter, value from v$nls_parameters where parameter
like '%CHAR%'
SQL> /
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
UTF8
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_NCHAR_CONV_EXCP
FALSE
2 >> 1) export of non-unicode ARServer database schema -DONE
2) import of this database schema into unicode Oracle database -
DONE
3) running install against database schema that was imported to
unicode Oracle database - DONE
3 >> Locale of the shell where installer is running:
# LANG=en_US.UTF-8
# export LANG
# LC_CTYPE=en_US.UTF-8
# export LC_CTYPE
# LC_NUMERIC=en_US.UTF-8
# export LC_NUMERIC
# LC_TIME=en_US.UTF-8
# export LC_TIME
# LC_COLLATE=en_US.UTF-8
# export LC_COLLATE
# LC_MONETARY=en_US.UTF-8
# export LC_MONETARY
# LC_MESSAGES=en_US.UTF-8
# export LC_MESSAGES
# LC_ALL=en_US.UTF-8
# export LC_ALL
# locale
LANG=en_US.UTF-8
LC_CTYPE=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
LC_MONETARY=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_ALL=en_US.UTF-8
# locale -a | grep en_US
en_US
en_US.ISO8859-1
en_US.ISO8859-15
[EMAIL PROTECTED]
en_US.UTF-8
#
4 >> I deleted all install logs from /usr/tmp dir.
5 >> downloaded a new install pack from dbc support site
6 >> unzipped and untared it into different folder
7 >> ran the installer and it's terminated in the same place as
before. Here is the error message:
Starting the AR System Server: Fri Jan 11 12:39:47 EST 2008
server: locale=[[ en_US.UTF-8 ]],
LANG=[[ en_US.UTF-8 ]] NLS_LANG=[[ american_america.AL32UTF8 ]]
Action Request System(R) Server Version 7.1.00 Build 200708221849
(c) Copyright 1991-2007 BMC Software, Inc.
390600 : The database is not the expected version (may need to run
upgrade program) (ARERR 36) 390600 : AR System server terminated --
fatal error encountered (ARNOTE 21)
***********************************************************************************
On Jan 17, 2:44 am, Dmitry Bezhenar <[EMAIL PROTECTED]>
wrote:
> Hi Roger,
>
> We've done such migration, but with oracle v9.2i not 10g.
> We had a quiet big application (thousands of ALs, filters etc..) based on
> ITSM v6.
>
> In the beginning we tried using Migrator for this purpose, but there were too
> many different errors using it. So we performed migration using Oracle
> import/export tool.
>
> Regards,
> Dmitry.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:[EMAIL
> PROTECTED] On Behalf Of Roger
> Sent: 16 January 2008 21:28
> To: [EMAIL PROTECTED]
> Subject: upgrade of ars 6.3 Solaris/Oracle 10g to 7.0.1 Solaris/Oracle10g
> Unicode
>
> Has anyone completed a upgrade from 6.3 non unicode Oracle 10g Db to
> 7.0.1 Unicode, using the Oracle Import Tool?
>
> Has anyone done the same upgrade using Migrator as Remedy recommends?
>
> I would love to get clarification on the success and steps involved
> with each method.
>
> Thanks,
>
> Roger
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.5/1228 - Release Date: 16/01/2008
> 09:01
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.5/1228 - Release Date: 16/01/2008
> 09:01
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
