Hi all, my database is Oracle 8.1.6 on Solaris. I want to incorporate multi language capability into the database, specifically Spanish & Portugese, but I cannot find any language files other than US English. Do I have no other option but to re-install again ?
Have little more investigation. See may be this link is of any help.
Thanks for the response Sam. But I want to know about installing the missing MSB & MSG files for the languages, which help me in seeing the error messages in the desired language. I could not find that information in the link you sent me.
What do I need to do to get non-English messages?
When you install Oracle select the main language required. Ensure that this
is done for any products installed at a later stage. At installation time
one language or all can be selected (except for on NT and Windows 95/98
where it is not possible to select all languages at install). In Oracle7,
any further languages need to be manually copied from the distribution
media whereas in Oracle8 installation of further languages requires
reinstallation of the product concerned.
The mesg directory for each product should contain message files in the
(product abbreviation)(language abbreviation).msb
(product abbreviation)(language abbreviation).msg (for some products only)
For just server messages, set NLS_LANGUAGE in the init.ora. If
non-English messages are required for all client products then set
NLS_LANG to include the chosen language. The language set by NLS_LANG
will override that set by NLS_LANGUAGE so you need to be sure that they
are the same, or that the language part of NLS_LANG is left blank.
How to install: Check out the following Metalink docs
Sam, I do not have access to Metalink docs as we are still running eval version. Can you email me the contents at email@example.com ?
Wow. I thought Oracle messages were non-English to begin with. You mean it can be worse, like in Spanish?
Click Here to Expand Forum to Full Width