Oracle Connection - Scriptcase 9 - Linux 64 Bits

Oracle Connection - Scriptcase 9 - Linux 64 Bits

This procedure will only work if you have a Scriptcase manual installation in your server.

To connect with Oracle in a Linux System, we must follow these steps below:

Step 1 -  Installing these packages:

UBUNTU/DEBIAN
CENTOS/RHEL
- sudo apt-get update
- sudo apt-get install libaio1
- sudo apt-get install libncurses5
- sudo apt-get install alien
- sudo apt-get install gcc-multilib g++-multilib
- sudo apt-get install libpam0g
- sudo apt-get install unixodbc-dev unixodbc


- sudo yum update
- sudo yum install libaio-devel
- sudo yum install libaio
- sudo yum install glibc
- sudo yum install compat-libstdc++-33
- sudo yum install glibc-devel
- sudo yum install libstdc++
- sudo yum install pam
- sudo yum install ncurses-devel
- sudo yum install unixODBC


Step 2 - Install the Instant Client:

Download the Instant Client version compatible with the archicteture x64:

UBUNTU/DEBIAN
CENTOS/RHEL
- sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
- sudo alien oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
- sudo dpkg -i oracle-instantclient12.1-basic_12.1.0.2.0-2_amd64.deb
- sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
- sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
- sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm

Step 3 - Copy the extension to the PHP extensions directory:

Download and extract the attached file(oci8.zip) and move this file in the PHP extensions directory.

Accessing the info.php file, search for the line extension_dir. This line will inform the exact path to the PHP extensions.


Step 4 - Edit the php.ini file:

Now that the extension was pasted at the directory, you will need to add at the bottom of the php.ini file this line below:

extension=oci8.so


Step 5 - Declare the environment variable responsible to identify the Oracle library:

Now it is necessary to declare the variable LD_LIBRARY_PATH in the responsible file for your system environment variables.

Check the path according to your System:

UBUNTU/DEBIAN
CENTOS/RHEL
- sudo nano /etc/apache2/envvars
- sudo nano /etc/sysconfig/httpd


The path to the library will depend on your installation. However, by default the path might be the same as this example:

Following the same example from php.ini, you will need to add just this variable at the bottom of the file with this syntax: 

export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/

If you are using CentOS/RHEL, you don't need to use the 'export' before the variable.


After doing all these procedures, you will need to restart your apache service.

UBUNTU/DEBIAN
CENTOS/RHEL
- sudo service apache2 restart
- sudo systemctl restart httpd

    • Related Articles

    • Oracle Connection - Scriptcase 8.1 - Linux

      To enable the connection to Oracle on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 ...

    • Manual Update - Linux

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Options > Settings, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this file to a ...

    • Install ScriptCase PHP 7.0 on a XAMPP on Linux

      Xampp Installation Using PHP 7.0 XAMPP It allows you to easily install Apache on your own computer, regardless of your operating system (Linux, Windows, MAC or Solaris). First you have to proceed to download XAMPP PHP ...

    • Install ScriptCase PHP 7.3 on a XAMPP in Linux

      Xampp Installation Using PHP 7.3 XAMPP It allows you to easily install Apache on your own computer, regardless of your operating system (Linux, Windows, MAC or Solaris). First you have to proceed to download XAMPP PHP ...

    • Filtering Connection Database - Oracle

      On various occasions, we encounter slowness when connecting to the database or while editing and executing applications. It is possible to resolve these issues by optimizing data loading through filter configuration. To do so, follow these steps: ...