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

Weblogic not start after creating the Domain.

After creating a domain using a RDBMS Security Store and starting WebLogic Server, we have reports that it cannot be started up with errors like the following:

psfmw_domain/servers/AdminServer/logs/AdminServer.log00006. Log messages will continue to be logged in /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/user_projects/domains/ipsfmw_domain/servers/AdminServer/logs/AdminServer.log.>
<Aug 19, 2011 3:12:17 AM CDT> <Notice> <Log Management> <BEA-170019> <The server log file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/user_projects/domains/ipsfmw_domain/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
<Aug 19, 2011 3:12:23 AM CDT> <Error> <Security> <BEA-090870> <The realm "myrealm" failed to be loaded: weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift..
weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealm(CommonSecurityServiceManagerDelegateImpl.java:465)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadRealm(CommonSecurityServiceManagerDelegateImpl.java:840)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealms(CommonSecurityServiceManagerDelegateImpl.java:869)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1028)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        Truncated. see log file for complete stacktrace
Caused By: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:365)
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:315)
        at com.bea.common.engine.internal.ServiceEngineImpl.lookupService(ServiceEngineImpl.java:257)
        at com.bea.common.engine.internal.ServicesImpl.getService(ServicesImpl.java:72)
        at weblogic.security.service.CSSWLSDelegateImpl.getService(CSSWLSDelegateImpl.java:155)
        Truncated. see log file for complete stacktrace
Caused By: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadFullLDIFTemplate(BootStrapServiceImpl.java:910)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFTemplate(BootStrapServiceImpl.java:688)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:176)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:160)
        at com.bea.common.security.internal.service.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:106)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:965591 fatal store error> kodo.jdo.FatalDataStoreException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2170)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2017)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1915)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1833)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:965591 nonfatal store error> kodo.jdo.DataStoreException: ORA-00942: table or view does not exist
 {prepstmnt 15960898 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) ipsfmw_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@908f05, (InputStream) java.io.ByteArrayInputStream@9dc8f2, (String) 3, (Timestamp) 2011-08-19 03:12:23.296] [reused=0]} [code=942, state=42000]
FailedObject: com.bea.common.security.store.data.XACMLAuthorizationPolicy@1486b51
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4207)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4171)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
        at kodo.jdbc.kernel.BatchingPreparedStatementManager.flushInternal(BatchingPreparedStatementManager.java:214)
        Truncated. see log file for complete stacktrace
Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00942: table or view does not exist
 {prepstmnt 15960898 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) ipsfmw_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@908f05, (InputStream) java.io.ByteArrayInputStream@9dc8f2, (String) 3, (Timestamp) 2011-08-19 03:12:23.296] [reused=0]} [code=942, state=42000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1421)
        Truncated. see log file for complete stacktrace
>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
<Aug 19, 2011 3:12:23 AM CDT> <Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:

There are 1 nested errors:

weblogic.security.service.SecurityServiceRuntimeException: [Security:090399]Security Services Unavailable
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:916)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1050)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        at weblogic.security.SecurityService.start(SecurityService.java:141)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Aug 19, 2011 3:12:23 AM CDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>
-bash-3.2$

Cause:

The root cause is that the RDBMS Tables are not created in the Security Datastore.

Solution:

Before booting the domain, the RDBMS tables need to be created in the database:
Specify the same connection properties, including the credentials of the user who has access, the database URL, etc., as specified for that RDBMS during domain creation.
    Run the appropriate script to create RDBMS tables. There are a set of SQL scripts for creating/removing RDBMS tables under WL_HOME/server/lib: e.g., for Oracle DB, rdbms_security_store_oracle.sql is to create RRDBMS tables and rdbms_security_store_oracle_remove.sql is to remove these tables.

For details, please refer to "Create RDBMS Tables in the Security Datastore" part in http://www.oracle.com/pls/as1111/lookup?id=SECMG346

Ref Doc:

WebLogic Server Cannot Start Up with RDBMS Security Store (Doc ID 1327167.1)
WebLogic Server Does Not Start With Error: BEA-090870 The realm "myrealm" failed to be loaded (Doc ID 1328521.1)

Running AutoConfig On DB Node Reports: UnsatisfiedLinkError Exception Loading Native Library: njni11 while DB upgraded to 11.2.0.2

Recently While DB Upgraded from 11.1.0.7 to 11.2.0.2 , while running autoconfig below is the error


Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: njni11 (No such file or directory)

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

This issue because of Database 11.2 it only comes with 64bit libraries, but we are still trying to use 32bit java as defined by context variables s_jdktop and s_jretop which points to ORACLE_HOME/appsutil/jre

So changed the s_jdktop and s_jretop in $CONTEXT_FILE  to point to $ORACLE_HOME/jdk/jre and ran the autoconfig and if went successful.

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Reference DOC: 1087973.1

FRM-92101 When Launching Forms on IBM AIX After fresh Install of EBS R12.1.1

Recently After fresh Install of R12.1.1 on IBM AIX , forms is not able to launch.. Getting the below error...

FRM-92101 : There was a failure in the Forms Server during startup.

This could happen due to invalid configuration. Please look into the web-server log file for details.

In Forms server log file:

$LOG_HOME/ora/10.1.3/j2ee/forms_default_group_1/application.log

formsweb: Forms session <3> aborted: runtime process failed during startup with errors exec(): 0509-036 Cannot load program .../apps/tech_st/10.1.2/bin/frmweb because of the following errors:

rtld: 0712-001 Symbol nnftboot was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnfoboot was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnfhboot was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnflboot was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nttini was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ntusini was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ntpini was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ntzini was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnflgav was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnflrne was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnflfrm was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol nnflgapc was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ldap_search_s was referenced
from module frmweb(), but a runtime definition
of the symbol was not found.

Cause:

The forms executable was not relinked successfully.   The "failed during startup: no response from runtime process" error message occurs when first trying to initialize the forms process versus actually performing a forms function.The most common cause for the failed relink is that the file "ldflags" in $ORACLE_HOME/lib32 is missing or pointing to an incorrect location.

Solution

In several customer instances, $ORACLE_HOME/lib32/ldflags was a symbolic link that pointed to a location that did not exist.  This was resolved by performing the following UNIX commands to point the $ORACLE_HOME/lib32/ldflags to the $ORACLE_HOME/lib/ldflags :

$ cd $ORACLE_HOME/lib32
$ rm ldflags
$ ln -s $ORACLE_HOME/lib/ldflags ldflags 

Then,  stop the web tier services (adopmnctl.sh stop) and relink the forms executable(s):

$ cd $ORACLE_HOME/forms/lib32/
$ make -f ins_forms.mk install

Refer DOC ID:AIX/R12: FRM-92101 When Launching Forms; application.log shows symbols not found (rtld: 0712-001) (Doc ID 454427.1)

Oracle Apps component Version

Oracle Apps component Version

Script to find Apache, Java, Jinitiator, Forms version and JVM details for Oracle E-Business Suite 11i [ID 466890.1] You can find the similar Script to find various component version for Oracle E-Business suite R12 at <<468311.1>> XML Publisher Version: http://ora-apps.blogspot.com/2007/10/find-xml-publisher-version.html Q: How to find Oracle Applications Web Server Version ? Q: How to find Version of Apache used with oracle apps 11i ? Log to Application tier as Operating System Usually called as APPLMGR ; go to location $IAS_ORACLE_HOME/Apache/Apache/bin and run command ./httpd -version You will see output like Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix) Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5) Which means you are on iAS Version 1.0.2.2.2 with patchset rollup 5 with Apache Version 1.3.19 Server version: Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server Above is output If you have installed 10g Application Server with 11i   Q: How to find Jinitiator Version ? Check for file like appsweb_SID_HOSTNAME.cfg under $OA_HTML/bin defined by environment variable FORMS60_WEB_CONFIG_FILE & search for entry like jinit_ver_name , you will see entry like jinit_ver_name=Version=1,3,1,23 which means Jinitiator version is 1.3.1.23 ; if your version is 1.3.1.18 you will see entry like 1,3,1,18

Q: How to find Forms Version in 11i ? Login to forms from frontend , on top menu bar of forms click on "Help" & Select "About Oracle Applications" go to "Forms Server " section. You should see entry like below depending on your forms version Oracle Forms Version : 6.0.8.26.0 Which mean you are on forms version 6.0.8.26 . If you want to know whats your forms patchset level then subtract 9 from fourth digit which means for above case form patchset 17 is applied.

Q: How to find Forms Version in Apps from command Line ? Enter "f60gen" on Forms Server and check for first line in output like Forms 6.0 (Form Compiler) Version 6.0.8.26.0 (Production) This confirms that you are on forms server version 6.0.8.26.0 and patch set 17. ( Patch Set = Fourth Digit - 9)

Q: How to find any Reports Version 11i ? or In Oracle Applications under ad utilities there is utility called as adident Used for Identification purpose or to find out file version use adident Header <filename> for ex. inorder to to find file version of one AR form i.e. ARXGLCOR.fmx adident Header ARXGLCOR.fmx You should see output like $Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $ $Header ARXGLCOR.fmb 115.15 2005/01/31 13:48 mraymond ship Which means above form executable consist of two forms whose version is 115.33 & 115.15 resp. Similarly you can use adident to find version of any report in 11i.  Q: How to find Operation System Version (Unix/Linux) ? For solaris use command uname -a You will see output like For Solaris SunOS servername 5.8 Generic_117350-23 sun4u sparc SUNW,Sun-Fire-V240 For RedHat Linux use command cat /etc/*release* You will see output like Red Hat Enterprise Linux AS release 3 (Taroon Update 6) Which means you are on Solaris 5.8 or Linux AS 3 resp.

Q: How to find if your Operating System is 32 bit or 64 Bit ? For solaris use command isainfo -v If you see out put like 32-bit sparc applications That means your O.S. is only 32 bit but if you see output like 64-bit sparcv9 applications 32-bit sparc applications above means your o.s. is 64 bit & can support both 32 & 64 bit applications

Q: Can I run 64 bit application on 32 bit Operating system ?

You can run 32 bit application (like oracle application server, web server, all oracle application server are 32 bit ) on both 32 /64 bit operating system but a 64 bit application like 64 bit database can run only on 64 bit operating system.

Q How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?

execute "file $ORACLE_HOME/bin/oracle" , you should see output like
/u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable SPARC Version 1
Now you know what should be bit of patch to download

Find component Version in Apps 11i/R12/12i
Q. How to find Apps Version (11i/R12/12i).
A.  Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output like 12.0.4 or 11.5.10.2
Q. Web Server/Apache or Application Server in Apps 11i/R12
A. Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built:   Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)
Output for R12 should be like
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built:   Dec  4 2006 14:44:38
Q. Forms & Report version (aka developer 6i) in 11i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
output like
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)
.
Q. Forms & Report version in R12/12i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings
Q. Database Version in 11i/R12/12i
A. Go to database section below.
Q. Oracle Jinitiator in 11i/R12/12i
A. Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

(Default is Java Plug-In for R12/12i )
Q. Oracle Java Plug-in in 11i/R12/12i
A. Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
Q. File Version on file system
adident Header <filename>
or
strings <file_name> | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility
Q. Version of pld file
*.pld are source code of *.pll which are inturn source of *.plx.  *.pll is in $AU_TOP/resource and to find its version check
adident Header $AU_TOP/resource/<filename>.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $
or
strings $AU_TOP/resource/<filename>.pll | grep -i header
FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);
Q. OA Framework Version
A.http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)
A.  Log in as Application user, set environment variable and run below query
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp
output for both should look like
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $
120.21 means OA Framework Version (coming soon..)
115.60 means OA Framework Version (coming soon..)
115.56 means OA Framework Version (coming soon..)
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E
Q. Discoverer Version for 11i (3i or 4i)
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version
Q. Discoverer Version for 11i or R12 (10g AS)
Check under Application Server Section as 10g AS Discoverer is on standalone

$ORACLE_HOME/bin and run the command:

strings -a dis51ws | grep "Discoverer Version:"

Q. Workflow Version with Apps
A. Connect to Database as apps user
SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;
Output like 2.6.0 means workflow version 2.6.0
.
Version for Fusion Middleware Component

Identity Management component Version/Release Number
A. Oracle Single Sign On
Connect to database which holds SSO repository
SQL>select version from orasso.wwc_version$;
B. Oracle Internet Directory
There are two component in OID (Software/binaries & Schema/database)
>>> To find software/binary version
$ORACLE_HOME/bin/oidldapd -version
output should look like
oidldapd: Release 10.1.4.0.1 - Production on mon jul 14 14:14:21 2008
Copyright (c) 1982, 2006 Oracle.  All rights reserved.
>>> To find Schema Version/ database use
ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \
-s base “objectclass=*” orcldirectoryversion
and output should be like
version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1
or run following query in database
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;
Output should be like OID 10.1.4.0.1
C. Application Server
1. Oracle Application Server 10g Rel 3 (10.1.3.X)
cat $ORACLE_HOME/config/ias.properties | grep Version
Version=10.1.3.0.0
2. For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
SQL> select * from ias_versions;
or
SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;
.
D. AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version
.
E. Oracle Portal
SQL> select version from portal.wwc_version$;
.
Database Component
I) Oracle Database
To find database version
SQL> select * from v$version;
or
All component version in database
$ORACLE_HOME/OPatch/opatch lsinventory -detail
.
Oracle Enterprise Manager
Metalink Note 605398.1  How to to find the version of the main EM components
.
Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release
 .
Related
http://teachmeoracle.com/version03.html

Script to find Apache, Java, JRE, Forms version for Oracle E-Business Suite R12

# +===========================================================================+
# | FILENAME
# | Instancedetails_R12.sh
# |
# | DESCRIPTION
# |   This script can be used to collect Apache, Jserv, Forms, Jinitiator and  
# |   Perl version in E-Business suite R12
# |
# | PLATFORM
# | Unix Generic, Linux, HP-UX,IBM AIX, Sunsolaris 
# |
# | NOTES
# |   Before running the script ensure that you have sourced the environment 
# |   by running APPS<SID>_host.env file from $APPL_TOP.  
# |
# | HISTORY
# |   Version 1.0
# +===========================================================================+
#
(
echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file  zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt
###
### END OF SCRIPT
###

Workflow Log file and troubleshoot

Workflow Log file location:
 -----------------------------------
Logs on CM Node at $APPLCSF/$APPLLOG/FNDC*.txt

To identify the 4 more recent log files for Workflow Mailer and Agent Listener services, run the following command:

# ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

Troubleshoot of WorkFlow:
===========================


Note:
How to Troubleshoot when the Workflow Services Go Down [ID 564394.1]
Troubleshooting Workflow Issues in Applications 11i [ID 266614.1]

1. Please advise at which time did mailer go down for the last time.

2. Upload the 4 more recent log files from $APPLCSF/$APPLLOG/FNDCPGSC*.txt

To identify the 4 more recent log files for Workflow Mailer and Agent Listener services, run the following command:

# ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

then upload the files.

3. Upload wfver.sql results
a. Go to $FND_TOP/sql
b. Start sqlplus connected as APPS schema user.
c. Run these commands:
spool wfver.txt
sta wfver.sql
spool off
d. Upload wfver.txt file generated.

4. For a notification that is not emailed:

a. Go to $FND_TOP/sql
b. Start sqlplus connected as APPS schema user.
c. Run this command:
start wfmlrdbg.sql <NID> <APPLSYS schema user> <APPLSYS's Pwd> where,
<NID>.................: Notification ID
<APPLSYS schema user>.: Default APPLSYS
<APPLSYS's Pwd>.......: Same password as APPS schema user
password.
d. Upload html file that is generated by the command execution.

If you don't know the notification id please execute:

SQL> select max(notification_id) from wf_notifications where status='OPEN'
and mail_status in
('MAIL', 'ERROR');

OPP Log file Location

Identify the OPP log file :

1.Directly from the file system based after identifying the corresponding OPP log file name using the following SQL statement:

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
  FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
 WHERE fcpp.processor_id = fcp.concurrent_process_id
   AND fcpp.action_type = 6
   AND fcpp.concurrent_request_id = &&request_id

2.Via the Forms application:

   1. Login to the application as SYSADMIN
   2. Responsibility: System Administrator
   3. Function: Concurrent --> Manager --> Administration
   4. Select the Output Post Processor
   5. Click on the Processes button
   6. Select the Concurrent Process which was active during the time that the request ran
   7. Click on the Manager Log button to open the Output Post Processor log file

3.Via the Oracle Application Manager (OAM)

   1. Login to the application as SYSADMIN
   2. Responsibility: System Administration
   3. Function: Oracle Applications Manager --> Concurrent Managers
   4. Select the Output Post Processor Service and click on View Details
   5. Click on View Processes
   6. Select the Concurrent Process which was active during the time that the request ran
   7. Click on the Log button to open the Output Post Processor log file

Determine what the heap size per OPP process is currently:

select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

TO KNOW OPP log :
=================
cd $APPLCSF/$APPLLOG
grep 1731722 FNDOPP*
grep Error* FNDOPP*

Clonig Issues

Troubleshooting RapidClone issues with Oracle Applications R12 [ID 603104.1]

Some of the Cloning Issues faced and it’s solution:

1    - While running adpreclone on EBS ,  APPS  user locked continiously .
Soultion - Follow metalink Note Id - ID 420001.1

2- PDF output problem in Instance. No PDF output produced  after cloning .

        Solution - Follow metalink Note Id ID 981163.1

3-    Got this in alert.log WARNING: Oracle executable binary mismatch detected.

Solution - Follow the metalink Note ID - 369260.1.

4-    After cloning, forms will not launch ,it will not come up.Performed the below Steps:

  EXEC FND_CONC_CLONE.SETUP_CLEAN; commit;
Ran the cmclean.sql scripts

Run Autoconfig on all nodes.(DB+CM+WEB Nodes)

5. After cloning Purge Concurrent Request and/or Manager Data request  status alway is running , it is not completing.

As per Metalink ID 1016766.102 ( OS Files are Purged from Wrong Instance when Running Purge Concurrent Requests),It is because of FNDCPPUR is trying to delete files it can't access because they are belonging to the original environment.
The following table and columns still contain PATH referencing the original
environment :
FND_CONCURRENT_REQUESTS.LOGFILE_NAME
FND_CONCURRENT_REQUESTS.OUTFILE_NAME
Perfoem the below Steps:

     a) Stop the concurrent managers.
     b) Start a SQL*Plus session as APPLSYS.
     c) Issue the following commands:
             TRUNCATE TABLE fnd_concurrent_requests;
             TRUNCATE TABLE fnd_concurrent_processes;
        
             UPDATE fnd_concurrent_queues
                SET running_processes = 0,
                    max_processes = 0;
             COMMIT;
     d) Exit the SQL*Plus session.
d)    Restart the concurrent managers.


6)While running adcfgclone.pl getting the Inventory problem , so enter the correct entry in /etc/oraInst.loc location.

7) Also after starting the services the listener was not coming up because of missing listener.ora file in $TNS_ADMIN location.

Solution:

Then Stop the APPS Services ./adstpall.sh apps/<appspwd>
run the Autoconfig .   ./adautocfg.sh

Then start the APPS Services   ./adstrtal.sh apps/<appspwd>