We can use RMAN to backup all the parts of the oracle database. RMAN backup commands can be used backs up Oracle database files, copies of database files, archived logs, or backup sets. Here is the general syntax for RMAN backup command Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options BACKUP INCREMENTAL …
RMAN Backup commands Read More »
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 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 …
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 »
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 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 »
