6
Feb

JServer JAVA Virtual Machine Component Invalid

Symptoms:

The JAVAVM Component has become invalid in the database.
 

Check the status of all the components in the database.
 
set pages 1000;
col comp_id for a12;
col comp_name for a35;
col version for a12;
col status for a12;
select comp_id,comp_name,version,status from dba_registry;


COMP_ID COMP_NAME VERSION STATUS
------------ ----------------------------------- ------------ ------------

MGD Oracle Machine Generated Data 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 INVALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
RAC Oracle Real Application Clusters 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID

15 rows selected.

Read more...

1
Nov

Utlrp.sql results to "Warning: XDB Now Invalid, Could Not Find Xdbconfig"

Symptoms:

When trying to recompile invalid objects by running the utlrp.sql script, the below error is thrown:
"XDB now invalid, could not find xdbconfig"
 
Furthermore, Oracle XML Database (XDB) is INVALID.

Error:

ERROR at line 1:
ORA-31024: Parser initialization failed with LPX-201 error
while parsing a stream to XOB
ORA-06512: at "SYS.UTL_RECOMP", line 865
ORA-06512: at line 4

Read more...

18
Feb

Applying AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2

The latest RUPs while writing this post are R12.AD.C.Delta.10 (Patch 25820806) and R12.TXK.C.Delta.10 (Patch 25828573).

Apply Required Database Patches

 
AD-TXK Delta 10 requires a number of database bug fixes to install and operate correctly.
 
NOTE: Take Central Inventory backups on the database and application tiers.
 
Before you apply the AD and TXK Delta 10 release update packs (RUPs), you must run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC). Use the command checkDBpatch.sh (on UNIX) or checkDBpatch.cmd (on Windows).

Check the OPatch utility version.

/u01/oracle/product/dbhome1/OPatch/opatch version
OPatch Version: 11.2.0.3.16

OPatch succeeded.

Upgrade to the latest OPatch Utility.

[oracle@ebsdb01 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.18

OPatch succeeded.

Read more...

3
Jul

Forms Service shows down in Oracle Enterprise Manager Cloud Control 12c

Symptoms

Forms service shows down for the E-Business Suite instance discovered in OEM but it is Up.

Cause

Wrong Forms URL

Solution

1. Go to targets-->All targets

2. In the Search Target Name, enter "Forms" or in the Search LOV select "Forms" then click (Go) button

Read more...

14
Jun

How to Create a Read Only APPS Schema in Oracle E-Business Suite

Create an APPS READONLY user

There are 2 ways to achieve this:

1) Create a user and grant select option to that user.

This will have to be done individually for all users that you want to have as read only.

2) Create a readonly role and assign users this role.

This will have to be done once and then assign this role to the users.

Read more...

Back to Top