asked on

Is there a way to utilize an Oracle wallet via PHP on windows?

I have a PHP codebase that resides on a Windows server that connects to an Oracle database. My database is moving to a Oracle in the cloud setup that requires us to use an Oracle wallet to connect.

I got the setup for the wallet and can connect via the utilities, but all my research thus far has me using oci_connect() with a session_mode of OCI_CRED_EXT. But PHP's oci_connect (https://www.php.net/manual/en/function.oci-connect.php) states "OCI_CRED_EXT is not supported on Windows for security reasons.".

Is there a way to utilize an Oracle wallet via PHP on windows?

Franck Pachot

Hi, I may be wrong as I don't use PHP be the only thing you need is to set the TNS_ADMIN environment variable to the wallet location (and be sure that the path in sqlnet.ora is the path of the wallet as well)
And I think OCI_CRED_EXT hast nothing to do with that. It is used for authentication wallet (password stored in the wallet rather than provided in the application). Your connection requires the wallet for SSL encryption.

Jezhra

ASKER

The Oracle in the cloud solution is coming from a third-party vendor and we are being told that we won't have direct access to our password, but will be given access to a wallet that stores the credentials. In the first meeting they remoted into one of our development servers and installed a wallet. I can make a connection using command line tools, but php balks because of the OCI_CRED_EXT flag on the call. I think its a combination of PHP and Windows that's giving me the grief at the moment.

ASKER CERTIFIED SOLUTION

Franck Pachot

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial