Home » RDBMS Server » Server Administration » how to change character set in oracle 11g r2 (11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production , RHEL 6.5)
how to change character set in oracle 11g r2 [message #638866] Tue, 23 June 2015 23:19 Go to next message
someswar1
Messages: 53
Registered: January 2008
Member
From My OS RHEL 6.5 Charaterset set as

set|grep NLS
NLS_DATE_FORMAT='DD.MM.YYYY HH24:MI:SS'
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ORA_NLS10=/opt/oracle/product/11.2.0.3/nls/data


And Oracle DB data base has at the moment:

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8

I need to update DB and os with this characterset AMERICAN_AMERICA.WE8ISO8859P15 .

Please help me how would I doing this without drop and reinstall the DB.

Regards
Someswar
Re: how to change character set in oracle 11g r2 [message #638867 is a reply to message #638866] Tue, 23 June 2015 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

The only approved way to establish a characterset for any Oracle database is to specify it when the database is initially created.
Re: how to change character set in oracle 11g r2 [message #638869 is a reply to message #638867] Tue, 23 June 2015 23:48 Go to previous messageGo to next message
someswar1
Messages: 53
Registered: January 2008
Member
Hello,

So there is no other way to change characterset if DB has been created?

Regards
Someswar
Re: how to change character set in oracle 11g r2 [message #638870 is a reply to message #638869] Tue, 23 June 2015 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
You can modify the DB content, but results may be indeterminate.
Re: how to change character set in oracle 11g r2 [message #638871 is a reply to message #638866] Wed, 24 June 2015 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Create a new db, export the old one, import into the new one.
What is the reason you NEED to change your character set from AL32UTF8 (which supports all characters) to WE8ISO8859P15 (which only supports western European characters)?


Re: how to change character set in oracle 11g r2 [message #638875 is a reply to message #638871] Wed, 24 June 2015 01:37 Go to previous messageGo to next message
someswar1
Messages: 53
Registered: January 2008
Member
Hello,

Actually my application supports only WE8ISO8859P15. Thatswhy I wanted to convert it .
At present these is the present Value

NAME VALUE
----------
LANGUAGE AMERICAN
TERRITORY AMERICA
CHARACTER SET AL32UTF8

If its not possible then please suggest me that if the database seed is configured with the AL32UTF8 character set, update the NLS_LANG with the following pattern (where the 'LANGUAGE', 'TERRITORY' and 'CHARACTER_SET' are those from the above result.

How would I update this?

Regards
Someswar
Re: how to change character set in oracle 11g r2 [message #638876 is a reply to message #638875] Wed, 24 June 2015 01:41 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Actually my application supports only WE8ISO8859P15.


Client and database character sets are completely independent, the only thngs to check are 1) the database character set contains at least all the characters the application/client need and 2) the client NLS_LANG parameter is correctly set to its own character set.
So just set your client character set to AMERICAN_AMERICA.WE8ISO8859P15 if this is the value it needs.

Previous Topic: SGA Size modification
Next Topic: Oracle 10g installation Problem
Goto Forum:
  


Current Time: Mon Oct 22 01:36:16 CDT 2018