Install Oracle 10g (10.2.0.3 onwards) on Windows 10 (Technical Preview)

October 6, 2014

We know it is too early, still as usual we are kicking in once again trying to install Oracle 10g onwards databases on an OS that’s in the early stages of testing/improvements.

If you are wondering whether Oracle 10g (10.2.0.3 onwards) could be installed on Windows 10 (TP), the shortest answer is yes and as usual the earlier hacks what we specified with http://windows7bugs.wordpress.com/2010/02/18/install-oracle-10g-onward-database-developer-on-windows-7/ are still valid for the installation on Windows 10 TP

All you need to do is to add an entry to the refhost.xml file like following:

<CERTIFIED_SYSTEMS>
<OPERATING_SYSTEM>
<VERSION VALUE=”5.0″/>
<SERVICE_PACK VALUE=”1″/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<VERSION VALUE=”5.1″/>
<SERVICE_PACK VALUE=”1″/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<VERSION VALUE=”5.2″/>
</OPERATING_SYSTEM>
<!–Microsoft Windows Vista–>
<OPERATING_SYSTEM>
<VERSION VALUE=”6.0″/>
</OPERATING_SYSTEM>
<!–Microsoft Windows 7–>
<OPERATING_SYSTEM>
<VERSION VALUE=”6.1″/>
</OPERATING_SYSTEM>
<!–Microsoft Windows 8–>
<OPERATING_SYSTEM>
<VERSION VALUE=”6.2″/>
</OPERATING_SYSTEM>
 <!–Microsoft Windows 10–>
    <OPERATING_SYSTEM>
      <VERSION VALUE=”6.4″/>
    </OPERATING_SYSTEM>
</CERTIFIED_SYSTEMS>

You may safely ignore the warnings (if any) and proceed with the Installation. Please note, as usual we warn you not to install unsupported databases on newer Operating Systems as you may risk with your valued data. Below, few screen shots from our installation attempt which was successful.

1

2

3

You will be prompted to install .NET Framework 3.5 (That includes .NET 2.0 and 3.0), and we suggest you install it for better stability of the database

4

6

7

8

That’s all folks

for Windows7bugs

rajesh


Install Windows 10 Technical Preview on Oracle Java VirtualBox

October 2, 2014

This is our first post after months long break. As Microsoft has released the technical preview for their forthcoming OS “Windows 10” we are once again engaging ourselves to try out “Uncertified” Oracle products over a possibly half cooked OS in the preview state.

Scenario:

Host: Windows 8.1 64Bit Professional

Intel i5, 8GB Memory, 1TB HDD (Dell E6420 14” laptop)

Java VirtualBox 4.3.16 r95972

image

We will try explain how to install Windows 10 Technical Preview on VirtualBox in next few steps

Windows 8.1 comes with Hyper-V enabled default. If you are planning to try out the 64Bit version of technical preview, make sure you disable Hyper-V from “Windows features”

image

Uncheck the Hyper-V & restart the computer when prompted.

In order to download the Technical preview you must signup for Windows Insider Program (http://windows.microsoft.com/en-us/windows/preview)

We are sure, if you are an enthusiast wanting to try out the preview, you are already a half geek, who knows how to signup something very straight forward like “Windows Insider”

Download your choice of technical preview, 32Bit or 34Bit ISO file. The file is on disk is 3.81GB, so if you have a slow connection, start download, have a nap. We are on a 12MBPS fiber connection and it took around 50 minutes for the download to finish!

image

Start Oracle VirtualBox now

image

Create a new Virtual Machine (Follow the images)

image

Based on available memory on your computer, setup the maximum memory you can allocate for the VM. We suggest a minimum 4GB for better performance

image

Create a virtual drive now, minimum 20GB is recommended

image

Complete the Virtual Disk creation based on your preferences (eg: location, VDI or VMDK)

We just created a new VM, however remaining are few more settings. Let us analyze what kind of choices were made by VirtualBox for our new VM until.

General

9

System

Change the number of processors to 2, if you have more cores.

11

Finally load your ISO file to the IDE controller.

12

Save the changes by clicking “Ok” and let us start the VM finally, thus initiating the installation process

13

Based on the language selection you made prior downloading the ISO file, you will be prompted to start the installation after couple of minutes waiting

14

Follow the prompts and Select “Custom” installation while prompted.

15

Rest assured, wait for the installation to complete.

16

We opted to go with “Express settings” for the installation

17

You will be asked to sign in with a Microsoft Account next, just select “Create a new account”, that will allow you to “Sign in without a Microsoft Account” option

18

Once a local account created, you will go through the same Windows 8/8.1 setting up procedure, stay calm

19

That’s it folks, now you have completed the installation of Windows 10 Technical Preview using Oracle VirtualBox!

It’s time to click on the “Start Menu” button Winking smile

21

for Windows7bugs

rajesh


Windows |Rotate your display

August 4, 2014

 

Once in a while, awkwardly you press a combination of keys and all of sudden your display is upside down or either by right or left side and you are baffled without an idea how to bring it back to the normal position? Here is the magic key combination

CTRL+ALT+UP Arrow Key (Normal position)

image

Try the following ones

  1. CTRL+ALT+Down Arrow key (Inverted/upside down)
  2. CTRL+ALT+Left Arrow Key (Taskbar by your right side vertical)
  3. CTRL+ALT+Right Arrow Key (Taskbar by your left side vertical)

Enjoy

rajesh


Android | Google PlayStore “No Connection”

July 11, 2014

 

I’m not an Android guy yet, but I have unmatched faith in Google search Smile

Today my daughter’s friends brought a touchmate 7” tab to me, complaining the Google play store doesn’t work. I didn’t have a clue, and my very second Google search brought me to the correct solution. Solution was something we hardly think of at the first place.

Those kids changed the system date and time to a past one! Reconfiguring the system date and time to the current resolved the issue.

Google should have better and meaningful error messages for such important components of Android system! What you think?

for Windows7bugs

rajesh


Educational | Download old question papers from “Annamalai” university portal

July 11, 2014

 

Navigation –> Your favorite browser

http://annamalaiuniversity.ac.in/

Click on “DDE” (Refer attached image below)

image

Now point mouse to “Academic Activities” –> “Old Question Papers”

image

Now you can start downloading the question papers

Select a semester from the left-hand side listing, easily locate your course from the listing using ctrl+f (Search as there are hundreds of courses listed) and start downloading

image

image

image

I can’t remember the portal being so simple earlier, anyway, it is never too late to have the things organized Smile

for Windows7bugs

 

rajesh


10 ways to be more efficient in the new Visio | Re-Blogged //Microsoft reference

July 1, 2014

Using Visio 2013? Well below link should make your life bit easier

  1. Move/Reshape/Resize etc
    1. http://blogs.office.com/2012/09/25/10-ways-to-be-more-efficient-in-the-new-visio/
  2. Edit/Rotate Text etc
    1. http://office.microsoft.com/en-001/visio-help/add-edit-move-or-rotate-text-on-shapes-HA102749355.aspx

 

for Windows7bugs

 

rajesh


Oracle Payroll | R12 | Simple view for employee paid salaries

June 19, 2014

 

Recently I were requested to build a report by the HR/Payroll team, running which they can generate the salary paid details for employees. Ie, a tabular listing with paid month, and total salary earned, grouped by year factor

0046

I found the request being one of the toughest, as my exposure to Payroll module and base tables was limited almost none, other than knowing the person and assignment tables and views!

Gradually I started going through the custom reports developed by our implementer and restructured few of their custom functions into a best possible view what meets our current requirements. As we are not using customized packages for the salary calculations, you should able to alter the below SQL and create your own with almost no efforts. We hope you will enjoy the solution!

Script for view

CREATE OR REPLACE VIEW XXEMPLOYEE_SALARIES_MONTHLY
AS
SELECT pap.person_id, pap.employee_number,to_char(ppa.date_earned,'Mon-YYYY') earned_month,
TO_NUMBER(to_char(ppa.date_earned,'MM')) MONTH_NUMBER,
TO_NUMBER(to_char(ppa.date_earned,'YYYY')) YEAR_FACTOR,
 sum(to_number(prrv.result_value)) PAID_AMOUNT
 FROM PAY_ELEMENT_TYPES_F petf
   ,PAY_INPUT_VALUES_F pivf
   ,PAY_PAYROLL_ACTIONS ppa
   ,PAY_ASSIGNMENT_ACTIONS paa
   ,PAY_RUN_RESULTS prr
   ,PAY_RUN_RESULT_VALUES prrv
   ,PER_ALL_ASSIGNMENTS_F paaf
   ,PER_ALL_PEOPLE_F pap
   ,PAY_ELEMENT_CLASSIFICATIONS pec
WHERE 1=1
  AND pec.classification_id = petf.classification_id
 and prrv.input_value_id = pivf.input_value_id
AND CLASSIFICATION_NAME IN ('Earnings','Supplemental Earnings')--Add in more based on your setup
  and pivf.name in ('Pay Value')
  AND petf.element_type_id = prr.element_type_id
  AND paa.assignment_action_id = prr.assignment_action_id
  AND prr.run_result_id = prrv.run_result_id
  AND petf.business_group_id = 81
  AND ppa.business_group_id = pap.business_group_id
  AND ppa.payroll_action_id = paa.payroll_action_id
  AND SYSDATE BETWEEN TRUNC(petf.effective_start_date) AND TRUNC(petf.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(pap.effective_start_date) AND TRUNC(pap.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(paaf.effective_start_date) AND TRUNC(paaf.effective_end_date)
  AND paaf.assignment_id = paa.assignment_id
  AND paaf.person_id = pap.person_id
 --and prrv.result_value > '0'
  AND paaf.business_group_id = pap.business_group_id
 AND pap.business_group_id = 81--double check
 GROUP BY pap.person_id,pap.employee_number, to_char(ppa.date_earned,'Mon-YYYY'),to_char(ppa.date_earned,'MM'),to_char(ppa.date_earned,'YYYY')
UNION ALL
SELECT  pap.person_id, pap.employee_number,to_char(ppa.date_earned,'Mon-YYYY') earned_month,
TO_NUMBER(to_char(ppa.date_earned,'MM')) MONTH_NUMBER,
TO_NUMBER(to_char(ppa.date_earned,'YYYY')) YEAR_FACTOR,
nvl(sum(to_number(prrv.result_value)),0)*-1  PAID_AMOUNT
                     FROM PAY_ELEMENT_TYPES_F petf
                                                 ,PAY_INPUT_VALUES_F pivf
                           ,PAY_PAYROLL_ACTIONS ppa
                            ,PAY_ASSIGNMENT_ACTIONS paa
                            ,PAY_RUN_RESULTS prr
                           ,PAY_RUN_RESULT_VALUES prrv
                           ,PER_ALL_ASSIGNMENTS_F paaf
                           ,PER_ALL_PEOPLE_F pap
                           ,PAY_ELEMENT_CLASSIFICATIONS pec
                    WHERE 1=1
                                    AND pec.classification_id = petf.classification_id
                  and prrv.input_value_id = pivf.input_value_id
                  AND CLASSIFICATION_NAME IN ('Voluntary Deductions','Involuntary Deductions','Social Insurance')--Add in more based on your setup
                  and pivf.name in ('Pay Value')
                               AND petf.element_type_id = prr.element_type_id
                  AND paa.assignment_action_id = prr.assignment_action_id
                  AND prr.run_result_id = prrv.run_result_id
                               AND ppa.business_group_id = pap.business_group_id
                  AND ppa.payroll_action_id = paa.payroll_action_id
                AND SYSDATE BETWEEN TRUNC(petf.effective_start_date) AND TRUNC(petf.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(pap.effective_start_date) AND TRUNC(pap.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(paaf.effective_start_date) AND TRUNC(paaf.effective_end_date)
                AND paaf.assignment_id = paa.assignment_id
                  AND paaf.person_id = pap.person_id
    --              and prrv.result_value > '0.00'
                    AND paaf.business_group_id = pap.business_group_id
                    AND pap.business_group_id = 81--double check
                  GROUP BY pap.person_id,pap.employee_number, to_char(ppa.date_earned,'Mon-YYYY'),to_char(ppa.date_earned,'MM'),to_char(ppa.date_earned,'YYYY')
 order by 2,5,4;

Sample Query

SELECT PERSON_ID, EMPLOYEE_NUMBER,earned_month,year_factor,
 SUM(PAID_AMOUNT) PAID_SALARY
 FROM XXEMPLOYEE_SALARIES_MONTHLY
 WHERE
 1=1
 AND EMPLOYEE_NUMBER =:P_EMPLOYEE_NUMBER
 AND YEAR_FACTOR BETWEEN NVL(:P_START_YEAR,YEAR_FACTOR) AND NVL(:P_END_YEAR,YEAR_FACTOR)
 GROUP BY PERSON_ID,EMPLOYEE_NUMBER,earned_month,YEAR_FACTOR, MONTH_NUMBER
 ORDER BY YEAR_FACTOR, MONTH_NUMBER

Enjoy another quality post from us guys :)

for Windows7bugs

rajesh


Follow

Get every new post delivered to your Inbox.

Join 51 other followers