Issues and fixes

Autoconfig Issues

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

ORA-29531 No Method Class oracle/xml/parser/plsql/XMLNodeCover during Autoconfig (Doc ID 470706.1)

ORA-07445: exception encountered: core dump [eosize()+125] [SIGSEGV] [ADDR:0x2C] [PC:0x3C76923] [Address not mapped to object] []

Above was resolved by executing the steps mentioned in the below Metalink Doc Id.

ORA-7445 [eosize()+125] errors After JAVAVM patch 19282021 DATABASE PSU (OCT2014) (Doc ID 1951362.1

Post clone of patch if required.

For Cm issue (Managers not coming up)
=================================

Apply patch 3830807 on all cm nodes.

Forms not Launching
=================
login to application node go to 


cd $AU_TOP/resource

Take backup of  CUSTOM.plx and replace this file from any of the working environment. 

Database issues after cloning

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

In alert log if you find such errors:

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of _ASH_SIZE to a sufficiently large value. Currently, ASH size is 167772160 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:

ORA-00600: internal error code, arguments: [kwqmfidliot:ins], [], [], [], [], [], [], [], [], [], [], []

To fix this 

Gather fixed object stats at DB level 

ref:1479804.1

eg

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

Need to fix the broken jobs
=========================

Check for the failed jobs
SQL> select job,LAST_DATE,BROKEN,FAILURES,TOTAL_TIME from dba_jobs;

Desc job in detail
=================
SQL> select what from dba_jobs where job=61;

Just unbreak them, and select a new execution date:
=================================================== 
sql> exec DBMS_JOB.BROKEN(<jobno>, FALSE, <next_date>);

ref:
https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3458126&_afrLoop=264058811036289&resultTitle=Need+to+fix+the+broken+jobs&commId=3458126&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=se4b66f4x_285

failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
R12: Resolving error mod_oc4j Failed To find A Failover OC4J Process For Session Request For Destination (Doc ID 785296.1)

How to recover older Oracle pl/sql source code from a package body after its has been replaced with newer code

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

Sol:

Yes by using a flashback query on all_source you can retrieve.

Run it as sys user.

SQL> select text

  2  from all_source

  3  as of timestamp

  4  to_timestamp('04-JUN-2010 21:30:00', 'DD-MON-YYYY HH24:MI:SS')

  5  where name = 'CARPENTERI_TEST'
  6  and type = 'PACKAGE BODY';

Ref:

http://stackoverflow.com/questions/2976682/can-i-recover-older-oracle-pl-sql-source-code-from-a-package-body-after-i-have-r


Arabic Language  displays as " ??????? "in toad or at db level.

Workaround:
============
Change regedit.exe NLS_LANG entry as per the database characterset take backup of entry edit and restart.
AR8MSWIN1256 ( for arabic)

Steps to install Oracle Developer Suite 10g.

1.       Install oracle jdk software (jdk-6u35-windows-i586).
2.       Install Oracle Develper Suite ds_windows_x86_101202_disk1/2.
3.       Upgrade Devloper Suite by applying Patch 10396165 & Patch 5983622.
4.       Apply fix patch 7047034.
5.       Apply fix patch 14825718.

$ cat tailalert

tail -2000 /trace/alert_DEV.log | grep -i ORA-

tail -1000 /trace/alert_DEV.log | grep -i ORA-

tail -500 /trace/alert_DEV.log | grep -i ORA-

tail -2000 /trace/alert_DEV.log | grep -i alter

Audit Vault Document
====================

Master Note For Oracle Database Auditing ( Doc ID 1299033.1 )
Section:Configuring what must be audited

Some Examples About Auditing And Output Of Auditing ( Doc ID 167293.1 )

Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

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

Cause

The profile option "AD_PATCH_MONITOR_PROFILE" has not been set to "unlimited" and is still set at the default value of "3". 

Check the profile option using the following query:

set pagesize 300

col profile format a25

col limit format a10

select PROFILE, RESOURCE_NAME, RESOURCE_TYPE, LIMIT

from dba_profiles

where profile='AD_PATCH_MONITOR_PROFILE';

Also check for other profiles related to the APPS user account. 

Examples of queries that can be used to check the APPS user account :

SQL> select profile , resource_name, limit from dba_profiles where resource_name like '%FAIL%';

SQL> select username, profile from dba_users where username='APPS';

SQL> select username, profile from dba_users where username='APPLSYS'; 

Solution

To implement the solution, please execute the following steps:

1.Login as SYS or SYSTEM and run:

SQL> alter profile AD_PATCH_MONITOR_PROFILE limit failed_login_attempts unlimited;

SQL> alter profile default limit failed_login_attempts unlimited password_lock_time 1/1440;

SQL> alter user apps account unlock;

Ref:--http://tobeimpact.blogspot.com/2012/06/ora-28000-account-locked-on-apps.html


Forms Compilation failed.
=====================

frmcmp_batch: fatal: /u01/DEV/R12/apps/tech_st/10.1.2/jdk/jre/lib/sparc/libjvm.so: unknown file type

./c: line 1: 26372 Killed                  frmcmp_batch module=$1 userid=$2 module_type=LIBRARY

This happens because libjvm.so gets corrupted. Replace this file from a working environment.

cd  /u01/DEV/R12/apps/tech_st/10.1.2/jdk/jre/lib/sparc/client/

mv libjvm.so libjvm.so-old
once moved copy file from another environment source environment profile and retest issue.

select * from dba_tab_privs where GRANTEE='USERNAME';

To delete log files with extension .log which are older than 30 
days.

cd /log/directory
find . -name '*.log'  -mtime +30 -exec rm -f {} \;

Attach home for non rac
====================
./runInstaller -silent -attachHome -invPtrLoc /etc/oracle/oraInst.loc ORACLE_HOME="/u01/12.1.0" ORACLE_HOME_NAME="UAT" "CLUSTER_NODES={}"

SRDC - Collect Physical Standby Database Information (Doc ID 1910064.1)