OraFAQ Forum: Server Utilities » CSALTER finished unsuccessfully. (merged 3)

Home » RDBMS Server » Server Utilities » CSALTER finished unsuccessfully. (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CSALTER finished unsuccessfully. (merged 3) [message #398960]

Mon, 20 April 2009 00:45

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Runing the CSALTER script by : SQL> @?/rdbms/admin/csalter.plb;
is the procedure to alter the charecterset of a database.

My question is where do I want to give my source and destination charecterset names??

regards,
Nataraj.

Report message to a moderator

Re: CSAlter command usage [message #398968 is a reply to message #398960]

Mon, 20 April 2009 01:11

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you follow the process detailed in the documentation?

Regards
Michel

Report message to a moderator

Re: CSAlter command usage [message #398971 is a reply to message #398968]

Mon, 20 April 2009 01:15

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Michel Cadot wrote on Mon, 20 April 2009 11:41

Did you follow the process detailed in the documentation?

Yes Miche,

I can't find out my answer,
Can you give me some reference?

Report message to a moderator

Re: CSAlter command usage [message #398978 is a reply to message #398971]

Mon, 20 April 2009 02:04

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

May be this one: Migrating a Character Set Using the CSALTER Script

Regards
Michel

Report message to a moderator

Re: CSAlter command usage [message #398993 is a reply to message #398978]

Mon, 20 April 2009 03:42

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

The document says,

Quote:

To change the database character set, perform the following steps:
1. Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN
NORMAL statement.
2. Do a full backup of the database, because the CSALTER script cannot be rolled
back.
3. Start up the database.
4. Run the Database Character Set Scanner utility.
CSSCAN /AS SYSDBA FULL=Y...
5. Run the CSALTER script.
@@CSALTER.PLB
SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
STARTUP;

I can't find out my answer here too..

regards,
Nataraj

Report message to a moderator

Re: CSAlter command usage [message #398995 is a reply to message #398993]

Mon, 20 April 2009 03:47

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because you didn't read carefully the document.
character sets are given on csscan call.

Regards
Michel

Report message to a moderator

Re: CSAlter command usage [message #398997 is a reply to message #398995]

Mon, 20 April 2009 03:56

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Do the CSAlter takes the parameters of CSScan implicitly?

if so, how to handle in below scenario?

I've executed CSScan two days before.
Found no changes required.
Today can I initiate the CSAlter.

pls find the attached csalter.plb file for your reference.

regards,
Nataraj

Attachment: csalter.plb
(Size: 6.41KB, Downloaded 2873 times)

[Updated on: Mon, 20 April 2009 04:26]

Report message to a moderator

Re: CSAlter command usage [message #399021 is a reply to message #398997]

Mon, 20 April 2009 05:20

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

Note that the CSALTER script does not perform any user data conversion. It only changes the character set metadata in the data dictionary.Thus, after the CSALTER operation, Oracle will behave as if the database was created using the new character set.

Report message to a moderator

Re: CSAlter command usage [message #399025 is a reply to message #399021]

Mon, 20 April 2009 05:30

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Babu,
I think u didn't understand my question.

My question is where do I need to give my source and destination charecterset names during the execution of CSAlter?

regards,
Nataraj

Report message to a moderator

Re: CSAlter command usage [message #399029 is a reply to message #399025]

Mon, 20 April 2009 05:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

Using "csalter.plb" script. Only change metadata in the data dictionary;

>> where do I need to give my source and destination charecterset names during the execution of CSAlter?

This is not like CSSCAN tool; There is no parameter for CSALTER script.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1013848

Report message to a moderator

Re: CSAlter command usage [message #399037 is a reply to message #399029]

Mon, 20 April 2009 06:04

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

gentlebabu wrote on Mon, 20 April 2009 16:09

Using "csalter.plb" script. Only change metadata in the data dictionary;

Babu, your statement is absolutely wrong.

csalter is used to change the charecterset of the whole database.

Report message to a moderator

Re: CSAlter command usage [message #399040 is a reply to message #399037]

Mon, 20 April 2009 06:12

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

I think still your not checking document.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1013848

Quote:

Quote:
Note that the CSALTER script does not perform any user data conversion. It only changes the character set metadata in the data dictionary.Thus, after the CSALTER operation, Oracle will behave as if the database was created using the new character set.

Using "csalter.plb" script. Only change metadata in the data dictionary;

>> where do I need to give my source and destination charecterset names during the execution of CSAlter?

This is not like CSSCAN tool; There is no parameter for CSALTER script.

Report message to a moderator

Re: CSAlter command usage [message #399051 is a reply to message #399040]

Mon, 20 April 2009 06:26

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Ok I accept Babu,

Quote:

CSAlter only changes the character set of metadata in the data dictionary,

But still "to which charecterset will the CSAlter changes the character set of metadata in the data dictionary?"

regards,
Nataraj

Report message to a moderator

Re: CSAlter command usage [message #399056 is a reply to message #399051]

Mon, 20 April 2009 06:54

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

From tables used by csscan.

Regards
Michel

Report message to a moderator

Re: CSAlter command usage [message #399067 is a reply to message #399056]

Mon, 20 April 2009 07:23

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Do the CSAlter takes the parameters of CSScan implicitly?

Report message to a moderator

Re: CSAlter command usage [message #399074 is a reply to message #399067]

Mon, 20 April 2009 07:59

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

CSALTER finished unsuccessfully. [message #399210 is a reply to message #398960]

Tue, 21 April 2009 02:21

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

I'm using an Oracle 10.2.0.4 database with WE8ISO8859P1 charecterset.

I've done a Character Set Scanner v2.1 (CSScan) on this DB as:
SQL> csscan FULL=Y FROMCHAR=WE8ISO8859P1 TOCHAR=UTF8 ARRAY=1024000 LOG=charcheck CAPTURE=Y PROCESS=4;

Verified the charcheck.txt file,
There is no Convertible, Truncated and Lossy Data exceptions in the Application/User Tables.
Only the Data Dictionary has some 3,392 CLOB "Convertible " datas. I hope we don't need to worry about this.
.
Please find the attached "charcheck.txt" file for your reference.

After ensuring a successful scan, I had shut down the database.

Started Up the Database in Restricted Mode: SQL> startup restrict;

Run the CSALTER script as below:

SQL> @@csalter.plb;
0 rows created.
Function created.
Function created.
Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?y
old 6: if (UPPER('&conf') <> 'Y') then
new 6: if (UPPER('y') <> 'Y') then

Checking data validility...
Exceptional data found in scanner result
PL/SQL procedure successfully completed.

Checking or Converting phrase did not finish successfully

No database (national) character set will be altered

CSALTER finished unsuccessfully.

PL/SQL procedure successfully completed.

0 rows deleted.

Function dropped.
Function dropped.
Procedure dropped.
SQL>

CSALTER finished unsuccessfully.

Please tell me why this failed?

regards,
Nataraj

Attachment: charcheck.txt
(Size: 8.70KB, Downloaded 2792 times)

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546858 is a reply to message #398960]

Fri, 09 March 2012 05:52

vikasgupta14
Messages: 3
Registered: March 2012
Location: india

Junior Member

Hi.
I tried to migrate with my database. I did backup, started in restricted mode the database.
when I run csalter.plb script I got:
SQL> @@csalter.plb
0 rows created.
Function created.
Function created.
Procedure created.
This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed ?(Y/N)?Y
old 5: if (UPPER('&conf') 'Y') then
new 5: if (UPPER('Y') 'Y') then
Enter value for 1: UTF8
old 8: param1 := '&1';
new 8: param1 := UTF8';
Checking data validility...
TOCHAR is not superset of FROMCHAR
PL/SQL procedure successfully completed.
0 rows deleted.
Alter database character set....
Checking or Converting phrase did not finish successfully
No database (national) character set will be altered
PL/SQL procedure successfully completed.
SQL>

What should I type where I got "Enter value for 1:" ??

I have already done this with ANOTHER DATABASE with same Oracle version(10.1.0.2.0) and now application working fine, but now i am getting this problem.

How to correct my mistake ?? and what should i do to do it successfully

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546860 is a reply to message #546858]

Fri, 09 March 2012 06:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no mistake only CSALTER can't handle all cases and it knows it and aborts when it finds it is a case it does not know how to do it.

What is your Oracle version?

Regards
Michel

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546866 is a reply to message #546860]

Fri, 09 March 2012 06:36

vikasgupta14
Messages: 3
Registered: March 2012
Location: india

Junior Member

thank you for quick reply

my Oracle version is 10.1.0.2.0.
I am following the same steps mentioned at site below
www.oracle-base.com/articles/10g/CharacterSetMigration.php

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546868 is a reply to message #546866]

Fri, 09 March 2012 06:38

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With the same character sets?
Note that the article is about 10.2

By the way, I don't know why you have the question about "&1". It does not exist in 10.2.

Regards
Michel

[Updated on: Fri, 09 March 2012 06:39]

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546869 is a reply to message #546868]

Fri, 09 March 2012 06:57

vikasgupta14
Messages: 3
Registered: March 2012
Location: india

Junior Member

Thanks for reply
Yes this document is for 10.2 and i am having oracle 10.1.0.2

Can you please guide me how to migrate charecter set from "WE8MSWIN1252" to "UTF8" for oracle version 10.1.0.2 .

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546870 is a reply to message #546869]

Fri, 09 March 2012 07:10

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Export/create a new database/import.
This is the ONLY way.

Regards
Michel

Report message to a moderator

Previous Topic:	Expdp problem
Next Topic:	how to use Escape character for loading data via sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:12:44 CST 2025