Thursday, August 18, 2011

How to merge patches in ORACLE APPS R12/11i

Step 1. Create two directory "source" and "dest"

cd home
mkdir source
mkdir dest

Step 2. Unzip patch into source directory.

cd home
$ ls -ltr pABC.zip
-rw-r--r-- 1 egaprt appseeg 0 Aug 18 06:06 pABC.zip
unzip pABC.zip -d source

Step 3: Now, Merge the patch

admrgpch -s source -d dest -merge_name ABC_merge

Step 4: Check the admrgpch.log logfile for any error

Friday, December 10, 2010

ORA-00600: internal error code, arguments: [kzdlk_zt2 err]

I got this while accessing table using db link. Please refer below for more information.

Reason :

I created db link using ‘IDENTIFIED BY VALUES’ instead of PASSWORD (as show in example below ). As per note 456320.1, on Oracle 10.2, dblink passwords are now stored in a special encrypted form to improve database link security. The "IDENTIFIED BY VALUES" clause is only intended for use by Oracle internal utilities.

CREATE DATABASE LINK ABC CONNECT TO EMP IDENTIFIED BY VALUES 'CF979929292' USING 'XYZ';

SQL> select name from v$database@ABC;
select name from v$database@ABC;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err],
[18446744073709551603], [], [], [], [], [], []

What I did :

I created the db links with special encrypted password and it worked for me as one db links was already there on EMP user.

SQL> select PASSWORDX from sys.link$ where USERID='EMP'; -- This will only be available, if there is some existing db link

PASSWORDX
--------------------------------------------------------------------------------
05B661WWWWR121DSDSECCCCCQW1210133B6FFCC

CREATE DATABASE LINK ABC CONNECT TO EMP IDENTIFIED BY VALUES '05B661WWWWR121DSDSECCCCCQW1210133B6FFCC' USING 'XYZ';

select count(*) from GTC_CLAIM_TYPE_DIM@GEND_ECP_USER;
COUNT(*)
----------
242

Compile INVALIDS of any SCHEMA

Earlier to this, I used the following commands to compile INVALID objects of any database

1. @?/rdbms/admin/utlrp
2. exec utl_recomp.recomp_parallel(threads=>5)
3. alter package/ procedure compile ... comand

I found one more utility that will help us to compile the invalids of any particular schema

exec dbms_utility.compile_schema('', FAlSE);

Ex;

exec dbms_utility.compile_schema('SCOTT', FAlSE);

We used “FALSE” as we have to compile invalids only not the whole schema.

Thursday, March 4, 2010

Plan stabilization using stored outlines

Hi ,

I got a chance to use the outlines . For more details please refer to the link mentioned below ..

http://www.scribd.com/doc/27666013/Plan-Stabalization-Using-Outline