Gen CSE crdb*.bat give "ORA-12560: TNS:protocol adapter error"
Article ID: 57647
Updated On:
Products
Issue/Introduction
Installing Gen 8.6 Windows CSE environment using Oracle 64-bit database
I 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
Environment
Release: 8.5, 8.6
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
Feedback
