How to install Oracle client on windows without install cd or stage area

Many years back, I devised this method to get Oracle client installed on all PCs on the network without needing an installation CD or staged media.  It was truly a "necessity is the mother of invention" thing.  I had once gone to a client site to find out how they were doing and whether our custom client server application was working fine for them.  It turned out that one of their PCs had a hard disk failure, so they wanted me to install the oracle client and application on the newly installed hard disk.  I was wondering how I would be able to do it without installation media. However, I took up the challenge and thought logically. We had other PCs which had the application and all I had to do was clone that to another PC.  All Windows applications store configuration settings in the Windows Registry.  Usually each application has its own tree in HKEY_LOCAL_MACHINE > Software.  So I exported the tree HKEY_LOCAL_MACHINE > Software > Oracle into a file called oracle.reg.  I also exported the tree HKEY_LOCAL_MACHINE > Software > ODBC into a file called odbc.reg.  

From the existing client PC, I copied the 

1. oracle directory 

2. oracle.reg

3. odbc.reg

4. C:\Documents and Settings\All Users\Start Menu\Programs\Oracle

I executed the oracle.reg and odbc.reg and put $ORACLE_HOME/bin in PATH.  I also set environment variables: ORACLE_SID, ORACLE_HOME, TNS_ADMIN in System properties dialog box.

That was it, oracle client was installed and usable.  

Unix stty command

The stty utility sets certain terminal I/O options  for  the device  that  is  the  current standard input. Without arguments, stty reports the settings of certain options.

In Solaris 10, if you type stty -a, it shows you all the settings for your terminal:

$ stty -a

speed 38400 baud;

rows = 60; columns = 157; ypixels = 0; xpixels = 0;

csdata ?

eucw 1:0:0:0, scrw 1:0:0:0

intr = ^c; quit = ^\; erase = ^?; kill = ^u;

eof = ^d; eol = ; eol2 = ; swtch = ;

start = ^q; stop = ^s; susp = ^z; dsusp = ^y;

rprnt = ^r; flush = ^o; werase = ^w; lnext = ^v;

-parenb -parodd cs8 -cstopb -hupcl cread -clocal -loblk -crtscts -crtsxoff -parext

-ignbrk brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr icrnl -iuclc

ixon -ixany -ixoff imaxbel

isig icanon -xcase echo echoe echok -echonl -noflsh

-tostop echoctl -echoprt echoke -defecho -flusho -pendin iexten

opost -olcuc onlcr -ocrnl -onocr -onlret -ofill -ofdel tab3

The ones I use the most are:

stty erase backspace_key

stty sane  

stty columns 180

Covert file format without downloading software

I came across www.zamzar.com which is an online file format conversion service.  For example, if you have a .docx file which you can't read as you don't have Microsoft Word 2007, and can't install Word Viewer due to your organization's policies, you can convert the file from .docx to .doc on www.zamzar.com and view it on your older Microsoft Word.

This converts not only document formats, but also image formats like .jpg, music formats like .mp3 and video formats like .rm.  A complete list of all formats is given here.

Currently on the free Zamzar service you can upload a maximum of 100 MB of data split between up to 5 different files. If you signup for an account with Zamzar though you can upload files up to 1 GB in size.  The pricing is like this:

Price File Size Concurrent Conversions Online Storage

Free   100 MB  5  Zero

$7 per month 200 MB  7     5 GB

$16 per month 400 MB 10   20 GB

$49 per month 1GB 15 100 GB

The name "Zamzar" is based on a character from the German author Franz Kafka's book "The Metamorphosis". In the novel Kafka describes the extraordinary story of a young man who is transformed whilst sleeping into a gigantic insect. The man's name - Gregor Samsa - was used as the basis for the company name because of its' powerful association with change & transformation.

Payables pre-req patch on 11i before upgrade to R12

If you are planning to upgrade your 11i instance to R12 and use Payables module, then you should first apply patch 7279377, before upgrading to R12.  Metalink Note 734066.1 gives more information about this issue:

Applies to:

Oracle Payables - Version: 11.5.10 to 12.0.5
Information in this document applies to any platform.

Description

AP Invoices that have been approved but are in the middle of the workflow process have the invoice status flag inadvertently set to NOT REQUIRED, which prevents these invoices from completing the payment cycle. 

Note: ALL AP Customers Upgrading from 11i to R12 MUST apply this patch in Pre-install mode. Review the README Patch 7279377 for detailed instructions.

Likelihood of Occurrence

Customers upgrading from 11i to R12.0.x are likely to encounter this problem if they have invoices in the middle of the workflow process. 

Possible Symptoms

After upgrading from 11i to R12..0.x, invoices in the middle of the workflow approval process are set to a status of NOT REQUIRED, even though they may have been Approved in 11i. 

The workflow architecture changed from 11i to R12 and so there is no upgrade for Workflow. For all invoices that are in middle of the approval process the flag WFAPPROVAL_STATUS has to be reset to REQUIRED and APPROVAL_READY_FLAG has to be set to Y. 

Workaround or Resolution

Download Patch 7279377. This is an AP Pre-Install Patch for R12. It only applies to those customers who have not completed the upgrade from 11i to R12.  Follow the instructions in the README file for download and application instructions.  

Patches

1. Download Patch 7279377
2. IMPORTANT: Please ensure that the patch application version of the file apinvupd.sql is (120.13.12000000.4) or greater:  patch/115/sql/apinvupd.sql 120.13.12000000.4

10gr2 on Oracle Enterprise Linux 5

If you try to install Oracle 10g on Oracle Enterprise Linux5, by using runInstaller the following error will appear:

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2

                                      Failed <<<<

You need to start runInstaller with ignoresysprereqs parameter as mentioned in metalink notes given below

 ./runInstaller -ignoreSysPrereqs

Before starting install of 10gr2 on Oracle Enterprise Linux5, be sure to go through these metalink notes:

For Linux x86 : Metalink Note 419646.1

For Linux x86_64: Metalink Note 421308.1

These two notes have details of all the os prerequisites for installation of 10gr2

Cannot access Metalink

There was a weekend outage for Metalink.  Since Saturday whenever I clicked the link Login, it would take me to the usual:

https://metalink.oracle.com/metalink/plsql/ml2_gui.startup

I was getting:

Not Found

The requested URL /metalink/plsql/ml2_gui.startup was not found on this server.

Thinking that this may be due to Metalink Outage, I didn't bother.  However when this occurred even on Monday, I cleared my cache and accessed metalink again.  They have made the flash based Software Configuration Manager interface (available from Software Configuration Manager tab inside metalink) the primary choice.  You also have the option of selecting the classic metalink.  If you do not want to clear your cache, try this link which will give you the option for chosing software config mgr or classic metalink:

https://metalink.oracle.com/CSP/ui/signin_en.html?language=en

Direct link to classic metalink: 

https://metalink2.oracle.com/metalink/plsql/f?p=125:1:6317119993221188440

So now you have 3 metalinks:

https://metalink.oracle.com takes you to Software Configuration Manager interface

https://metalink2.oracle.com takes you to classic metalink

https://metalink3.oracle.com takes you to Metalink version 3 which is currently available only to Siebel customers.

The new metalink or "My Oracle Support" still gives this error regularly:

My Oracle Support Services Error
A server connection error occurred
Security Error #2048
Please try again later.
Close.

For now I am using the classic metalink interface, as it is faster. I'll experiment with the software configuration manager interface sometime later.

libXp.so.6: cannot open shared object file: No such file or directory

While doing a fresh install of 11i vision on Oracle Enterprise Linux 5, RapidInstall gave the following error:

Rapid Install Wizard will now launch the Java Interface.....

Exception in thread "main" java.lang.UnsatisfiedLinkError: /11istage/startCD/Disk1/rapidwiz/jre/Linux/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

        at java.lang.ClassLoader$NativeLibrary.load(Native Method)

        at java.lang.ClassLoader.loadLibrary0(Unknown Source)

        at java.lang.ClassLoader.loadLibrary(Unknown Source)

        at java.lang.Runtime.loadLibrary0(Unknown Source)

        at java.lang.System.loadLibrary(Unknown Source)

        at sun.security.action.LoadLibraryAction.run(Unknown Source)

        at java.security.AccessController.doPrivileged(Native Method)

        at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)

        at sun.awt.DebugHelper.(Unknown Source)

        at java.awt.Component.(Unknown Source)

This error comes because libXp.so.6 library is not present in /usr/lib.  The rpm which contains this file is libXp-1.0.0-8.i386.rpm.  It is present in the Oracle Enterprise Linux 5 DVD  in /server directory.  So copy this rpm from the DVD or CD and install it:

rpm -ivh libXp-1.0.0-8.i386.rpm

Once this is installed, confirm about the presence of the the file libXp.so.6 by this command:

$ ls -ld /usr/lib/libXp.so.6

lrwxrwxrwx 1 root root 14 Jul 29 06:45 /usr/lib/libXp.so.6 -> libXp.so.6.2.0

$ 

Google Chrome and E-Business Suite

There is a lot of press about google chrome which is an open source internet browser developed by google. A beta version is available for download here. I decided to test how E-Business Suite fairs on chrome. Here's my observations:

Self Service login worked fine as expected.

As soon as I launched forms, this error appeared:

Forbidden

You don't have permission to access /dev60cgi/oracle/apps/fnd/formsClient/FormsLauncher.class on this server.

In order to access this application, you must install the Oracle JInitiator Plugin version 1.3,1,29. To install this plugin, click here to download the oajinit.exe executable. Once the download is complete, double-click the oajinit.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete

Copyright ©1998, 1999, 2000, 2001, 2002 Oracle Corporation

I'll have to locate an instance configured with Sun JRE plugin to check if google chrome works fine.

Windows Server 2003 memory limits

We had a call about memory thresholds of Windows Server 2003. A Hyperion application required more than 2 GB of memory for its process. 32-bit Windows doesn't allow a process more than 2GB in size. To enable it, you need to start windows with /3GB switch.

A table of memory limits is available on this MSDN article.

A 32-bit process can have a memory address of 2GB in both 32-bit and 64-bit windows.

A 64-bit process can have 2 GB in 64 bit windows and

x64: 8 TB with IMAGE_FILE_LARGE_ADDRESS_AWARE

Intel IPF: 7 TB with IMAGE_FILE_LARGE_ADDRESS_AWARE

Database Scripts Library

Metalink Note 131704.1 is an index of database scripts:

Database Scripts

Last updated on September 25, 2008

AdvancedQueueing	ContentMgmt.Spatial	ContentMgmt.Text	ContentMgmt.UltraSearch
ContentMgmt.interMedia	DBA.Admin	DBA.Architecture	DBA.DBCreationAndConfiguration
DBA.Monitoring	DBA.Parameters	DBA.SQL	DBA.Storage
DBA.UpgradeAndMigration	DBWarehouse.MaterialView	DBWarehouse.ParallelExecution	DBWarehouse.Partitioning
Distributed.General	Distributed.Replication	Distributed.Streams	Globalization
Globalization.DST	HighAvailability.BR	HighAvailability.Corruption	HighAvailability.DataGuard
HighAvailability.RMAN	Install.Installer	Install.UnixGeneric	JVM
Manageability.MemoryMgmt	Manageability.Utilities.ExportImport	Manageability.Utilities.SqlLoader	Performance.Database
Performance.Locking	Performance.SqlTuning	Scalability.OPS	Scalability.RAC
Security.DBSecurity

Oracle E-Business Suite History

Oracle E-Business Suite started life as Oracle Financials in 1987.

March 12, 1986: Oracle goes public with revenues of $55 million USD.

August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software. Oracle Corporation acquires TCI for its project management software.

October 1987: Oracle Applications Release 1

Sometime in August 1988 they released there first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reason of having General ledger application_id is 101.

November 1988: Release 3

January 1989: Release 4

May 1989: Release 5

October 1989: Release 6

May 1990: Release 7

November 1990: Release 8

June 1992: Release 9

1995: Release 10

April 1998: Release 11

July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation.

May 2000: Release 11i

Feb 2006: 11.5.10.2

31 Jan 2007: R12

(Most of the dateline is from Anand's post on oracleappshub.com)

How to see the contents of a CLOB column without special tools

Recently Sabrix had some issues and they turned on logging. Sabrix detailed messages go into the CLOB column extended_message present in the table sabrix_log. However we were unable to see beyond 4000 characters of a row in sqlplus. Instead of using any special tools to see the contents of a CLOB column, I advised the DBAs to extract the data like this:

create table sabrix_clob as select extended_message from sabrix_log;

exp file=sabrix_clob.txt userid=apps/apps tables=apps.sabrix_log

vi sabrix_clob.txt

Export dump file is an ASCII file if all you are exporting is character data. You can very easily see the contents of the CLOB column inside the export dump file.

SQORAS32 an unsupported operation was attempted

We were getting this error when we tried connecting Kewill Flagship installed on a Windows 2003 R2 box (with 10.2.0.3 Oracle client for windows installed) to an Apps 11i instance. This error comes up whenever you try to access the DSN in Control Panel > ODBC Data Sources. A google search returns the first hit in OTN forums: http://forums.oracle.com/forums/thread.jspa?messageID=2195086

The post refers this to metalink note 403021.1 and patch 5699495. Reproducing the contents of the note here:

Applies to:

Oracle ODBC Driver - Version: 10.2.0.3
Microsoft Windows 2000
Microsoft Windows XP
Microsoft Windows Server 2003
Microsoft Windows (32-bit)

Description

"An unsupported operation was attempted" error occurs when trying to do the following with the Oracle ODBC Driver version 10.2.0.3.0:

1. Create a DSN
2. Click on any tabs in the DSN configuration screen other than the "Workarounds" tab. It will not bring up the other tabs.
3. Click on OK to save the DSN.

This problem began after applying the RDBMS 10.2.0.3.0 for Windows 32-bit, Patch 5337014, which installs the 10.2.0.3.0 Oracle ODBC Driver.

This issue was filed under two bugs: Bug 5699495 and Bug 5747525.

Likelihood of Occurrence

Your Applications use the Oracle ODBC driver 10.2.0.x.0 and you applied the RDBMS 10.2.0.3.0 patchset.

Possible Symptoms

"An unsupported operation was attempted" error occurs when trying to do the following with the Oracle ODBC Driver version 10.2.0.3.0:

1. Create a DSN
2. Click on any tabs in the DSN configuration screen other than the "Workarounds" tab. It will not bring up the other tabs.
3. Click on OK to save the DSN.

This problem began after applying the RDBMS 10.2.0.3.0 for Windows 32-bit, Patch 5337014, which installs the 10.2.0.3.0 Oracle ODBC Driver.

Workaround or Resolution

• If you have applied only the Oracle Database Server Version 10.2.0.3.0 Patch 5337014 please apply Patch 5699495 to apply the fix for the Oracle ODBC Driver.
• If you have applied one of the Oracle Database Server Version 10.2.0.3 Patch 1 through 6. Please copy over the sqoras32.dll and sqresus.dll from Patch 5699495 to the \bin directory to apply the fix for the Oracle ODBC Driver.

The fix for Bug 5699495 / / Bug 5747525 has been released in the 10.2.0.3.0 RDBMS Patch 7 Patch 6038241 or higher. It is listed in the release notes as Bug 5747525.

If you are working on a Japanese Operating System please read Note 435737.1 "SQORAS32 An Unsupported Operation was Attempted."

Patches

There are two ways to get the fix for this issue:

1. If you have applied 10.2.0.3.0 Oracle Database patch 1 through 6 then you can apply:

Patch 5699495 for the Oracle ODBC Driver.

Or

2. 10.2.0.3.0 RDBMS Patch 7 Patch 6038241 or higher using opatch to install the fix along with the other Oracle Database bug fixes contained in patch 1 through 7.

After applying patch 5699495, the error went away.

Oracle database client server version interoperability matrix

Metalink Note 207303.1 provides a matrix of oracle database client server version interoperability matrix:

It is always best to use the same version in client and server.  In Apps, we still have 8.0.6 Tools oracle home and 8.1.7 iAS oracle home which connect to 9i or 10g databases.  Since it is an Oracle product, it is supported, even though the matrix says otherwise.

ADJRIOPTS and ADJREOPTS

ADJRIOPTS and ADJREOPTS are two context file variables for setting the maximum java heap size for java child processes spawned by FNDSM:

$ grep ADJREOPTS $CONTEXT_FILE

         -Xmx512M

$ grep ADJRIOPTS $CONTEXT_FILE

         -mx512m

This sets the upper limit for java heap size.  

Instance Health check through Software Configuration Manager

A recent announcement in metalink talks about improvements in health checks introduced by Software Configuration Manager:

What is a Software Configuration Manager Health Check?

A Software Configuration Manager Health Check from Oracle Support provides advice based on business rules related to Oracle best practices, certificated configuration, security and patching. Health Checks are dynamically applied to newly uploaded customer configuration information based on Oracle Configuration Manager (OCM) data, providing you with immediate feedback on potential issues you may want to address. The Health Check rules and data elements are monitored and executed at Oracle and are updated on a regular basis. This approach of maintaining the rules at Oracle ensures you will always have the benefit of the latest knowledge and information. Health Checks currently focus on the following areas:

• Oracle Database - checks the database host, highlights incorrect parameter usage, and recommends improvements in table and index layout, storage management and table space allocation
• Oracle eBusiness Suite - validates current patch configuration, recommends critical missing patches and dependencies
• Oracle Fusion Middleware – provides basic setup configuration, product certification, and recommends critical missing patches and dependencies
• Oracle Newly Acquired Companies – captures basic configuration data
• Host/OS – checks host and kernel parameter settings, platform memory configuration, storage and system utilization, and system configuration
• Oracle Software Certification – checks latest patch set applied and validates your current configuration against the latest Oracle certifications information

What improvements have been made to Software Configuration Manager Health Checks?

The following new features and improvements have been made to the Software Configuration Manager Health Checks:

• New - July Database CPU Health Check added to reduce risk associated with not being current on latest critical patch update release
• Updated – Reclassification (Critical Issue, Warning Issue, Informational Issues) of 18 database-related Health Checks based on direct customer feedback and input from Oracle subject matter experts; focused on Logging & Archiving, Operating System Limits, Database Patchset and Certifications
• Updated - Removal of 120 redundant, non-critical Oracle eBusiness Suite Health Checks
• Updated – Resolved 30 Health Check policy-related bugs
• Updated – Resolved 26 Health Check product-related bugs and enhancements

I am currently trying to find the scripts which are performing these health checks. Will update this post as I learn more.

Free one hour mini lessons on Oracle University during Openworld 2008

I was going through Oracle University home page and found that they are offering free one hour mini lessons on the following topics during Oracle Openworld 2008

• Sept 22, 2pm EDT: 11g RAC Administration: Clustering Knowledge for Seamless Learning
• Sept 23, 2pm EDT: Hyperion 11.1.1: What’s New in Planning, Essbase, and Financial Management
• Sept 24, 2pm EDT: PeopleSoft and SOA: Tomorrow’s Framework Today
• Sept 24, 4pm EDT: Oracle Application Integration Architecture: Adapt, Evolve, and Thrive
• Sept 25, 2pm EDT: Integrating Siebel Applications 8.0: Point-to-Point and Hub-and-Spoke

Difference between GATHER_FIXED_OBJECT_STATS and GATHER_DICTIONARY_STATS

There are two procedures in the DBMS_STATS package for gathering statistics on Oracle native objects:

GATHER_FIXED_OBJECT_STATS
GATHER_DICTIONARY_STATS

There is a very good thread on asktom.oracle.com regarding this. I am borrowing from that thread to explain the difference between the two and when they need to be run:

GATHER_FIXED_OBJECT_STATS collects statistics for fixed X$ and K$ objects. It needs to be run whenever any init.ora parameter is changed. Fixed objects are the magic tables that are not tables - they are not "dictionary" tables. The x$ tables would change size in response to init.ora setting changes generally. Setting processes higher will add rows to various x$ views for example.

So, they could be considered a one time thing unless you make a big change to your parameter
settings.

GATHER_DICTIONARY_STATS collects statistics for SYS schema. It needs to be run whenever you do "big things" to the dictionary (loaded a schema - not put data into the schema, but rather did things in the schema that affect the dictionary like creating and dropping objects...) - you would consider gathering statistics.

Look at last_analyzed for the sys tables to see when the dictionary was gathered against. Metalink Note 281793.1 states that the DBA_OPTSTAT_OPERATIONS view may be used to determine the start and end time of all DBMS_STATS operations executed at the schema and database level.

txkFrmUTF8.pl and txkGenExtSecConf.pl fail during autoconfig

Recently I got a call from Sesh who said that Autoconfig had errored out on Application tier (Apache, Jserv, Forms). Here are the errors in autoconfig.log:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:


[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: $IAS_ORACLE_HOME/Apache/perl/bin/perl -I $IAS_ORACLE_HOME/Apache/perl/lib/5.00503 -I $IAS_ORACLE_HOME/Apache/perl/lib/site_perl/5.
005 -I $APPL_TOP/au/11.5.0/perl $COMMON_TOP/admin/install/$CONTEXT_NAME
txkFrmUTF8.pl INSTE8_SETUP 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: $IAS_ORACLE_HOME/Apache/perl/bin/perl -I $IAS_ORACLE_HOME/Apache/perl/lib/5.00503 -I $IAS_ORACLE_HOME/Apache/perl/lib/site_perl/5.
005 -I $APPL_TOP/au/11.5.0/perl $COMMON_TOP/admin/install/$CONTEXT_NAME
txkGenExtSecConf.pl INSTE8_APPLY 1


AutoConfig is exiting with status 2

I ran the file txkFrmUTF8.pl file manually and this is what I got:

SQL Command: SELECT language_code||',' FROM fnd_languages WHERE installed_flag IN ('B','I') AND language_code NOT IN ('US', 'SQ','IS','LT','VN')
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (txkFrmUTF8.pl)
TIME : Tue Sep 2 16:07:34 2008
FUNCTION: TXK::IO::open [ Level 3 ]
MESSAGES:
error = Unable to open file by ref
errorno = Illegal seek

STACK TRACE
TXK::Error::abort('TXK::Error', 'HASH(0x1d01d8)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::IO=HASH(0xd625b0)', 'HASH(0x60f7b0)', undef) called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::IO=HASH(0xd625b0)', 'HASH(0x60f7b0)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/IO.pm line 302
TXK::IO::open('TXK::IO=HASH(0xd625b0)', 'HASH(0xd63b04)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 601
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x5794a4)', 'true') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 376
TXK::SQLPLUS::validateConnectInfo('TXK::SQLPLUS=HASH(0x5794a4)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 267
TXK::SQLPLUS::setConnectInfo('TXK::SQLPLUS=HASH(0x5794a4)', 'HASH(0x14d95c)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/TechstackDB.pm line 588
TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x59cd78)', 'SELECT language_code||\',\' FROM fnd_languages WHERE installed_f...') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/TechstackDB.pm line 563
TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x59cd78)', 'SELECT language_code||\',\' FROM fnd_languages WHERE installed_f...') called at txkFrmUTF8.pl line 147
eval {...} called at txkFrmUTF8.pl line 112
)
ERRORCODE = 1 ERRORCODE_END

There are various metalink notes on errors thrown by txkFrmUTF8.pl. However none of them is having the exact error we faced. I finally tried a workaround of changing the perl version which worked:

$ ADPERLPRG=/opt/VRTSperl/bin/perl
$ export ADPERLPRG

$ PERL5LIB=/opt/VRTSperl/lib/5.8.8:/opt/VRTSperl/lib/site_perl/5.8.8:$AU_TOP/perl
$ export PERL5LIB


$ $ADPERLPRG txkFrmUTF8.pl


Script Name : txkFrmUTF8.pl
Started : Mon Sep 8 13:54:00 EDT 2008


Enter the APPS username: apps

Enter the APPS password:
ORACLE_HOME : $ORACLE_HOME
LD_LIBRARY_PATH : $ORACLE_HOME/network/jre11/lib/sparc/native_threads:$APPL_TOP/cz/11.5.0/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
PATH : $IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$APPL_TOP/ad/11.5.0/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
ORA_NLS :
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_NUMERIC_CHARACTERS : .,
NLS_SORT : binary
CONTEXT_NAME : $CONTEXT_NAME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TXK_TOP :
APPLTMP : $COMMON_TOP/temp
TWO_TASK : $TWO_TASK
ORACLE_LOCALPREFERENCE : $ORACLE_HOME/tools/admin
TNS CONNECT STRING : $TWO_TASK
SQLPLUS : $ORACLE_HOME/bin/sqlplus


After Setting Environment

ORACLE_HOME : $ORACLE_HOME
LD_LIBRARY_PATH : $ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/network/jre11/lib/sparc/native_threads:$APPL_TOP/cz/11.5.0/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
PATH : $ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:$IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$APPL_TOP/ad/11.5.0/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
ORA_NLS : $ORACLE_HOME/ocommon/nls/admin/data
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_NUMERIC_CHARACTERS : .,
NLS_SORT : binary
CONTEXT_NAME : $CONTEXT_NAME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TXK_TOP : $COMMON_TOP/rgf/$CONTEXT_NAME
APPLTMP : $COMMON_TOP/temp
TWO_TASK : $TWO_TASK
ORACLE_LOCALPREFERENCE : $ORACLE_HOME/tools/admin
TNS CONNECT STRING : $TWO_TASK
SQLPLUS : $ORACLE_HOME/bin/sqlplus
Setting of Environment completed.

SQL Command: SELECT language_code||',' FROM fnd_languages WHERE installed_flag IN ('B','I') AND language_code NOT IN ('US', 'SQ','IS','LT','VN')
Installed Languages:
D
F
FRC
HU
I
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
$ $ADPERLPRG

$ $ADPERLPRG txkGenExtSecConf.pl

Enter the APPS username: APPS

Enter the APPS password:
SQLPLUS : $ORACLE_HOME/bin/sqlplus
ORACLE_HOME : $ORACLE_HOME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
TWO_TASK : $TWO_TASK
PATH : $IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$AD_TOP/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
TNS CONNECT STRING : $TWO_TASK
LD_LIBRARY_PATH : $ORACLE_HOME/network/jre11/lib/sparc/native_threads:$CZ_TOP/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_SORT : binary
NLS_NUMERIC_CHARACTERS : .,


After Setting Environment

SQLPLUS : $ORACLE_HOME/bin/sqlplus
ORACLE_HOME : $ORACLE_HOME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
PATH : $ORACLE_HOME/bin:$IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$AD_TOP/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
LD_LIBRARY_PATH : $ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/network/jre11/lib/sparc/native_threads:$CZ_TOP/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_SORT : binary
NLS_NUMERIC_CHARACTERS : .,
TXK_TOP : $COMMON_TOP/rgf/$CONTEXT_NAME

Setting of Environment completed.

IAS PatchSet : 5
Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf :
#ServerHeader Off
Uncommented :
ServerHeader Off


Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf :
#OpmMtxFile $IAS_ORACLE_HOME/Apache/Apache/logs/opm_sys_mtx.pid
Uncommented :
OpmMtxFile $IAS_ORACLE_HOME/Apache/Apache/logs/opm_sys_mtx.pid


Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf :
#ServerHeader Off
Uncommented :
ServerHeader Off


ERRORCODE = 0 ERRORCODE_END

To ensure that this works when you run adconfig.sh, make changes to the value of s_adperlprg and s_perl5lib in the context file:

s_adperlprg = /opt/VRTSperl/bin/perl
s_perl5lib = /opt/VRTSperl/lib/5.8.8:/opt/VRTSperl/lib/site_perl/5.8.8:$AU_TOP/perl