Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Multiple SID's (instances) possible with Oracle 8 (Unix)?

Multiple SID's (instances) possible with Oracle 8 (Unix)?

From: <gschnei_at_genre.com>
Date: 28 Dec 2005 06:02:59 -0800
Message-ID: <1135778579.507469.100640@g43g2000cwa.googlegroups.com>


Hi guys,

sorry to bug you, but I've got a (hopefully) simple question:

We have a client in South-Korea running an Oracle Database. They are using Oracle 8 on some sort of Unix (I guess it's Linux), and they are using a characterset KO16KSC5601
(NLS_LANG=American_America.KO16KSC5601).
We are running Oracle 8 on a W2K-server having the encoding WE8ISO8859P1. Here, with our encoding, everything works fine, Korean characters are displayed smoothley. However, when I'm sending them some load-data
(tab-separated for SQL-Loader), there are always error-messages (I
could look up the exact errorcode if necessary).

So, looking at our W2K Oracle-installation, I suggested to create another SID on their Unix-system with the encoding WE8ISO8859P1, and they should be done.

However, their DBA said that this would not be possible, he didn't give me any reason.

Now my question to you is:

Is it true that within Unix (text-only, no graphs) you can only run ONE SID with exactly ONE encoding?

If not, is there anywhere a "howto" or something with which I can slap the DBA's ears?

Or, do you gys have any suggestion how migrating one character-set into the other?

Please be aware that I'm neither a DBA nor an Oracle-specialist.

TIA & best regards from Cologne, Germany!

Greg Received on Wed Dec 28 2005 - 08:02:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US