Monday, 28 March 2016

Oracle Apps 12.2 comes with 12.1.0.2 with startCD 51 and is the suggested for upgrades from 11i or R12.1.3


Its general information that starting with the latest R12.2 installation with startCD 51 comes with 12cR1 -12.1.0.2 which includes the interoperability patches with R12.2.
Future upgrades need to have 11.2.0.4 or higher.

Earlier startCD like 50 used to come with the RDBMS 11.2.0.3 which had to be upgraded to 11.2.0.4 or higher.

Please refer 11.2.0.3 to 11.2.0.4 upgrade steps in my blog.

Thanks

Saturday, 26 March 2016

Setting up YUM local repository using CDROM to install groups like Development tools OEL 6.4

1) Insert OEL 6.4 cdrom
2) Mount it
    #mkdir /mnt/cdrom (only for first time, if its already there its not required)
    #mount -t iso9660 /dev/cdrom /mnt/cdrom
    #ls /mnt/cdrom (To verify the listing )
3) #cd /etc/yum.repos.d/
4) Take the backup of existing file -> public-yum-ol6.repo
    #cp -p public-yum-ol6.repo public-yum-ol6.repo_bkp
    #vi public-yum-ol6.repo   (and change below)
    Go to the last part under and changes as below.
------------------------
  [ol6_UEK_latest]
  name=Unbreakable Enterprise Kernel for Oracle Linux 6
  baseurl=file:///mnt/cdrom
  gpgkey=file:///mnt/cdrom//RPM-GPG-KEY
  gpgcheck=1
  enabled=1
-------------------------
     Search for string enabled and all other entries should be 0 (enabled=0)
5) #yum repolist ( To verify whether its working fine)
6) Verify the installed groups
    #yum grouplist | more
And check which one you wanted to install, it will show Installed and Available Groups and also Available Language Groups.
7) Install the lets say Development tools (Here its case sensitive and should match exactly as you will get the output from #yum grouplist | more)
 #yum groupinstall 'Development tools'


Monday, 8 February 2016

Compiling apps invalids from sql prompt or Toad

Select number of Invalids

select * from dba_objects where status='INVALID' and owner='APPS'

From sqlplus as apps/apps user
------------
SQL> execute sys.utl_recomp.recomp_serial('APPS');

PL/SQL procedure successfully completed.
------------

From Toad
----------
begin
sys.utl_recomp.recomp_serial('APPS');
end;

----------
Verify Invalids after compilation.

select * from dba_objects where status='INVALID' and owner='APPS'

Thats It..........

SQL Shared Area - BIND MISMATCH