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 | Install Oracle Products

August 10, 2015

I’m sure you guys didn’t hear much from us for a long time. Actually we were been too busy testing Windows 10 to make sure that we can safely migrate our existing domain joined computers. Almost everything works as they were working on Windows 8.x and we confirm the following to you:

  1. You can install Oracle developer Suite 10g in Windows 10 Professional edition, following the same hacks provided as provided with the following post https://windows7bugs.wordpress.com/2010/02/18/install-oracle-10g-onward-database-developer-on-windows-7/
  2. You can install Toad 10.x without any issues over Windows 10 without any specific hacks
  3. You can install 11g client 32Bit without any issues, by ignoring the only one warning at the installation startup
  4. You can get over with the Oracle VirtualBox NIC related issues by installing the test build 5.0 (download from VirtualBox test builds)

 

We are yet to test the developer suite 6i, once completed we will update this thread.

So, we hope you would be more than happy to know that, almost all legacy Oracle products are installable over Microsoft’s latest OS!!

 

regards,

for Windows7bugs

rajesh


Install Oracle 10g onward database, developer on Windows 7

February 18, 2010

General Notice:

Please note, we don’t have solution for you, if you are trying to install Oracle database 10.1.x.x on Windows 7 or Windows 8. We apologize for a bit confusing title for this particular post which says “Install 10g onwards…” which is not literally true! Our tested database version was 10.2.0.3 and we were having the impression that all 10g releases had the same architecture.

We tried around a couple of dozen times to install 10.1.0.2 database on both Windows 7 (32/64bit) and on Windows 8, and every time the results were futile and we are resigning from future attempts :)

*Update* 11.Dec.2011

*Update* 13.Nov.2012

We are limiting this workaround method for Oracle Database versions 10.2.x.x and above, as one recent lab test proved that 10.1.x.x installation on Windows 7 never completing successfully. Run under compatibility mode set as OS version 5.1 (Windows XP Professional), failed to create database during the installation process, throwing Oracle error “ORA-12546”

This error looks like the same issues we had with Database 9i setup in the lab, apparently without any solutions. So, we guess it is time to move on :)

*Update* 21.Nov.2012

Looks like we are always on to the subject :) Anyway for those who guys have access to Oracle support, there is a happy news. The frequent crash experienced by Developer 10g forms are addressed to a greater level with an upgrade to 10.1.2.3.0 (patch number 5983622)

Noticed changes

  1. Forms doesn’t crash while opening form modules which are referring views, database objects like packages, procedures and functions WHILE NOT connected to database (Provided, minimum one time the forms developer was connected to the database, until a restart). Speaking English. Start developer 10g(patched), connect to database. Close forms developer and start it again, try to open forms modules without connecting to database until the computer restarts, you shouldn’t experience crashes.
  2. Quicker start-up, and the interface is ready to serve much faster than 10.1.2.0.2
  3. Installation has an option to override required OS version with y/n prompt

PART I (Install Oracle 10g on Windows 7)

Almost after more than year time, We still receive requests asking for assistance with installing Oracle 10g database while Oracle has 11g release 2 in place. We do understand why many need Oracle 10g against the latest released database and we confirm our claim once again YOU CAN INSTALL Oracle 10g on Windows 7 (Home Basic, Home Premium, Professional etc)

Though I believe the maximum number Oracle applications are accessed through Microsoft Windows clients, when the cooperation comes in, Oracle and Microsoft behave like sisters in a fight and the end users suffer!

As a Oracle developer it is my primary requirement to have a local database running from my laptop/desktop, having the oracle development tools properly installed and once I started with Windows 7, apparently failed miserably to get the Oracle stuff installed properly on Windows 7.

It took me almost 6 or more months to come against another wordpress blog where a user has posted a fix and frankly it WORKS

Before checking the workaround check what Chris F has to say

“Thanks.  This was helpful.  I noticed when installing the 10.2.0.4 server that even after changing the refhost.xml file, I was still getting the same version check errors.  I then had to go into the “install/oraparam.ini” file and change the certified version comma-delimited list there.  After that, the installer was happier.”

here is the work around.

Example, go to this folder “E:\Installers\Oracle_10g_1023\Disk1\stage\prereq\db”

locate the file “refhost.xml”, open it with notepad

you must see something like this

<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>
</OPERATING_SYSTEM>
</CERTIFIED_SYSTEMS>

now add the following:

<!–Microsoft Windows 7–>
<OPERATING_SYSTEM>
<VERSION VALUE=”6.1″/>
</OPERATING_SYSTEM>

within <CERTIFIED_SYSTEMS>   </CERTIFIED_SYSTEMS> tags, and the final entries should look like this

<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>
</CERTIFIED_SYSTEMS>

Now run the Oracle installer and you would see the installation completes without giving any errors.

PART II (Install Developer Suite 10g on Windows 7)

Step 1 Setup Virtual Memory

Depending upon actual memory available with your computer, setup virtual memory. You can go upto double the size of actual memory while setting up your virtual memory. Please refer to the image(s) below

You would be asked to restart the computer and please restart.

Step 2 Setting up the Developer Suite 10g installer

Open the Disk 1 folder and locate “Setup.exe’

Right click “Setup.exe” and change the compatibility to Windows XP Service Pack 2 or 3

Step 3 Install Developer Suite 10g

Double click and start the installation, if you already have Sp1 installed and running latest Java runtime, you may come across PSAPI.DLL errors a number of times, caused by a function call missing information. You can safely ignore the warning messages and complete the installation.