NLS_LANG to American_America.AL32UTF8 is correct. Also look at the LANG, ARLANG, and LC_* env vars. Not sure ARLANG was introduce in 6.3 or 7.x since I skipped 6.3.
I did a UTF8 conversion of Oracle8i during our 6.0.1 upgrade, but never had these issues. You may want to investigate the behavior of the conversion utility you are using, and how it handles character conversion for non 7bit ascii characters, make sure this is in line with what remedy expects. Did you read up on the ar.conf settings? There is at least one that has to be set to UTF8. Axton Grams On 11/24/06, Bezhenar, Dmitry <[EMAIL PROTECTED]> wrote:
** Hello Axton, ARADMIN.FIELD_DISPPROP - I enlarged the column size of the PROPSHORT column. That's all. :) Also I had to rebuild some indexes - SYS.I_COL1 OE.CUST_EMAIL_IX ARADMIN.ACTLINK_IND ARADMIN.ARCTR_IND ARADMIN.CHAR_MENU_IND ARADMIN.FILTER_IND ARADMIN.I2725_706000322_1 ARADMIN.I2920_536870913_1 ARADMIN.I2921_536870913_1 ARADMIN.I832_536870916_1 When I try to view contents of the database I see some strange values - �DERUNG (should be ÄNDERUNG). I suppose some European characters did not convert correctly. arerror.log contents - ORA-00020: maximum number of processes (%s) exceeded 390600 : Verbindung mit SQL-Datenbank kann nicht initialisiert werden. (ARERR 551) Stop server 390600 : AR System-Server wurde beendet - Schwerwiegender Fehler ist aufgetreten (ARNOTE 21) Also I've set NLS_LANG to American_America.AL32UTF8. Is it correct? Thank you. Kind Regards Dmitry Bezhenar ------------------------------ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* Friday, November 24, 2006 12:01 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: After converting charset in Oracle (WE8ISO8859P15 -> AL32UTF8) ARS service can not start ** arerror.log and arapi.log output would be extremely helpful. There are some ar.conf values that need to be set to use a unicode db. Something like Db-Character-Set. "...and I just enlarged column sizes" What tables/columns? Axton Grams On 11/24/06, Bezhenar, Dmitry <[EMAIL PROTECTED] > wrote: > > Hello List, > > another Oracle question. > I am now in process of converting the charset in our Oracle database > from WE8ISO8859P15 to AL32UTF8. > The procedure is mostly similar to the following description - > > *Character Set Scanner utility* > > though the change from US7ACII to UTF8 could be done with only using the > 'alter database command' we will use the character set scanner utility > CSSCAN to scan for any change required. > > *Installing the CSSCAN schema. > * > Before using the cssan you must install the schema as a user with DBA > privileges. This is done by executing the csminst.sql script located at > $ORACLE_HOME/rdbms/admin > > cd $ORACLE_HOME/rdbms/admin > $sqlplus "/ as sysdba" > > SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 17 16:00:16 2006 > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > Connected to: > Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.6.0 - Production > SQL> START csminst.sql > > *Executing CSSCAN* > > The CSSCAN executable is located at the $ORACLE_HOME/bin. After > executing the script you must connect to the Database as a user with DBA > privileges. The CSSCAN utility prompts you with options to scan a table, > schema or the enter database. We choose to scan the entire database in our > case. > > The CSSCAN displays your current character set version and prompts you > to enter the new character set version. > > > $ csscan > Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue Oct > 17 16:03:15 2006 > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > Username: system > Password: > Connected to: > Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.6.0 - Production > > > (1) Full database, (2) User, (3) Table: 1 > 1 > Enter new database character set name: > UTF8 > Enter number of scan processes to utilize (1..32): 1 > > > > After the successful completion of the scan three report files will be > created scan.txt, scan.out and scan.err. > > In my case I have exported the database objects with exceptions as > specified in the scan.out and plan to import it back after the database > conversion is done. > > > *Changing the Character Set at Database Level* > > > Shutdown all application services and the database and listener. You > must do a clean shutdown of your database and start it up in restricted mode > before changing the character set. Also you must not have any active > sessions before issuing the alter database command. > > SQL> alter database character set internal_use UTF8; > alter database character set internal_use UTF8 > > *Import Back Database Objects.* > > After a successful character set conversion at the database level now > you can import back the objects and rebuild the indexes specified the in > scan.out report. > > I've searched for all the objects that are not convertible using this > csscan utility, modified these objects (mostly it was "exceed column size" > error and I just enlarged column sizes). Then I switched the charset (alter > database character set internal_use UTF8). The database seemed to work > fine. So I started the ARS service. But the service did not start. > > There are two possible explanations - > > 1. The procedure described above is not right. It is not possible to > upgrade the database to Unicode this way. If so, what is a right procedure? > > 2. I need to change something in ARS configuration files also. ARS can > not connect to a database with another char set so easily. If so, what > should I correct in ARS? > > > > Thank you for your assistance. > > I tried to find the procedure of switching/upgrading to Unicode within > ARS manuals with no success. > > > > Environment: > > > > Oracle 9.2 + ARS 6.3 on a Win2003 platform. This is our test/development > server. I will have to switch our productive one (ARS 6.3 + Oracle 9.2 + > Solaris 9) later on also. > > > > Kind regards > Dmitry Bezhenar > __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
