Thread: Will This Work?
When I create a Oracle 11gR2 database we initially use the netca and dbca utilities to create the basic database files and network connections. Afterwards we run a bash script to create the application database detail files. We use this bash script to define certain files on specific raid-1 file systems.
How would we do this using PostgreSQL? What is the version of PostgreSQL you would suggest running on RHEL 5.9 x86_64? If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export DMP file to load the PostgreSQL database?
Thanks,
Gene Poole
How would we do this using PostgreSQL? What is the version of PostgreSQL you would suggest running on RHEL 5.9 x86_64? If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export DMP file to load the PostgreSQL database?
Thanks,
Gene Poole
gene.poole wrote > When I create a Oracle 11gR2 database we initially use the netca and dbca > utilities to create the basic database files and network connections. > Afterwards we run a bash script to create the application database detail > files. We use this bash script to define certain files on specific raid-1 > file systems. > How would we do this using PostgreSQL? The PostgreSQL documentation is quite good in covering this stuff though a number of items end up being distro-specific with additional information available elsewhere. I'd suggest forgetting about the fact you are migrating an existing application to PostgreSQL and approach it from a fresh-start perspective and learn generally how PostgreSQL operates. Once you have a feel for how things correlate the migration should go much more smoothly. EnterpriseDB (with whom I am in no way affiliated) seems to have setup a focus for itself in supporting Oracle to PostgreSQL migrations. Other's may be capable as well but they, IMHO, at least have done the best job marketing that niche... > What is the version of PostgreSQL > you would suggest running on RHEL 5.9 x86_64? The most recent version usually - 9.3; 9.2 if you dislike .0 releases. Since you are migrating I'd suggest 9.3 regardless because by the time you are ready it'll probably be at least a .2 release. > If I wanted to move from > Oracle to PostgreSQL is it possible to use a Oracle export DMP file to > load the PostgreSQL database? No clue; though doubtful. Even if technically capable of being used for an import inherent language differences would likely cause the SQL commands to fail. Again, this is a problem that has already been addressed and I would generally advise paying for someone else's experience rather than trying to figure it out on your own while asking for no-charge help from the community. Disclosure: I have only minimal scanned the net for this kind of material, and have never used any of it myself. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Will-This-Work-tp5770524p5770526.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
Hi,
I don't think an oracle dump file will work with PostgreSQL. You could look at tools like ora2pg which will do both - pull data/procedures from Oracle and then load into PostgreSQL. It also provides a lot of flexibility so that you could change the in-built data type mapping from Oracle to PostgreSQL. You could also have a look at orafce so that your Oracle codew with sysdate/dual etc work in PostgreSQL.
If you are looking for continuous replication from Oracle to PostgreSQL, rather than a one time migration, GoldenGate should do the job. There may be inexpensive alternatives to GoldenGate.
Regards,On Thu, Sep 12, 2013 at 2:58 AM, David Johnston <polobo@yahoo.com> wrote:
gene.poole wrote> When I create a Oracle 11gR2 database we initially use the netca and dbcaThe PostgreSQL documentation is quite good in covering this stuff though a
> utilities to create the basic database files and network connections.
> Afterwards we run a bash script to create the application database detail
> files. We use this bash script to define certain files on specific raid-1
> file systems.
> How would we do this using PostgreSQL?
number of items end up being distro-specific with additional information
available elsewhere.
I'd suggest forgetting about the fact you are migrating an existing
application to PostgreSQL and approach it from a fresh-start perspective and
learn generally how PostgreSQL operates. Once you have a feel for how
things correlate the migration should go much more smoothly.
EnterpriseDB (with whom I am in no way affiliated) seems to have setup a
focus for itself in supporting Oracle to PostgreSQL migrations. Other's may
be capable as well but they, IMHO, at least have done the best job marketing
that niche...The most recent version usually - 9.3; 9.2 if you dislike .0 releases.
> What is the version of PostgreSQL
> you would suggest running on RHEL 5.9 x86_64?
Since you are migrating I'd suggest 9.3 regardless because by the time you
are ready it'll probably be at least a .2 release.No clue; though doubtful. Even if technically capable of being used for an
> If I wanted to move from
> Oracle to PostgreSQL is it possible to use a Oracle export DMP file to
> load the PostgreSQL database?
import inherent language differences would likely cause the SQL commands to
fail. Again, this is a problem that has already been addressed and I would
generally advise paying for someone else's experience rather than trying to
figure it out on your own while asking for no-charge help from the
community.
Disclosure: I have only minimal scanned the net for this kind of material,
and have never used any of it myself.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Will-This-Work-tp5770524p5770526.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Gene Poole > Sent: Wednesday, September 11, 2013 4:11 PM > To: pgsql-novice@postgresql.org > Cc: jpdsys2@comcast.net; etpoole60@comcast.net; jpdsys7@comcast.net; etpoole64@gmail.com; etpoole6465@gmail.com > Subject: [NOVICE] Will This Work? > > When I create a Oracle 11gR2 database we initially use the netca and dbca utilities to create the basic database filesand network connections. Afterwards we run a bash script to create the application database detail files. We use thisbash script to define certain files on specific raid-1 file systems. > How would we do this using PostgreSQL? What is the version of PostgreSQL you would suggest running on RHEL 5.9 x86_64?If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export DMP file to load the PostgreSQLdatabase? > > Thanks, > Gene Poole My co-worker and I ported our application from Oracle to PostgreSQL. I can't answer your questions about netca or dbca created configuration files. I never really used either of those tools. We started from scratch with everything which is both a blessing and a curse (mostly a blessing). Obviously, it look uslonger than if we had used ora2pg or another tool to port the table structures. Now we have a better grasp of what PostgreSQLcan and cannot do. We were able to use PostgreSQL features that Oracle lacked. Also our stored functions are muchcleaner since they were all rewritten from scratch at the same time. We are also using RHEL 5.9 x86_64. We could have used the RPM's provided by the community but instead chose to install fromsource because it gives us more flexibility (our own version of Perl, binaries and data where we want them, etc). Westarted with 9.0 but switched to 9.1 partway through our conversion. We're running 9.2 now and will be moving to 9.3 soon.If I were in your shoes, I would start with 9.3. No, as far as I know, there is no way to use an Oracle dump file to load the PostgreSQL database. HTH, Matt Matthew Musgrove EF Johnson Technologies, Inc. Senior Software Engineer This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information.If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, youare hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attachedto this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notifyus by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them todisk. Thank you.
Gene Poole wrote: > If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export > DMP file to load the PostgreSQL database? Oracle goes out of their way to ensure that it is difficult to get data out of an Oracle database and migrate it somewhere else. No tool supplied by Oracle will extract the data in a useful format. If you use Toad (an expensive third party tool), that will do the trick. There is also ora2pg or oracle_fdw to extract data from Oracle to PostgreSQL. I'm only speaking about the actual data here, not the metadata. ora2pg does a good job there, but you'll probably need to do some stuff by hand or check that ora2pg's suggestions are sane. Yours, Laurenz Albe