Feedback Print

Linux

The automatic installation already comes with the Oracle extension only needing to connect with the database.

If you are using your own previously configured environment, you will need to enable the Oracle extension in PHP.

Oracle PDO

Setting up Oracle PDO on Linux

Due to a problem in the Oracle 64-bit extension, you can not use the connection with the automatic installation. To learn how to use Oracle with your 64bit Scriptcase access the documentation.

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

  • Install the dependencies below:
UBUNTU\DEBIAN CENTOS\RHEL
- sudo apt-get update - sudo yum update
- sudo apt-get install libaio1 - sudo yum install libaio-devel
- sudo apt-get install libncurses5 - sudo yum install libaio
- sudo apt-get install alien - sudo yum install glibc
- sudo apt-get install gcc-multilib g++-multilib - sudo yum install compat-libstdc++-33
- sudo apt-get install libpam0g - sudo yum install glibc-devel
- sudo apt-get install unixodbc-dev unixodbc - sudo yum install libstdc++
  - sudo yum install libstdc++
  - sudo yum install pam
  - sudo yum install ncurses-devel
  - sudo yum install unixODBC

Installing Oracle Client

UBUNTU\DEBIAN  
Architecture x86 Architecture x64
sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm 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.i386.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_i386.deb 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_i386.deb sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
CENTOS\RHEL  
Architecture x86 Architecture x64
sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Restart the Apache Server:

sudo /etc/init.d/apachesc9 restart

Oracle 8.0.5 or Higher

Setting up Oracle 8.0.5 or Higher on Linux

Due to a problem in the Oracle 64-bit extension, you can not use the connection with the automatic installation. To learn how to use Oracle with your 64bit Scriptcase access the documentation.

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

  • Install the dependencies below:
UBUNTU\DEBIAN CENTOS\RHEL
- sudo apt-get update - sudo yum update
- sudo apt-get install libaio1 - sudo yum install libaio-devel
- sudo apt-get install libncurses5 - sudo yum install libaio
- sudo apt-get install alien - sudo yum install glibc
- sudo apt-get install gcc-multilib g++-multilib - sudo yum install compat-libstdc++-33
- sudo apt-get install libpam0g - sudo yum install glibc-devel
- sudo apt-get install unixodbc-dev unixodbc - sudo yum install libstdc++
  - sudo yum install libstdc++
  - sudo yum install pam
  - sudo yum install ncurses-devel
  - sudo yum install unixODBC

Installing Oracle Client

UBUNTU\DEBIAN  
Architecture x86 Architecture x64
sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm 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.i386.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_i386.deb 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_i386.deb sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
CENTOS\RHEL  
Architecture x86 Architecture x64
sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Restart the Apache Server:

sudo /etc/init.d/apachesc9 restart

Oracle ODBC

Setting up Oracle ODBC on Linux

Due to a problem in the Oracle 64-bit extension, you can not use the connection with the automatic installation. To learn how to use Oracle with your 64bit Scriptcase access the documentation.

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

  • Install the dependencies below:
UBUNTU\DEBIAN CENTOS\RHEL
- sudo apt-get update - sudo yum update
- sudo apt-get install libaio1 - sudo yum install libaio-devel
- sudo apt-get install libncurses5 - sudo yum install libaio
- sudo apt-get install alien - sudo yum install glibc
- sudo apt-get install gcc-multilib g++-multilib - sudo yum install compat-libstdc++-33
- sudo apt-get install libpam0g - sudo yum install glibc-devel
- sudo apt-get install unixodbc-dev unixodbc - sudo yum install libstdc++
  - sudo yum install libstdc++
  - sudo yum install pam
  - sudo yum install ncurses-devel
  - sudo yum install unixODBC

Installing Oracle Client

UBUNTU\DEBIAN  
Architecture x86 Architecture x64
sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm 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.i386.rpm sudo alien oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
sudo alien oracle-instantclient12.1-odbc-12.1.0.2.0-1.i386.rpm sudo alien oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
sudo dpkg -i oracle-instantclient12.1-basic_12.1.0.2.0-2_i386.deb 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_i386.deb sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
sudo dpkg -i oracle-instantclient12.1-odbc-12.1.0.2.0-2_i386.deb sudo dpkg -i oracle-instantclient12.1-odbc-12.1.0.2.0-2_amd64.deb
CENTOS\RHEL  
Architecture x86 Architecture x64
sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-odbc-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm

Restart the Apache Server:

sudo /etc/init.d/apachesc9 restart

Oracle 8

Setting up Oracle 8 on Linux

Due to a problem in the Oracle 64-bit extension, you can not use the connection with the automatic installation. To learn how to use Oracle with your 64bit Scriptcase access the documentation.

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

  • Install the dependencies below:
UBUNTU\DEBIAN CENTOS\RHEL
- sudo apt-get update - sudo yum update
- sudo apt-get install libaio1 - sudo yum install libaio-devel
- sudo apt-get install libncurses5 - sudo yum install libaio
- sudo apt-get install alien - sudo yum install glibc
- sudo apt-get install gcc-multilib g++-multilib - sudo yum install compat-libstdc++-33
- sudo apt-get install libpam0g - sudo yum install glibc-devel
- sudo apt-get install unixodbc-dev unixodbc - sudo yum install libstdc++
  - sudo yum install libstdc++
  - sudo yum install pam
  - sudo yum install ncurses-devel
  - sudo yum install unixODBC

Installing Oracle Client

UBUNTU\DEBIAN  
Architecture x86 Architecture x64
sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm 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.i386.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_i386.deb 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_i386.deb sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
CENTOS\RHEL  
Architecture x86 Architecture x64
sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Restart the Apache Server:

sudo /etc/init.d/apachesc9 restart

Oracle 7 or Lower

Setting up Oracle 7 or Lower on Linux

Due to a problem in the Oracle 64-bit extension, you can not use the connection with the automatic installation. To learn how to use Oracle with your 64bit Scriptcase access the documentation.

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

  • Install the dependencies below:
UBUNTU\DEBIAN CENTOS\RHEL
- sudo apt-get update - sudo yum update
- sudo apt-get install libaio1 - sudo yum install libaio-devel
- sudo apt-get install libncurses5 - sudo yum install libaio
- sudo apt-get install alien - sudo yum install glibc
- sudo apt-get install gcc-multilib g++-multilib - sudo yum install compat-libstdc++-33
- sudo apt-get install libpam0g - sudo yum install glibc-devel
- sudo apt-get install unixodbc-dev unixodbc - sudo yum install libstdc++
  - sudo yum install libstdc++
  - sudo yum install pam
  - sudo yum install ncurses-devel
  - sudo yum install unixODBC

Installing Oracle Client

UBUNTU\DEBIAN  
Architecture x86 Architecture x64
sudo alien oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm 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.i386.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_i386.deb 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_i386.deb sudo dpkg -i oracle-instantclient12.1-devel_12.1.0.2.0-2_amd64.deb
CENTOS\RHEL  
Architecture x86 Architecture x64
sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm sudo yum install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Restart the Apache Server:

sudo /etc/init.d/apachesc9 restart

Creating a Connection with ScriptCase

  • Access ScriptCase using the URL http://127.0.0.1:8090/scriptcase
  • After accessing ScriptCase, access or create a new project, click on the new connection icon or access “Database > New Connection”

Creating a new connection Creating a new connection

  • After that, you will see a page with all the database connections that you can create. Select a “Oracle” connection

 Selecting a Linux database connection Selecting a Linux database connection

  • New connection : You will place the information of the connection to your database here:

 Connecting with Linux database Connecting with Linux database

  • Connection Name : Defines the name of your new connection.
  • DBMS Driver : Allows you to select the drivers: Oracle 8.0.5 or Higher.
  • TSNAME : Insert the name or IP of the server where the Linux database is located with the Service Name created in the Linux installation.
  • Username : Inform the user to access the Linux database.
  • Password : Inform the password to access the Linux database.
  • Test Connection : Displays a message of the status of the connection if successful or not.

  • For more options on connecting, click on the Advanced tab:

 Advanced setup for the Linux database Advanced setup for the Linux database

  • client_encoding : Database Encoding.
  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Persistent Connection - Persistent Connection are connections that don’t close when finishing a script.
  • Use the schema before table name - Allows the use of schemas before the name of the tables.

  • Filter : Accessing this tab, we can setup which tables will be listed on this connection:

Filtering the Linux database Filtering the Linux database

  • Show - Allows the display of the the filters on the tables, views, System Tables and procedures.
    • Tables - Allows to setup the display of Tables from your database.
    • Views - Allows to setup the display of Views from your database.
    • System Tables - Allows to setup the display of System Tables from your database.
    • Procedures - Allows to setup the display of Procedures from your database.
  • Searches - Allows to define which tables and Owner will be displayed.
    • Tables - Allows to define a prefix (prefix%) or name of the tables for display.
    • Owner - Allows to define the owner of the tables for listing.
    • Show - Allows to define what will be displayed or not from the table an owner’s setup.