topic Oracle database Arbic problem in Data Management Questions

Oracle database Arbic problem

MuhammadShakeel — Sun, 07 Jul 2013 07:50:15 GMT

Hello

We are facing a problem in Oracle Geodatabase, where we are unable to create feature dataset & classes/ with Arabic names.
When I create feature dataset in Oracle Geodatabase its displaying following msg "It item was not found" but feature database is being copied there. but data is not copying after I rename feature dataset and again displaying message "It item was not found" and when i delete feature dataset so that delete easily but after i refresh in geodatabse then All feature dataset come again.
Can you help me out in this problem?

Regards/
Shakeel

Re: Oracle database Arbic problem

VinceAngelo — Sun, 07 Jul 2013 13:17:10 GMT

You didn't provide any information on any of the software in use, but any modern
software should be able to handle this, IF you've configured the database correctly.

What character set did you establish for the database?
What NLS_LANG have you defined on the clients?
Have you verified that you can use the desired character set from SQL*Plus on
both the server and from clients?

You probably want to ask this question in an Oracle forum. If you do, be sure
to provide complete software version information (e.g., "Oracle 11.2.0.3.6 server
with 11.2.0.3.0 client")

- V

PS: You're more likely to get responses to your questions if you don't mark them
as answered (the green check) in the question.

Re: Oracle database Arbic problem

MuhammadShakeel — Mon, 08 Jul 2013 04:21:50 GMT

Thanks for your reply .

Answers to your queries:

NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CHARACTERSET
WE8MSWIN1252
NLS_NCHAR_CHARACTERSET
AL16UTF16

And we are using Oracle database 11g release2 x64 (64-bit) 11.2.0.1.0.
Oracle database 11g release2 Client x32 (64-bit) 11.2.0.1.0.

Re: Oracle database Arbic problem

VinceAngelo — Mon, 08 Jul 2013 10:20:44 GMT

Okay, so I believe that the WE8MSWIN1252 character set makes that database
instance useless for international characters. You need to drop and recreate the
instance, and choose the UTF-8 character set at creation. Then you need to set
the NLS_LANG to the appropriate value before loading. Follow the Oracle
documentation for international character set support.

- V

Re: Oracle database Arbic problem

MuhammadShakeel — Tue, 09 Jul 2013 04:19:00 GMT

Thanks for reply ,

Please can you tell me how can i change UTF-8 character and which one and also NLS_LANG which one i will use ?
and can you send me any link for Oracle
documentation for international character set support?

Thank you .

Re: Oracle database Arbic problem

VinceAngelo — Tue, 09 Jul 2013 10:17:10 GMT

It's a option on the installation procedure (the advanced installation procedure).

After 25 years as an Oracle DBA, install has become a reflex; I'm not really capable
of describing it to a novice. Besides, Oracle installation details are really outside the
scope of these Esri forums.

If you are going to administer an Oracle geodatabase, you really ought to have some
Oracle administration training. If Oracle training isn't possible, then I'd suggest using
an RDBMS more suited to casual administration.

- V