Posts

Showing posts with the label oci

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...