Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save syahzul/2632262df21974ecd02be3ccce66fbef to your computer and use it in GitHub Desktop.
Save syahzul/2632262df21974ecd02be3ccce66fbef to your computer and use it in GitHub Desktop.

Revisions

  1. syahzul revised this gist Apr 12, 2021. 1 changed file with 1 addition and 1 deletion.
    Original file line number Diff line number Diff line change
    @@ -35,7 +35,7 @@ ln -s /usr/local/lib/libclntsh.dylib.19.1 /usr/local/lib/libclntsh.dylib
    ## Install extension with PECL

    ```bash
    pecl install oci8
    pecl install oci8-2.2.0
    ```

    If the script prompt you to provide the path to ORACLE_HOME directory, respond with:
  2. syahzul revised this gist Oct 14, 2020. 1 changed file with 2 additions and 2 deletions.
    Original file line number Diff line number Diff line change
    @@ -18,8 +18,8 @@ sudo mkdir /opt/oracle

    Download the following files from [Oracle website](https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html)

    - [Basic Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-basic-macos.x64-19.8.0.0.0dbru.zip)
    - [SDK Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-sdk-macos.x64-19.8.0.0.0dbru.zip)
    - [Basic Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-basic-macos.x64-19.8.0.0.0dbru.zip)
    - [SDK Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-sdk-macos.x64-19.8.0.0.0dbru.zip)

    Unzip all theses files into a the directory `/opt/oracle/instantclient_19_8`.

  3. syahzul revised this gist Oct 14, 2020. 1 changed file with 7 additions and 7 deletions.
    Original file line number Diff line number Diff line change
    @@ -18,17 +18,17 @@ sudo mkdir /opt/oracle

    Download the following files from [Oracle website](https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html)

    - [instantclient-basic-macos.x64-19.3.0.0.0dbru.zip](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-basic-macos.x64-19.3.0.0.0dbru.zip)
    - [instantclient-sdk-macos.x64-19.3.0.0.0dbru.zip](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-sdk-macos.x64-19.3.0.0.0dbru.zip)
    - [Basic Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-basic-macos.x64-19.8.0.0.0dbru.zip)
    - [SDK Package (ZIP)](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-sdk-macos.x64-19.8.0.0.0dbru.zip)

    Unzip all theses files into a the directory `/opt/oracle/instantclient_19_3`.
    Unzip all theses files into a the directory `/opt/oracle/instantclient_19_8`.

    ## Create symlinks

    ```bash
    ln -s /opt/oracle/instantclient_19_3/sdk/include/*.h /usr/local/include/
    ln -s /opt/oracle/instantclient_19_3/*.dylib /usr/local/lib/
    ln -s /opt/oracle/instantclient_19_3/*.dylib.19.1 /usr/local/lib/
    ln -s /opt/oracle/instantclient_19_8/sdk/include/*.h /usr/local/include/
    ln -s /opt/oracle/instantclient_19_8/*.dylib /usr/local/lib/
    ln -s /opt/oracle/instantclient_19_8/*.dylib.19.1 /usr/local/lib/
    ln -s /usr/local/lib/libclntsh.dylib.19.1 /usr/local/lib/libclntsh.dylib
    ```

    @@ -41,7 +41,7 @@ pecl install oci8
    If the script prompt you to provide the path to ORACLE_HOME directory, respond with:

    ```bash
    instantclient,/opt/oracle/instantclient_19_3
    instantclient,/opt/oracle/instantclient_19_8
    ```

    **Note:**
  4. syahzul renamed this gist Dec 4, 2019. 1 changed file with 0 additions and 0 deletions.
  5. syahzul revised this gist Dec 4, 2019. 1 changed file with 2 additions and 2 deletions.
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,10 @@
    # How to install OCI8 on macOS 10.15 (Catalina) with PHP 7.3
    # How to install OCI8 on macOS 10.15 (Catalina) with PHP 7.3 or 7.4

    ## Requirements

    - [Homebrew](https://brew.sh)
    - Command Line Tools for Xcode
    - PHP 7.3 via Homebrew
    - PHP 7.3 or 7.4 via Homebrew

    ## Preparation

  6. syahzul created this gist Dec 4, 2019.
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,67 @@
    # How to install OCI8 on macOS 10.15 (Catalina) with PHP 7.3

    ## Requirements

    - [Homebrew](https://brew.sh)
    - Command Line Tools for Xcode
    - PHP 7.3 via Homebrew

    ## Preparation

    Create a folder to store Oracle Instant Client files.

    ```bash
    sudo mkdir /opt/oracle
    ```

    ## Download Oracle Instant Client

    Download the following files from [Oracle website](https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html)

    - [instantclient-basic-macos.x64-19.3.0.0.0dbru.zip](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-basic-macos.x64-19.3.0.0.0dbru.zip)
    - [instantclient-sdk-macos.x64-19.3.0.0.0dbru.zip](https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-sdk-macos.x64-19.3.0.0.0dbru.zip)

    Unzip all theses files into a the directory `/opt/oracle/instantclient_19_3`.

    ## Create symlinks

    ```bash
    ln -s /opt/oracle/instantclient_19_3/sdk/include/*.h /usr/local/include/
    ln -s /opt/oracle/instantclient_19_3/*.dylib /usr/local/lib/
    ln -s /opt/oracle/instantclient_19_3/*.dylib.19.1 /usr/local/lib/
    ln -s /usr/local/lib/libclntsh.dylib.19.1 /usr/local/lib/libclntsh.dylib
    ```

    ## Install extension with PECL

    ```bash
    pecl install oci8
    ```

    If the script prompt you to provide the path to ORACLE_HOME directory, respond with:

    ```bash
    instantclient,/opt/oracle/instantclient_19_3
    ```

    **Note:**

    If you ever got error `command not found: pecl`, make sure PHP bin folder is included in your environment path.

    ## Test it out

    Create a file containing the following codes.

    ```php
    if (function_exists('oci_connect')) {
    echo 'OCI8 is working!';
    }
    else {
    echo 'Whoopss...not working!';
    }
    ```

    Restart your HTTP Server and test.

    ## References
    - [macosx-install-php-oracle-oci8.md](https://gist.github.com/gido/5237100)