RW-50010: Error: - script has returned an error

Last couple months I was held up with some personal stuff that kept me away from my tech blogs. Today I will share a couple of issues that we faced while setting up a 11.5.10.2 instance on a windows 2003 server and their resolution.

==

Cannot execute Install for database ORACLE_HOME

There was an error while running the command - E:\oraerp\uviserpdb\9.2.0\temp\UVISERP_usearvp405\adrun9i.cmd APPS APPS
The process tried to write to a nonexistent pipe.

RW-50010: Error: - script has returned an error: 1
RW-50004: Error code received when running external process.

==

We encountered the above error on the database server while rapid install was in the process of installing the vision database. The error was quite deceptive. After checking basic things like read write permissions etc, I came across a suggested solution to reduce the %NUMBER_OF_PROCESSORS% environment variable to less than 12. Our server has 16 CPUs and hence rapid installer (rather the java program which is invoked by rapid installer) was expecting the number of cpus to be less than 12. The suggested solution was to change the NUmBER_OF_PROCESSORS environment variable to 12 or less and reboot the server. Once, that is done clean up the failed install and start over again.

I did not want to clean up a failed install. I came up with the following approach instead:

- Defined a new environment variable with the same name (NUMBER_OF_PROCESSORS) at user level (the owner of the db file system / user-code with which rapid install was being run) and assigned a value of 12.
- Instead of a clean up, I restarted the installation with restart option : RapidWiz.cmd -restart

Once this was done, we got past the error and the installation continued. The joy of overcoming this issue was short lived when I saw the following error 10 minutes after I sorted out the first one:

==

"Cannot execute update of the OUI Inventory for database ORACLE_HOME\n";

There was an error while running the command - E:\oraerp\uviserpdb\9.2.0\temp\UVISERP_usearvp405\adrun9i.cmd APPS APPS
The process tried to write to a nonexistent pipe.

RW-50010: Error: - script has returned an error: 1
RW-50004: Error code received when running external process.

Registering local Oracle Home located at E:\oraerp\uviserpdb\9.2.0 to central oracle inventory
RC-00126: Update inventory failed.
null
Raised by oracle.apps.ad.clone.util.OracleHomeCloner

==

The last three lines of error was obtained from the Oracle Inventory logs.

This was due to the fact that we already had a 10g database running on the same server for some other application. The oracle inventory was created by 10g installation. However, all oracle installations will try to update the same Oracle Inventory. 11.5.10.2 brings in 9.2.0.6 database as part of the tech stack and this would not update the oracle inventory created by oracle 10g. I employed the following workaround to get past this issue:

- Renamed the whole existing oracle folder containing the inventory
- Ran rapid install and the new inventory was created. Installation was successful.

Also, ours is a two node install with no apps components on db server. So i can rename the inventory created by 9.2.0.6 instance any time and bring back the 10g inventory if 10g oracle home needs to be patched.

- Aravind Kamath