Problems with Oracle with SC 8.1.0.17

Scriptcase 8 Discussion
#1

Hello,
I started a project developed on Oracle database deployments then was developed with version 8.0.0.25, currently use the version of Scriptcase is 8.1.017, my system is a Windows 7 PRO and I always used the Oracle client 11.2 .0.3 (not Instant Client) with other projects and I never had problems.

The error in Scriptcase when connecting to the database during the configuration is:
"Connection error
Unable to load the specified driver. System Error 1114: initialization routine dynamic link library (DLL) failed.
(Oracle OraClient11g_home1_32bit, C: \ Oracle \ OraClient11gR2 \ BIN \ SQORA32.DLL). odbc_exec () Expects parameter 1 to be resource, boolean given "

I do not mind the drive Oracle that use with other applications or via odbc or direct access.
Tests on odbc and sqlplus not have problems, the same diagnostic Scriptcase reports that you’re all set with Oracle.

Initially I thought it was my client and replaced with instant client but the error message does not change.

I reset the machine several times, configuring both Oracle instant client to client but the situation does not change manually using sqlplus or odbc works through Scriptcase not.

I used XAMPP configuring with Oracle, using a script manual connection and I have no problems.

Do you have any advice?
Regards
Boly64

#2

Windows 64?? The full oracle client works (I know we use it here). But you need to install the 32 bit oracle client not the 64 bit. This because scriptcase is 32 bits.
You need to configure your tnsnames.ora also (at least we do). If you put the right string in there it should connect. Try the sqlplus.exe to connect first or download sqldeveloper (32 bit) to connect to your oracle for testing.

#3

Thank rr you for your quick response :

My system is Windows Seven 64Bit
Oracle Client 11.2.0.3 32Bit
Oracle Server 12c 64Bit

TNSPING, SQLPLUS :

C:\Windows\System32>tnsping p

TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 23-NOV-2
015 20:30:48

Copyright © 1997, 2011, Oracle. All rights reserved.
Used parameter files:
C:\Oracle\OraClient11gR2
etwork\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.0.14)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PWL)))
OK (10 msec)

C:\Windows\System32>SQLPLUS TOOLS/TOOLS@P
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 23 20:30:51 2015
Copyright © 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

SQL> DESCRIBE SSN_PREZZO_TARIFFARIO;
Name Null? Type

SSN_CODNOMENCLATORE NOT NULL VARCHAR2(15)
SSN_DESCNOMENCLATORE VARCHAR2(180)
SSN_IMPTARIFFARIO NOT NULL NUMBER(15,3)

SQL>

PATH SYSTEM
C:\Oracle\OraClient11gR2\bin

Oracle in Connection in scriptcase

string name of TS SC :

192.168.0.14/PWL

USER
TOOLS
PASSWORD
TOOLS

ERRORE:

ocilogon(): OCIEnvNlsCreate() failed. There is something wrong with your system -
please check that PATH includes the directory with Oracle Instant Client librarie

#4

I have these enabled in my php.ini:
extension=php_oci8.dll
extension=php_oci8_11g.dll

Please check if that goes for you too.
You need to restart your webserver after changing this.

Also I changed my httpd.conf:
FcgidInitialEnv PHPRC “C:\PROGRA~2\NetMake\v8\components\php”
FcgidInitialEnv PATH “c:\oracle\ora10g\bin;C:\PROGRA~2\NetMake\v8\components\php;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;”
FcgidInitialEnv SystemRoot “C:\Windows”
FcgidInitialEnv SystemDrive “C:”
FcgidInitialEnv TEMP “C:\WINDOWS\Temp”
FcgidInitialEnv TMP “C:\WINDOWS\Temp”
FcgidInitialEnv windir “C:\WINDOWS”

So check the PATH thing as well

#5

I confirm what you say , the file diagnostics me back the sequent highlighted in red the probable cause in my opinion . Rehearsing manually with xampp it is enhanced with the version of Oracle client in full ci8

[TABLE]
[TR]
[TD=“class: e”]OCI8 Support[/TD]
[TD=“class: v”]enabled[/TD]
[/TR]
[TR]
[TD=“class: e”]OCI8 DTrace Support[/TD]
[TD=“class: v”]disabled[/TD]
[/TR]
[TR]
[TD=“class: e”]OCI8 Version[/TD]
[TD=“class: v”]2.0.8[/TD]
[/TR]
[TR]
[TD=“class: e”]Revision[/TD]
[TD=“class: v”]$Id: f04114d4d67cffea4cdc2ed3b7f0229c2caa5016 $[/TD]
[/TR]
[TR]
[TD=“class: e”]Oracle Run-time Client Library Version[/TD]
[TD=“class: v”]0.0.0.0.0[/TD]
[/TR]
[TR]
[TD=“class: e”]Oracle Compile-time Instant Client Version[/TD]
[TD=“class: v”]11.2[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR=“class: h”]
Directive Local Value Master Value [/TR]
[TR]
[TD=“class: e”]oci8.connection_class[/TD]
[TD=“class: v”]no value[/TD]
[TD=“class: v”]no value[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.default_prefetch[/TD]
[TD=“class: v”]100[/TD]
[TD=“class: v”]100[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.events[/TD]
[TD=“class: v”]Off[/TD]
[TD=“class: v”]Off[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.max_persistent[/TD]
[TD=“class: v”]-1[/TD]
[TD=“class: v”]-1[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.old_oci_close_semantics[/TD]
[TD=“class: v”]Off[/TD]
[TD=“class: v”]Off[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.persistent_timeout[/TD]
[TD=“class: v”]-1[/TD]
[TD=“class: v”]-1[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.ping_interval[/TD]
[TD=“class: v”]60[/TD]
[TD=“class: v”]60[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.privileged_connect[/TD]
[TD=“class: v”]Off[/TD]
[TD=“class: v”]Off[/TD]
[/TR]
[TR]
[TD=“class: e”]oci8.statement_cache_size[/TD]
[TD=“class: v”]20[/TD]
[TD=“class: v”]20[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR=“class: h”]
Statistics [/TR]
[TR]
[TD=“class: e”]Active Persistent Connections[/TD]
[TD=“class: v”]0[/TD]
[/TR]
[TR]
[TD=“class: e”]Active Connections[/TD]
[TD=“class: v”]0 [/TD]
[/TR]
[/TABLE]

#6

Duh I overread the part that is was on your deployment server. Too quick from my side…
We are running on uniform here. I assume your xampp is also 32 bits, if not then this is the error…
Anyway both oracle dlls should also be installed in your deployment server. Yet the have a dependancy on MSVCR90.dll, OCI.dll, kernel32.dll and php5ts.dll which on itself depend pm other libs. You could run depends.exe (dependencywalker) to check if all dependant dll’s are there.
Since it gives version 0.0.0.0.0 I guess something is not loading on php. I cant tell you from here what exactly, I wish I could.
Since uniform server works here I guess it has minor differences compared to xampp.
I assume you run xampp as service, in which case the service must have access to the oracle path, oracle should the FIRST one in your Path environment variables (not the user path the system environment variables). You can use processexplorer from sysinternals to study the details of your running xampp process. There you can see which dlls are loaded. If all else fails you can use procmon from sysinternals to study what gets loaded and what doesnt. Be sure to sharpen your filters in there then since it gives a very big log of what your system is doing in miniscule detail.
With procmon you can surely see which dll is supposed to be loaded, sysinternals are the best in techy tools for finding why something isnt working next to nirsoft…

#7

I assume your xampp is also 32 bits, if not then this is the error…
Anyway both oracle dlls should also be installed in your deployment server. Yet the have a dependancy on MSVCR90.dll, OCI.dll, kernel32.dll and php5ts.dll which on itself depend pm other libs. You could run depends.exe (dependencywalker) to check if all dependant dll’s are there.