Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sozDD-00FNvp-Il for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 05:51:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sozDB-00C9tb-4v for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 05:51:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sozDA-00C9tS-NC for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 05:51:16 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sozD6-000w1g-Qg for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 05:51:16 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-2d88c0f8e79so1467243a91.3 for ; Thu, 12 Sep 2024 22:51:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726206672; x=1726811472; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=7apjPxkW0jKoOaM/alYTcsFqBoLLF3QWLyI62+JzNc0=; b=U3PLzJ3BJSAVYuaw7wVNyzCWjpjK/m6y0Wke6hm1L9fi+EERUKXQSiOyDgh5jUpIV9 hgVtVUOMWOo8/e2G8/dTVLHbN+tipvmVegaSryg25R/5jbK9Ty0qK0Mc1fr28e4jApme Fw3QSa8zE8A1iwfnMlvrD9saDP+4VTKzJHbK3yw284+btc0/Z6EVqUD+/h47bwomXdEQ ITcBbUmKbUnSxDcTNeusRGufMW4iRf4ni4OeEoBV8OPP3IuG9jHRGdS9eOkTlScmRLTb cuFER9Dgzqj8TYQZE2SZ+/VJ10e4D6lwfJoBYsV2UpHC4EVBPqrig/NtltL2UURx6wDa z/Jg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726206672; x=1726811472; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=7apjPxkW0jKoOaM/alYTcsFqBoLLF3QWLyI62+JzNc0=; b=Ws+NWGWZzxSLsMbcjW3mR022xtnoGwWMbp6YyEtmruyqs/lbYuRfXy9IzrhynW1OkP dAlwrMiuls1D1EdDLLJ3fl+d0Lmt8u6hLEtdqLj1wjJp6Y9Nxttu8SHYCUKBhZEtNMGc 9j4iUGaH26buRq4r3Hvv6dUwwovCKflyVH6lCJNLuqTITvCh9ssd58SAOkEuvqTfhEDK nwGDrrc2GVHQbESQ3px2bqqzcprORZni7PdsBf/CDuYIxu7ohnhCkklp4ZkqN+YiEXNv HOIMPgMtjviywoZq1DdXLToRgyptUc1U6VsrwkC2wf/uLje4jM9xS3VmR50/g+Sjne00 6x1A== X-Forwarded-Encrypted: i=1; AJvYcCVN1d7XoYyH835eMtRLFot9xjbNBrkHuS5rSQejJy8Za3qdVFhv+mKHE+anpdsZaSwpx54i8vaj02/cgg==@lists.postgresql.org X-Gm-Message-State: AOJu0Yy2d4QmSgbWvU8/VJSJovwLAec9StrWqPq9ebu6y0z/zMdWRzrz C2BjwaGbjfTplwibDncgopyx8tQPBOHJbLS1kFHDSZ7Dmj41pU/dWr/IaxILQGu/8ajyuIlF5Qd Q5mKdM6rV8Nk5ijWr4FePKmE8/k8= X-Google-Smtp-Source: AGHT+IHf5L6qICIMbVZZE8ZdQ8FVMovNwb5oAJIPqy4s0to2oMSnkdzRC89x0vwRtxAQaw5nhJf50z7k/fO+NQ9iULQ= X-Received: by 2002:a17:90a:ba88:b0:2da:5156:1253 with SMTP id 98e67ed59e1d1-2db9ffb36bfmr6208899a91.21.1726206672185; Thu, 12 Sep 2024 22:51:12 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Ikram Date: Fri, 13 Sep 2024 10:51:00 +0500 Message-ID: Subject: Re: is the oracle client supposed to be owned by postgres or root? To: Muhammad Waqas Cc: Henry Ashu , pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000812f190621f9cf7f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000812f190621f9cf7f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFAM Muhammad Waqas 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 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] [image: Like us on >> Facebook] [image: Follow us on >> Twitter] [image: Connect with us on >> LinkedIn] [image: Visit >> our YouTube Channel] [image: >> Visit us on Instagram] >> > > > -- > *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. > > --000000000000812f190621f9cf7f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Henry Ashu,

=C2=A0EDB migration tool= kit is good for data objects when the target is community PostgreSQL. It wo= n'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 Mi= gration Portal for schema migration, as it leverages to correct DDLs online= and reassess if these fail after Assessment and conversion by Portal. Agai= n for data you will have to use EDB Migration toolkit.

=
Regards,
Muhammad Ikram


On Fri, Sep 13, = 2024 at 9:45=E2=80=AFAM Muhammad Waqas <waqas.m@bitnine.net> wrote:
Oracle Binaries and Oracle Datab= ase 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 data= base to Postgres, should the Oracle client be own by the postgres=C2=A0user= or root user?

Thank you

Henry Ashu

Database Administrator
o:=C2=A0503.672.5114=C2=A0|= =C2=A0f:=C2=A0800.551.8821=C2=A0|=C2=A0DAT.com

3D"DAT=C2=A0 =C2=A0=C2=A03D"Like==C2=A0=C2=A03D"F==C2=A0=C2=A03D"Connect=C2=A0=C2=A03D"Visit=C2=A0=C2=A03D"Visit


--
= Muhammad Waqas
Senior Technical Su= pport Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
Email:=C2=A0=C2=A0waqas.m@bitnine.net=C2=A0
1st floor, suit no F-04, CO= LABS Karachi, 8-C Khayaban-e-Tanzeem,=C2=A0
DHA Phase 5 Tauheed Commercial Area,
<= div>Defense V Defense Housing Author= ity, Karachi, Karachi City, Sindh,=C2=A0
75500 Pakistan.
--000000000000812f190621f9cf7f--