Skip to content

Instantly share code, notes, and snippets.

View PaulNeumann's full-sized avatar

Paul Neumann PaulNeumann

8 followers · 0 following
View GitHub Profile
@PaulNeumann
PaulNeumann / _SQLcl_for_Oracle_Vagrant_Boxes.md
Last active September 1, 2019 03:10
Automatically Installing SQLcl for Oracle's Vagrant Database Boxes

Automatically Installing SQLcl for Oracle's Vagrant Database Boxes

Oracle provides Vagrant configuration files for installing several versions of Oracle Database in the oracle/vagrant-boxes GitHub repository. The Oracle Database box installers allow running user-defined scripts automatically after the database has been set up and started. This document provides instructions and scripts that use this functionality to install SQLcl.

Overview:

  • The procedure below installs SQLcl for the vagrant user only.
  • Oracle envrionment variables are set for the vagrant user (using oraenv), so that SQLcl can find the database's tnsnames.ora file, and the vagrant user can run the database utilities, like SQL*Plus and RMAN.
  • SQLcl requires Java 1.8 or above. The procedure installs the latest OpenJDK from the Oracle Linux Yum Server, and creates a script to allow the vagrant user to run SQLcl without Java version conflicts, while preserving the
@PaulNeumann
PaulNeumann / _VBox_GA_Install_Linux.md
Last active May 23, 2021 00:28
How to install VirtualBox Guest Additions for Linux from the command line

How to install/upgrade/downgrade VirtualBox Guest Additions for Linux from the command line

The basic steps used are from https://www.vagrantup.com/docs/virtualbox/boxes.html.

Run the script below to install, upgrade or downgrade the VirtualBox Guest Additions for Linux. The script will install the latest version by default, but also allows specifying a different version as an argument. Note: The script requires the bzip2 and wget packages.

If the guest already has a shared folder with the host, one can also copy VBoxGuestAdditions.iso from the VirtualBox installation folder (usually C:\Program Files\Oracle\VirtualBox on Windows) instead of downloading the Guest Additions using wget. However, mounting the .iso from a shared folder probably won't work--the file needs to be copied to the guest's filesystem.

@PaulNeumann
PaulNeumann / _SQLcl_Win10.md
Last active January 30, 2024 10:54
SQLcl installation on Windows 10
  1. Add SQLPATH as a user environment variable, pointing to %USERPROFILE%\Documents\Oracle
  2. Add C:\Program Files\SQLcl\bin to system PATH envrionment variable
  3. Rename C:\Program Files\SQLcl\bin\sql.exe to _sql.exe
  4. Copy sql.cmd to C:\Program Files\SQLcl\bin

Note: Portions of sql.cmd are adapted from Oracle's sql.bat, which was used to start older versions of SQLcl on Windows, and from Glen Conway's excellent hints in this thread in the Oracle SQLcl Community.

@PaulNeumann
PaulNeumann / Remove_Ubuntu_GAs.md
Last active March 1, 2020 01:33
How to remove preinstalled VirtualBox Guest Additions from Ubuntu

Removing Preinstalled VirtualBox Guest Additions from Ubuntu

Ubuntu 18.04 (and 19.03) has an older version of the VirtualBox Guest Additions preinstalled. The "normal" method of using the VirtualBox Guest Additions image (VBoxGuestAdditions.iso) to upgrade doesn't work unless the preinstalled Guest Additions are removed first.

Removing the preinstalled Guest Additions

  1. Run the following commands:

    

    2. 



sudo apt remove virtualbox-guest-utils



  


  




    


          
    

      

        
        

          

              @PaulNeumann
          

          

            
                PaulNeumann
                / VirtualBox_Resources.md
            
            

              Created
              February 22, 2020 00:36
            

              
                VirtualBox Resources
              
          

        

      

        

  



    


          
    

      

        
        

          

              @PaulNeumann
          

          

            
                PaulNeumann
                / Ubuntu_Vagrant_libvirt.md
            
            

              Last active
              December 13, 2024 16:10
            

              
                How to Install the Vagrant libvirt Provider on Ubuntu 22.04.2 LTS Desktop or Server
              
          

        

      

        

  

      

    
How to Install the Vagrant libvirt Provider on Ubuntu 22.04.2 LTS (and above) Desktop or Server


This document describes how to install the Vagrant libvirt provider on Ubuntu 22.04.2 LTS Desktop or Server. Much of the content is based on a blog post by Philippe Vanhaesendonck of Oracle Corp. describing how to set up the Vagrant libvirt provider on Oracle Linux.


All of the commands shown should be run in a terminal window or SSH session.


Before You Start


Verify That Your CPU Supports Hardware Virtualization