Using Windows Azure to Create a Linux VM and Oracle Database
Submitted by dmann on Wed, 05/27/2015 - 10:50
Create a VM
- Create a new Azure VM from the catalog.
- Pick the OEL / 188.8.131.52.0 Enterprise image.
- Change the password of oracle OS account to your preferred value.
- Login to Oracle account with an X client (MobaXTerm on Windows or ssh -Y on OSX)
EnvironmentThe VM created in the above steps will have a generic Linux install along with binaries. No environment is set up. In order to create and operate a database the following environment variables must be set after logging in as Oracle user:
export ORACLE_SID=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export PATH=$PATH:$ORACLE_HOME/bin export SHLIB_PATH=$ORACLE_HOME/lib export ULIMIT=unlimited
Run dbcaNow you should be able to run dbca and create a new database. By default /u01 should be 40gb with about 23gb left free. This is OK for small databases, but for larger databases you will want to create and attach more storage to the VM.
Create an EndpointCreate an endpoint. This can be Port 1521 on your VM to any outside port.
- Name : Oracle
- Protocol : TCP
- Public Port : 1725
- Private Port : 1521