Hello list, We are finally getting to upgrade our 7.6.04 SP5 servers. I’m not sure about going all the way to 9 just yet so I’m targeting 8.1.2 for now.
When I run the installer to upgrade on a test server I get the following error: The underlying database <ORACLE_SID> is a Unicode database, but your AR server is configured as Non-Unicode. These inconsistent settings may result in data corruption. Contact BMC Support (go to http://www.bmc.com/support). Before I contact support does anyone know what setting(s) I need to change to allow the install to go thru? The setup has been running since at least 2011 We are using Oracle 11g From the query: select value from v$nls_parameters where upper(parameter) = 'NLS_NCHAR_CHARACTERSET'; It appears we have the database running as AL16UTF16 The AR System app servers are on Red-Hat Linux and have: LANG=C LC_ALL=C (There is no environment variable set for NLS_LANG) An "arsystem env" reports the following: CLIENT_LOCALE=en_us.8859-1 LANG=C LC_ALL=C ORA_NLS=/apps/remedy/oracle/product/11.2.0/nls/data Since we are in the US we know there is no multi-byte data in the database. I think the way we got into this was: System was installed as ARS 7.1, Oracle Client 10, Oracle Server 10g (on remote server) System was upgraded to ARS 7.6.04, Oracle Client 11, Oracle Server 10g (on remote server) Database was upgraded to Oracle 11g (by installing new Oracle instance on new db server, Oracle DataPump to move data over, server alias moved to new db server). No changes to ARS app or Oracle Client. Fred _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"