Techgoeasy

Top queries to find Patch applied in Oracle apps

We often get the task to check patches applied in the oracle apps environment. Here are the Top queries to find Patch applied in EBS How to find if the bug number or patch is applied to Apps EBS select substr(APPLICATION_SHORT_NAME,1,10) Product,substr(BUG_NUMBER,1,10),Version,last_update_date applied_date from ad_bugs where BUG_NUMBER= to_char(‘&bug_no’); How to find the patch level of …

Top queries to find Patch applied in Oracle apps Read More »

Oracle Concurrent Manager

Oracle, Oracle Ebuisness Suite

Oracle Concurrent Manager is a important piece in Oracle E-Business Suite product. it helps in batch processing of many things. I am here presenting the some details about it It consists of several part. Explaining each of these in details .It gives u a glimpse of How an E-Business Suite Concurrent Manager Process Works Types of Oracle Concurrent …

Oracle Concurrent Manager Read More »

How to login to Linux with SSH private key from window client

Oracle, Oracle cloud

In the previous we learn about how to generate ssh key pair from puttygen. Now we can use that ssh key pair to login to Linux with the putty client First we need to make sure ,the public keys is the copied to the Linux box user $home/.ssh/authorized_keys. If you are doing this for cloud …

How to login to Linux with SSH private key from window client Read More »

How to generate ssh key pair on Unix using ssh-keygen

Oracle, Oracle cloud

We can generate ssh key pair on Unix using ssh-keygen utility. This comes under openssh in all Unix flavour (1) Run the ssh-keygen ssh-keygen -b 2048 -t rsa rsa : it is the algorithm for generating the public -private key pair 2048 : it is bit size ssh-keygen -b 2048 -t rsa Generating public/private rsa key pair. …

How to generate ssh key pair on Unix using ssh-keygen Read More »

Patch history tables in Oracle Apps (11i/R12.1/R12.2)

Oracle, Oracle Ebuisness Suite

Patch history tables in Oracle Apps 11i and R12.1 AD_APPL_TOPS Stores information about all APPL_TOPS utilizing this instance. AD_APPLIED_PATCHES Stores information about all distinct updates applied. AD_BUGS Stores information about all distinct bug fixes applied. AD_DRIVERS Stores information about the drivers that comprise an update. AD_FILE_VERSIONS Stores version information for files. AD_FILES Stores information about …

Patch history tables in Oracle Apps (11i/R12.1/R12.2) Read More »

How to find optimizer and database underscore/hidden parameter in Oracle

Oracle, Oracle Database

This article is part of Oracle database administration tutorials and has query,explanation and examples on how to find the underscore/hidden parameters for Optimizer and in general any oracle database underscore parameters Query to list all the underscore parameter with Description set lines 132 column name format a45 column description format a50 select ksppinm name, ksppdesc …

How to find optimizer and database underscore/hidden parameter in Oracle Read More »