OraFAQ Forum: Server Administration » Why I cannot set the Charactor Set while installing.

Home » RDBMS Server » Server Administration » Why I cannot set the Charactor Set while installing. (ORACLE10g 10.2.0 RHEL5)

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

Why I cannot set the Charactor Set while installing. [message #310407]

Tue, 01 April 2008 02:42

crazyzhou
Messages: 38
Registered: March 2008
Location: china

Member

whatever my OS' language is English or Chinese, the Charactor set of the database I choose is ZHS16GBK or UTF8, after the installation is completed, the parameter NLS_LANGUAGE's value always is "AMARICAN":just like the following:

SQL> show parameter nls

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_calendar                         string
nls_comp                             string
nls_currency                         string
nls_date_format                      string
nls_date_language                    string
nls_dual_currency                    string
nls_iso_currency                     string
nls_language                         string      AMERICAN
nls_length_semantics                 string      BYTE
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string
nls_territory                        string      AMERICA
nls_time_format                      string
nls_time_tz_format                   string
nls_timestamp_format                 string
nls_timestamp_tz_format              string

how can I install the ZHs16GBK or other Charactor Set?
thank you!

Report message to a moderator

Re: Why I cannot set the Charactor Set while installing. [message #310411 is a reply to message #310407]

Tue, 01 April 2008 02:50

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

use nls_database_parameters to get your database character set.
nls_language is a language not a character set.

Regards
Michel

Report message to a moderator

Re: Why I cannot set the Charactor Set while installing. [message #310416 is a reply to message #310411]

Tue, 01 April 2008 03:23

crazyzhou
Messages: 38
Registered: March 2008
Location: china

Member

I have set the Charactor Set, but why I can not find the parameter NLS_DATABASE_PARAMETERS ?

Report message to a moderator

Re: Why I cannot set the Charactor Set while installing. [message #310423 is a reply to message #310407]

Tue, 01 April 2008 03:56

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL> desc NLS_DATABASE_PARAMETERS;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PARAMETER                                 NOT NULL VARCHAR2(30)
 VALUE                                              VARCHAR2(40)

Report message to a moderator

Re: Why I cannot set the Charactor Set while installing. [message #310533 is a reply to message #310423]

Tue, 01 April 2008 09:19

crazyzhou
Messages: 38
Registered: March 2008
Location: china

Member

I'm so ashamed of this. I thought NLS_DATABASE_PARAMETERS is a parameter.
thanks Michel and Arju, I appreciate your help.

Report message to a moderator

Previous Topic:	ORA-12012: error on auto execute of job 425
Next Topic:	Steps to create database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 16:45:12 CDT 2024