Oracle DBA:RMAN basetables

Last updated on August 31st, 2016 at 05:12 pmRMAN is a powerful tool for taking backup .It maintains all the backup related informations oin Rman basetables in Rman catalog.We are listing all  tables and views are which  are vgenerated in the catalog database. Use the DESCRIBE command for each table or view to display column information.We have given some explanation for each table so that … Continue reading Oracle DBA:RMAN basetables »

NID Utility

Last updated on November 23rd, 2015 at 01:55 pmThe NID Utility is a new utility introduced with Oracle 9.2. 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 1. Backup Database 2. shutdown immediate 3. startup mount 4. Open one session and run NID with sysdba privileges … Continue reading NID Utility »

Oracle Advanced Queuing

Last updated on November 23rd, 2015 at 01:28 pmOracle Advanced Queuing provides message queuing as an integrated part of the Oracle Server, thereby creating a message-enabled database. Oracle uses the following components to deliver AQ fuctionality: Message A message is the smallest unit of information inserted into and retrieved from a queue. It contains user data (payload) in the form of an object type, and … Continue reading Oracle Advanced Queuing »

Oracle Parallel Query Option

Last updated on September 14th, 2016 at 09:19 pmWhat Parallel Query Option can perform 1.To speed up access to data by using multiple processes 2.To maximise machine resource usage in query processing 3.To reduce elapsed time by increasing resource usage Operations That Can Run with Parallel Query Option 1.Parallel 2. Full table scans  or table move 3.Fast full index scans 4.Create index or rebuild index 5.Create table … Continue reading Oracle Parallel Query Option »

PL/SQL Gateway in R11i

Last updated on November 28th, 2015 at 11:55 amThe PL/SQL Gateway in R11i provides support for building PL/SQL-based applications on the Web. – PL/SQL stored procedures can retrieve data from a database and generate HTTP responses containing data and code to display in a Web browser. – Also can upload/download file to datbase table from browser and access that file from the browser. – also … Continue reading PL/SQL Gateway in R11i »

Top queries to find Patch applied in Oracle apps

Last updated on August 24th, 2016 at 06:46 pmWe often get the task to check patch applied in oracle apps environment. Here are the Top queries to find Patch applied in ERP How to find if the bug number or patch is applied to Apps ERP 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 pi.patch_level, … Continue reading Top queries to find Patch applied in Oracle apps »

How Oracle RAC handles instance failure and recovery

Last updated on August 31st, 2016 at 05:37 pmOracle uses a simple mechanism of a heartbeat to detect instance failure of a node in a RAC cluster. The cluster manager software detects if it cannot receive the heartbeat of the other instances and if it does not the recovery process begins. From what I can find, this heartbeat is provided by the udlm package on … Continue reading How Oracle RAC handles instance failure and recovery »

R12 includes Oracle’s Containers for J2EE ( R12 OC4J)

Last updated on August 31st, 2016 at 08:16 amR12 includes Oracle’s Containers for J2EE (R12 OC4J) -Through R12 OC4J you can execute Servlets, Java Server Pages (JSP), Enterprise Java Beans (EJB) -OC4J replaces the older JServ implementation for running servlets on the web server -Oracle Application Server 10gR3 (10.1.3) is the latest production version -OC4J is based on J2EE standards:Specific directory structure,File requirements (content & naming conventions),XML file … Continue reading R12 includes Oracle’s Containers for J2EE ( R12 OC4J) »

Important Profiles for OA Framework

Last updated on August 31st, 2016 at 05:40 pmI am listing here important Profiles for OA Framework Oracle Applications Look and Feel / APPS_LOOK_AND_FEEL Specifies the look and feel for all OA Framework based pages. This value can be set at any of the Site, Application, Responsibility or User levels. -Valid seeded values include: blaf – Oracle’s corporate Browser Look-and-Feel [ OTN Version of BLAF guidelines … Continue reading Important Profiles for OA Framework »

OA Framework Basics

Last updated on November 14th, 2015 at 02:49 pmOA Framework Basics Key JSP Application Components A typical JSP application involves the following components: a browser for client access, a database for enterprise data and a web application server (“middle tier”) where the application objects live. -The browser communicates with the middle tier using HTTP (Hyper Text Transfer Protocol) which involves sending a request message to … Continue reading OA Framework Basics »

INST_TOP (Oracle R12 INSTANCE_HOME ) decoded

Last updated on September 30th, 2016 at 06:09 pmWith R12 ,Oracle has introduced a new Top call INST_TOP. Features on this R12 INST_TOP -All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top – All configuration files have been moved to INST_TOP like DBc file All the http related config files appsweb.cfg All the start or stop scripts all the OC4J related … Continue reading INST_TOP (Oracle R12 INSTANCE_HOME ) decoded »

How to find R12 components Version

Last updated on July 22nd, 2018 at 05:35 pmWe are often asked How to find R12 components Version. This is includes all R12.0/R12.1 and R12.2.I will try to explain how to find out that with variours R12 version with command and reports. Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Version sh -c “awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print $2}’ $ADMIN_SCRIPTS_HOME/ -version;” Jre … Continue reading How to find R12 components Version »