Forms Launching Error, After Fresh R12.1.1 Installations on Linux x86 32 bit

I faced issue while launching forms on newly installed R12.1.1 Oracle Applications.

FRM-92101:  formsweb: Forms session <1> aborted: runtime process failed during startup with errors /apps/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

While chekcing the Web Forms log file. in $LOG_HOME/ora/10.1.3/j2ee/<forms>/<forms>_<default_group_1>/application.log
 formsweb: Forms session <1> exception stack trace:

oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
        at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
        at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
        at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
        at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:619)

Cause:

The issue is caused by the openmotif21 package which is missing from the system.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.

Solution:

1. Install package openmotif rpm.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.
2. Bounce the services.(both Apps+DB)
3. now able to launch the forms.

Ref Doc: FRM-92101: Forms Server [ID 1192205.1]

Error in Installing R12.1.1 Oracle Applications in Final Step 5

Recently faced the issue while installing R12.1.1 installtion. After final steps of R12.1.1 installations, Faced the below error in Final Screenshot.

HTTP
-----
   checking URL = http://localhost.localdomain:8000
   RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page
----------
checking URL = http://localhost.localdomain:8000/OA_HTML/help
   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
------------------
   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
   checking URL = http://localhost.localdomain:8000/OA_HTML/jtfTestCookie.jsp
   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

I checked the application installation log file(/apps/inst/apps/TEST_localhost/logs/05030038.log).the above error was there.. while again investing the log file, observed that
the autoconfig was failing. So checked the autoconfig logfile (/apps/inst/apps/TEST_localhost/admin/log/05030620/adconfig.log), The below error was found.

[CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /apps/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl  -1
No of scripts failed in CVM phase: 1
AutoConfig is exiting with status 1

I didn't find the exact hit on support.oracle.com , so plan to run the perl scripts manually which was failing..SO ran the perl scripts and it autoconfig got successful.and click the
retry button of R12 Installtion screen, it got successful.

[applmgr@localhost bin]$ perl adgentns.pl contextfile=/apps/inst/apps/TEST_localhost/appl/admin/TEST_localhost.xml  appspass=apps
##########################################################################
                   Generate Tns Names
##########################################################################
Logfile:  /apps/inst/apps/TEST_localhost/admin/log/05030918/NetServiceHandler.log
        Classpath                   : /apps/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/apps/apps_st/comn/java/classes
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END

Issue with running catupgrd.sql while Database upgrade from 10.2.0.4 to 11.2.0.3:

Getting below error while running catupgrd.sql scripts while DB upgrade.

SELECT TO_NUMBER('MUST_HAVE_RUN_PRE-UPGRADE_TOOL_FOR_TIMEZONE')
                *
ERROR at line 1:
ORA-01722: invalid number

Cause:
------------
The Pre-Upgrade Script is not creating the registry$database table & inserting the Platform DST Patch Information.The error may also appear if the the registry$database table exists,  but does not contain the required information.

Solution:
-----------------

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> create table registry$database_b as select * from registry$database;

Table created.

select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> INSERT into registry$database
  2                      (platform_id, platform_name, edition, tz_version)
  3                 VALUES ((select platform_id from v$database),
  4                         (select platform_name from v$database),
  5                          NULL,
  6                         (select version from v$timezone_file));

1 row created.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit
         13 Linux x86 64-bit                                             4

SQL> commit;

Commit complete.

SQL> delete from sys.registry$database where TZ_VERSION is NULL;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit                                             4

Ref Doc: catupgrd.sql fails With ORA-01722 Invalid Number after running the Pre-Upgrade Script [ID 1466464.1]

Opatch Error while Applying PSU 5 Patch in 11g.

Recently i got the below error while applying the PSU5 Patch on one of my Dev instance.

[oracle@xxxxxxxxxxxxxxxxxxxxx]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
UtilSession failed: oracle/cluster/install/InstallException
Log file location: /oracle/product/11.2.0.3/XXXXXX/cfgtoollogs/opatch/opatch2013-04-25_02-37-35AM_1.log
OPatch failed with error code 73
The Stack Trace error shows the below error:

[Apr 25, 2013 2:37:38 AM]    OUI-67073:UtilSession failed: oracle/cluster/install/InstallException
[Apr 25, 2013 2:37:38 AM]    Finishing UtilSession at Thu Apr 25 02:37:38 EDT 2013
[Apr 25, 2013 2:37:38 AM]    Log file location: /oracle/product/11.2.0.3/OIMDEV/cfgtoollogs/opatch/opatch2013-04-25_02-37-35AM_1.log
[Apr 25, 2013 2:37:38 AM]    Stack Description: java.lang.RuntimeException: oracle/cluster/install/InstallException
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgClusterwareInfo.createClusterwareInfo(OiipgClusterwareInfo.java:155)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgClusterwareInfo.getClusterwareInfo(OiipgClusterwareInfo.java:180)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgDetectCluster.<init>(OiipgDetectCluster.java:131)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgDetectCluster.getDetectCluster(OiipgDetectCluster.java:146)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getLocalNode(Rac.java:1789)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getInstance(Rac.java:1236)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getInstance(Rac.java:1101)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.NSession.validateConnectStringNodes(NSession.java:85)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:418)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Apr 25, 2013 2:37:38 AM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)

I tried to search in oracle.support and google and didn't fine anything.. it 's looks more like java error rather than Database error. Then i carefully saw the java error and found that it is trying to searching Local Node. While querying opatch lsinv, the local and remote node was showing different node name rather than current node..

Rac system comprising of multiple nodes
  Local node = xxxxxxxxxxxxxxxx
  Remote node = xxxxxxxxxxxxxxxxx
SO i updated the updateNodeList parameter like below, and the opatch apply went successful.

cd $ORACLE_HOME/oui/bin/
./runInstaller -silent -updateNodeList ORACLE_HOME=/oracle/product/11.2.0.3/XXXXX "CLUSTER_NODES={host.cisco.com}"

Issues while applying RUP 7 Patch on 11.5.10 CU2 on IBM AIX

1 ld: 0711-783 WARNING: TOC overflow. TOC size: 78748 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-101 FATAL ERROR: Allocation of 16204512 bytes failed
in routine init_symtab_info. There is not enough memory available.      

Solution: ld: 0711-101 FATAL ERROR: While Relinking Product MSC MSO MSR (Doc ID 330990.1)       
LDR_CNTRL=""MAXDATA=0x40000000""
export LDR_CNTRL          Run the patch again      
                           "
2.AD Worker error:
The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above                                                                          

 Solution: Patch 6241631-11i.ATG_PF.H.RUP7 fails on icxwtab.odf: Table Has Duplicate Keys (Doc ID 1148403.1)            
    1. Run the backup copy of ICXDLTMP.sql as the APPS user from the 11i.ATG_PF.H.delta.7 Patch directory.
    For example :
    sqlplus apps/apps_pwd @patch Directory/backup/[SID]/[HostName]/icx/sql/ICXDLTMP.sql           
 2. Restart the failed worker via the adctrl Utility using option 2"

adncep3(): Invalid destination character set: UTF8

Issue with the Patch Admerge :
----------------------------------------
Character-set converting files...
adncep3(): Invalid destination character set:  UTF8

Adncnv error:
  Character-set conversion failed

Please check the adncnv logfile at admrgpch.log.

************* Start of AD Character-set Conversion session *************
AD Character-set Conversion version: 12.0.0
AD Character-set Conversion started at: Fri Jan 27 2012 05:32:18

AD Merge Patch error:
  Character-set conversion failed.

Solution:
--------
To implement the solution, please execute the following steps:

1. Manually set (and export) environment variable NLS_LANG to be American_America.US7ASCII.

2. Run again
     admrgpch -s patches -d mrgd_patches -merge_name mrg_patch

3. Migrate the solution as appropriate to other environments.

Export Import Issues

IMP-00019: row rejected due to ORACLE error 1

IMP-00003: ORACLE error 1 encountered

ORA-00001: unique constraint (APPLSYS.FND_CONC_PROG_ONSITE_INFO_U1) violated

ORA-06512: at "APPS.FND_PROG_ONSITE_INSERT", line 4

ORA-04088: error during execution of trigger 'APPS.FND_PROG_ONSITE_INSERT'

Solution:

We have dropped the index FND_CONC_PROG_ONSITE_INFO_U1 and import the table FND_CONCURRENT_PROGRAMS and finally create the index.

SQL> Drop index FND_CONC_PROG_ONSITE_INFO_U1;

Index dropped.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_CONCURRENT_PROGRAMS  commit=y ignore=Y log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi_1

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 17:51:43 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table      "FND_CONCURRENT_PROGRAMS"       9841 rows imported
Import terminated successfully without warnings.

SQL> select count(*) from APPLSYS.FND_CONCURRENT_PROGRAMS;

  COUNT(*)
----------
      9841

SQL> CREATE INDEX "APPLSYS"."FND_CONC_PROG_ONSITE_INFO_U1" ON "APPLSYS"."FND_CONC_PROG_ONSITE_INFO" ("PROGRAM_APPLICATION_ID", "CONCURRENT_PROGRAM_ID") PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT) TABLESPACE  "APPS_TS_TX_IDX" ;

Index created.

Issues: 

IMP-00058: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_SEED'
Import terminated successfully with warnings.

We tried to execute the import command with below command and got the error.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_USER  commit=y ignore=Y CONSTRAINTS=N indexes=N
log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 14:20:22 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table                     "FND_USER"
IMP-00058: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_SEED'
Import terminated successfully with warnings.

Then accordign to DOC ID:OERR: ORA 1552 cannot use system rollback segment for non-system tablespace (Doc ID 18951.1), we have created a new rollback segment and made it online and tried the import again.

SQL> create rollback segment ssi_test TABLESPACE APPS_UNDOTS1;

Rollback segment created.

SQL> select SEGMENT_NAME,OWNER,STATUS,TABLESPACE_NAME from DBA_ROLLBACK_SEGS where SEGMENT_NAME='SSI_TEST';

SEGMENT_NAME                   OWNER  STATUS
------------------------------ ------ ----------------
TABLESPACE_NAME
------------------------------
SSI_TEST                       SYS    OFFLINE
APPS_UNDOTS1

SQL> alter rollback segment ssi_test online;

Rollback segment altered.

SQL> select SEGMENT_NAME,OWNER,STATUS,TABLESPACE_NAME from DBA_ROLLBACK_SEGS where SEGMENT_NAME='SSI_TEST';

SEGMENT_NAME                   OWNER  STATUS
------------------------------ ------ ----------------
TABLESPACE_NAME
------------------------------
SSI_TEST                       SYS    ONLINE
APPS_UNDOTS1

We got unique constraint (APPLSYS.FND_USER_U1) violated error while again import.

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (APPLSYS.FND_USER_U1) violated

Also we tried with option   CONSTRAINTS=N indexes=N  , but same error reoccured.

SO we plan to truncate the FND_USER table after taking the backup(fnd_user_bkp_210111) and tried the import , it was successfull.

SQL> SQL> create table fnd_user_bkp_210111 as select * from fnd_user;

Table created.

SQL> select count(*) from fnd_user;

  COUNT(*)
----------
       452

SQL> select count(*) from fnd_user_bkp_210111;

  COUNT(*)
----------
       452

SQL> truncate table fnd_user;

Table truncated.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_USER  commit=y ignore=Y

log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 15:32:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table                     "FND_USER"        452 rows imported
Import terminated successfully without warnings.

SQL> select count(*) from fnd_user;

  COUNT(*)
----------
       452