Oracle - jakestanley/dotfiles GitHub Wiki

Some software licenses prohibit distribution via third party package management means and as a result I've found they can't be reliably installed on any given platform in reasonable way with package managers. One good example of this is Oracle stuff. These are the Oracle tools I use to do my job, with useful links on how to install them for various platforms.

  • sqlplus
  • sqldeveloper

SQL*Plus

Installing SQL*Plus on Ubuntu

# Add Oracle lib LD_LIBRARY_PATH export to Zsh profile
if [ -f ~/.zprofile ](/jakestanley/dotfiles/wiki/--f-~/.zprofile-); then
    if [ $(cat ~/.zprofile ](/jakestanley/dotfiles/wiki/grep--c-"export-LD_LIBRARY_PATH")-==-"0"-); then
        echo "export LD_LIBRARY_PATH=\"/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH\"" >> ~/.zprofile;
    fi
fi

# Add Oracle lib LD_LIBRARY_PATH export to Bash profile
if [ -f ~/.profile ](/jakestanley/dotfiles/wiki/--f-~/.profile-); then
    if [ $(cat ~/.profile ](/jakestanley/dotfiles/wiki/grep--c-"export-LD_LIBRARY_PATH")-==-"0"-); then
        echo "export LD_LIBRARY_PATH=\"/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH\"" >> ~/.profile;
    fi
fi
  • Logout and log back in again, or run ``

SQL Developer

  • TODO