oracle jinitiator 1.1.8.2,EBS 常用 sql

登录sql：

[root@ebslouis ~]# su - oracle

[oracle@ebslouis ~]$

[oracle@ebs 4318672]$ source /home/oracle/.ora

[oracle@ebslouis ~]$ sqlplus /nolog

SQL> conn /as sysdba

Connected.

SQL> conn apps/apps

Connected.

SQL>

1. 查看patch是否打上

SQL> select * from ad_bugs where bug_number='4318672';

2. 查看EBS版本

select product_group_name, product_group_type, release_name from fnd_product_groups;

3. 查看用jre模式的基础patch是否安装

select bug_number, decode(bug_number,

'3438354', '11i.ATG_PF.H',

'4017300', '11i.ATG_PF.H.RUP1',

'4125550', '11i.ATG_PF.H.RUP2',

'4334965', '11i.ATG_PF.H RUP3',

'4676589', '11i.ATG_PF.H RUP4',

'5382500', '11i.ATG_PF.H RUP5 HELP',

'5473858', '11i.ATG_PF.H.5',

'5674941', '11i.ATG_PF.H RUP5 SSO Integrat',

'5903765', '11i.ATG_PF.H RUP6',

'6117031', '11i.ATG_PF.H RUP6 SSO 10g Integration',

'6330890', '11i.ATG_PF.H RUP6 HELP',

'6241631', '11i.ATG_PF.H.RUP7',

'8248307', '11i.ATG_PF.H RUP7 HELP'

) n_patch, last_update_date

FROM ad_bugs

WHERE bug_number

IN ( '3438354', '4017300', '4125550', '4334965', '4676589', '5382500', '5473858', '5674941', '5903765', '6117031', '6330890', '6241631', '8248307' );

4. 查询 form compiler 版本

[root@ebslouis oracle]# su - oracle

[oracle@ebslouis bin]$ source /home/oracle/.app

[oracle@ebslouis bin]$ cd /d01/oracle/visdb/9.2.0/bin

[oracle@ebslouis bin]$ f60run

Forms 6.0 (Forms Runtime) Version 6.0.8.24.1 (Production)

Forms 6.0 (Forms Runtime): Release  - Production

5. 查询 Developer 6i Patch 版本

Forms: 6.0.8.28.x --> Developer 6i Patch 19

Forms: 6.0.8.27.x --> Developer 6i Patch 18

Forms: 6.0.8.26.x --> Developer 6i Patch 17

Forms: 6.0.8.25.x --> Developer 6i Patch 16

Forms: 6.0.8.24.x --> Developer 6i Patch 15

6. 查看EBS安装的所有patch

select bug_number patch_id from ad_bugs;

7. 查看EBS安装完系统后打的patch

SELECT distinct ap.patch_name,decode(ab.application_short_name, null, mini.app_short_name,ab.application_short_name) application_short_name,ap.patch_type patch_type, mini.patch_level patch_level,ap.last_update_date Applied FROM applsys.ad_bugs ab, applsys.ad_applied_patches ap,applsys.ad_patch_drivers pd, applsys.ad_patch_driver_minipks mini WHERE ab.bug_number = ap.patch_name and ap.applied_patch_id = pd.applied_patch_id and pd.patch_driver_id = mini.patch_driver_id(+) ORDER BY ap.last_update_date desc；

8. 查看oracle版本号

SQL> select * from v$version;