Environment connecting to the Oracle 64-bit server and using the Oracle 32-bit client software

Document ID : KB000057647
Last Modified Date : 14/02/2018
Show Technical Document Details

We're installing CA Gen r8.5 CSE environment using Oracle 64 bit database.

I found statements below on the page for CSE Installation and Configuration - Prerequisites for CSE Configuration - Configuring Databases - Create Oracle CSE Database in Client Server Encyclopedia User Guide.

Note: For CSE Servers running on a 64-bit Oracle database, the 32-bit Oracle client software must also be installed with the 64-bit Oracle database software. Install the 32-bit Oracle client software after installing the database server software to ensure that the Oracle client bin directory precedes the Oracle server bin directory in the PATH environment variable. In this case, the 64-bit database engine and the 32-bit client library have different ORACLE_HOME values.

When I used the 32-bit Oracle client software to execute sample .bat files (ex. crdbcse.bat,crdbdir.bat), I got an error: 



ORA-12560: TNS:protocol adapter error


SQL> whenever sqlerror exit failure

SQL> whenever oserror exit failure


SQL> startup nomount pfile=C:\oracle\product\11.2.0\dbhome_1\dbs


ORA-12560: TNS:protocol adapter error


C:\oracle\product\11.2.0\dbhome_1\dbs>oradim -edit -sid DBCSE -startmode auto -srvcstart system Unable to start service, OS Error 1056


The sample Windows Oracle CSE database creation .bat files (crdbcse.bat & crdbdir.bat) do not work on an environment using the Oracle 32-bit client software to connect to the Oracle 64-bit server because the files do not support a connection via the Oracle TNS Listener (required for a 32-bit client-> 64-bit database connection).

At this stage, the CSE software configuration is not yet started and the goal is to simply create the Oracle instance and database for the CSE. Therefore, the Oracle instance/database can either be created by running the .bat files with the 64-bit SQLPlus client using a local connection to the database or by using the standard database configuration tool provided by Oracle.

After the Oracle instance/database are created, as written in the manual, the 32-bit Oracle client software must also be installed for use by the 32-bit Windows Oracle CSE software.

In addition the reference in the Client Server Encyclopedia User Guide to "after installing the database server software" has been replaced with "after creating ORACLE CSE database".