LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-26-2003, 05:48 PM   #1
ayman
LQ Newbie
 
Registered: Apr 2003
Posts: 6

Rep: Reputation: 0
Question how can change characterset in oracle?


hello there:
I have installed linux version of oracle 9.2.0 in redhat 8
and during the installation process I chose the character set that needed.......
after successfully installation process how I can change the character set .....???
plz help me......

thanks alot
 
Old 04-26-2003, 06:30 PM   #2
hamster
Member
 
Registered: Apr 2003
Location: Waterford, Ireland
Distribution: Mandrivia 2006.1, Ubuntu 7.10
Posts: 188

Rep: Reputation: 30
Hi ayman,

I haven't Oracle 9 documentation with me at the moment, you could try their website... I did it for oracle 8.1.7, I'm assuming it similar for 9i as follows (hopefully they haven't changed the procedure too much): Apologies for the quick 'copy 'n paste' and the the fact that the "svrmgr" cmd isn't used anyway more

SCOPE & APPLICATION

The method described here is documented in the Oracle 8.1.x documentation.
It is not documented but it can be used in version 8.0.x.

Before using this method it is essential to do a full backup of the
database.

This method does not work in Oracle7.

Note that changing the database or the national character set as described
in this document does not change the actual character codes, it only
changes the character set declaration. If you want to convert the contents
of the database (character codes) from one character set to another
you must use the Oracle Export and Import utilities. This is needed,
for example, if the source character set is not a binary subset of
the target character set, i.e. if a character exists in the source
and in the target character set but not with the same binary code.


RELATED DOCUMENTS


<Note:62107.1> The National Character Set in Oracle8
<Note:119164.1> Changing Database Character set - Valid Superset definitions

Oracle8i National Language Support Guide


CHANGING THE DATABASE OR NATIONAL CHARACTER SET
================================================



In Oracle8 there is another way of changing the database or national character
set. The method uses two commands, which are documented in the Oracle8i
National Language Support Guide:

ALTER DATABASE [<db_name>] CHARACTER SET <new_character_set>
ALTER DATABASE [<db_name>] NATIONAL CHARACTER SET <new_NCHAR_character_set>

The database name is optional. The character set name should be specified
without quotes, for example:

ALTER DATABASE CHARACTER SET WE8ISO8859P1

To change the database character set perform the following steps.
Note that some of them have been erroneously omitted from the Oracle8i
documentation:

1. Make sure the parallel_server parameter in INIT.ORA is set to false
or it is not set at all.

2. Execute the following commands in Server Manager (svrmgrl):

SVRMGR> SHUTDOWN IMMEDIATE; -- or NORMAL

<do a full database backup>

SVRMGR> STARTUP MOUNT;
SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SVRMGR> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> ALTER DATABASE CHARACTER SET <new_character_set>;
SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL
SVRMGR> STARTUP RESTRICT;

3. Restore the parallel_server parameter in INIT.ORA, if necessary.

4. Execute the following commands in Server Manager:

SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL
SVRMGR> STARTUP;

The double restart is necessary because of a SGA initialization bug, fixed in Oracle9i.

Last edited by hamster; 04-26-2003 at 06:34 PM.
 
Old 04-27-2003, 05:42 PM   #3
ayman
LQ Newbie
 
Registered: Apr 2003
Posts: 6

Original Poster
Rep: Reputation: 0
Smile thank you sir

hello hmaster:
Thank you so much sir for ur co operation.....
bye.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 02:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 12:27 PM
Can't automount with correct CharacterSet sstyl SUSE / openSUSE 1 10-26-2005 06:10 AM
Characterset problem?: little boxes with numbers alienDog Slackware 4 05-08-2004 08:36 PM
Change Characterset (Pine) Aerial Slackware 2 10-26-2003 04:20 PM


All times are GMT -5. The time now is 06:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration