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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
