Translate this Page

 

This posting contains the issue that I got during the migration Oracle DB and Apps EBS  as we post in trilogy of migration part I, II and III. And how to solve the problem, hope this can help you.

Ø      FRM-92150 WEB Client Version too New

SOLUTION (NOTE: 788151.1) :

Cross check the version of forms server used from the forms server installed .  Use the cmd

f60gen|grep Forms|grep Version

The output is  Forms 6.0 (Form Compiler) Version 6.0.8.xx, if not same, re-apply patch for developer6i_patch19. And assure the user already have permission. After that relink the “fnd” module.

In the java console ( or JInitiator console ) check the version. You should have the same version.

Ø      While running patch 6372396, found error :

CREATE UNIQUE INDEX APPLSYS.FND_ENV_CONTEXT_U1 ON APPLSYS.FND_ENV_CONTEXT

(CONCURRENT_PROCESS_ID, VARIABLE_NAME) LOGGING STORAGE (INITIAL 4K NEXT 8K

MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELIST GROUPS 4

FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE APPLSYSX

Statement executed.

AD Worker error:

The index cannot be created as the table has duplicate keys.

SOLUTION (http://oracleappstechnology.blogspot.com/2007/07/inserticmrecord-failed-due-to-ora-00001.html) :

The index was dropped and recreated and the concurrent managers started up. Meanwhile for the corrupt FND_ENV_CONTEXT, Oracle gave this solution:

1. Make sure that concurrent managers are not running and there are no FNDLIBR processes.

2. Drop table FND_ENV_CONTEXT as APPLSYS user.

3. Open telnet window and source apps environment.

4. Execute the following:

adodfcmp userid=applsys/apps mode=tables odffile=/patch/115/odf/afcmgr.odf touser=apps/ priv_schema=system/ logfile=”adodfcmp.log”

Ø      While install Oracle Database 10g Software

Error OUI-10094: Problem in saving inventory. Installation cannot continue.

SOLUTION (http://www.orafaq.com/forum/t/72550/0/) :

1. Create a new oraInst.loc file in the $ORACLE_HOME. This file should have the follow content:

inventory_loc=$ORACLE_HOME/oraInventory

inst_group=<the_Unix_group_that_owns_the_software_installation>

2. After creating $ORACLE_HOME/oraInst.loc, start OUI with the following options:

./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
./runInstaller -invPtrLoc /somepath_db/10.2.0/oraInst.loc

The -invPtrLoc flag is used to locate the oraInst.loc file.

3. Install 10gR2

By following these steps, you are installing 10gR2 using a new (separate) oraInventory

PROBLEM 1:

SQL> select comp_name, version, status from dba_registry;
ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE

PROBLEM 2:

SQL> select comp_name, version, status from dba_registry;
COMP_NAME                           VERSION        STATUS
----------------------------------- -------------- -----------
Spatial                             9.2.0.8.0      VALID
Oracle9i Catalog Views              9.2.0.8.0      VALID
Oracle9i Packages and Types         9.2.0.8.0      INVALID
JServer JAVA Virtual Machine        9.2.0.8.0      VALID
Oracle9i Java Packages              9.2.0.8.0      VALID
Oracle XDK for Java                 9.2.0.10.0     VALID
Oracle Text                         9.2.0.8.0      VALID
Oracle9i Real Application Clusters  9.2.0.8.0      INVALID
Oracle interMedia                   9.2.0.8.0      VALID

When upgrade from 9.2.0.3 to 9.2.0.8

Please check dba_registry for component ‘Oracle9i Packages and Types’ should VALID.

if not, we should fix it because we can’t continue to upgrade to 10g regarding problem when

collect information using utlu102i.sql, the minimum space required is very huge.

WARNING: --> APPLSYSD tablespace is not large enough for the upgrade.
.... currently allocated size: 20614 MB
.... minimum required size: 198370831250003 MB
.... increase current size by: 198370831229389 MB
.... tablespace is AUTOEXTEND ENABLED.

SOLUTION :

Combine 2 Notes :

Note:360509.1 Ora-04020 on Sys.Cdc_alter_ctable_before When Running Catalog.Sql

Set the following in the INIT.ORA then restart the database:

_system_trig_enabled=false
aq_tm_processes=0
job_queue_processes=0

AND

Note:579002.1 Select From Dba_registry Shows Packages & Types Invalid

To resolve this:

1. Disable the SYS.CDC_ALTER_CTABLE_BEFORE trigger.

SQL> ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;

2. Recompile DBMS_STANDARD.

SQL> ALTER PACKAGE dbms_standard compile;

3. Run catalog.sql and catproc.sql, then re-enable the trigger.

SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql

4. Enable the SYS.CDC_ALTER_CTABLE_BEFORE trigger.

SQL> ALTER TRIGGER sys.cdc_alter_ctable_before ENABLE;

After that Compile invalid objects :

SQL> @?/rdbms/admin/utlrp.sql

Ø      When startup the applications found error :

Cause:  Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on.

Action:  Check that your gateway environment variable is set correctly.

starting forms  metrics server for TRAN4DEV.

Cannot reconnect to gateway

Cause:  Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on.

Action:  Check that your gateway environment variable is set correctly.

adfmsctl.sh: exiting with status 0

SOLUTION :

Check dbc file in $FND_SECURE, set dbc file correctly.

Ø      Error when running adpatch :

ATTENTION: All workers either have failed or are waiting:

FAILED: file fndsec.jar   on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

in adwork01.log :

Calling /u02/ascp4w/ascp4devcomn/util/jre/1.1.8/bin/jre ...
java.lang.NoClassDefFoundError: java/sql/Blob
        at oracle.jdbc.driver.OracleStatement.get_blob_value(OracleStatement.java:6239)
        at oracle.jdbc.driver.OracleStatement.getBLOBValue(OracleStatement.java:4263)
        at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:986)
        at oracle.aurora.server.tools.loadjava.LoadJava.load(LoadJava.java:967)
        at oracle.aurora.server.tools.loadjava.LoadJava.loadAndCreateJar(LoadJava.java:1027)
        at oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(LoadJava.java:1259)
        at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1135)
        at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:266)
        at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:57)
Exception in thread "main"

SOLUTION 1 (Note:178021.1):

1) In adovars.env, change this-> ADJREOPTS=-mx128m to this ->ADJREOPTS=-mx256m (or higher)

2) Your classpath in adovars.env should be set to:

CLASSPATH=”$OA_JRE_TOP/lib/rt.jar:$OA_JRE_TOP/lib/i18n.jar:$JAVA_TOP/jdbc111.zip:$JAVA_TOP/xmlparserv2.zip:$JAVA_TOP/loadjava.zip:$JAVA_TOP/apps.zip:$ORACLE_HOME/forms60/java:$JAVA_TOP”

3) Make sure your setting of OA_JRE_TOP=”/local/java/jre1.1.8″ or whereever the java runtime environment   is installed.

SOLUTION 2:

1) Move $JAVA_TOP/appsjborg2.zip to other directory

2) Re-Generate Jar

Ø      After running catupgrd.sql, Oracle Data Mining status INVALID ;

COMP_NAME                  VERSION      STATUS
-------------------------- ------------ -----------
Oracle XML Database        10.2.0.2.0   VALID
Oracle Data Mining         10.2.0.2.0   INVALID
OLAP Catalog               10.2.0.2.0   VALID

AND Found Error when try to compile invalid objects:

PLS-00907: cannot load library unit PUBLIC.DBMS_SQL

SOLUTION (NOTE: oracle-apps-dba) :

SQL> Shutdown immediate
SQL> Startup upgrade
SQL> @?/rdbms/admin/utlirp.sql
SQL> Shutdown immediate
SQL> Startup
SQL> @?/rdbms/admin/utlrp.sql

And You’ll be find, your problem are solved.

Ø      When Gather Schema Statistic APPS, Found Error ;

ORA-20005: object statistics are locked (stattype=ALL)

SOLUTION (NOTE: 375351.1) :

Check the object that have locked :

SELECT owner, table_name, stattype_locked
FROM dba_tab_statistics WHERE stattype_locked IS NOT NULL;

– To unlock all the tables in a schema at once:

EXEC dbms_stats.unlock_schema_stats('schema_owner');

–To unlock individual tables (need to run for all tables individually):

EXEC dbms_stats.unlock_table_stats('table_owner','table_name');

Ø      After Upgrade to 10g some applications found error :

REP-0736 : There exists uncompiled program unit(s). REP-1247 : Report Contains Uncompiled PL/SQL.

In Alert Log Found Error :

ORA-00600: internal error code, arguments: [16203], [], [], [], [], [], [], []

SOLUTION:

Happen in the applications that using the remote objects. Add the owner in the front of the remote objects, so the format is OWNER.OBJECT_NAME@DBLINK.

Ø      Error When Running Push Plan Information:

ORACLE error 904 in FDPSTP
Cause: FDPSTP failed due to ORA-00904: "A1"."SUPPLIER_SITE_ID" : invalid identifier
ORA-02063 : preceding line from ATEST
ORA-02063 : Preceding 2 lines from TEST
ORA-06512 : at "APPS>MSC_M2A_PUSH", line 2558
ORA-065

SOLUTION (NOTE 431751.1) :

   Alter system set optimizer_features_enable=9.2.0 scope=memory;

Ø      After Fresh Install, Servlets and JSP Pages return “Page Not Found” :

HTTP 404 Not Found

In Apache/logs/error_log

[Wed Feb 10 17:02:02 2010] [error] [client 172.16.14.23] client denied by server configuration: /backup/ascp/ascpprodcomn/portal/ASCPPROD_tborcdb6/oprocmgr-service
[Wed Feb 10 17:02:15 2010] [error] OPM:Can not find one alive process
[Wed Feb 10 17:02:15 2010] [error] [client 172.16.59.47] File does not exist: /oa_servlets/AppsLogin

SOLUTION (NOTE 372096.1):

Create file oprocmgr.conf in $IAS_ORACLE_HOME/Apache/Apache/conf

<IfModule mod_oprocmgr.c>
            Listen 8101
            ProcNode levidb.levicorp.com 8101
<VirtualHost _default_:8101>
<IfDefine SSL>
            SSLEngine off
</IfDefine>
            Port 8101
            <Location />
                        Order Deny,Allow
                        Deny from all
                        Allow from localhost
                        Allow from levidb
                        Allow from levidb.levicorp.com
            </Location>
            <Location /oprocmgr-service>
                        SetHandler oprocmgr-service
            </Location>
            <Location /oprocmgr-status>
                        SetHandler oprocmgr-status
            </Location>
</VirtualHost>
</IfModule>

Ø      After Input Username and PasswordFresh Install, Servlets and JSP Pages return “Page Not Found” :

After insert username in web login found error :

JSP Error:

Request URI:/OA_HTML/fndvald.jsp

Exception:

java.lang.NoSuchMethodError: oracle.apps.fnd.common.AppsLog: method isEnabled(I)Z not found
  at oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:158)
  at oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:139)
  at oracle.apps.fnd.sso.SessionMgr.createAppsSession(SessionMgr.java:1393)
  at _oa__html._fndvald._jspService(_fndvald.java:74)
  at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
  at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
  at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
  at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
  at oracle.jsp.JspServlet.service(JspServlet.java:148)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
  at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
  at org.apache.jserv.JServConnection.run(JServConnection.java:294)
  at java.lang.Thread.run(Thread.java:571)

SOLUTION (NOTE 295383.1):

Apply Patch 3777544

JSP Error:


Ø      Request URI:/OA_HTML/OA.jsp

Ø      Exception:

oracle.jsp.provider.JspCompileException:

Ø      Errors compiling:/backup/ascp/ascpprodcomn/html/_pages/_oa__html//_OA.java

Note: sun.tools.javac.Main has been deprecated.
/backup/ascp/ascpprodcomn/html/_pages/_oa__html/_OA.java:64: Method setRequestCharacterEncoding(javax.servlet.jsp.PageContext) not found in class oracle.apps.fnd.framework.webui.OAJSPHelper.
        OAJSPHelper.setRequestCharacterEncoding(pageContext);
                                               ^
/backup/ascp/ascpprodcomn/html/_pages/_oa__html/_OA.java:69: Method getSessionLock(javax.servlet.http.HttpSession) not found in class oracle.apps.fnd.framework.webui.OAPageBean.
          sessionLock = pageBean.getSessionLock(session);
                                               ^
2 errors, 1 warning

        at oracle.jsp.app.JspJavacCompiler.compile(JspJavacCompiler.java:218)
        at oracle.jsp.app.JspAppLoader.reloadPage(JspAppLoader.java:1155)
        at oracle.jsp.app.JspAppLoader.loadPage(JspAppLoader.java:1005)
        at oracle.jsp.app.JspAppLoader.getPage(JspAppLoader.java:671)
        at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:337)
        at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
        at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
        at oracle.jsp.JspServlet.service(JspServlet.java:148)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
        at org.apache.jserv.JServConnection.run(JServConnection.java:294)
        at java.lang.Thread.run(Thread.java:571)

Ø      When Convert Database, Found Error ORA-00600 [ksfqfret_2]:

Starting backup at 22-FEB-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input filename=/transdev4w01/staging/rbs02.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/22/2010 09:36:35
ORA-00600: internal error code, arguments: [ksfqfret_2], [354], [200], [], [], [], [], []

SOLUTION (NOTE 437809.1):

Due to the Bug 5208043, Increase DB_FILES parameter.

Ø      Component Oracle Database Server is INVALID after upgrade to 10.2.0.4:

Oracle Database 10.2 Upgrade Status Utility           02-22-2010 14:21:33
.
Component                                Status         Version  HH:MM:SS
Oracle Database Server                  INVALID      10.2.0.4.0  00:05:26 
JServer JAVA Virtual Machine              VALID      10.2.0.4.0  00:00:42
Oracle XDK                                VALID      10.2.0.4.0  00:00:07
Oracle Database Java Packages             VALID      10.2.0.4.0  00:00:09
Oracle Text                               VALID      10.2.0.4.0  00:00:07
Oracle XML Database                       VALID      10.2.0.4.0  00:01:45
Oracle Real Application Clusters        INVALID      10.2.0.4.0  00:00:00
Oracle interMedia                         VALID      10.2.0.4.0  00:01:31
Spatial                                   VALID      10.2.0.4.0  00:00:52

SOLUTION (NOTE 437809.1):

SQL> col object_name format a30
SQL> select owner, object_type, object_name, status from dba_objects where object_name like 'DBMS_SQLPA';

OWNER     OBJECT_TYPE         OBJECT_NAME                    STATUS
--------- ------------------- ------------------------------ -------
SYS       PACKAGE             DBMS_SQLPA                     VALID
SYS       PACKAGE BODY        DBMS_SQLPA                     INVALID
PUBLIC    SYNONYM             DBMS_SQLPA                     VALID

SQL> drop table PLAN_TABLE$ purge;

Table dropped.

SQL> drop public synonym plan_table;

Synonym dropped.

Running Upgrade again :
SQL> @?/rdbms/admin/catupgrd.sql

If still INVALID, try to compile all objects

SQL> shutdown immediate
SQL> startup
SQL> @?/rdbms/admin/utlrp.sql

Ø      Error linkxlC not found when relink in IBM-AIX:

Relinking module 'PYATUPD' in product pay ...
/
/ascpdev4w/ascpprodappl/mrp/11.5.0/lib/libmrp.a
/ascpdev4w/ascpprodappl/bom/11.5.0/lib/libbom.a
/ascpdev4w/ascpprodappl/wip/11.5.0/lib/libwip.a
/ascpdev4w/ascpprodappl/inv/11.5.0/lib/libinv.a
/ascpdev4w/ascpprodappl/mrp/11.5.0/lib/libmrp.a
/ascpdev4w/ascpprodappl/fnd/11.5.0/lib/libfnd.a    -lsql
/ascpdev4w/ascpprodora/8.0.6/lib/nautab.o
/ascpdev4w/ascpprodora/8.0.6/lib/naeet.o
/ascpdev4w/ascpprodora/8.0.6/lib/naect.o
/ascpdev4w/ascpprodora/8.0.6/lib/naedhs.o `cat
/ascpdev4w/ascpprodora/8.0.6/lib/naldflgs`  -lnetv2 -lnttcp -lnetwork -lncr
-lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3
-lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr  -lnetv2
-lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric  -lepc -lnlsrtl3  -lcore4
-lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3
-lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3  -lld -lm `cat /ascpd
ev4w/ascpprodora/8.0.6/lib/sysliblist`  -lm
/ascpdev4w/ascpprodora/8.0.6/rdbms/lib/defopt.o
/ascpdev4w/ascpprodora/8.0.6/rdbms/lib/ssbbded.o          /usr/lib/libC_r.a
/bin/sh: linkxlC:  not found
make: The error code from the last command is 127.

Stop.
Done with link of wip executable 'WICDOL' on Tue Feb 23 13:43:13 CST 2010

Relink of module "WICDOL" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /ascpdev4w/ascpprodappl/wip/11.5.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

SOLUTION (NOTE: 213142.1 & 234785.1):

1.       Verify that linkxlC located in the /usr/vacpp/bin directory
2.       If not found then install XL C/C++ for AIX:
a.       Insert cd software XL C/C++ for AIX
b.       # smitty install_latest
3.       If the file can found in the /usr/vacpp/bin directory then Add appropriate path-directory to linkxlC file in $PATH variable.
# export PATH=/usr/vacpp/bin:/usr/vacpp/exe:$PATH
4.       Apply Manifest Patch or Relink again.

Ø      Error AC-50480 while generating listener.ora during Autoconfig:

Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
java.lang.Exception: Error while generating listener.ora.
        at oracle.apps.ad.tools.configuration.NetServiceHandler.generate806Listener(NetServiceHandler.java:2503)
        at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2272)
        at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:2978)
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 512
ERRORCODE = 512 ERRORCODE_END

SOLUTION:

1. export ORACLE_CONFIG_HOME=/SIDora/iAS
2. Running adconfig.sh again
3. Assure the environment of IAS_ORACLE_HOME to the path /SIDora/iAS

If still error :
verify there is service name FNDFS_hostname on $TNS_ADMIN/tnsmanes.ora, if not copy from $IAS_ORACLE_HOME/network/admin/sid_hostname/tnsnames.ora

Ø      Error “NULL cannot get connected to database“ when login to personal homepage:

Receive error:

NULL cannot get connected to database.

The details of the error message are :

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE.Tokens: MESSAGE = java.lang.Exception: Can not get a JDBCConnection; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:625)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:601)
at _oa__html._OAErrorPage._jspService(_OAErrorPage.java:75)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)

SOLUTION (NOTE: 277935.1) :

1.       Verify the value of column SESSION_COOKIE_NAME in table ICX_PARAMETERS already set to the service_name of the database. (the value is case sensitive) .
2.       Verify the value of APPS_JDBC_URL in dbc file in $FND_SECURE already set to the right database and host.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

   
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha