BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

Which Oracle Client? Using 11g CMS DB, 11g/10g data sources
1 members found this topic helpful

 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
dajabon
Principal Member
Principal Member



Joined: 09 Sep 2003

Posts: 148



PostPosted: Wed Mar 10, 2010 9:17 am 
Post subject: Which Oracle Client? Using 11g CMS DB, 11g/10g data sources

We are setting up a new BOE XI 3.1, SP2, FP2.4 system on five 64-bit Linux servers/nodes/boxes. We are using an Oracle 11g database for CMS.

2 nodes/boxes will run CMS and 3 will run BO reporting and job servers.

I dug into this and here is what I found:
Quote:
BO XI 3.1 Base Install Release Notes: "There are known connectivity issues with Oracle 11g when used as a CMS database. It is recommended that you use an earlier version of Oracle as a database, for example Oracle 10g. This applies to both UNIX and Windows installations."


However, this does not answer all of my questions, so I hope someone here can help out:

1) Does FixPack 2.4 still suffer from the Oracle 11g client problem?

2) Is the Oracle 11g client problem limited to just CMS nodes are also dedicated reporting/processing nodes as well?

3) What about the Oracle client bit version; can I use the 64-bit version of Oracle 11g client?
I installed the latest 11.2 64-bit client using the "Administrator" option and found no "lib32" folder.

Any help would be welcome. I have also opened a "Customer Message" with SAP, but I trust you all more than I do them. icon_wink.gif
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13981
Location: London


flag
PostPosted: Wed Mar 10, 2010 9:38 am 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Quote:
1) Does FixPack 2.4 still suffer from the Oracle 11g client problem?

I would be surprised if it didn't, Service Packs are usually where this changes.
Quote:
2) Is the Oracle 11g client problem limited to just CMS nodes are also dedicated reporting/processing nodes as well?

Check the Business Objects PAR Product Availablity Report for 3.1 SP2, also check there for your question, above, if you have not being referring to this already.
Quote:

3) What about the Oracle client bit version; can I use the 64-bit version of Oracle 11g client?

Nope, you have to use 32 bit client, BO is compatable with 64 Bit hardware and OS software, but, currently, only in 32 bit modes.

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
dajabon
Principal Member
Principal Member



Joined: 09 Sep 2003

Posts: 148



PostPosted: Wed Mar 10, 2010 12:06 pm 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Mak 1, thanks for the answers!

All that I could find documented on this topic is in the "BusinessObjects Enterprise XI 3.1 SP2 for Linux Supported Platforms"

Quote:

Data Source Middleware Support
BusinessObjects Enterprise Suite products that are compiled as 32-bit native binary are designed to use 32-bit data source middleware connectivity. Unless otherwise specified in the PAR, 64-bit middleware connectivity is not supported.
...

CMS Database (Repository) & Audit Databases
Provider Name --- Data Connector
Oracle 11g R1 (11.1) --- Oracle Net Client 10.2 (1) (2)

(1) Oracle Real Application Cluster (RAC) is supported.
(2) For more information about support of Oracle 11g R1 with Oracle Net Client 10.2, please refer to the Release Notes.

...

Web Intelligence, Desktop Intelligence, Dashboard and Analytics Data Sources
Provider Name --- Data Connector
Oracle 11g R1 (11.1) --- Oracle Net Client 11gR1 (11.1) (4) (6)
Oracle 10g R1 (10.1) --- Oracle Net Client 10.1 (6)
Oracle 10g R2 (10.2) --- Oracle Net Client 10.2 (6)

(4) Not supported for Predictive Analysis.
(6) Oracle Real Application Cluster (RAC) is supported.


The funny part is that the XI 3.1 SP2 Release Notes make no mention of Oracle 11g; only the XI 3.1 Release Notes make such a mention (cited in original post).

SAP Support is saying to follow the "BusinessObjects Enterprise XI 3.1 SP2 for Linux Supported Platforms" exclusively. So then my answers from this document would be CMS Nodes should run Oracle 10.2 client, WebI Processing Server Nodes should run Oracle 11 client. Also the doc clearly states 32-bit is the way to go, although I suppose if the 64-bit middleware included 32-bit libraries all would be OK, except as I noted before 11.2 does not for Linux.

So my only remaining question is whether or not to install the 11.1 or 11.2 client on the processing nodes. DBA says put the latest version but the doc seems to say to match the client version to the database version.

I cannot locate a PAR document for XI 3.1 SP2. Too be honest, I have never really been able to find these. Where are they stored?


Last edited by dajabon on Wed Mar 10, 2010 12:45 pm, edited 2 times in total
Back to top
bension
Forum Associate
Forum Associate



Joined: 01 Sep 2005

Posts: 734
Location: San Diego, CA



PostPosted: Wed Mar 10, 2010 12:27 pm 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

See this link for the PAR:

http://www.forumtopics.com/busobj/viewtopic.php?t=139214
Back to top
dajabon
Principal Member
Principal Member



Joined: 09 Sep 2003

Posts: 148



PostPosted: Wed Mar 10, 2010 12:35 pm 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

bension wrote:
See this link for the PAR:
http://www.forumtopics.com/busobj/viewtopic.php?t=139214


Thanks! That helps!

Hmmm... so if I follow the instructions there they lead me to a section called "Supported Platforms/PARs". Therefore, my conclusion is that the document I have been reading "BusinessObjects Enterprise XI 3.1 SP2 for Linux Supported Platforms" is the XI 3.1 SP2 Linux PAR. Is this a correct conclusion?
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13981
Location: London


flag
PostPosted: Wed Mar 10, 2010 2:20 pm 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Quote:
So my only remaining question is whether or not to install the 11.1 or 11.2 client on the processing nodes. DBA says put the latest version but the doc seems to say to match the client version to the database version.


Match it to the DB version, i.e. follow the PAR. I'm not saying it won't work, I have used many unsupported components, not from choice, in the past and have not had issues.
However, if I was initially responsible, as you are, for setting this up I would go with the PAR.
Quote:
Therefore, my conclusion is that the document I have been reading "BusinessObjects Enterprise XI 3.1 SP2 for Linux Supported Platforms" is the XI 3.1 SP2 Linux PAR. Is this a correct conclusion?

Yep, could have told you that, PAR = Supported Platforms yesnod.gif .

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
risinguday
Forum Member
Forum Member



Joined: 28 Jun 2010

Posts: 3


flag
PostPosted: Tue Aug 17, 2010 5:12 am 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Brining the topic back to life.

Currently in our setup we have BO XI R3.1 SP3 deployed with the repository and reporting databases on Oracle 10g.
We are having a few application databases migrated to Oracle 11gr2 (Oracle database 11g Enterprise Edition Release 11.2.0.1.0 - 64 bit Production)

From the Platforms supported document for BOXI R3.1 SP3 for Linux, I read that Oracle 11g R2 is not supported as repository and audit database, however I could not find anything about reporting database.
banghead.gif
Back to top
dajabon
Principal Member
Principal Member



Joined: 09 Sep 2003

Posts: 148



PostPosted: Wed Aug 18, 2010 8:45 am 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Oracle 11.2.x databases as data stores should be fine. In fact, what matters more is the client that you install on the BO server. Make sure it is 11.1.x or lower (even if the box is not running the CMS).
Back to top
Darth Services
Principal Member
Principal Member



Joined: 20 Nov 2007

Posts: 342
Location: Death Star Schema


flag
PostPosted: Mon Jul 18, 2011 4:44 am 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

Solaris - BOE XI 3.1 SP4. I have just upgraded to 11gR2 (11.2.0.2) for the CMS and Audit databases and am having problems configuring LDAP authentication in the CMC, the ever helpful "An internal error has occurred in the secLdap plugin".

SAP KB Article #1486546 - Oracle Net Client 11.1 support for BusinessObjects Enterprise XI 3.1 Service Pack 3 on CMS database. Anyone have any update for SP4?

Looking at the "SAP BusinessObjects Enterprise XI 3.1 SP4 for Solaris Supported Platforms" document it has on page 8 for CMS databases:
Quote:

Oracle 10g R1 (10.1) | Oracle Net Client 10.1 (1)
Oracle 10g R2 (10.2) | Oracle Net Client 10.2 (1)
Oracle 11g R1 (11.1) | Oracle Net Client (11.1.0.6) (1) (2)
Oracle 11g R2 (11.2) (4) | Oracle Net Client (11.1.0.6) (1) (2)
Oracle 11g R2 (11.2) | Oracle Net Client (11.2) (1) (2)

(1) Oracle Real Application Cluster (RAC) is supported.
(2) LDAP configuration not supported. For more information about support of Oracle 11g R1 with Oracle Net Client 10.2 as alternative, please refer to the Release Notes.


Why are some of the footnote in blue, some in black?
Where is footnote (4)?!
It seems according to footnote 2 that Oracle 11gR2 with 10.2 client is not supported either for LDAP configuration?! Refering to the Release Notes for SP4 does not mention "support of Oracle 11g R1 with Oracle Net Client 10.2 as alternative" at all!

Please help!
Back to top
viru4808
Principal Member
Principal Member



Joined: 09 Jan 2008
ASUG Icon
Posts: 142
Location: somewhere in universe


flag
PostPosted: Mon Feb 27, 2012 11:57 pm 
Post subject: Re: Which Oracle Client? Using 11g CMS DB, 11g/10g data sour

I know am replying to an Old Post, but maybe this will help someone...

We had the same problem while configuring LDAP Authentication with BO XI 3.1 SP4, this is discussed in detail in SAP Note: 1202563.

We had to update the Oracle Client on CMS server from 10.2.0.4 to 10.2.0.5.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0392 seconds using 17 queries. (SQL 0.0109 Parse 0.0009 Other 0.0273)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo