JDBC connection scripts for Oracle Applications R12

Last updated on May 31st, 2019 at 03:44 amThis article is part of EBS tutorials and provides different JDBC connection scripts for Oracle Applications R12 Oracle  OC4J connect to Oracle database using JDBC connection. Here is the list of some good scripts on JDBC connection The OC4J JVM process id can be found using the below opmnctl command opmnctl status -l A) To find total … Continue reading JDBC connection scripts for Oracle Applications R12 »

How to find the High Water mark of the Oracle Table

Last updated on May 29th, 2019 at 05:38 pmHigh Water Mark of Oracle table High water mark is a term used in oracle table to show the blocks  which has been ever used in the life cycle of the oracle table. So basically if the oracle table block is flat structure, it is right most block in the structure. This is used by Oracle process … Continue reading How to find the High Water mark of the Oracle Table »

alter system switch logfile v/s archive log current

Last updated on May 29th, 2019 at 05:39 pmRedo and archive log files are two important pieces in Oracle database environment. They both are used for recovering the database from failure.I would be explaining two important command alter system switch logfile and alter system archive log current about them ,their difference and what they command actually performs in the oracle database ALTER SYSTEM SWITCH LOGFILE This … Continue reading alter system switch logfile v/s archive log current »

How to change the DBNAME /DBID using DBNEWID(nid) utility for Oracle database

Last updated on May 28th, 2019 at 03:43 amThe DBNEWID(NID) Utility is a new utility introduced with Oracle database. The NID utility allows you to change only the DBNAME, or only the DBID or both DBNAME and DBID in the same command. Change Only the DBID Backup Database rman target / backup database; exit shutdown immediate sqlplus / as sysdba SQL> shutdown immediate; Database closed. … Continue reading How to change the DBNAME /DBID using DBNEWID(nid) utility for Oracle database »

RMAN Backup commands

Last updated on May 28th, 2019 at 03:37 amWe 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 LEVEL [=] … Continue reading RMAN Backup commands »

RMAN List backup commands

Last updated on May 28th, 2019 at 03:42 amRMAN List backup is a useful command to list the backup taken in the system.It shows all the details about the backup taken,what time it was taken, location of the backup. LIST BACKUP List all the backup taken in the system RMAN> LIST BACKUP; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed … Continue reading RMAN List backup commands »

Top queries to find Patch applied in Oracle apps

Last updated on May 28th, 2019 at 03:45 amWe often get the task to check patch applied in 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 particular application select … Continue reading Top queries to find Patch applied in Oracle apps »

Top Ten secret about Oracle Concurrent Manager and Types

Last updated on May 28th, 2019 at 03:44 amOracle 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 Manager Internal … Continue reading Top Ten secret about Oracle Concurrent Manager and Types »

Analytic functions in oracle

Last updated on May 19th, 2019 at 06:01 pmThis post is part of SQL tutorial and we would be discussing Analytic functions in oracle with examples, detailed explanation . We have already studied about Aggregate function like avg ,sum ,count. Lets take an example select count(*) from EMP; select sum (bytes) from dba_segments where tablespace_name=’TOOLS’; select deptno ,count(*) from emp group by deptno; SQL> desc … Continue reading Analytic functions in oracle »

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

Last updated on May 19th, 2019 at 06:03 pmIn 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 instance, cloud … Continue reading How to login to Linux with SSH private key from window client »

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

Last updated on May 19th, 2019 at 06:05 pmWe can generate ssh key pair on Unix using ssh-keygen utility. This comes under openssh in all Unix flavour 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. Enter file in … Continue reading How to generate ssh key pair on Unix using ssh-keygen »