1626443 - PCM10: Failed to connect to Oracle database when configuring PCM v10 64bit "80880021 General Data Base Error ORA-12541 : TNS:no listener"

Symptom

When trying to connect to Oracle database, PCM configure failed to connect and raised 2 possible error messages :
"80880021 General Data Base Error ORA-12541 : TNS:no listener"

Or
"Invalid Workflow user - General Database Error"

Environment

• SAP BusinessObjects Profitability and Cost Management 10.0 (PCM)
• Oracle 11g client package installed on the same machine
• Business Objects Enterprise components (BOE - IPS 4.0 SP2 for CMS tool) installed and connected with Oracle CMS schema

Reproducing the Issue

1. Start with a working system:
   a) Windows Server 2008 64bit
   b) Oracle 11gR2 64bit
   c) Information Platform Services 4 (4.0 SP2) installed as the first product
   d) Can connect to the CMS correcly
2. Install PCM v10.0 64bit on the Primary Applications server.
3. Run the “Configuration Wizard” and the error message will be generated on the “Test Connection to Primary Server” page after pressing the “Next >” button.

Cause

• During the configuration, PCM v10 64bit environment failed to connect Oracle database due to the OCI Oracle *.dll currently installed in the system
• The PATH for Environment Variables pointed at the OCI dll from Client Oracle package, instead of using the OCI dll from the Oracle Instant Client for 64-bit

Resolution

1. Download the basic package "Instant Client for Microsoft (x64)" from the Oracle download website :
   
   
2. Extract the "instantclient-basic-windows.x64-11.2.0.2.0.zip" on a local drive of the PCM server.
   For example, C:\OCIx64\Instantclient_11_2
   
   
3. Copy all files from the root of "C:\OCIx64\Instantclient_11_2"  (excluding the 2 sub-directories "vc8" and "vc9")
   
4. Paste all of them into the "...SAP BusinessObjects\PCM\x64" directory
   
   
5. Copy the 2 files (oraocci11.dll and oraocci11.sym) from "C:\OCIx64\Instantclient_11_2\vc9"
   
   
   
   
6. Paste these 2 files into the "...SAP BusinessObjects\PCM\x64" directory.
   
   
7. Confirm the copy of the 2 files oraocci11.dll and oraocci11.sym to replace the 2 existing ones in the "...SAP BusinessObjects\PCM\x64" directory.
   
8. From the PCM Configure, choose the location of 64 bit OCI dll respectively from "...SAP BusinessObjects\PCM\x64" directory as shown below :

After completing the PCM Configure, PCM changes the PATH values in Environment Variables with the following order :
PATH : C:\Program Files (x86)\SAP BusinessObjects\PCM\x64; C:\app\Administrator\product\11.2.0\dbhome_1\BIN;...
Unfortunately, with this order, the CMS fails to connect to Oracle database.
The workaround to make both CMS and PCM work is :
1. Modify the order in the PATH values as following :
PATH : C:\app\Administrator\product\11.2.0\dbhome_1\BIN;C:\Program Files (x86)\SAP BusinessObjects\PCM\x64;... where ORACLE HOME BIN directory will be at the first place in the PATH, before PCM x64 directory
2. Reboot the machine
Knowing the issue of changing values in PATH for PCM Configuration, a new enhancement request was raised and can be tracked under the ADAPT01577625 :  PCM won't modify the system path if the OCI.dll is in the PCM x64 install directory for 64 bit setups or PCM Install directory for 32 bit setups. If the DLL is found anywhere else the path will be modified as before and asks for reboot.
This enhancement request has been implemented in PCM 10 SP01. Please see the PCM 10 SP release notes for full details.

See Also

1805310 - PCM: Oracle related errors
1753611 - PCM 10 Upgrade Configuration Errors - Oracle database
1626443 - PCM10:Fail to connect to Oracle database when configuring PCM v10 64bit
1853742 - Oracle Support for PCM v10 requires Oracle Database 11g Enterprise Edition Release
1671525 - PCM: What versions of Oracle are supported by PCM 10?
1524945 - PCM: When will PCM support Oracle v11.2?
1546214 "PCM: Oracle 11g R2 - #1 Installation"
1546171 "PCM: Oracle 11g R2 - #2 Create PCM Database"
1546215 "PCM: Oracle 11g R2 - #3 Create PCM TableSpace"
1546209 "PCM: Oracle 11g R2 - #4 Listener Configuration"
1546218 "PCM: Oracle 11g R2 - #5 Create PCM Schema"
1546210 "PCM: Oracle 11g R2 - #6 Configuration Wizard"
See also the PCM 10 Installation Guide available through the SAP Help Portal

Keywords

ADAPT01577625, ADAPT 01577625, Oracle OCI, Instant Client, x64 bit

Header Data

Released On	16.07.2013 10:58:10
Release Status	Released to Customer
Component	EPM-PCM Profitability and Cost Management, EPO, PP, AA, Metify
Priority	Normal
Category	Bug Filed