Sandeep Panchal Blog

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...

Network bandwidth Amount of traffic that the network can actually transport Network latency time taken between and through network devices LAN Local Area Networking Ethernet Topologies Bus topology Basic star topology LAN Token Ring Token Ring Topology FDDI (Fibre Distributed Data Interface) Switches Used to link several separate LANs.Switch packets between multiple LANs as needed Internetworking devices Hubs (concentrators) Bridges Routers Switches WAN Wide Area Network Wide Area Network Topologies Frame relay Integrated Services Digital Network  (ISDN) Leased line Asynchronous Transfer Mode (ATM) Measuring Latency Use ping  to find the PMTU between systems PMTU Path Maximum Transmission Unit ping ping -f -n <number of pings> -l <size> <destination IP address> Helps verify IP-level connectivity Used to send an ICMP echo to a target name or IP address ping -? shows command-line options available Netstat Displays protocol statistics Ab...

I have compiled a list of commonly use (Obviously -not all) 3rd party softwares with Oracle applications. These products extend the capabilities of Oracle applications. as an Oracle Apps DBA you may need to work with these software vendors and Sometime you may also need to configure these softwares with Oracle applications. Fortunately i have worked on all of these in the past. 1. AventX The AventX Oracle Connector (hereafter referred to as AventX Connector) provides the capability to deliver reports via fax, email or printer. AventX Connector processes documents from Oracle E-business suite (hereafter referred to as Oracle Applications or OA) and submits them to the document delivery system for delivery AventX Connector uses a set of tables in the Oracle database to store site-specific configuration options and document delivery information. In addition, AventX Connector requires the compilation, installation, and registration of customized forms and library files. http://www....

Atleast my name reached to the Moon.

UNIX Commands Description : UNIX for DBAs Basic and Advance commands example Example : *** Few of the command here are really dangerous , Please be very careful to run these commands**** UNIX Command for Expert users *** tar Create tape archives and add or extract files Note: There is no "untar" linux / unix command. Backup Oracle applications file system In this example , I am using tar command to create the zipped archive of Oracle applications file system (Including appltop,common top, ias oracle home, 806 oracle home So many ways to use it. This is how you can create tape archives , (tar + gzip saves lot of space) tar -cvf - 8.0.6 |gzip -c > 8.0.6.tar.gz tar -cvf - appl |gzip -c > appl.tar.gz tar -cvf - comn |gzip -c > comn.tar.gz tar -cvf - iAS |gzip -c > iAS.tar.gz This is how you can restore the files to normal files from archives . nohup gunzip -c 806.tar.gz |tar -xvf - >806.out & nohup gunzip -c comn.tar.gz |tar -xvf - >com...

*** This is unsupported scenraio**********Please use it at your own risk****May work only if INDEX datafile is missing while clone. If you clone from a hot/cold backup and by mistake you miss a datafile and you have already done 'alter database open resetlogs' , Then in order to bring the missing datafile you need to copy all data files again. What you can do it you can list the objects in the datafile and then recreate the objects. ** This is UNsupported scneraion*** but a possible scenario**** Suppose datafile is missing from WIPX tablespace. check for the missing datafile. SQL> select file_name from dba_data_files where tablespace_name='WIPX'; FILE_NAME -------------------------------------------------------------------------------- /dbdata/data2/wipx05.dbf /dbdata/data2/wipx03.dbf /dbdata/data2/wipx01.dbf /dbdata/data2/wipx04.dbf /dbdata/data1/wipx07.dbf /dbdata/data1/wipx02.dbf /oracle/10.2.0/dbs/MISSING00894 7 rows selected. **Find out ...