How to Install Windows Server 2012R2 on Oracle VirtualBox

Oracle VirtualBox can be used to create Linux, Windows , Solaris, BSD, IBM OS/2 and Mac OSx virtual machines, etc. URL for downloading VirtualBox https://www.virtualbox.org/wiki/Downloads

This post demonstrates how to install Windows Server 2012R2 evaluation version onto Oracle VirtualBox.

  1. First go to Windows Server 2012R2 evaluation downloading website “https://www.microsoft.com/en-in/evalcenter/evaluate-windows-server-2012-r2
    Choose ISO file type
    Download ISO image of Windows Server 2012R2 evaluation

2. Start Oracle Virtual Manager, Select NEW.

Name: Windows Server 2012R2

Type: Microsoft Windows

Version: Windows 2012(64-bit)

Capture

3. Give 5120M memory size depending on availability.

Capture

4. Create an virtual hard disk.

Capture

5. Choose “VDI( VirtualBox Disk Image)“.

Capture

6. Choose “Dynamically allocated“.

Capture

7. Give size 30GB.

Capture

8. Also you can choose where the VDI image file located.

Capture

9. Click “create” to create “Windows Server 2012R2” virtual machine.

Capture

10. Now attach the ISO image to the virtual CD/DVD drive by :

a)Ensure the Windows Server 2012R2 VM is selected and click Settings.
b)Select Storage. Click on Empty under IDE Controller.
c)In the Attributes section, click on “+”sign for adding optimal disk.
d)Select “Choose a disk file”.
e)Browse to the location where you saved the Windows DVD ISO file and select it.
f)Click Open.
g)It should look similar to the following graphic.

Capture
Capture

11)  Now we can install Windows 2012R2 .

a)Select the Windows Server 2012R2 VM in VirtualBox and click Start.
When the Install screen appears, click Next.

1

b)Click Install Now.

2

c)Select 2012 evalution Datacenter (Server with a GUI) and click Next. The Server Core installation includes a command prompt but not a graphical user interface (GUI).

d)Review the license terms, select the checkbox to accept the license terms, and click Next.

3

e) Select Custom: Install Windows only (advanced).

4

f) The 30 GB drive you created with the VM will be selected as Drive 0 Unallocated Space. Click Next.

5

g)The installation will begin .

6

h)When prompted, enter a password for the Administrator account in the Password and Retype password text boxes.  Click Finish.

Capture
Capture

To log on Windows Server 2012R2, press the host key plus the Delete key to simulate the CTRL + ALT + DELETE key combination. The host key is the right-CTRL key by default.

How to Fix Incomplete RDBMS DST Upgrading in 12c

It is a good practice to raise a service request for issues of DST upgrading in production environment.

There is a database upgraded from 11.2.0.4 to 12.1.0.2 by using “Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA (Doc ID 1516557.1)”. For some reason, the DST upgrading was not complete successfully after the upgrading checking:

Current DST state is still “Upgrade”.

SQL>SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
    FROM DATABASE_PROPERTIES
    WHERE PROPERTY_NAME LIKE 'DST_%'
    ORDER BY PROPERTY_NAME;

PROPERTY_NAME			    VALUE
----------------------------------- ------------------------------
DST_PRIMARY_TT_VERSION		    18
DST_SECONDARY_TT_VERSION	    14
DST_UPGRADE_STATE		    UPGRADE

Try to end the upgrading, still got issues.

SQL>shutdown immediate
SQL>startup

SQL>alter session set "_with_subquery"=materialize;
SQL>alter session set "_simple_view_merging"=TRUE;


SQL>VAR fail number
SQL>BEGIN
DBMS_DST.END_UPGRADE(:fail);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
END;
/
Number of failures: 2
BEGIN
*
ERROR at line 1:
ORA-56929: Ending an upgrade window failed
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 1289
ORA-06512: at line 

SQL>SELECT * FROM sys.dst$error_table;

no rows selected

SQL>SELECT OWNER, TABLE_NAME, UPGRADE_IN_PROGRESS 
      FROM ALL_TSTZ_TABLES 
     where UPGRADE_IN_PROGRESS='YES';

OWNER            TABLE_NAME                    UPG
---------------- ----------------------------  ----  
GSMADMIN_INTERNAL AQ$_CHANGE_LOG_QUEUE_TABLE_L YES
GSMADMIN_INTERNAL AQ$_CHANGE_LOG_QUEUE_TABLE_S YES

Start database normally and run DBMS_DST.UPGRADE_DATABASE.

SQL>set serveroutput on
SQL>VAR numfail number
SQL>BEGIN
DBMS_DST.UPGRADE_DATABASE(:numfail,
parallel => TRUE,
log_errors => TRUE,
log_errors_table => 'SYS.DST$ERROR_TABLE',
log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
error_on_overlap_time => FALSE,
error_on_nonexisting_time => FALSE);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
END;
/

Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Failures:0

PL/SQL procedure successfully completed.



SQL>SELECT * FROM sys.dst$error_table;

no rows selected

End the upgrading.

SQL> VAR fail number
BEGIN
DBMS_DST.END_UPGRADE(:fail);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
END;
/
An upgrade window has been successfully ended.
Failures:0

PL/SQL procedure successfully completed.

Check the successful upgrading.

SQL>SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
      FROM DATABASE_PROPERTIES
     WHERE PROPERTY_NAME LIKE 'DST_%'
  ORDER BY PROPERTY_NAME;  

PROPERTY_NAME             VALUE
------------------------- -------
DST_PRIMARY_TT_VERSION       18
DST_SECONDARY_TT_VERSION      0
DST_UPGRADE_STATE          NONE


SQL>SELECT * FROM v$timezone_file;

FILENAME		VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_18.dat 	     18 	 0

Reference:

Updating the RDBMS DST version in 12c Release 1 (12.1.0.1 and up) using DBMS_DST (Doc ID 1509653.1)

Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database . (Doc ID 1585343.1)