Home » RDBMS Server » Backup & Recovery » ORA-06553: PLS-553: character set name is not recognized (oracle11g, 11.1.0.7.0, aix6.1)
icon14.gif  ORA-06553: PLS-553: character set name is not recognized [message #462160] Wed, 23 June 2010 01:30 Go to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi All,

We have changed the character set of one database to US7ASCII.
Now when we are trying to take the backup of a user using exp
utility, we are getting stuck up with the below error message.

Export: Release 11.1.0.7.0 - Production on Wed Jun 23 12:31:39 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SYSTEM 
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully


Please help me as soon as possible as i have to provide the
solution. Thanks in advance.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462165 is a reply to message #462160] Wed, 23 June 2010 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
We have changed the character set of one database to US7ASCII

How?

Regards
Michel

Report message to a moderator

icon14.gif  Re: ORA-06553: PLS-553: character set name is not recognized [message #462173 is a reply to message #462165] Wed, 23 June 2010 01:43 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Michel,

Changed the character set using csscan and csalter utilities.

Regards,
soft doctor.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462183 is a reply to message #462173] Wed, 23 June 2010 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And no warning from csscan?

Regards
Michel

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462189 is a reply to message #462183] Wed, 23 June 2010 02:29 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi Michel,

I am very sorry for wrong input... Embarassed Sad

I have just came to know that character set has changed as
per the below code. 

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; 
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> update sys.props$ set VALUE$='US7ASCII' where 
     NAME='NLS_CHARACTERSET'
SQL> SHUTDOWN;
SQL> STARTUP;
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
SQL> select * from NLS_DATABASE_PARAMETERS;


Now we have tried to with csscan utility.
We are warned with the below message.Please suggest and
save us. Thanks for quick response.

. process 6 scanning SYS.WRH$_LATCH_MISSES_SUMMARY[AAATyhAACAAAVchAAA]
. process 10 scanning SYSTEM.LOGMNR_PROPS$[AAARGnAACAAABnpAAA]
. process 14 scanning MDSYS.OLS_DIR_BUSINESSES[AAAPbPAACAAAHeJAAA]
ORA-30967: operation directly on the Path Table is disallowed

CSS-00144: failed to scan table XDB.XDBACL_PATH_TAB

. process 21 scanning SYSTEM.LOGMNRC_GSII[AAARHkAACAAABeRAAA]

Creating Database Scan Summary Report...

Creating Individual Exception Report...

Scanner terminated successfully.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462198 is a reply to message #462189] Wed, 23 June 2010 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
SQL> update sys.props$ set VALUE$='US7ASCII' where
NAME='NLS_CHARACTERSET'

This is the error, now your database is screwed.
Try to put back the preceding and use a valid method to change the character set but I advice you to restore from a valid backup.

Regards
Michel

Report message to a moderator

icon14.gif  Re: ORA-06553: PLS-553: character set name is not recognized [message #462246 is a reply to message #462198] Wed, 23 June 2010 05:05 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi Michel,

We are successed.. Smile

Now I have changed the character set to original one and
tried with the exp. Now its working fine except one small
error message.
Can you please advice me.
. . exporting table                   EMP          0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.


Regards,
Soft_Doctor

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462260 is a reply to message #462246] Wed, 23 June 2010 05:38 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
EXP-00091 Exporting questionable statistics

Cause: Export was able to export statistics, but the statistics may not be useable. The statistics are questionable because one or more of the following happened during export:

- A row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export,


- Only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table.

Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462262 is a reply to message #462260] Wed, 23 June 2010 05:40 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Doctor should know what is 'c' section,
before going to do that.
As you a soft doctor you should know what are the consequences of your code
sriram Smile

[Updated on: Wed, 23 June 2010 05:41]

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462266 is a reply to message #462262] Wed, 23 June 2010 05:49 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Sriram,

sorry to say, I did not get you

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462270 is a reply to message #462266] Wed, 23 June 2010 05:54 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
you should know what are the consequences of your code

Before changing anything on the database.

sriram

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462274 is a reply to message #462246] Wed, 23 June 2010 06:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to manually tell exp utility to ignore the statistics by using 
statistics=none

along with other export options
or
set the proper values for NLS_LANG in your OS environment.
export NLS_LANG=yourValue.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462294 is a reply to message #462274] Wed, 23 June 2010 07:24 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi,

Same issue regarding character set. I have changed the character
set to original one i.e. AL32UTF8 as usually by updating props$ view.

Now I tried to change the character set from AL32UTF8 to
US7ASCII with the below procedure.

1. Ran the csscan utility.
2. Restarted the database with restrict option.
3. ran the csalter utility.

But I got the message like below.

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 validity...
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.


Observed that in csscan, got the below issue.

ORA-30967: operation directly on the Path Table is disallowed

CSS-00144: failed to scan table XDB.XDBACL_PATH_TAB

Can any one please help me....

[Updated on: Wed, 23 June 2010 07:30]

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462297 is a reply to message #462294] Wed, 23 June 2010 07:33 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
>>Ran the csscan utility

Is it successfull?

>> ran the csalter utility.
As Which user you are connected...

With the info you provided...I can give you

see the below...
http://www.oracle-base.com/articles/10g/CharacterSetMigration.php
And
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1013848

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm

sriram

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462298 is a reply to message #462297] Wed, 23 June 2010 07:42 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi Sriram,

in csscan, got the below error message.
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.XDBACL_PATH_TAB

ran the csalter.plb with sys user itself.

Report message to a moderator

Re: ORA-06553: PLS-553: character set name is not recognized [message #462330 is a reply to message #462298] Wed, 23 June 2010 09:43 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Most probably this table is been protected.
Are you really using XDB options?
Check metalink. There are few related issues reported.

Report message to a moderator

Previous Topic: ora-19809,ora-19804
Next Topic: Recovery of database with backup of Oracle folder
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 21:16:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.