Re: AW: How to Install Oracle 12 Client in Existing Oracle Home

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: woodwardinformatics@xxxxxxxxxxxxxxxx, backseatdba@xxxxxxxxx
  • Date: Wed, 8 May 2019 15:59:48 -0500

A few years ago, I had the pleasure of helping a vendor move their Fortran-based ERP package for the building construction industry from mainframe VSAM files to Oracle.  It was easy, and it wasn't pretty, but they needed the data in an RDBMS so that they could feed BI/DW environments.

The application itself still hums along on Fortran.  Today.  In 2019.  And the vendor itself is comfortably profitable in their niche in the construction industry.

Before anyone thinks themselves superior, remember that we have all seen highways and bridges rebuilt in a few months while in use, but none of us have ever seen that happen in software, ever, anywhere. The project managers, trained in construction and repurposed into IT, were awesome and performed their jobs flawlessly, keeping the development and testing teams progressing smoothly with full transparency and no hiccups.

It is no joke that if buildings and roads were built the way software is developed, then the first gopher to come along would destroy civilization.




On 5/8/19 15:20, Michael D O'Shea/Woodward Informatics Ltd wrote:

All I can say is that I am gobsmacked. Having written that, I saw a green-field VB6 contract role advertised the other day. They're going to get who they deserve, that’s for sure.

Thanks for your replies all.

Mike


Am 08.05.2019 um 19:34 schrieb Jeff Chirco <backseatdba@xxxxxxxxx <mailto:backseatdba@xxxxxxxxx>>:

Our ERP system is done in COBOL. It was a package purchased many years ago but we own the source code and have completely redone it over the years. It is a totally custom ERP system. The COBOL developers range from 20-39 years old, granted they were all hired from within and trained into that position. However we have begun to work on moving this ERP system into APEX.

On Wed, May 8, 2019 at 7:42 AM Michael D O’Shea/Woodward Informatics Ltd <woodwardinformatics@xxxxxxxxxxxxxxxx <mailto:woodwardinformatics@xxxxxxxxxxxxxxxx>> wrote:

    I just have to ask, sorry - COBOL? Is there much COBOL there or
    this is just one of the remaining remnant applications? And is
    new COBOL development ongoing? And the developers, what age range?

    I do a lot of contract work in banks and although I’ve heard
    rumours there is COBOL in the wild, I have never met one of these
    developers. Especially Pro*COBOL.

    Decades back I used to develop in Cics and RM/COBOL. As I write,
    that was decades back. I have not seen COBOL on the (UK) contract
    job boards for years either.

    Mike

    Von meinem iPhone gesendet

    Am 08.05.2019 um 15:31 schrieb Scott Canaan <srcdco@xxxxxxx
    <mailto:srcdco@xxxxxxx>>:

    I was wondering the same thing.  In 12.1.0.2, the Oracle Homes
    are slightly different, though.  I have to make sure that the
    Pro*COBOL precompiler is there, as the application is written in
    COBOL.

    In looking at the inventory on the special Oracle Home that I
    built in 2016 that includes the client, the comps.xml file is
    different in that it includes the client install in addition to
    the base install.

    The problem is that I can’t just take a chance that it will work.

    *Scott Canaan ‘88**
    */Sr Database Administrator
    /Information & Technology Services
    Finance & Administration

    *Rochester Institute of Technology
    *o: (585) 475-7886 | f: (585) 475-7520**

    _srcdco@xxxxxxx <mailto:srcdco@xxxxxxx>_| c: (585) 339-8659

    *CONFIDENTIALITY NOTE*: The information transmitted, including
    attachments, is intended only for the person(s) or entity to
    which it is addressed and may contain confidential and/or
    privileged material. Any review, retransmission, dissemination
    or other use of, or taking of any action in reliance upon this
    information by persons or entities other than the intended
    recipient is prohibited. If you received this in error, please
    contact the sender and destroy any copies of this information.

    *From:*Shane Borden <sborden76@xxxxxxxxx
    <mailto:sborden76@xxxxxxxxx>>
    *Sent:* Wednesday, May 8, 2019 10:19 AM
    *To:* Scott Canaan <srcdco@xxxxxxx <mailto:srcdco@xxxxxxx>>
    *Cc:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
    *Subject:* Re: How to Install Oracle 12 Client in Existing
    Oracle Home

    Perhaps I am mistaken, but isn’t the client already a part of
    the database software?

    ---

    Thanks,


    Shane Borden

    sborden76@xxxxxxxxx <mailto:sborden76@xxxxxxxxx>



        On May 8, 2019, at 9:59 AM, Scott Canaan <srcdco@xxxxxxx
        <mailto:srcdco@xxxxxxx>> wrote:

        We have an application that needs to have the Oracle client
        installed in the same Oracle Home as the database software. 
        Somehow, I managed to do it with Oracle 12.1.0.2, but the
        client installer for Oracle 12.2.0.1 won’t let me.  It says
        there’s already Oracle software in that home and won’t let
        me move on.

        How do I do this?

        This is Oracle 12.2.0.1 on Red Hat 7 Linux.

        *Scott Canaan ‘88**
        */Sr Database Administrator
        /Information & Technology Services
        Finance & Administration

        *Rochester Institute of Technology
        *o: (585) 475-7886 | f: (585) 475-7520

        _srcdco@xxxxxxx <mailto:srcdco@xxxxxxx>_| c:(585)339-8659


        *CONFIDENTIALITY NOTE*: The information transmitted,
        including attachments, is intended only for the person(s) or
        entity to which it is addressed and may contain confidential
        and/or privileged material. Any review, retransmission,
        dissemination or other use of, or taking of any action in
        reliance upon this information by persons or entities other
        than the intended recipient is prohibited. If you received
        this in error, please contact the sender and destroy any
        copies of this information.


Other related posts: