Обсуждение: Migration oracle toc postgres

Поиск
Список
Период
Сортировка

Migration oracle toc postgres

От
Tzuriel Kahlon
Дата:
Hello all ,

Im trying to migrate orqcle schema to poatgres via python script .
All is going well except on twvle which have long .
We got the error :
cx_Oracle.OperationalError: ORA-00600: internal error code, arguments: [kdsgrp1-kdsgnp1], [19], [101193363], [0], [], [], [], [], [], [], [], []

Its happened on AIX in oracle 19.27.
Someone is encountered this issue ?



בברכה 
צוריאל כחלון 
0523851143

Re: Migration oracle toc postgres

От
Laurenz Albe
Дата:
On Thu, 2026-05-07 at 07:30 +0300, Tzuriel Kahlon wrote:
> Im trying to migrate orqcle schema to poatgres via python script .
> All is going well except on twvle which have long .
> We got the error :
> cx_Oracle.OperationalError: ORA-00600: internal error code, arguments: [kdsgrp1-kdsgnp1], [19], [101193363], [0], [],
[],[], [], [], [], [], [] 
>
> Its happened on AIX in oracle 19.27.
> Someone is encountered this issue ?

That means that the Oracle server crashed, and that you have found a bug
in Oracle (or you have data corruption).  You need to consult their support.

Yours,
Laurenz Albe



Re: Migration oracle toc postgres

От
Ron Johnson
Дата:
On Thu, May 7, 2026 at 12:31 AM Tzuriel Kahlon <tzuriel1986@gmail.com> wrote:
Hello all ,

Im trying to migrate orqcle schema to poatgres via python script .

I suggest you look at ora2pg, which worked flawlessly for me not only in converting the Oracle schema but in generating load files for Postgresql COPY.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Re: Migration oracle toc postgres

От
mao andy
Дата:
Logically, why would the ORA-00600 error relate to your Oracle to Postgres migration? 
You are making changes in Postgres, but not on the Oracle side. When did you get the ORA-00600? 

On Thu, May 7, 2026 at 4:39 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Thu, May 7, 2026 at 12:31 AM Tzuriel Kahlon <tzuriel1986@gmail.com> wrote:
Hello all ,

Im trying to migrate orqcle schema to poatgres via python script .

I suggest you look at ora2pg, which worked flawlessly for me not only in converting the Oracle schema but in generating load files for Postgresql COPY.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!