Sandeep Panchal Blog

Identifying the trace file is not a complex task. But its not very easy also. Oracle helps in identifying the correct tracefile for a session. ALTER SESSION SET tracefile_identifier=SANDEEP; Then you can easily identify the file. Oracle will generate the file name like sid_ora_pid_SANDEEP.trc OR if you have session id, You can query, v$session to check the column tracefile. Hope this helps. Regards Sandeep Panchal.

Covert to Shared appltop. : This was tested on 11.5.10, Please check the Oracle documentations for the latest patches and updates. (Ref: metalink note : Sharing the Application Tier File System in Oracle Applications Release 11i [ID 233428.1] ) 1 Verify the pre-requisites 1.1 Software Requirements: Ensure that these minimum versions are present in your system. • 5035661 to each iAS ORACLE_HOME in the application tier. • TXK AutoConfig Templates RUP O or higher (Apply patch 5478710 to each APPL_TOP in the application tier) • TXK Technology Stack Minipack B (Apply patch 3219567 to each APPL_TOP in the application tier) • AD Mini-pack I or higher (Apply patch 4038964) • iAS Oracle HTTP Server Rollup 5 or higher (Apply the latest critical patch update available for Oracle E-Business Suite 11i. Refer to section "Oracle HTTP Server Patches for Oracle E-Business Suite 11i" for instructions) • Discoverer 4.1.48.08 (See OracleMetaLink Doc ID: 139516.1 OracleMetaLink Doc...

I was just exploring the 11g software CD and found very interesting script. sshUserSetup.sh , While RAC installation to create the user equivalence this script will be very useful. running keygen and scp is a boring task. This script makes your life easy. cd -mount-/oracle/sshsetup sshUserSetup.sh -hosts "host1 host2" -user oracle -advanced ========================================================================== Script Location [root@rac1 database]# ls -ltr total 36 -rwxr-xr-x 1 root root 3226 Aug 15 2009 runInstaller drwxr-xr-x 2 root root 4096 Aug 15 2009 rpm drwxr-xr-x 4 root root 4096 Aug 15 2009 install drwxr-xr-x 14 root root 4096 Aug 15 2009 stage drwxrwxr-x 2 root root 4096 Aug 15 2009 sshsetup drwxrwxr-x 2 root root 4096 Aug 15 2009 response drwxr-xr-x 12 root root 4096 Aug 17 2009 doc -rw-r--r-- 1 root root 5402 Aug 17 2009 welcome.html [root@rac1 database]# pwd /data3/database [root@rac1 database]# cd sshsetup [root@rac1 sshsetup]# ls ssh...

My suggestion: To start with , Read more and more about Oracle application architecture and Oracle applications Utilities. 1. How to learn Oracle applications Architecture :   Oracle Applications Architecture diagram.   Image from Oracle Applications Concepts Release 12  Part No. B31450-04 This is the very basic explanation of Oracle applications Architecture.   It explains Multi Tiered computing supports Oracle applications Product. 1. Desktop Tier :    The client interface is provided through HTML for HTML-based applications, and via a  Java applet in a Web browser for the traditional Forms-based applications. 2. Application Tier :     In General this is the actual host for Oracle Applications . Three servers or service groups comprise the basic application tier for Oracle Applications: Web services : The Web services component of Oracle Application Server processes requests received  over the network ...

After Reading my first post on “How to Become Oracle Apps DBA” http://oracleinout.blogspot.com/2010/05/how-to-become-oracle-apps-dba-part1.html . Now its time to understand Roles and Responsibilities of Oracle APPS DBAs. I am trying to summarize the Roles and Responsibilities of Oracle Apps DBA.  Once you understand R&R of Oracle Apps DBA then you can follow the correct learning path. Understanding Oracle Application Architecture. You must be familiar with Oracle Applications file system, Login URLs, Single node multi node etc. Start and Stop (In Real world its called bouncing Oracle applications services: May differ)  -Please check my post on this How to start and shutdown oracle applications Check if the Oracle applications are working fine (Checking services,Database,Listeners)  Frequent Application of Security patches, RDBMS Patches, Functional Patches.  Applying latest releases of the application patches(with/without hot patch option) from Oracle to ...

What are Oracle AD (AD is an abbreviation for Applications DBA) utilities. Quick Refrence adadmin           Performs maintenance tasks for Oracle Applications. adchkdig          Checks the integrity of Oracle Applications patches downloaded from OracleMetaLink. adutconf.sql     Reports standard information about the installed configuration of Oracle Applications. adctrl               Manages parallel workers in AD Administration and AutoPatch. adident           Reports the version and translation level of an Oracle Applications file. adncnv           Converts a file from one character set to another. admrgpch       Merges multiple patches into a single merged patch. adrelink.sh  ...

Checklist Description Step1 : In Real world, Oracle DBA with Expert Level are the qualified members to be Oracle apps dba.  Good Level of Core DBA knowledge required. Step2: As soon as possible , Try to see the Oracle applications front end screen. This may boost you to learn ASAP. Try some navigation (Like Users,Responsibilities) Step3: Get the software from http://edelivery.oracle.com/ You may need at least 30-35GB space to create the stage area (Oracle application Software) , I think the largest software in the world with largest size of installation files. Depending on the speed of internet it may take between 1-10 days to download the software (Yes !!!!) and you need approx 100 GB to Install Software.  Small configuration laptops/Desktops cannot handle Oracle applications. Step4: Install Oracle Applications Follow Step by Step http://download.oracle.com/docs/cd/B40089_09/current/acrobat/120oaig.pdf You can refer the earlier post on Oracle apps R12 install. h...