Technote

(troubleshooting)

"Oracle not Installed" error when accessing Oracle database information in Configuration Manager

Problem(Abstract)

You have an Oracle database installed. When you try to create an instance or access or change any database information through WebSphere Commerce Configuration Manager you receive the following message: Oracle not installed.

Cause You get this message because there are incorrect or missing entries in the product.xml file located under CommerceServerxxx\xml.

This is the Oracle section of the product.xml file:

<database>
<name>ORACLE</name>
<edition>
<name>Server</name>
</edition>
<version></version>
<release>$ORACLE_RELEASE</release>
<modification>$ORACLE_MODIFICATION</modification>
<fixpak>$ORACLE_FIXPAK</fixpak>
<default></default>
<install>
<date></date>
<time></time>
<path></path>
</install>
<upgraded></upgraded>
</database>

<database>
<name>ORACLE</name>
<edition>
<name>Client</name>
</edition>
<version></version>
<release>$ORACLE_RELEASE</release>
<modification>$ORACLE_MODIFICATION</modification>
<fixpak>$ORACLE_FIXPAK</fixpak>
<default></default>
<install>
<date></date>
<time></time>
<path></path>
</install>
<upgraded></upgraded>
</database> Resolving the problem Use the following steps to resolve the problem. You must know your Oracle version and installation path or client installation path (in case of a remote database).

1. Back up your product.xml file.

2. Change the Oracle section of the file to look the same as the following section:
   <database>
   <name>ORACLE</name>

<edition>
<name>Server</name>
</edition>
<version>9</version>
<release>$ORACLE_RELEASE</release>
<modification>$ORACLE_MODIFICATION</modification>
<fixpak>$ORACLE_FIXPAK</fixpak>
<default>1</default>
<install>
<date></date>
<time></time>
<path>D:\oracle\ora92</path>
</install>
<upgraded></upgraded>
</database>

<database>
<name>ORACLE</name>
<edition>
<name>Client</name>
</edition>
<version>9</version>
<release>$ORACLE_RELEASE</release>
<modification>$ORACLE_MODIFICATION</modification>
<fixpak>$ORACLE_FIXPAK</fixpak>
<default>1</default>
<install>
<date></date>
<time></time>
<path>D:\oracle\ora92</path>
</install>
<upgraded></upgraded>
</database>

3. Populate the following tags:
<Version>: This is the Oracle version.
<default>: This must be set to "1" in order to make Oracle the default database. Make sure you check the DB2 entries in the XML file and set the <default> tag there to "0" if it is not already "0".
<path>: This is the Oracle installation path. If you have a remote database then this is your client installation path.

4. Ensure that you update both the <server> and <client> section.

5. Once the changes are made, save the file and restart the Configuration Manager. Cross Reference information

Segment	Product	Component	Platform	Version	Edition
Commerce	WebSphere Commerce Professional Edition	Configuration	AIX, Linux, Solaris, Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4, 5.6.1.4	Professional Edition
Commerce	WebSphere Commerce - Express	Configuration	i5/OS, Linux, Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4	Express
Commerce	WebSphere Commerce Business Edition	Configuration	AIX, Linux, Solaris, Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4
Commerce	WebSphere Commerce Developer Enterprise	Configuration	Windows	6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4	Enterprise
Commerce	WebSphere Commerce Developer Professional Edition	Configuration	Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4, 5.6.1.4	Developer Professional Edition
Commerce	WebSphere Commerce Developer Business Edition	Configuration	Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4	Developer Business Edition
Commerce	WebSphere Commerce Developer Express	Configuration	Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4	Developer Express

   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21244426