These character set must match in these places. Ar.conf Character Set NLS_LANG What is given during oracle client and server setup
If i understood it correctly there is some problem during db setup as you said you have not changed anything at AR side -----Original Message----- From: "Grooms, Frederick W" <frederick.w.gro...@xo.com> Sent: 01-07-2015 11:54 PM To: "arslist@ARSLIST.ORG" <arslist@ARSLIST.ORG> Subject: ARS Install 8.1 Unicode/Non-Unicode 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"