Thread: is the oracle client supposed to be owned by postgres or root?

is the oracle client supposed to be owned by postgres or root?

From

Henry Ashu

Date:

12 September, 23:07:43

Please I want to migrate my Oracle database to Postgres, should the Oracle client be own by the postgres user or root user?

Thank you

Henry Ashu

Database Administrator
o: 503.672.5114 | f: 800.551.8821 | DAT.com

RE: is the oracle client supposed to be owned by postgres or root?

From

Date:

13 September, 07:19:46

Postgres can take

Use EDB migration took kit, that will most of the work for you

Here is url go through it

https://www.enterprisedb.com/products/migration-toolkit-move-oracle-postgresql

From: Henry Ashu <henry.ashu@dat.com>
Sent: Thursday, September 12, 2024 1:08 PM
To: pgsql-admin@lists.postgresql.org
Subject: is the oracle client supposed to be owned by postgres or root?

Please I want to migrate my Oracle database to Postgres, should the Oracle client be own by the postgres user or root user?

Thank you

Henry Ashu

Database Administrator
o: 503.672.5114 | f: 800.551.8821 | DAT.com

Re: is the oracle client supposed to be owned by postgres or root?

From

Muhammad Waqas

Date:

13 September, 10:45:16

Oracle Binaries and Oracle Database file should by own by oracle user and oinstall group.

First you have to migrate objects from oracle to postgresql, In which you can use ora2pg tool.and then migrate data.

On Thu, 12 Sept 2024 at 22:08, Henry Ashu <henry.ashu@dat.com> wrote:

Please I want to migrate my Oracle database to Postgres, should the Oracle client be own by the postgres user or root user?
Thank you
Henry Ashu
Database Administrator
o: 503.672.5114 | f: 800.551.8821 | DAT.com

Muhammad Waqas

Senior Technical Support Engineer - Tech Support Center (Karachi)

Mobile: +92-322-2844150

Email: waqas.m@bitnine.net

1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,

DHA Phase 5 Tauheed Commercial Area,

Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,

75500 Pakistan.

Re: is the oracle client supposed to be owned by postgres or root?

From

Muhammad Ikram

Date:

13 September, 11:51:00

Hi Henry Ashu,

EDB migration toolkit is good for data objects when the target is community PostgreSQL. It won't be migrating code objects like procedures, packages, functions etc. For PostgreSQL target one may opt Ora2pg.

If your target is EDB Postgres then EDB Migration toolkit is good and even better is EDB's Migration Portal for schema migration, as it leverages to correct DDLs online and reassess if these fail after Assessment and conversion by Portal. Again for data you will have to use EDB Migration toolkit.

Regards,

Muhammad Ikram

On Fri, Sep 13, 2024 at 9:45 AM Muhammad Waqas <waqas.m@bitnine.net> wrote:

Oracle Binaries and Oracle Database file should by own by oracle user and oinstall group.

First you have to migrate objects from oracle to postgresql, In which you can use ora2pg tool.and then migrate data.

On Thu, 12 Sept 2024 at 22:08, Henry Ashu <henry.ashu@dat.com> wrote:
Please I want to migrate my Oracle database to Postgres, should the Oracle client be own by the postgres user or root user?
Thank you
Henry Ashu
Database Administrator
o: 503.672.5114 | f: 800.551.8821 | DAT.com

--
Muhammad Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
Email: waqas.m@bitnine.net
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.