8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Character Set Migration using CSSCAN and CSALTER

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! They will be deleted!

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!