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

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_at_gmail.com
>> <mailto:backseatdba_at_gmail.com>>:
>>
>> 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_at_strychnine.co.uk
>> <mailto:woodwardinformatics_at_strychnine.co.uk>> 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_at_rit.edu
>> <mailto:srcdco_at_rit.edu>>:
>>
>>> 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_at_rit.edu <mailto:srcdco_at_rit.edu>_| 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_at_gmail.com
>>> <mailto:sborden76_at_gmail.com>>
>>> *Sent:* Wednesday, May 8, 2019 10:19 AM
>>> *To:* Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>
>>> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>>> *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_at_gmail.com <mailto:sborden76_at_gmail.com>
>>>
>>>
>>>
>>> On May 8, 2019, at 9:59 AM, Scott Canaan <srcdco_at_rit.edu
>>> <mailto:srcdco_at_rit.edu>> 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_at_rit.edu <mailto:srcdco_at_rit.edu>_| 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.
>>>
>

--
http://www.freelists.org/webpage/oracle-l