Search This Blog

Friday, December 24, 2010

Issue: “Active Users” concurrent request is completed with error

Issue: “Active Users” concurrent request is completed with error
Error: ar60run: relocation error: /d03/ivdev1/oracle/ivdev1ora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Fix: add the following entry in adovars.env
LD_PRELOAD=/lib/libcwait.so
export LD_PRELOAD
Bounce Concurrent manager

Ref Notes:
Note: 404500.1 - Running Concurren Request Causes ar60run: relocation error libjava.so: symbol__libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Note: 389698.1 - Concurrent Requests Getting Error: ar60run: Relocation Error
Note: 284535.1 - ar60runb Relocation Error 'Version Glibc_2.0 Not Defined In File libc.so.6' When Running Concurrent Requests

Thursday, November 18, 2010

Important metalink Doc id's

My Oracle Support Useful document ID's:    










SNO Document ID Description


1282434.1 EBS Concurrent Manager Performance - Best Practices - US


1285571.1



1186338.1 Advisor Webcast scheduled for the Applications Technology Group (ATG) of the E-Business Suite, 


740964.1 Advisor Webcast Archived Recordings


380489.1 Oracle Support white paper Using
Load-Balancers with Oracle E-Business Suite Release 12.



213021.1 Concurrent Processing (CP) / APPS Reporting Scripts


980924.1 Using WGET to download My Oracle Support Patches


287176.1 DMZ Configuration with Oracle E-Business Suite 11i


390374.1 Oracle Performance Diagnostic Guide (OPDG)


419728.1 How To Gather Statistics On Oracle Applications 11.5.10(and above) - Concurrent Process,Temp Tables, Manually


863800.1 How to Change the DBID, DBNAME Using NID Utility


976188.1 Patch Wizard Utility


199081.1  Overview Reference for SQL_TRACE, TKProf and Explain Plan


1118846.1  Determining Which Tape(s) RMAN Will Use For A Restore Or Tapes For Specific Backups


1053147.1 11gR2 Clusterware and Grid Home - What You Need to Know


404954.1 How To: How to run OATM migration utility 


747806.1 How To Identify Which Scheduled Workbooks And User Are Associated With Which Database View / Result  


761836.1  Easy Steps to Install/ Upgrade/ Migrate/ Uninstall APEX - Example 3.1.2


744143.1 Tuning performance on eBusiness suite


419475.1 Removing Credentials from a Cloned EBS Production Database 


171855.1 CCM.sql Diagnostic Script for Concurrent Manager


743716.1 How to Setup and Test Failover of PCP on Non-RAC Environments


213021.1 Concurrent Processing (CP) / APPS Reporting Scripts


295206.1 How to Count Total Number of Users Connected to ORACLE Application 


262557.1 10g: DataPump Export and Import Job and Attached Client Sessions 


557259.1 Oracle E-Business Suite 11i and 12 PC Client Performance 


216212.1 Disaster Recovery and the E-Business Suite 


465259.1 EBS and APS Decentralized Apps Instances Overview and Diagram 


342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)


131704.1 Database Scripts Library Index 


185489.1 Setting Up Parallel Concurrent Processing On Unix Server 


169935.1 Troubleshooting Oracle Apps Performance Issues 


104541.1 Troubleshooting (Concurrent Manager Generic) 


175485.1 How to Apply an 11i Patch When adpatch is Already Running 


183643.1 Workflow Scripts 


122812.1 TROUBLESHOOTING: Tuning Queries That Cannot be Modified


468760.1 How to Save the DDL Scripts of the Various Database Objects Like PROCEDURE and FUNCTION in to a OS File?


151475.1 Unix Shell Script to Check if Database Connection is Alive


1036553.6 HOW TO DETERMINE WHICH SCRIPT CREATES AN INVALID DATABASE OBJECT


1089693.1 How to Troubleshoot Communication From the Oracle Management Service (OMS) to the Grid Control Repository Database in 10g Enterprise Manager Grid Control?

121632.1 Database Report - Space Usage


837570.1
Complete Checklist for Manual Upgrades to 11gR2



132793.1 Script to Extract SQL Statements for all V$ Views


241512.1 Script to Collect Data Guard Logical Standby Diagnostic Information


1020180.6 Script to Generate CREATE TABLESPACE


557070.1 ORA-24247 Trying To Send Email Using UTL_SMTP from 11gR1 (11.1.0.6) or higher [ID 557070.1] APEX send mail

1092593.1 Master Note for Oracle Application Express (APEX) Printing Issues [ID 1092593.1] Apex Master

745695.1 PDF Printing with APEX in 11g DB Results in Format Error or ORA-20001 [ID 745695.1]


744866.1 Printing Large PDF Reports Results in Various Errors [ID 744866.1]


454701.1
How To Debug APEX and PDF Printing Integration (BI Publisher) Issues [ID 454701.1]



562807.1 Configuring an APEX Application to Use SSO With SDK in Separate Schema [ID 562807.1]


1094413.1 Master Note for Oracle Application Express (APEX) Authentication [ID 1094413.1]


565396.1
How to Access Apex Application Without Defining Any User and Without Prompting for Login Credentials [ID 565396.1]



1233515.1
Troubleshooting & Verifying APEX SSO Configuration Setup Steps [ID 1233515.1]



422073.1
Host Credentials: How to Configure the Grid Control Agent for PAM and LDAP? [ID 422073.1]



360416.1 Oracle10g / 11g - Getting Started with Recovery Manager (RMAN) [ID 360416.1]


386990.1 DB CONVERSION: 32 bit -->64 Bit Broke OLAP OPTION [ID 386990.1]


352306.1



859100.1 Troubleshooting Guide for Tablespace Issues [ID 859100.1]


132254.1
Note.132254.1 Speeding up and Purging Workflow 2.5 and 2.6
Workflow

332351.1 Note: 332351.1 - How To Remove or To Reinstall the OLAP Option To 10g and 11g OLAP

278111.1 NOTE:278111.1 - How To Remove the Oracle OLAP API Objects From 9i and 10g Databases


296187.1 NOTE:296187.1 - How To Manually Install Oracle OLAP into a 9i, 10g or 11g database After the DB Has Been Created


727889.1 NOTE:727889.1 - How to Add the Olap Option in a Database Instance


352306.1 NOTE:352306.1 - Upgrading OLAP from 32 to 64 bits (Doc ID )


837570.1 Note: 837570.1 - Complete Checklist for Manual Upgrades to 11gR2


215187.1 SQLT (SQLTXPLAIN) - Tool that helps to diagnose SQL statements performing poorly [ID 215187.1]







209214.1 How To Restore From An Old Backupset Using RMAN? [ID 209214.1]


338607.1 How To Check (Validate) If RMAN Backup(s) Are Good [ID 338607.1]


341337.1 RMAN-00600 [13200] Backing Up Archivelog Files with Skip Inaccessible. [ID 341337.1]


15476.1 FAQ about Detecting and Resolving Locking Conflicts [ID 15476.1]







305796.1
RMAN and Flash Recovery Area [ID 305796.1]



315098.1 How is the space pressure managed in the Flash Recovery Area - An Example. [ID 315098.1]


829755.1 Space issue in Flash Recovery Area( FRA ) [ID 829755.1]


278308.1 How to Resolve ORA-00257: Archiver is Stuck Error in 10g? [ID 278308.1]







153371.1 Init.ora Parameter "PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT" Reference Note [ID 153371.1]


153370.1 Init.ora Parameter "PLSQL_NATIVE_LIBRARY_DIR" Reference Note [ID 153370.1]


111316.1 How to 'DROP' a Datafile from a Tablespace [ID 111316.1]


167492.1



459353.1 Known issues on Top of 11i.ATG_PF.H. delta.6 (RUP6) - 5903765 [ID 459353.1] Responsibility missing

429852.1 Reactivated User Does Not See Responsibilities [ID 429852.1]


727638.1 Unable to See Responsibilities after End Date Is Removed on ATG RUP6 [ID 727638.1]


822527.1  (How To Find Where The Memory Is Growing For A Process)







557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite [ID 557194.1]


837570.1 Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]


558408.1 Restoring a database to a higher patchset [ID 558408.1]




790559.1 RMAN Restore of Backups as Part of a Database Upgrade [ID 790559.1]




434991.1 EBS-Demantra Integration Installation Overview and Diagram [ID 434991.1]


258021.1 How to monitor the progress of a materialized view refresh (MVIEW) [ID 258021.1]


578248.1 HOW TO DOWNLOAD WORKFLOW FILE .wft [ID 578248.1]


967232.1 Java.Lang.StringIndexOutOfBoundsException Error when Opening the Advanced Worklist [ID 967232.1]


1280607.1 10.2.0.5 Patch Set - Linux x86 (32bit) README [ID 1280607.1]


1280606.1 10.2.0.5 Patch Set - Linux x86-64 README [ID 1280606.1]


179661.1 E-Business Suite Diagnostics 11i Test Catalog [ID 179661.1]


275876.1 Oracle Application Framework Profile Options Release 11i (11.5.10) (Doc ID 275876.1)


1309300.1 11.1.0.1 GC install fails at Add-On OMS Side Configuration Step (Doc ID 1309300.1)


823586.1 Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 11i [ID 823586.1]



417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator) [ID 417692.1]


1280606.1 10.2.0.5 Patch Set - Linux x86-64 README [ID 1280606.1]


370841.1 Find Two Bills of Material (BOM) for the Same Item (BOMFDBOM) leading to ORA-01427 or SQL-02112 error [ID 370841.1]


153960.1 FAQ: X Server Testing and Troubleshooting [ID 153960.1]


12535.1 Troubleshooting Guide for TNS-12535 / ORA-12535 / ORA-12170 Errors [ID 12535.1]


1178133.1 Extended Support Patch Level Verification in Oracle E-Business Suite Release 11.5.10 [ID 1178133.1]



1224763.1 Patch Wizard : The Set Completed Normally With Outcome Error [ID 1224763.1]


469822.1 Oracle Workflow Release 12 Diagnostics [ID 469822.1]


376694.1 Using the Oracle Wallet Manager Command Line Interface in Release 12 [ID 376694.1]


339718.1 Java Notification Mailer Fails to Send Email Notifications with Framework Regions [ID 339718.1]


1267768.1 New Required Patches for Patch Wizard, Patch Manager, and Oracle Application Change Management Pack for Oracle E-Business Suite Releases 11i, 12.0, and 12.1 [ID 1267768.1]

472752.1 How to Unlock/Reset Super User cn=orcladmin When the ODS's Password Has Been Forgotten or is Unknown? [ID 472752.1]


434049.1 Db Hangs Because Archive Logs Get Not Deleted Although Enough Reclaimable Space [ID 434049.1]


264951.1
Standard Concurrent Requests Fail After Fresh Install or Clone on Linux [ID 264951.1]



338291.1 Howto Enable WMS / MSCA Logging? [ID 338291.1]


782162.1 MWA Troubleshooting Tips for Release 12 [ID 782162.1]


338071.1 I would like you to review How To Configure Discoverer 10g (10.1.2) Plus/Viewer For HTTPS / SSL Access (Doc ID 338071.1)



338071.1 How To Configure Discoverer 10g (10.1.2) Plus/Viewer For HTTPS / SSL Access (Doc ID 338071.1)


429852.1 Troubleshooting Missing Responsibilities For A User [ID 429852.1]


751438.1 How To Check List, Start And End Dates Of A Parent Concurrent Request And All Child Processes [ID 751438.1]







1304305.1 Concurrent Processing - Product Information Center (PIC) [ID 1304305.1]

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3]

Symptoms matched description of Bug:4430244  described on Note 4430244.8
Segment advisor code can load blocks into the cache for dropped objects.
This can lead to internal buffer cache like ORA-600 [kcbz_check_objd_typ_3].

Known workarounds for this behaviour were used without success:
1. Disable automatic segment advisor
exec sys.dbms_scheduler.disable( '"SYS"."AUTO_SPACE_ADVISOR_JOB"' );
2.Use "alter system flush buffer cache" to clear bad blocks from the cache


This issue is fixed in

Segment Advisor
The segment advisor performs analysis on the fragmentation of specified tablespaces, segments or objects and makes recommendations on how space can be reclaimed. The advisor is accessible from Enterprise Manager (Home > Advisor Central > Segment Advisor) or from PL/SQL by using the  
    • DBMS_ADVISOR package:
    DECLARE
      l_object_id  NUMBER;
    BEGIN
      -- Create a segment advisor task for the SCOTT.EMP table.
      DBMS_ADVISOR.create_task (
        advisor_name      => 'Segment Advisor',
        task_name         => 'EMP_SEGMENT_ADVISOR',
        task_desc         => 'Segment Advisor For EMP');
    
      DBMS_ADVISOR.create_object (
        task_name   => 'EMP_SEGMENT_ADVISOR',
        object_type => 'TABLE',
        attr1       => 'SCOTT', 
        attr2       => 'EMP', 
        attr3       => NULL, 
        attr4       => 'null',
        attr5       => NULL,
        object_id   => l_object_id);
    
      DBMS_ADVISOR.set_task_parameter (
        task_name => 'EMP_SEGMENT_ADVISOR',
        parameter => 'RECOMMEND_ALL',
        value     => 'TRUE');
    
      DBMS_ADVISOR.execute_task(task_name => 'EMP_SEGMENT_ADVISOR');
    
      -- Create a segment advisor task for the USERS tablespace.
      DBMS_ADVISOR.create_task (
        advisor_name      => 'Segment Advisor',
        task_name         => 'USERS_SEGMENT_ADVISOR',
        task_desc         => 'Segment Advisor For USERS');
    
      DBMS_ADVISOR.create_object (
        task_name   => 'USERS_SEGMENT_ADVISOR',
        object_type => 'TABLESPACE',
        attr1       => 'USERS', 
        attr2       => NULL, 
        attr3       => NULL, 
        attr4       => 'null',
        attr5       => NULL,
        object_id   => l_object_id);
    
      DBMS_ADVISOR.set_task_parameter (
        task_name => 'USERS_SEGMENT_ADVISOR',
        parameter => 'RECOMMEND_ALL',
        value     => 'TRUE');
    
      DBMS_ADVISOR.execute_task(task_name => 'USERS_SEGMENT_ADVISOR');
    END;
    / 
    
    -- Display the findings.
    SET LINESIZE 250
    COLUMN task_name FORMAT A20
    COLUMN object_type FORMAT A20
    COLUMN schema FORMAT A20
    COLUMN object_name FORMAT A30
    COLUMN object_name FORMAT A30
    COLUMN message FORMAT A40
    COLUMN more_info FORMAT A40
    
    SELECT f.task_name,
           f.impact,
           o.type AS object_type,
           o.attr1 AS schema,
           o.attr2 AS object_name,
           f.message,
           f.more_info
    FROM   dba_advisor_findings f
           JOIN dba_advisor_objects o ON f.object_id = o.object_id AND f.task_name = o.task_name
    WHERE  f.task_name IN ('EMP_SEGMENT_ADVISOR', 'USERS_SEGMENT_ADVISOR')
    ORDER BY f.task_name, f.impact DESC;
     

Wednesday, November 17, 2010

Is there an option to limit each user to 10GB of TMP alone?


Solution Description:
No quota can be granted on temp tablespaces, though it is applicable on other regular tablespace. The reason we can’t grant quota on temp tablespace for following 2 reasons:

* Temp segments DO NOT consume any quota that a user might possess.
* Temp segments can be created in a tablespace for which a user does not have a quota.

Please refer metalink note 1054952.6 for more information. We need to fix the code that is consuming the whole temp tablespace.

Hi all,
Could you please suggest me on above information.

Basic handy scripts for Apps DBA on reguler support

SQL> select instance_name,status,to_char(startup_time,'dd Mon, yyyy hh24:mi:ss') from gv$instance;

###########Script to get locks information########

column sess format a8 word_wrapped
column id1   format 999999999999
column id2   format 99999999
column req     format 999
column type  format a4
column "Module" format a30 word_Wrapped
SELECT lpad('-->',DECODE(request,0,0,5),' ')||sid sess
       , id1
       , id2
       , lmode
       , ctime
      ,  request req, type --, sanj_sessf(sid) "Module"
FROM V$LOCK
 WHERE id1 IN (SELECT id1 FROM gV$LOCK WHERE lmode = 0)
 ORDER BY id1,request;

###########Blocking sessions######

column blocker format a25
column blockee format a25
column sid_serial format a10

select
 (select username || ' - ' || osuser from v$session where sid=a.sid) blocker,
 a.sid || ', ' ||
 (select serial# from v$session where sid=a.sid) sid_serial,
 ' is blocking ',
 (select username || ' - ' || osuser from v$session where sid=b.sid) blockee,
 b.sid || ', ' ||
 (select serial# from v$session where sid=b.sid) sid_serial
 from v$lock a, v$lock b
 where a.block = 1
   and b.request > 0
   and a.id1 = b.id1
   and a.id2 = b.id2;




###########Scripts to get locks in RAC env ######################
SELECT DECODE(request,0,'Holder: ','Waiter: ') ||
inst_id,sid sess, id1, id2, lmode, request, type,addr
FROM GV$LOCK
WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request > 0)
ORDER BY id1, request;

SQL> select sql_text from v$sqltext where HASH_VALUE = (select SQL_HASH_VALUE from v$session where sid = &n);

SQL> select sid,serial#,status,action,module,LAST_CALL_ET,WAIT_TIME,PROCESS from v$session where sid = &n;

###Steps to verify DR Synch###

select sequence# - 1
from v$log
where status = 'CURRENT';


select sequence#, applied,to_char(first_time, 'mm/dd/yy hh24:mi:ss') first from   v$archived_log order by first_time;


SQL> select * from (select SEQUENCE#,FIRST_TIME,APPLIED from v$archived_log order by SEQUENCE# desc) where rownum <=150;


#####Script for Nodes Information#############

spool fnd_nodes
set pagesize 50
col node_name format a15
col server_id format a9
col server_address format a15
col platform_code format a4
col webhost format a12
col domain format a18
col virtual_ip format a12
set linesize 132
select
  node_id,
  platform_code,
  support_db D,
  support_cp C,
  support_admin A,
  support_forms F,
  support_web W,
  node_name,
  server_id,
  server_address,
  domain,
  webhost,
  virtual_ip
from
  fnd_nodes
order by node_id;

###############Invalids##############
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;

col object_name for a30
col owner for a10
select object_name,owner,object_type,status
from DBA_OBJECTS where status like 'INVALID%'
order by object_name;


select owner, object_name,object_type from dba_objects where status ='INVALID';

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...