[njhajhajha]

hello,
I am using Process maker 3.2.2 version
I have downloaded OracleInstantClient12.1DLLs and placed in apache/bin ,I referedf Process maker Oracle database Connection documentation and followed same steps.
Also made changes "extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client" in php.ini file


I am able to connect with my SQL develover ,but when i connect using Process maker i get following error:

.Resolving Host Name 192.168.11.177
.Checking port 1521
.Error Testing Connection: Connecting to host failed : Oracle connection refused
.Error Testing Connection: Opening database failed : Oracle connection refused


Please Help!!!

[amosbatto]

What is the operating system of your Oracle server?
What is the operating system of your ProcessMaker server?
Did you reboot both of your servers to make sure that the changes in the configuration have taken effect? (You can restart services, but I often find that I have forgotten to restart all of them, so rebooting makes sure.)

In the Oracle command line, you need to do this to allow remote connections:
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Now verify that the ProcessMaker server can connect to the Oracle server. In the command line of the ProcessMaker server, enter these commands:
ping {oracle-server-domain-or-ip}
nmap -sS -O -p1521 {oracle-server-domain-or-ip}
(If you are using Windows, then you can find nmap installers here.)

Then, in the command line of your Oracle server, enter this command:
netstat -an {oracle-server-domain-or-ip}
lsnrctl status
Post the output of these commands.

[njhajhajha]

Thanx for your Response!!!

OS of Oracle Server is Windows Server 2012 R2
Os of Process mamker server is Windows 8


I got this :

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
BEGIN DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); END;

*
ERROR at line 1:
ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml
ORA-06512: at "XDB.DBMS_XDB", line 712
ORA-06512: at "XDB.DBMS_XDB", line 898
ORA-06512: at line 1

[njhajhajha]

It just worked!!! Problem was with .dll files in apache/bin folder of Process maker.


Regards,

[Isabelle]

Hi, same problem for me.
I installed PM 3.3 on windows 7.
I also have downloaded OracleInstantClient12.1DLLs, placed in apache2/bin. I refered Process maker Oracle database Connection documentation and followed same steps.
made changes "extension=php_oci8_12c.dll ;" in php.ini file

but I'm still having Oracle connection refused.
Resolving host name DB : Ok
Chercking port 1521 : OK
but then
Error Testing connection : connection to host failed : Oracle connection refused
Error Testing connection : Opening database failed : Oracle connection refused

However, I can ping the oracle12 database serveur, telnet to 1521 port is OK and connecting to the oracle database
Can you explain how you solved the problem with .dll files?

Oracle database use AMERICAN_AMERICA.AL32UTF8 charactere set. I hadded a windows system variable NLS_LANG= AMERICAN_AMERICA.AL32UTF8 and I have tried also AMERICAN_AMERICA.UTF8, but it didn't work.

Thanks for any help!