2
Oct

REP-0004: Warning: Unable to open user preference file

Symptoms:

Concurrent request logfiles have the below error:

REP-0004: Warning: Unable to open user preference file

 

Cause:

The prefs.ora is either missing or non-accessible.

 

Solution:

1. No prefs.ora file in HOME directory:

Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file.  If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora file that came with the Oracle Tools.

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

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

12
Jan

ADOP Prepare phase fails while cloning Run Context file to refresh Patch context file

Issue:

While running adop phase=prepare, it fails on one node while trying to clone Run Context file to refresh Patch context file.

Error:

It fails with the following error in the ADOP Session.
ADOP prepare phase fails with [UNEXPECTED] occurred during CONFIG_CLONE Patch File System from Run File System

The log file has the following error:

ERROR: Could not clone the Run context file due to the following exception:
AC-00005: No write permissions for creating the Context file - /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
ERROR: Failed to clone Run Context file to refresh Patch context file

applpreprod@ebsapp01:~$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/PREPROD/fs1/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch edition context: /u01/PREPROD/fs2/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch file system free space: 83.74 GB

Validating system setup.
Read more...

Back to Top