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

• 10.2.0.4 (Server Patch Set)  

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;

   

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';