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.1Post 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
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';
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.
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)
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
============
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.
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.
=====================
once moved copy file from another environment source environment profile and retest issue.
select * from dba_tab_privs where GRANTEE='USERNAME';
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-oldonce 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={}"
====================
./runInstaller -silent -attachHome -invPtrLoc /etc/oracle/oraInst.loc ORACLE_HOME="/u01/12.1.0" ORACLE_HOME_NAME="UAT" "CLUSTER_NODES={}"
