Oracle Connection - Scriptcase 8.1 - Linux

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\DEBIANCENTOS\RHEL
- sudo dpkg —add-architecture i386

- sudo apt-get update

- sudo apt-get install libaio1:i386
- sudo apt-get install libncurses5:i386
- sudo apt-get install alien

- sudo apt-get install gcc-multilib g++-multilib

- sudo apt-get install libpam0g:i386

- sudo apt-get install ksh:i386
- sudo apt-get install unixodbc-dev:i386 unixodbc:i386
- sudo yum update
- sudo yum install libaio-devel.i686
- sudo yum install libaio.i686
- sudo yum install glibc.i686
- sudo yum install compat-libstdc++-33.i686
- sudo yum install glibc-devel.i686
- sudo yum install libstdc++.i686
- sudo yum install pam.i686
- sudo yum install ncurses-devel.i686
- sudo yum install unixODBC.i686
- sudo wget ftp://195.220.108.108/linux/centos/6.7/os/i386/Packages/ksh-20120801-28.el6.i686.rpm
- sudo yum install ksh-20120801-28.el6.i686.rpm
- sudo yum install nano


Step 2 - Download Instant Client Oracle :

Oracle Instant Client Basic 12.1.0.2.0-1
Oracle Instant Client Devel 12.1.0.2.0-1

Step 3 - Download PHP extension : 


PHP 5.6
PHP 5.4

Step 4 - Copy the extension to the folder ext scriptcase :
- sudo cp oci8.so /opt/NetMake/v81/components/apache/ext/


Paso 5 - Install the Oracle Instant Client

UBUNTU\DEBIANCENTOS\RHEL
Modificar el cliente instantánea instalador de Oracle a .deb para ser ejecutable:
- sudo alien —target=amd64 oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm
- sudo alien --target=amd64 oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm
Install the Instant Client Oracle :
- 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
- yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm
- yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm


Paso 6  - Restart apache :
- sudo /etc/init.d/apachesc81 restart

    • Related Articles

    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • 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: ...