Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ORA-06553: PLS-553: character set name is not recognized
salomon londono
post Mar 30 2017, 05:28 PM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 30-March 17
Member No.: 51,872



Hello, I need help for solutions of the error ORA-06553: PLS-553: character set name is not recognized
Go to the top of the page
 
+Quote Post
burleson
post Mar 31 2017, 10:04 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13



Hi Salomon and welcome to the forum!

>> I need help for solutions of the error ORA-06553: PLS-553: character set name is not recognized

Why are you changing character sets?

You have a syntax error, please post your code as these are not directly related errors.

See this related thread:

http://dbaforums.org/oracle/index.php?showtopic=21313












--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
salomon londono
post Apr 1 2017, 09:41 AM
Post #3


Newbie
*

Group: Members
Posts: 5
Joined: 30-March 17
Member No.: 51,872



QUOTE (salomon londono @ Mar 30 2017, 05:28 PM) *
Hello, I need help for solutions of the error ORA-06553: PLS-553: character set name is not recognized




Hello, the operating system of my database changed and now does not allow to do an export and import of the database.

The error that now says is that the character set is not recognized.

I want to make an export and import but for this error I can not do it
Go to the top of the page
 
+Quote Post
limsk
post Apr 3 2017, 02:52 AM
Post #4


Advanced Member
***

Group: Members
Posts: 87
Joined: 20-January 08
From: Kuala Lumpur, MY
Member No.: 16,279



QUOTE (salomon londono @ Apr 1 2017, 10:41 PM) *
Hello, the operating system of my database changed and now does not allow to do an export and import of the database.

The error that now says is that the character set is not recognized.

I want to make an export and import but for this error I can not do it


Your situation is not clear. What is your database character set ? And what was the operating system changed from / to ?

Characterset issues during import/export are normally caused by improper settings of the session doing the process.



Go to the top of the page
 
+Quote Post
burleson
post Apr 3 2017, 10:48 AM
Post #5


Advanced Member
***

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13



Hi,

Also, check to see if you can connect to sqlplus:

http://dba-oracle.com/bk_alter_session_set_nls_language.htm

Also see here:

http://www.dba-oracle.com/t_nls_characterset.htm






--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
salomon londono
post Apr 3 2017, 12:32 PM
Post #6


Newbie
*

Group: Members
Posts: 5
Joined: 30-March 17
Member No.: 51,872



QUOTE (burleson @ Apr 3 2017, 10:48 AM) *



Hello!
This is the error that the ORACLE gives when I try to do a database export

ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully


I did what you recommend in the previous post, but it will not let me change the NLS_LANG parameter.

ORA-12705: invalid or unknown NLS parameter value specified

Please, I need your help
Go to the top of the page
 
+Quote Post
burleson
post Apr 4 2017, 01:48 PM
Post #7


Advanced Member
***

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13



Hi,

NLS_LANG is an environmental variable:

The nls_lang parameter is an important component for any Oracle database that displays non-English characters. You can set nls_lang in your initialization parameter file (init.ora) and you can also set it at the session level and within shell scripts:

NLS_LANG='english_united kingdom.we8iso8859p1';
export NLS_LANG





--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
salomon londono
post Apr 5 2017, 02:55 PM
Post #8


Newbie
*

Group: Members
Posts: 5
Joined: 30-March 17
Member No.: 51,872



QUOTE (burleson @ Apr 4 2017, 01:48 PM) *
Hi,

NLS_LANG is an environmental variable:

The nls_lang parameter is an important component for any Oracle database that displays non-English characters. You can set nls_lang in your initialization parameter file (init.ora) and you can also set it at the session level and within shell scripts:

NLS_LANG='english_united kingdom.we8iso8859p1';
export NLS_LANG



HI!!


I am placing this statement in .bat
but it does not work,

ORA-12705: invalid or unknown NLS parameter value specified
Go to the top of the page
 
+Quote Post
burleson
post Apr 6 2017, 12:26 PM
Post #9


Advanced Member
***

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13



Hi,

>> I am placing this statement in .bat

You never said that you are on Windows!

See here:

http://nagaappani.blogspot.com/2013/05/set...for-oracle.html




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
salomon londono
post Apr 12 2017, 11:15 AM
Post #10


Newbie
*

Group: Members
Posts: 5
Joined: 30-March 17
Member No.: 51,872




Good morning dear

Finally, I finished my request with the change of the database character set, I did the following:

C:\>sqlplus /nolog
SQL> connect / as sysdba
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP RESTRICT;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE CHARACTER SET WE8MSWIN1252;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

Thanks so much.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 17th October 2017 - 10:15 AM