While that is recommended by Oracle (and perhaps all other DB vendors), it is not always possible to do that. Applications (not just Remedy) that depend on a vendor database, are designed to connect and communicate with the database using a client library. So when that client library is upgraded, the application may no longer be compatible with the underlying DB. Client libraries of a DB on the other hand are generally always compatible for at least one version backwards.
I would update client libraries with as much care as upgrading the underlying DB, and not just do it because the underlying DB is compatible with the application, but not its client of that same version.. The upgrade problem you had must have been specific to that particular upgrade script & if I was you, I would raise it as a defect as the upgrade script was perhaps deficient to not handle the previous database client libraries.. Joe From: Shiju John Sent: Wednesday, April 04, 2012 8:55 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi, The 11g client donot work properly, with the Oracle 10g R2 Server. In a recent up gradation, i have faced the same issue, and was forced to degrade the client version to 10g R2 client. It is mentioned in the Oracle site (as far as I remember) that the server and clients should be in the same version, but release doesnot matter. Thanks, Shiju.... On Wed, Apr 4, 2012 at 6:56 AM, jaya munjal <[email protected]> wrote: ** Frederick We are on Unix and know we need a 64 bit Oracle 11g client. But wanted to check if there are any issues that people have faced using 11g client with 10g server. As BMC support is saying that we would have to test ourselves if 11g client is fully compatible with 10g server Regards Jaya ------------------------------------------------------------------------------ From: "Grooms, Frederick W" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 12:55 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 1:57 PM To: [email protected] Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards ------------------------------------------------------------------------------ From: "Easter, David" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011) Extended Support Ends: 31-Jul-2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: [email protected] Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya -- Thanks and Regards, Shiju John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
