Feb 24, 2011
Cloning Issues
725

Cloning Issues

Oracle Applications Cloning Issues: 1.  While running adpreclone on EBS , APPS user locked continiously. Soultion – Follow metalink Note Id – ID 420001.1 2.  PDF output problem in Instance. No PDF output produced after cloning . Solution – Follow metalink Note Id ID 981163.1 3.  Got this in alert.log...
Feb 24, 2011
Reducing Patching Downtimes for Apps
337

Reducing Patching Downtimes for Apps

How to reduce patching downtime in oracle apps?? One of the most commonly-cited reasons for not patching E-Business Suite environments is that it takes too much downtime.  If you’re relatively new to Apps system administration, here’s a primer on the key techniques compiled by our Applications Release Engineering group for...
Feb 24, 2011
Minimize downtime during upgrade
374

Minimize downtime during upgrade

// // How to minimize downtime for Oracle Apps Upgrade Information in this applies to any platform.  1.  Migration in NOARCHIVELOG mode, which will reduce the upgrade time and hence downtime. 2.  As the main function of the migration is to create a new data dictionary, the upgrade can be tested for most...
Feb 24, 2011
Scripts
540

Scripts

// // SQL script to know what and all changes patch has done in Instance col patch_name format a8 heading “Patch|Name” col instance_name format a10 heading “Instance|Name” col name format a10 heading “Node Name” col APPL_TOP format a10 col subdir format a20 col filename format a18 col latest format a20...
Feb 24, 2011
Oracle Database 11g New Features
273

Oracle Database 11g New Features

Oracle 11g New Features: Oracle 10g and 11g differences. ■Adaptive Cursor Sharing. ■ADDM Enhancements (for RAC). ■Automated Maintenance Tasks. ■Automatic Memory Management. ■Automatic SQL Tuning . ■Automatic Storage Manager (ASM) Enhancements. ■AWR Baseline Enhancements . ■Case Sensitive Passwords . ■Data Recovery Advisor . ■Database Resident Connection Pool . ■Database Replay...
Feb 24, 2011
Unable to get Apps Responsibilities on portal Page
348

Unable to get Apps Responsibilities on portal Page

Unable to get Apps Responsibilities on portal Page Error in application.log 06/04/14 11:22:13 portal: id=107356852400,1 ContentFetcher Unexpected Exception Request Failed:oracle.webdb.dispatcher.DispatcherException: I/O Error dispatching request name=content-fetcher61 label=webPortlet url=http://serverA:8888/jpdk/providers/sample time=65006ms time…out=65000ms process=Dispatching Solution: 1. Check you have hosts entries in the portal server for the erp servers 2. Check with network admin...
Feb 19, 2011
Invalid Objects Query
355

Invalid Objects Query

// // SQL> select count(*) from dba_objects where status=’INVALID’; COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status FROM dba_objects WHERE status = ‘INVALID’ ORDER BY owner, object_type, object_name; // //
Feb 19, 2011
Tablespace space check script
769

Tablespace space check script

// // You can query this for how much free, used, total, and percentage filled space is available for each tablespace select tablespace_name, ROUND(bytes_free,2) free,ROUND(bytes_total-bytes_free,2) used, ROUND(bytes_total,2) total,perused from (select a.tablespace_name, a.bytes_free,b.bytes_total, ROUND((100-(100*a.bytes_free/b.bytes_total)),2)  perused from (Select tablespace_name,sum(bytes)/1024/1024 bytes_free From dba_free_space Group by tablespace_name) a, (Select tablespace_name,sum(bytes)/1024/1024 bytes_total From dba_data_files Group...
Feb 19, 2011
How to check shared pool and SGA size
309

How to check shared pool and SGA size

How to check shared pool and SGA size Execute this as sysdba Show parameter sga Show parameter shared // //
Feb 19, 2011
How to check for DB links
317

How to check for DB links

How to check Database links in Oracle Database // _