Month: September 2013

Appreciating the efforts of selfless techy bloggers

On By windows7bugsIn Offtopic2 Comments

 

We started this blog by February 18th 2010 and we are rushing towards the completion of 4 years!

We have posted just few and always after testing what we post thoroughly for days and weeks to insure that what a visitor reads/follows is 100% dependable and in full.

As a practice we always made sure that we will try to avoid copying and pasting as much as possible, unless we cannot do it better than an original post.

Many a times we were asked why we do such efforts as we don’t have any “benefits” coming to us in monetary terms, and the answer is simple.

“There are always few things free in life, by others”

We are utilizing this occasion to thank and encourage whole those techy friends who spent & spend much valued time to tap down millions of words, which become sentences and solutions, helping a never known person by the other corner of the world to resolve a problem or to build something, else looks impossible.

Kudos to you, kudos to us and we remain, dedicated to continue doing our “Karma”

Cheers from entire windows7bugs blog team

Linux “service xyz does not support chkconfig”

On By windows7bugsIn Linux, Oracle related2 Comments

 

Majority of the scripts, which you want to startup certain services during the boot process itself are usually placed (CentOS, RHEL, OUL(Oracle Unbreakable Linux)) in /etc/init.d folder

We had a requirement to disable the automatic startup of Oracle database, which was a part of Oracle Vision Instance 12.1.3

The vision database node server on Oracle linux, starts up the database services during the boot process itself, thus delaying the booting process.

After a long scrutiny (as I am not very familiar with Linux) I found that during the boot up, one particular service “ebizdb” was being executed and I found a script with automatic execution within “/etc/init.d” folder

Recently I have learned that I could change a .sh script using “chmod” command to executable so that I could call it without using “./” and the syntax was

chmod +x myscript.sh

Just keeping my fingers crossed (make a note of my acceptance that I am not a linux geek) I tried the following

chmod –x ebizdb

and bingo!

Prior that I tried

chconfig ebizdb off

and kept on receiving error message stating “service ebizdb does not support chkconfig”

The job was done by just the script’s behavior from executable to non-executable.

Hope this helps few out there, who are Linux noobies like me!

 

regards,

admin

Oracle E-Business Suite R12 Internet explorer 10 “unidentified”

On By windows7bugsIn Oracle Applications(R12), Oracle related, Windows 81 Comment

 

Just 24 hours back, I made another attempt to setup a vision instance at home using VM templates from Oracle and, guys, it was a total success *grin* (Will post the installation steps later, stay tuned, it is loads of fun!)

However I was stuck with an issue, the html/jsp pages will not render properly in Internet Explorer 10 (I am using Windows 8 Pro 64bit) and started with my favorite search toy “google” once again

image

 

image

I came across a blog post from Oracle discussing about the certification path here

and within the thread there was another reference towards a later blog entry, which explained the certification details(here). Unless you are in a hurry, you shouldn’t miss the minimized quote says

Compatibility Mode for IE 10 + EBS 12

To prevent issues with certain OA Framework pages, you should run IE 10 in “Compatibility Mode.” See the “Known Issues” section in Note 389422.1 for more details.

 

image

How to? have a look at the below images

image

That’s all Smile

image

hope the post was useful for minimum few out there

 

regards,

admin

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6

On By windows7bugsIn Linux, Oracle relatedLeave a comment

 

We always refer www.oracle-base.com for exclusive tips on installing various Oracle products and we would suggest, it is one of the best repositories you can also depend upon for.

Recently we were having a requirement to migrate our legacy 10.1.2.x Oracle database to 11gR2 and we followed this thread by www.oracle-base.com to.

Our scenario was involving a VM instead of physical server which was hosted on Windows 8 64 Professional edition using Oracle’s VirtualBox 4.2.18

Following the straight forward instructions we installed Oracle Linux 6.2 X86_64 (64bit) and added Oracle’s own public repository for yum repository (instructions here)

Next we ran an update cycle, and our distro was upgraded to 6.4 from 6.2 and the first issue we realized was X terminal. To resolve, we did the following few activities

Uninstalled the VirtualBox addons

Re-configured the X terminal

Re-installed VirtualBox addons

Then went ahead with instructions available with the oracle-base post for the 11gR2 installation.

Even though all the instructions were tailored for a successful installation of 11GR2 we were stuck as soon as we tried to start the installation process by calling

./runInstaller

A number of Java exceptions where thrown and while digging around, came to a conclusion that, it was due to the exporting DISPLAY and later allowing access to the same.

We found a thread on stackoverflow, with a solution and the solution was

as root

set DISPLAY

$DISPLAY=:0.0

$export DISPLAY

$xhost +

then as user oracle

$su – oracle

$DISPLAY=:0.0

$export DISPLAY

$cd /stage/database

$./runInstaller

A number of .so files were upgraded to recent versions during the 6.2 to 6.4 upgrade process, hence the installer will prompt missing library files which you can safely ignore (We would recommend you to resolve such warning if you are doing a production installation, a test scenario could overlook these wanings)

It is painful, however, please do confirm all the recommended packages or new versions are already available with your linux installation prior going ahead with the installation.

We installed unixODBC package(s) using the add remove software, a newer version than the one suggested by Oracle and proceeded with the database installation.

Even though we were able to complete the installation successfully, left us with huge concerns like the time and efforts required, the level of knowledge about linux and complexities resolving the dependency which is almost nothing in the case of Windows environment.

Anyway, we hope you would enjoy another quality post by us!

regards,

admin

Oracle, Migrating from Developer 6i to 11g & Weblogic Application Server 10.3.6

On By windows7bugsIn Oracle relatedLeave a comment

 

There are no guarantees that Windows 7 and Windows 8 machines will support Client/Server architecture applications developed by Oracle developer 6i, even after your patch certain .dll files (refer to our previous post here )

So, it is time to move on. Many legacy applications cannot be discontinued as they serve the businesses in tailored manner. Hence the best practices should include migration to latest Oracle products and retaining such applications for next “N” number of years.

We are going to draft the easiest methods to migrate to Oracle Weblogic server 10.3.6 & Developer suite 11g briefly over here. Please read on how to install the weblogic server here

Make sure you have made multiple backups for your forms 6i source modules & reports

Create local folders from development machines with easily identifiable names (eg: myapp11gtest)

Start compiling your 6i modules (forms, menu modules, libraries) using 11g forms developer or use the batch mode compiler.

Address the obsolete triggers (KEY-NEXT-ITEM for eg)

Port the compiled forms & other modules to your weblogic server

Please note, if your environment is totally windows based, you may not recompile the form modules once again at weblogic server end. On the other hand if you are developing modules on windows environment and later porting them to Weblogic server hosted in a linux environment, you must recompile the modules once again

Idiot proof notice: Always keep multiple backups for your source files!, You cannot port 6i applications compiled using Developer 10g suite to Weblogic server which has 11g developer suite components and expect the .fmx files to load

regards,

admin

Oracle applications, fnd_standard.set_who

On By windows7bugsIn Oracle Applications (R12.0.4)Leave a comment

 

One of the best features of Oracle applications is the flexibility to add custom applications and extend the functionality of the business suite. Many time developers who are not well versed with the Oracle’s guidelines for custom development for Oracle applications will totally ignore the pre-requisites for fnd_standard.set_who API to work properly by avoiding to include the following mandatory columns while designing tables

  1. CREATION_DATE    DATE
  2. CREATED_BY    NUMBER
  3. LAST_UPDATE_DATE    DATE
  4. LAST_UPDATED_BY    NUMBER
  5. LAST_UPDATE_LOGIN    NUMBER

Which will fail the API call and result in “No record history available here” notification

Another possibility is, developer adds these columns with the custom tables at later stages and manually add the columns to the block, without involving the datablock wizard, thus not properly linking the block with newly created columns.

Manually adding the columns with proper column names and data types may not generate an error while compiling, however the API will not able to see those columns.

The best method to avoid this problem is, by running the data block wizard once after new columns are added to the custom table(s)

Run the data block wizard, refresh the data source and make sure you don’t have any column within the left side pan

Recompile and test the custom application once again. 99% this method should solve the fnd_standard.set_who API not updating information.

 

regards,

admin