on 03-23-2017 7:39 PM
I'm working in an environment that has some old software. Currently they are running BO XI R2 over a Oracle 8i and 11g data warehouse. I have done a new install of BO and migrating reports and universes. The connection to Oracle 8i does not exit and is not supported by SAP. Does anyone have a work around for SAP BO 4.2 SP2 working with a Oracle 9 Drivers? Any help here would be great. Upgrading Oracle 8i is not an option at this point. FYI, the Repository and Audit DBs for the new installation are in SQL Server and Universe Connect to the 11g DB is working fine. Thanks for the help
My client was stuck with an heavily modified ERP, unable to upgrade Oracle's 8i DB. The solution I implemented was to create an empty 10g DB and copy small tables, use DBLink to the larger required tables. The BO Connection would go to this 10g DB and all was good. SAP should be able to suggest this since they do support the drivers used in this solution. No issues and customer is very pleased with this combined Oracle and SAP supported solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There's no way to be in a fully supported configuration, but you could try using a 10g or 11g client. Note that you will need the 64-bit client.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There are no workarounds. oracle 8 and 9 are not supported. Customer need to move their data to supported DB or not use the product.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and is not supported by SAP
Raise a message with SAP and ask for an alternative solution.
If you are facing any technical challenges/errors - Explain them briefly.
Regards,
Harish Karra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Denis,
Always PAM output or a formal channel (OSS message or other services) is the right way to suggest customers to be on supported platforms. Upgrading database to supported version might be the only solution but in above query requestor mentioned that "Upgrading Oracle 8i is not an option at this point" so I thought it is better to suggest him to go thru the formal channel to get same answer.
Regards,
Harish Karra
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.