DBA Arena


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

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

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

Issue:

After applying Exadata or Super Cluster Bundle Patch on the RDBMS HOME of an EBS R12.2 database, the APPS.AD_ZD_ADOP Package becomes invalid and all ADOP sessions fail.

Error:

applprod@ebsapp01:~$ adop -status

Enter the APPS password:

==============================================================
ADOP (C.Delta.7)
Session Id: 55
Command: status
Output: /u01/PROD/fs_ne/EBSapps/log/status_20161115_112514/adzdshowstatus.out
===================================wo============================

File System Synchronization Type: Full
declare
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"
ORA-06512: at line 6

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

=====================

Read more...

Issue:

While applying the OJVM patch on Exadata, the patch application fails on relinking.

Error:

OPatch failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Re-link fails on target "jox_refresh_knlopt ioracle".

OJVM Patch Installation:

Go to the patch directory.

[oracle@exadb01~]$ cd /u01/exadata_patch_apr2016/22738416/Database/11.2.0.4.0/11.2.0.4.160419OJVMPSU/22674697

OPatch Conflict Check

Determine whether any currently installed interim patches conflict with this patch.

[oracle@exadb01 22674697]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2016-11-04_13-34-29PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Read more...