Enabling Oracle Cloud ODBC
At Scriptcase, we have the following drivers available for connection to Oracle: Oracle 8.0.5 or Above, Oracle PDO, Oracle ODBC and Oracle 8 . If you are using your own pre-configured environment, Oracle extensions must be enabled manually in PHP.
Before proceeding at this documentation, check your PHP architecture. For drivers to be enabled correctly, the files must be downloaded according to the architecture used.
- In your Scriptcase, there is the file info.php, access it by URL:
http://127.0.0.1:8092/scriptcase/info.php, where you will find information regarding architecture in the phpinfo().
NOTE: Download the Oracle instant client according to your PHP architecture.
- Architecture i386/i686 = 32 bits
- Architecture x86_64 = 64 bits
Below are listed the files required for Oracle drivers to be enabled.
- Extension oci8.so: Clique Aqui
- Oracle Instant Client 18.104.22.168(x86_64): Clique Aqui
IMPORTANT: The PHP 7.3 is compatible with Oracle Instant Client 11.2 or Higher.
To download the Oracle Instant Client below the version 22.214.171.124, it is necessary to have a Oracle account.
- Oracle Instant Client 12.2.0 or Higher: Click Here
|Drive||Versão do banco de dados Oracle|
|Oracle PDO||9i||10g||11g R1||11g R2(11.2)||12c||18c||19c|
|Instant Client||Versão de base de dados Oracle|
|126.96.36.199||9i||10g||11g R1||11g R2(11.2)||12c||18c||19c|
Configuring Oracle ODBC on MacOs
It is necessary to enable the Oracle extension in PHP and configure Instant_Client to make the connection. Follow the steps described below to enable the connection drivers.
1 - On your Mac terminal, log in as root and create a folder with instant client numbering in
mkdir -p /usr/local/instantclient/188.8.131.52/
2 - Extract all content from the Instant Client downloaded previously on your Mac system and copy to the folder created in the previous step:
cp -avr __MACOSX/ oci_client_macosx_12/ /usr/local/instantclient/184.108.40.206/
3 - Copy the previously downloaded oci8.so extension to the PHP extensions directory:
ATENÇÃO: If you followed our documentation to install Scriptcase manually on macOs, the extension is already in the extensions directory. You can proceed to item 5.
sudo cp oci8.so /usr/local/lib/php/pecl/20180731
Access the info.php file and search for the extension_dir line. It will tell you the exact path to the directory responsible for PHP extensions.
4 - Edit the php.ini file(
/usr/local/etc/php/8.1/php.ini) and declare the Oracle extension at the end of the file.
5 - Restart the apache service for the changes to be saved. Use the command below for this:
sudo apachectl restart
Connection to Scriptcase
- Oracle ODBC: Click here
Questions or Connection Problems?
Contact our support in case of connection problems or questions regarding this database.