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...

2
Apr

Monitoring Tablespace Size

The following query helps us to check the total size and free space of individual tablespaces in a tabular format



set linesize 1200
set pagesize 1200
column tablespace_name format a20 heading 'Tablespace'
column sumb format 999,999,999
column extents format 9999
column bytes format 999,999,999,999
column largest format 999,999,999,999
column Tot_Size format 999,999 Heading 'Total| Size(Mb)'
column Tot_Free format 999,999,999 heading 'Total Free(MB)'
column Pct_Free format 999.99 heading '% Free'
column Chunks_Free format 9999 heading 'No Of Ext.'
column Max_Free format 999,999,999 heading 'Max Free(Kb)'
set echo off
PROMPT FREE SPACE AVAILABLE IN TABLESPACES
select a.tablespace_name,sum(a.tots/1048576) Tot_Size,
sum(a.sumb/1048576) Tot_Free,
sum(a.sumb)*100/sum(a.tots) Pct_Free,
sum(a.largest/1024) Max_Free,sum(a.chunks) Chunks_Free
from
(
select tablespace_name,0 tots,sum(bytes) sumb,
max(bytes) largest,count(*) chunks
from dba_free_space a
group by tablespace_name
union
select tablespace_name,sum(bytes) tots,0,0,0 from
dba_data_files
group by tablespace_name) a
group by a.tablespace_name
order by pct_free;

Read more...

8
Feb

PRCT-1011 : Failed to run "osdbagrp". Detailed error: null

Symptoms:

Trying to register the database manually, it fails

Cause:

The binary osdbagrp in the RDBMS ORACLE_HOME/bin is corrupted for some reason.

Error:

[oracle@ebsdb01 bin]$ srvctl add database -d ebstest -o /u01/app/oracle/product/12.1.0.2/dbhome_1 -p +DATA/EBSTEST/PARAMETERFILE/spfileebstest.ora -r primary -a DATA,RECO_EBST
PRCR-1006 : Failed to add resource ora.ebstest.db for ebstest
PRCT-1011 : Failed to run "osdbagrp". Detailed error:

Read more...

Back to Top