Pre-Built Oracle database for learning and testing using Oracle Developer VM



Oracle developer day pre-installed virtual machine is very useful to perform lab testing on Oracle database. It is very helpful for practicing about Oracle database on Linux machine on your laptop. You can also export your application database and import into this pre-installed oracle VM, It is very quick and easy to setup.

Here is the steps to setup Oracle developer day VM 

Please note that this appliance is for testing purposes only, as such it is unsupported and should not to be used in production environment. This virtual machine contains:
1)Oracle Linux 7
2)Oracle Database 12c Release 2 Enterprise Edition (12.2.0.1 Linux x86-64)
3)Oracle XML DB
4) Oracle SQL Developer 4.2
5) Oracle Application Express 5.1
6)Oracle REST Data Services 3.0.9
7)Hands-On-Labs (accessed via the Toolbar Menu in Firefox)

Requirements

1)At least 2GB RAM. Default VM is 1G RAM, for better performance increase.
2)At least 15GB of free space (Note: virtualization works best with contiguous space so it is a good idea if on Windows to run a defrag program, and make sure you are using NTFS for your file system to handle large files on Windows. )
3)2GHz Processor (a lesser processor will be acceptable but slower)
4)Mozilla Firefox 2.0 or higher, Internet Explorer 7 or higher, Safari 3.0 and higher or Google Chrome 1.0 or higher
5)Adobe Acrobat reader
6)Admin privileges on your box

How to Setup Oracle Developer VM

  1. Download and install Virtual Box
    Go to http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html and download Virtual Box. Then run the installer. No special settings are required.

2) Download the Oracle Developer VM

Download Oracle Developer VM

  1. Import downloaded ova file into Virtual Box

Click the “Import Appliance..” to import the downloaded ova file

Oracle Developer VM

Select the downloaded ova file and click next

Now you will see the appliance  setting.No changes required and click next

And installation would start

Oracle Developer VM

Once Imported,below screen will be displayed

 

Now Oracle Developer Days VM is completed installed.

If you want to connect the database from your PC, then click setting  and choose host only adapter

 

Click Ok and your settings  is completed.

Now you can start the VM by hitting the ‘Start’ button. You will see the login screen for the Linux Box.

Use Oracle username and Oracle password to login to the box  . The root password for the Linux VM is also oracle

About 12c Oracle database installation

The CDB instance is ‘ORCL’ and the PDB instance is ‘PDB1’.  All the schema password is oracle only

You can open Terminal and connect to the database

[oracle@localhost ~]$sqlplus sys/oracle as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 6 21:30:10 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

PDB1@ORCL>

This will get connected to the Pluggable database.

If you want to connect to Container database ,then

[oracle@localhost ~]$sqlplus sys/oracle@CDB as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 6 23:30:10 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

CDB$ROOT@ORCL>

Exercises are available for: Database 12c (including JSON, XML DB, …), SQL Developer, APEX, REST Data Services and Cloud Services.  So you can directly use them.

You can also connect to this database  using sql developer on your windows machine also.You need to specify the IP address on the Linux machine in it


Leave a Reply