Gen CSE crdb*.bat gives "ORA-12560: TNS:protocol adapter error"

Products

• Gen

Issue/Introduction

Installing Gen 8.6 Windows CSE environment using Oracle 64-bit database, found statements below on the Gen 8.6 doc page for Prerequisites for CSE Configuration

Note: 
For 32-bit CSE Servers (Windows, AIX only) which run against 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 creating ORACLE CSE database 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 using the 32-bit Oracle client software to execute sample .bat files (ex. crdbcse.bat,crdbdir.bat), receive an error:

"ORA-12560: TNS:protocol adapter error"

SQL> whenever sqlerror exit failure

SQL> whenever oserror exit failure

SQL>

SQL> startup nomount pfile=%ORACLE_HOME%\dbs\initdbcse.ora

ORA-12560: TNS:protocol adapter error

%ORACLE_HOME%\dbs>oradim -edit -sid DBCSE -startmode auto -srvcstart system Unable to start service, OS Error 1056

Resolution

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 is 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.

Additional Information

Gen Windows Oracle CSE Configuration with a 64-bit Oracle Database