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
- 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
- Import downloaded ova file into Virtual Box
Click the “Import Appliance..” to import the downloaded ova file
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
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