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

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