Start options in Oracle Forms 12c

October 15, 2016

The simplest, the most effective to start your Forms based application without a browser.

daniel4pitss

So I’ve read quite a lot of blog entries and news regarding Oracle Forms 12c in the last weeks since the release. It is nice to hear and see that Oracle Forms still is not dead.
The release brought some nice features with it. Today I would like to have a look at the different start options, that are now available.

Embedded Java applet

The standard start in the last couple of years. So its still possible to call your form application through the Java plugin embedded in html. Just create a new section in the formsweb.cfg. The parameters for the standard behaviour are:

baseHTML=webutilbase.htm
baseHTMLjpi=webutiljpi.htm

Unbenannt

There is also an option to embed JNLP in html:

basejnlp=base.jnlp
baseHTMLjpi=basejpi_jnlp.htm

Both options require a Java Plugin and a browser.

Java Webstart

This method of starting a Formsapplication is not new. But whats new is the fact that Oracle now supports this option…

View original post 255 more words


Migrating Oracle developer 6i applications to Windows 2008 R2

October 13, 2016

Hi guys

Even though my blog has reached 600k+ visits, I am one of those “lucky” tech bloggers who is hardly reached through emails for some specific tips and helps.

One of the recent were about migrating from Developer 6i developed web deployment to Windows 2008 R2, and the asker decided to approach me through email after reading my post about installing Developer 6i suite on Windows 7 and later OS

There were many emails until I realized they have a web deployment! Using Developer 6i & I was truly impressed. Developer 6i setup was one of the toughest, when I tried it by 2004-2005 period and I truly given up once after a number of failures to setup it properly and “googling” wasn’t as efficient as today when a single search fetches you hundreds of blog posts those explain such setups minutely so that a beginner can, without sweating much could, almost setup anything!

The hacks I posted with my blog towards installing Developer 6i on Windows 7/later and Windows Servers did have it’s own drawbacks. Many of the Oracle products like Oracle graphs doesn’t work with the .dll hacks & we experienced unexpected crashes and I have made sure that I did warn the enthusiasts about them with my blog. Did it stop people from taking risks? I don’t think so

Our legacy Oracle database server hardware was 14 years old when we decided to finally decommission it. Many places around the world businesses never listen to the Administrators complaining about the age of hardware and how difficult it is to maintain obsolete hardware and software. Oracle database(proprietary) must be one of the widely used database without proper licensing and I hardly believe many small organizations will ever pay the unbelievable prices Oracle tries to extract from customers when they want to do proper licensing. Many of those environments may have new admins and the entire development teams dispersed or the software company that has developed the software diversified and started selling fish. Anyway, my asker’s situation was not far different. His hardware was obsolete and the company has brought him a new hardware with 4GB memory and he was desperately looking for a method to migrate from his Windows 2003 server to Windows 2008 R2 server

Can you/should you take risks by trying to migrate to a newer OS because there are “few hacks” available over internet?

I work as information technology manager and I will not let it happen, knowing and after having bad experiences. Instead I will try to find better solutions, like converting your Windows 2003 physical machine into a Virtual Machine and going online from a newer hardware and OS

Mr. Asker’s scenario

Windows 2003 Server with Developer 6i Web deployment and Oracle database 10g and his hardware has just 2GB memory!

His requirement

Want to start using the new hardware and Windows 2008 R2. Can’t take risks

My suggestion to him

  1. Use VMWare’s P2V converter, Convert the legacy server into a VM
  2. From the new hardware, run the VM

While I am NOT at all happy with the 4GB physical memory, I will suggest anyone who wants to go with such an approach to upgrade their hardware to have minimum 8GB so that the Windows 2008 R2 can reserve 4GB for itself, 3GB maximum for the 32Bit Windows 2003 Server and tweaking the Oracle database SGA to 40% of from the 3GB reserved for the VM!

Let us consider the few advantages of converting legacy hardware to virtual machines quickly

  1. One can always take a full backup of the VM, based on mission criticality, in addition to the database backups. Such backups will help the administrators to restore the whole “machine”, if something goes drastically wrong
  2. No headaches to figure out how the deployment was made, especially when there are hardly any documentations available explaining the setups

My asker got so excited that he stopped answering my consequent mails checking about progresses. That’s the downside of free consultancy in most of the cases. Oh well, that was not my first experience anyway. This year itself I helped someone to setup a 12c environment and when he was online, he told me how he had tears in his eyes and later he stopped answering my calls Winking smile

I hope I made some sense with this post and if you are someone who is frantically looking for a way to “Migrate” without risking much, give it a try. Have comments or need more clarifications? Use the comments area to let me know about them.

 

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


Oracle Database 12c installation fails | Admin share

May 15, 2016

Hi guys

While you are working in a very complex environments, it may become mandatory as a domain admin to disable the “Admin Share” from your specific computer (How to disable Admin Share) in order to protect some contents from other “Admins”. Well, it happens :)

While disabling the “Admin Shares” gives you a kind of invisibility, it has major disadvantages also. One of them being, asset collection software failing to read information about your computer in the network. This list could be long like the one provided by this Microsoft article. Though the article was specifically written for Windows XP, most of listed issues are applicable to all later versions of client OS (Haven’t tried with Server OS yet)

&

Oracle 12c installation will fail, and provide you very confusing error messages about unable to read temp location and more. If you come across such an error, do not wait, read our previous article about disabling Admin Share on Windows 7, browse to the registry “HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters” & check the value for key “AutoShareWks” Type: DWORD entry and confirm it is not set as “0”. If yes, change the value to “1”, reboot your box and the installation must go ahead without giving errors associated with reading details about “TEMP” space.

Please note, this is just one of the issues & you may be subjected to other issues while installing the Oracle software, especially on a uncertified platform like Windows 10.

Hope the above helps few souls out there.

 

regards,

rajesh