Re: How to Install Oracle 12 Client in Existing Oracle Home
From: Leng Burgess <lkaing_at_gmail.com>
Date: Fri, 10 May 2019 10:05:34 +1000
Message-Id: <FE518E64-3C64-4EBB-9521-9354104DF7E4_at_gmail.com>
>> On 9 May 2019, at 6:28 am, Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>>
>> That goes back to my original question. When we did this in 10g, client side stuff was not in the database installation (the pro*COBOL precompiler for one), so the client was needed as well. It is there now, along with the client libraries, but I just wanted to make sure that everything they need is there. That’s a question I have out to the vendor.
>>
>> 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: Andrew Kerber <andrew.kerber_at_gmail.com <mailto:andrew.kerber_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 4:21 PM
>> To: Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>
>> Cc: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>; Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>; woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> What feature does the client have that is not already included in the database installation?
>>
>> On Wed, May 8, 2019 at 3:19 PM Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>> That was what I was told I had to do. I didn’t want to do it, and I’m actually glad that the installer isn’t letting me do it now. Although I’m getting pressure to figure out a way to get it done as they don’t want to change the architecture at this point and the app upgrade is now behind schedule.
>>
>> 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: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 3:03 PM
>> To: Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>
>> Cc: Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>;woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> I don't think anyone is arguing that you can't have the client on the same server as the database. Putting two different Oracle installations in the same home is the problem.
>>
>>
>>
>>
>> On Wed, May 8, 2019 at 1:52 PM Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>> I understand all that. We prefer to have them separate, but I lost that battle years ago.
>>
>> The (quick) history is this. Several times a year the app would start running slowly. It would only be fixed by restarting the app server and bouncing the database. At that point, it was running on old Solaris hardware and we were in the process of upgrading the app and migrating to Red Hat 7 and much newer servers. We did some analysis and found that the database was responding very quickly, however the app was sending the same SQL almost a million times, so it looked like the SQL was taking a long time to run. The decision was made to co-locate the app and the database (something I don’t like to do) to “eliminate the network” from the transaction. My belief was that the move from Solaris to Red Hat would have been enough to solve the problem as benchmarking that I had done showed that the Red Hat servers were 10 – 20 times faster than the Solaris servers. I was overruled, so I had to create an Oracle Home that ran the database and also contained all of the client software so the app could run.
>>
>> That’s how we got to where we are now. Now we are trying to upgrade from Oracle 12.1.0.2 to 12.2.0.1 and need a similar configuration. I’d love to go back to the app server / database server configuration, but those that made the original decision to co-locate them have said no.
>>
>> 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: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 2:40 PM
>> To: Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>
>> Cc: woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> Installing a client in an existing home puts you in a precarious position at best with Oracle Support.
>>
>>
>>
>>
>> On Wed, May 8, 2019 at 1:35 PM Jeff Chirco <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>> wrote:
>> 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.
>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>
Date: Fri, 10 May 2019 10:05:34 +1000
Message-Id: <FE518E64-3C64-4EBB-9521-9354104DF7E4_at_gmail.com>
I just searched the Oracle support site and found these notes. So I think you can go back to your company and quote these documents, and install it into a new Oracle Home…
Unable To Find Procob Precompilers On One Of The RAC Nodes After Installation (Doc ID 1432893.1)
Precompiler FAQ for 12cR1 (12.1.0.x) (Doc ID 1569872.1)
TIP: It is highly recommended to install Precompilers or any other Client software components into a separate ORACLE_HOME to avoid problems during installation, relink etc.
Q: How to avoid problems when a Precompiler needs to be patched - but Database cannot be shut down or upgrade/patching is not possible?
- It is always a better strategy to install a separate Oracle Client into a separate ORACLE_HOME because it contains the full set of Precompilers (except demos etc - see below). In cases where a patch has to be applied to a Oracle Client component, the Database can be up and running - otherwise has to be shutdown for a relink.
Please note that ANY patch set has to be reapplied to the installation after adding new products to the installation to keep the products in sync.
> On 10 May 2019, at 9:55 am, Leng Burgess <lkaing_at_gmail.com> wrote: > > Hi Scott, > > I vaguely recall that you could actually install the Oracle Client software on top of an existing ORACLE DB HOME in 10g! In fact, I had to install Pro*Cobol too :) > > Yes, back in 10g all the client software came in a different zip file and you simply installed them into an existing Oracle RDBMS home. > > I have not done any such installation (Pro*Cobol and RDBMS in the same home) after 10g so cannot comment on that one now. > > I think that we also have Pro*C lying around in my new organisation but the applications do not reside on the Oracle DB Server so we haven’t had to wrestle with this delima. > > Have you logged a call with Oracle Support and what did they say? > > > Cheers, > > Leng. > >
>> On 9 May 2019, at 6:28 am, Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>>
>> That goes back to my original question. When we did this in 10g, client side stuff was not in the database installation (the pro*COBOL precompiler for one), so the client was needed as well. It is there now, along with the client libraries, but I just wanted to make sure that everything they need is there. That’s a question I have out to the vendor.
>>
>> 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: Andrew Kerber <andrew.kerber_at_gmail.com <mailto:andrew.kerber_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 4:21 PM
>> To: Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>
>> Cc: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>; Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>; woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> What feature does the client have that is not already included in the database installation?
>>
>> On Wed, May 8, 2019 at 3:19 PM Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>> That was what I was told I had to do. I didn’t want to do it, and I’m actually glad that the installer isn’t letting me do it now. Although I’m getting pressure to figure out a way to get it done as they don’t want to change the architecture at this point and the app upgrade is now behind schedule.
>>
>> 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: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 3:03 PM
>> To: Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>
>> Cc: Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>;woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> I don't think anyone is arguing that you can't have the client on the same server as the database. Putting two different Oracle installations in the same home is the problem.
>>
>>
>>
>>
>> On Wed, May 8, 2019 at 1:52 PM Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>> wrote:
>> I understand all that. We prefer to have them separate, but I lost that battle years ago.
>>
>> The (quick) history is this. Several times a year the app would start running slowly. It would only be fixed by restarting the app server and bouncing the database. At that point, it was running on old Solaris hardware and we were in the process of upgrading the app and migrating to Red Hat 7 and much newer servers. We did some analysis and found that the database was responding very quickly, however the app was sending the same SQL almost a million times, so it looked like the SQL was taking a long time to run. The decision was made to co-locate the app and the database (something I don’t like to do) to “eliminate the network” from the transaction. My belief was that the move from Solaris to Red Hat would have been enough to solve the problem as benchmarking that I had done showed that the Red Hat servers were 10 – 20 times faster than the Solaris servers. I was overruled, so I had to create an Oracle Home that ran the database and also contained all of the client software so the app could run.
>>
>> That’s how we got to where we are now. Now we are trying to upgrade from Oracle 12.1.0.2 to 12.2.0.1 and need a similar configuration. I’d love to go back to the app server / database server configuration, but those that made the original decision to co-locate them have said no.
>>
>> 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: Seth Miller <sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com>>
>> Sent: Wednesday, May 8, 2019 2:40 PM
>> To: Backseat DBA <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>>
>> Cc: woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>; Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>>; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: How to Install Oracle 12 Client in Existing Oracle Home
>>
>> Installing a client in an existing home puts you in a precarious position at best with Oracle Support.
>>
>>
>>
>>
>> On Wed, May 8, 2019 at 1:35 PM Jeff Chirco <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com>> wrote:
>> 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.
>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 10 2019 - 02:05:34 CEST