Posts

Showing posts from November, 2019

Using Oracle Autonomous database with PHP

The Oracle Cloud free tier is pretty generous, one thing that stands out is the free tier for a managed database.  Normally I would use mysql , but this is oracle and I haven't used that in a long time.  I also haven't used it with PHP These are my notes to make it work on ubuntu overview: 1. download and install oracle client and sdk 2. setup your wallet 3. setup php 4. test 1. setup and install oracle stuff mkdir /opt/oracle mkdir /opt/oracle cd /opt/oracle wget https://download.oracle.com/otn_software/linux/instantclient/193000/instantclient-basic-linux.x64-19.3.0.0.0dbru.zip wget https://download.oracle.com/otn_software/linux/instantclient/193000/instantclient-sdk-linux.x64-19.3.0.0.0dbru.zip unzip instantclient-basic-linux.x64*.zip unzip instantclient-sdk-linux.x64-*.zip echo /opt/oracle/instantclient_19_3 > /etc/ld.so.conf.d/oracle-instantclient ldconfig echo "LD_LIBRARY_PATH=/opt/oracle/instantclient_19_3:$LD_LIBRARY_PATH" >> /etc/envirome...