Oracle Database (10g) & Developer 6i settings for Arabic/Urdu support

November 6, 2016

Hi guys

I think it was 2001-2002 our company decided to migrate to Developer 6i based build from Developer 2000 (4.5). We had loads of fun setting up the Arabic part for the forms runtime. I remember setting up the NLS_LANG string as ‘ARMSAWIN1256’ instead of ‘AR8MSWIN1256’ and wasting hours trying to figure out what went wrong.

If not often, I receive requests once in a while, asking about setting up the Arabic (Right to left languages) environment for client server architecture. Today I am “Showing” you a how to, rather than typing the entire stuff here :)

This Video demonstrates the following few

  1. Creating a database using AR8MSWIN1256 character set
  2. Setting up the languages and Unicode parameters to show correct languages
  3. Setting up client OS (Windows Xp, later OS)
  4. Hope the attempt helps few out there :)

 

regards,

rajesh

 

 


Windows 10 | Cumulative Update KB3194496

October 10, 2016

 

Few weeks back I have decided to stop receiving the insider builds for Windows 10 as I hardly found anything interesting that needs such huge volumes of downloads and my precious time! (A bit prudish here). Well it was all easy…not entirely. Even after leaving the Insider program for this particular PC, I kept watching the Windows Update program trying to download the subsequent builds and miserably failing to install them. Fortunately for me, this PC is mostly used as a media center, hooked to my TV.

To stop receiving the newer builds, I unlinked my Live account finally and deleted the C:\Windows\SoftwareDistribution folder after disabling Windows Update for a short period.

image

Then I realized that I had this issue with a cumulative update KB3194496! Each time I tried update, the lengthy process will fail with “we couldn’t complete the updates, undoing changes.”

After few days search, I came across this link through “Bing”, the greatest search engine EVAR invented by a man!

Though there were many other POSTs explaining some different types of fixes, I opted to go with the solution provided by Microsoft, running a small .msi file downloaded from this link

I had a reason for choosing this fix, as I “was” an Insider while the patch was downloaded and failed the first time. Whatever, after running the .msi and answer with “A” to the prompt in the command line, I downloaded and installed the update without any issues. You may try the same, if you are/were an Insider!

 

regards,

rajesh


Windows 10 | Control your Windows Updates

October 10, 2016

 

We have relatively small network & upgraded all possible candidates to Windows 10 professional edition during the free upgrade period, to realize that our 15MBPS (Okay stop mocking us) fiber optic connection was choked & almost no browsing was possible as almost all the machines started downloading the updates. Our WSUS server cannot handle the Windows 10 unless upgraded and we were frantically searching for a method to stop the client machines directly downloading the updates & came across many beautiful blog posts those systematically explained how we could use group policies to control how the clients download updates.

One of the best posts we adopted for our network is available here

We tried the group policy workaround with few of the laptops in the IT and we were able to stop those automatic download of end number of updates those Microsoft pushed everyday to address the numerous issues they were not even able to fix with the anniversary update!

As a user with administrator privileges, start the local group policy editor.

 

image

Navigation –> Computer Configuration->Administrative Templates->Windows Components->Windows Update

image

image

image

image

Find “Configure Automatic Updates” and open it.

image

Here you can choose, suitable for your situation. For me, notifications are fine & then I decide when I should download the updates.

image

Close the Group policy update MSC (Microsoft System Console) and you are all set. From next reboot, you will be given notifications about the downloads, rather than automatically start downloading and clogging your internet connection.

(If you are always connected to WIFI, you can use the “Metered” connection trick to avoid downloading updates automatically. As this trick is not applicable for Ethernet connections, I am not getting into detailed how to this time)

Important Note: You may forget to download and apply the much needed updates, so make sure you will never stop looking at the notification panel for update related.

Regards,

rajesh


Windows 10 | Anniversary update Version 1607

September 5, 2016

Hi guys

There were loads of hype about the first major update Microsoft released for their Windows 10 operating system. While desktops are yet to receive the update through Windows update, many laptops and notebooks were first in the line to receive the update by early August 2016.

As usual, this huge update brings many new features to the relatively new OS that is still evolving. Personally I feel it is a mobile OS, sized for desktops and laptops as Microsoft cannot ignore the corporate/development segments.

One of the major leaps are with the Ubuntu based Linux subsystem, that works perfectly fine & until date, the max I have used it for was to access our Linux servers through SSH. Yes, it works :)

v

So what exactly the objective behind this post? If you have already noticed, I have started this blog to list the bugs of Windows 7 and to post possible solutions to many of the issues Windows 7 survived for years without any proper fixes…then I realized there were better sites dedicated for the OS and slowly shifted my attention towards Oracle based developments and technologies. Once again, as the OS is fresh and buggy, I have decided to choose few topics and to start posting my experiences.

Version 1607, Build 14393.82 AKA anniversary update did break most of the other installed Microsoft, Including Office Suite 2013. The maximum affected suite components were Microsoft Outlook and Excel & as the updates were only available for laptops, we were able to overcome the issues by patching the systems with additional patches provided by Microsoft windows update channel.

While data/internet charges are getting cheaper by date, many may not be bothered by the volume of data used for downloading these additional patches, which are still being pushed to those machines which were updated to 1607, countries like India where majority cannot afford huge downloads will find the update landing them in hot soup, as without the patches to iron out the bugs with 1607, the total OS will be shaky and buggy, making it frustratingly annoying to live with.

Does it mean you shouldn’t update? definitely no. You must update when Microsoft eventually pushes it to for your desktop machines and once after the updates are in place, you have a better “Defender” that started appearing at the right notification area with a shield symbol and does a better job (?)

Hope the above helps few out there to plan the 1607 update properly and to be prepared for huge data consumptions!

 

regards,

rajesh

 

 


Windows 10 | Cannot login because the device is offline?

June 17, 2016

 

Seriously?

Hi guys

Many of you were ditched into “free Windows 10” upgrade from your Windows 7 & 8 and I am sure few out there chose to link their existing local accounts with a Microsoft account (live, outlook and err hotmail accounts)

I have four computers (including my work laptop) running Windows 10 and the 10 years old HP micro tower PC that works as a home theater is my guinea pig for all Windows insider tests.

Windows insider program made it sure that the insider logs on to the computer using a Microsoft account, most probably for the headcount? Anyway they do let the user hook up a live account when the insider program is turned on inside Windows update advanced area. Yet demand the user to logon to the computer using Microsoft account must be for usage statistics.

Anyway, “trusting” Microsoft’s long “proven” privacy protection shit, I agreed to link my local account with my windows insider id and upgraded the box to latest build (Anniversary build? with linux sub-system)

Came the fun, I was told my device was offline so the password cannot be checked and the network connection status icon over the logon screen showed that the connectivity were broken

After few minutes of struggle I remembered that I had my daughter’s account added as family member and quickly managed to logon to the box and the network connection fixed itself (Should be a bug?)

I tried to switch the user account to my local account that is linked to a microsoft account, and I was able to.

So what was going wrong?

A family account (Microsoft account) was able to logon to the box without a live internet connection

A local account linked to Microsoft account was blocked because there were no internet accesses

I am sure I was damn lucky to have another account available with the box to log and to let the connection repair itself & I am yet to come across a valid explanation towards the annoying issues like my experience above.

However, I figured out a way to address such situations by unhooking the local account from Microsoft account, yet to continue receiving the insider builds.

I added my Windows insider Microsoft account as “Other Users” and changed the account type as “Administrator”. (You need to verify this account on the box by validating the account at later stages) Not only this has addressed the issues with device being offline and being locked out, I realized I can add accounts under the family and use the family safety finally against the child accounts!

image

Actually logging on to a computer using ONLY a Microsoft account is a very bad idea incase if you are using your primary account. Anyone (family) who knows the PIN or password that you set for the Microsoft access will able to access your mails and other sensitive information without additional efforts as everything is linked and many places they won’t have to logon to explicitly to access the information.

Hope you will not be locked out of your box, after reading this post :)

regards,

rajesh


Java runtime 1.8.0.91 | Oracle EBS R12 (12.0.6)

May 2, 2016

Hi guys

You could run into a situation after the latest Java client runtime update, your R12 instance failing to load forms, complaining about the lower version of JRE. This is mainly due to the fact that, if your Windows OS is 64Bit, the latest java runtime update installs both 64Bit & 32Bit and most of the R12 environments run against 32Bit JRE.

Internet explorer (the only one browser that runs the JRE properly for EBS R12) loads the 64Bit java runtime by default from a 64Bit Windows OS & eventually the forms will fail to load.

At present the only possible solution to address this situation is to uninstall the 64bit version of java runtime, using “Programs and features” or “Add remove programs” based on the version of Windows you are using.

Hope this helps few out there :)

regards,

rajesh

 

 


Windows 10 | Hack to dirty desktop

January 17, 2016

 

Hi guys

Starting from Windows 8, Microsoft has clearly switched their target consumers to mobile users and snatched the clean desktop experience from power users.

Windows 10 is basically a huge PHONE OS, however, significant efforts were made by Microsoft to reduce the gap between a mobile OS and pure desktop experience by the addition of a semi effective start button. Yet it satisfy the frustrated me? Not entirely

For example, I have multiple versions of Oracle developer installed in my box, starting from Developer 6i, Developer 10g & Developer 11g in the same box & almost all elements within the developer stacks share the common names like forms developer, reports builder etc. Using the jump list was NEVER my cup of tea as it takes time, efforts to distinguish. Though the new start menu allows one to drag and drop the apps to desktop, send to desktop is a sure missing option which could truly confuse a person who switched from XP/7 recently.

I’m responsible a middle size IT infrastructure and was promoting the usage of classicshell, the free start button/ start menu alternative that brings a kind of Windows XP/7 style start button/menu experience back to both Windows 8.x and Windows 10 OS.

image

You can obtain ClassicShell here

With periodic updates, this freeware remains one of the best solutions for crippled start menu available with Windows 10 OS.

Install it, Open Classic start menu settings, check “Show all settings” & make the few settings as seen with the below images and you are all ready to enjoy a cleaner desktop experience

image

image

You can setup the most comfortable start menu style here

image

Skin allows you to disable the frames around the icons.

image

Once the above you are all good to start experiencing the classic start menu on your Windows 8/10 box

for Windows7bugs

rajesh