Your database is not Unicode, it's using an Arabic character set - AR8ISO8859P6 - this would be AL32UTF8 if it was Unicode. If you really need a Unicode system you'll probably have to perform a clean install of ARS against a Unicode database and migrate your data.
Mark From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Fatima Sent: 06 July 2010 14:59 To: [email protected] Subject: ARS 7.5 patch 5 Upgrade ** Hi everyone, We are upgrading from ARS 6.3 on: - Solaris 10 - Oracle 9i - Apache Tomcat 5.5.26 to ARS 7.5 on: - Solaris 10 - Oracle 10g - Apache Tomcat 5.5.29 The Oracle upgrade from 9i to 10g went fine. We upgraded ARS 6.3 to ARS 7.1 fine. With the ARS 7.5 patch 5 installer, we get an error indicating that our underlying database is not Unicode but ARS is configured as Unicode. Although our database is Unicode, our NLS Parameters are as follows: SQL> SELECT * FROM V$NLS_PARAMETERS; PARAMETER VALUE ---------------------------------------------------------------- ---------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_CHARACTERSET AR8ISO8859P6 NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE Does anyone know exactly which parameters does the installer check to know if the database is Unicode or not, so we can ensure they are set correctly. The OS LANG and NLS_LANG parameters are not set, do they need to be set to any specific value? The weird thing is that the ARS 7.5 patch 3 installer runs smoothly without this error, but we prefer to go to patch 5. Thanks, Fatima Amin _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
