public inbox for [email protected]
help / color / mirror / Atom feedis the oracle client supposed to be owned by postgres or root?
4+ messages / 4 participants
[nested] [flat]
* is the oracle client supposed to be owned by postgres or root?
@ 2024-09-12 17:07 Henry Ashu <[email protected]>
2024-09-13 01:19 ` RE: is the oracle client supposed to be owned by postgres or root? [email protected]
2024-09-13 04:45 ` Re: is the oracle client supposed to be owned by postgres or root? Muhammad Waqas <[email protected]>
0 siblings, 2 replies; 4+ messages in thread
From: Henry Ashu @ 2024-09-12 17:07 UTC (permalink / raw)
To: [email protected]
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
[image: DAT Solutions] <https://www.dat.com/; [image: Like us on
Facebook] <https://www.facebook.com/loadboards; [image: Follow us on
Twitter] <https://twitter.com/loadboards; [image: Connect with us on
LinkedIn] <https://www.linkedin.com/company/datsolutions; [image: Visit
our YouTube Channel] <https://www.youtube.com/datloadboards; [image: Visit
us on Instagram] <https://instagram.com/dat_solutions;
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: is the oracle client supposed to be owned by postgres or root?
2024-09-12 17:07 is the oracle client supposed to be owned by postgres or root? Henry Ashu <[email protected]>
@ 2024-09-13 01:19 ` [email protected]
1 sibling, 0 replies; 4+ messages in thread
From: [email protected] @ 2024-09-13 01:19 UTC (permalink / raw)
To: 'Henry Ashu' <[email protected]>; [email protected]
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 <[email protected]>
Sent: Thursday, September 12, 2024 1:08 PM
To: [email protected]
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
<https://www.dat.com/; <https://www.facebook.com/loadboards; <https://twitter.com/loadboards; <https://www.linkedin.com/company/datsolutions; <https://www.youtube.com/datloadboards; <https://instagram.com/dat_solutions;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is the oracle client supposed to be owned by postgres or root?
2024-09-12 17:07 is the oracle client supposed to be owned by postgres or root? Henry Ashu <[email protected]>
@ 2024-09-13 04:45 ` Muhammad Waqas <[email protected]>
2024-09-13 05:51 ` Re: is the oracle client supposed to be owned by postgres or root? Muhammad Ikram <[email protected]>
1 sibling, 1 reply; 4+ messages in thread
From: Muhammad Waqas @ 2024-09-13 04:45 UTC (permalink / raw)
To: Henry Ashu <[email protected]>; +Cc: [email protected]
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 <[email protected]> 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
> [image: DAT Solutions] <https://www.dat.com/; [image: Like us on
> Facebook] <https://www.facebook.com/loadboards; [image: Follow us on
> Twitter] <https://twitter.com/loadboards; [image: Connect with us on
> LinkedIn] <https://www.linkedin.com/company/datsolutions; [image: Visit
> our YouTube Channel] <https://www.youtube.com/datloadboards; [image:
> Visit us on Instagram] <https://instagram.com/dat_solutions;
>
--
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email: *[email protected] <[email protected]>*
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is the oracle client supposed to be owned by postgres or root?
2024-09-12 17:07 is the oracle client supposed to be owned by postgres or root? Henry Ashu <[email protected]>
2024-09-13 04:45 ` Re: is the oracle client supposed to be owned by postgres or root? Muhammad Waqas <[email protected]>
@ 2024-09-13 05:51 ` Muhammad Ikram <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Muhammad Ikram @ 2024-09-13 05:51 UTC (permalink / raw)
To: Muhammad Waqas <[email protected]>; +Cc: Henry Ashu <[email protected]>; [email protected]
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 <[email protected]> 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 <[email protected]> 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
>> [image: DAT Solutions] <https://www.dat.com/; [image: Like us on
>> Facebook] <https://www.facebook.com/loadboards; [image: Follow us on
>> Twitter] <https://twitter.com/loadboards; [image: Connect with us on
>> LinkedIn] <https://www.linkedin.com/company/datsolutions; [image: Visit
>> our YouTube Channel] <https://www.youtube.com/datloadboards; [image:
>> Visit us on Instagram] <https://instagram.com/dat_solutions;
>>
>
>
> --
> *Muhammad Waqas*
> *Senior Technical Support Engineer - Tech Support Center (Karachi)*
> Mobile: +92-322-2844150
> Email: *[email protected] <[email protected]>*
> 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.
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-09-13 05:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-12 17:07 is the oracle client supposed to be owned by postgres or root? Henry Ashu <[email protected]>
2024-09-13 01:19 ` [email protected]
2024-09-13 04:45 ` Muhammad Waqas <[email protected]>
2024-09-13 05:51 ` Muhammad Ikram <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox