Problem:
After applying patch 9239090 (ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK), DataInstall must be run. However, after sourcing the environment and running the DataInstall command, the following error appears:
java.lang.ClassNotFoundException: oracle.apps.per.DataInstall
Solution:
Source the application tier environment (not the database tier environment) and then run DataInstall.
java oracle.apps.per.DataInstall <un> <pw> thin <host:port:sid>
java oracle.apps.per.DataInstall apps apps thin hrmstest:1522:TEST1
Other solutions:
Ensure that the IP address for the server is set in the hosts file (IP4 IP address in this case), then open a new Command Prompt window and restart DataInstall.
Output sample from actual run:
Microsoft Windows [Version 6.0.6001] Copyright (c) 2006 Microsoft Corporation. All rights reserved. C:Windowssystem32>cd oracleTEST1appsapps_stappl C:oracleTEST1appsapps_stappl>TEST1_hrmstest.cmd ECHO is off. ECHO is off. C:oracleTEST1appsapps_stappl>tnsping test1 TNS Ping Utility for 32-bit Windows: Version 10.1.0.5.0 - Production on 31-JAN-2012 10:01:04 Copyright (c) 1997, 2003, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp) (HOST=hrmstest.domainname.local)(PORT=1522)) (CONNECT_DATA= (SID=TEST1))) OK (20 msec) C:oracleTEST1appsapps_stappl>java oracle.apps.per.DataInstall apps apps thin hrmstest:1522:TEST1 DataInstall for hrglobal +-------------------------------------------------+ | DataInstall Main Menu | +-------------------------------------------------+ 1. Select legislative data to install/upgrade 2. Select college data to install/upgrade 3. Select JIT or OTL to install/upgrade 4. Exit to confirmation menu Enter your choice : Enter your choice : 1 # Localisation Product(s) Leg. Data? Action -- ------------------- ------------------------ ---------- ------------- 1 Global Human Resources Install 2 Australia Human Resources 3 Belgium Human Resources 4 Canada Human Resources 5 China Human Resources 6 Denmark Human Resources 7 Finland Human Resources 8 France Human Resources 9 Germany Human Resources 10 Hong Kong Human Resources 11 Hungary Human Resources 12 India Human Resources 13 Ireland Human Resources 14 Italy Human Resources 15 Japan Human Resources 16 Korea, Republic of Human Resources 17 Kuwait Human Resources 18 Mexico Human Resources 19 Netherlands Human Resources 20 New Zealand Human Resources 21 Norway Human Resources 22 Poland Human Resources 23 Russian Federation Human Resources 24 Saudi Arabia Human Resources 25 Singapore Human Resources 26 South Africa Human Resources 27 Spain Human Resources 28 Sweden Human Resources 29 United Arab Emirates Human Resources 30 United Kingdom Human Resources 31 United States Human Resources 32 United States US Federal Human Resources <Product #><Action> - Change Action where <Action> is [I : Install, C : Clear] [Return] - To return to main menu. Enter your choice (for example 2I) : 1i # Localisation Product(s) Leg. Data? Action -- ------------------- ------------------------ ---------- ------------- 1 Global Human Resources Install 2 Australia Human Resources 3 Belgium Human Resources 4 Canada Human Resources 5 China Human Resources 6 Denmark Human Resources 7 Finland Human Resources 8 France Human Resources 9 Germany Human Resources 10 Hong Kong Human Resources 11 Hungary Human Resources 12 India Human Resources 13 Ireland Human Resources 14 Italy Human Resources 15 Japan Human Resources 16 Korea, Republic of Human Resources 17 Kuwait Human Resources 18 Mexico Human Resources 19 Netherlands Human Resources 20 New Zealand Human Resources 21 Norway Human Resources 22 Poland Human Resources 23 Russian Federation Human Resources 24 Saudi Arabia Human Resources 25 Singapore Human Resources 26 South Africa Human Resources 27 Spain Human Resources 28 Sweden Human Resources 29 United Arab Emirates Human Resources 30 United Kingdom Human Resources 31 United States Human Resources 32 United States US Federal Human Resources <Product #><Action> - Change Action where <Action> is [I : Install, C : Clear] [Return] - To return to main menu. Enter your choice (for example 2I) : +-------------------------------------------------+ | DataInstall Main Menu | +-------------------------------------------------+ 1. Select legislative data to install/upgrade 2. Select college data to install/upgrade 3. Select JIT or OTL to install/upgrade 4. Exit to confirmation menu Enter your choice : 4 DataInstall - Actions confirmation Do you really wish to exit and save your changes? [Y] - Yes, save then exit [N] - No, don't save but exit [Return] - To return to the DataInstall Main Menu Enter your choice (for example Y) : Y DataInstall - Actions summary ----------------------------- The following actions will be performed: Localisation Product(s) Leg. Data? Action -------------------- ------------------------ ---------- ------------- Global Human Resources Install Localisation College Data? Action -------------- ------------- ------------- United Kingdom United States Option Data? Action ------------------------------ ------------- ------------- JIT/Geocode Oracle Time and Labor (OTL) C:oracleTEST1appsapps_stappl>
0 Comments.