Monday, January 28, 2013

Oracle Applications/Versions/Patch Levels and machine, server or instance Queries



--> What Applications/Versions/Patch Levels are loaded on my machine ?
select  
      substr(a.APPLICATION_NAME,1,60) "Application Name"
   ,  substr(i.PRODUCT_VERSION,1,4)  "Version"
   ,  i.PATCH_LEVEL    "Patch Level"
   ,  i.APPLICATION_ID   "Application ID"
   ,  i.LAST_UPDATE_DATE   "Last Update"
from   APPS.FND_PRODUCT_INSTALLATIONS  i
   ,  APPS.FND_APPLICATION_ALL_VIEW  a
where   i.APPLICATION_ID   = a.APPLICATION_ID
--  not all applications update the next field correctly
--  and i.PATCH_LEVEL   like '11i%'
--  these are the applications that concern me most
--  and i.APPLICATION_ID in   ('0','140','260','101','200','275','201','222','185')
order by a.APPLICATION_NAME
;

--> What patches are loaded on my machine ?
select patch_name,
       patch_type,
       applied_patch_id,
       rapid_installed_flag,
       maint_pack_level
from   ad_applied_patches
where  patch_name like '%'
order by 1
;
          OR

select * from ad_bugs;


--> Question: What machine, server or instance am I using ??
SQL>   Select name from v$database;
SQL>   select instance_name from v$instance;
SQL>   select * from global_name;
SQL>   SELECT VALUE FROM V$PARAMETER WHERE NAME='db_name';
SQL>   select to_number(translate(substr(version,1,9),'1.$','1')) from v$instance;
SQL>   select s.machine from v$session s where s.audsid = userenv('sessionid');
SQL>   select global_name from global_name;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect