|Character Set Migration using CSSCAN and CSALTER - Change the default character set of your database using the character set scanning utilities provided by Oracle.|
Mario said...I think that it would be better add a note that talk about the file scan.txt with the results of the first step.
Mario said...you have to verify that no user are connected (es. sysman).
Be sure that EM is down (emctl stop dbconsole)
Tim... said...I think you're getting into the obvious here!
Mario said...I'm sorry for the obvious ... I have another note for you. If you change charset you can find this error message in the alert.log:
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
see metalink Note:428441.1 to unset the parameter.
I have found it changing from WE8ISO8859P1 to WE8ISO8859P15 (two times on two different databases).
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!