Whilst attempting to start the ARCSDE service, the following error message appears:
DB_open_instance()::db_connect (OCI8) error: -1init_DB DB_instance_open_as_dba: -51DBMS error code: -1
Within the ARCSDE Home folder, analyse the log file for further errors. In this particular scenario, a further error message was found:
DBMS error code: 12557ORA-12557: TNS:protocol adapter not loadable
This error relates to the parameters set within the configuration file dbinit.sde. Ensure the Oracle Home and Path are set to the Oracle client and client bin area respectively. For example:
set ORACLE_SID= <SID NAME>set ORACLE_HOME=d:\oracle\product\11.2.0\client_1set LOCAL=<SID NAME>set PATH=d:\oracle\product\11.2.0\client_1\bin