Showing posts with label Certification. Show all posts
Showing posts with label Certification. Show all posts

Monday, January 7, 2008



The 11g OCP certification should be available this year. You can register for the production exam 1Z0-050 New Features on Prometrics and pass the exam on Mon Feb 18th or later, the OCA exams 1Z1-051 SQL Fundamentals and 1Z1-052 Admin I are in beta and the OCP exam 1Z1-053 Admin II is planned for early 2008 (well, the OCA exams are planned for late 2007, so do not rely on this timeframe).
Check the official page :
Oracle Education 11g certification

Wednesday, January 2, 2008

What’s Different TOP’s in Application 11i

If you want to learn apps dba or want training in apps dba and going through this documentation you might be confused to see again & again that everybody is talking about & its quite difficult to unserstand any topic without knowing what the hell is different tops like APPL_TOP , COMMON_TOP or what eaxctly is TOP ?
For me TOP is nothing but top level directory & preceded by related software . So TOP is top level directory in file system or oracle 11i software .
If you have done 11i or oracle application Installation by now ( if not please go though my training for apps dba in my previous posts) Oracle Installer Installs Apps 11i in DB Tier & Application Tier : so lets take Application Tier you will see three directories under your base Installation directory, these diretories are APPL, ORA & COMN (Check pic. at left top of this page) so directory APPL is called as APPL_TOP i.e. top appl directory where files & directories related to different Application ( like GL General Ledger, PO Purchase Order..) exists. If You are DBA you can correlate it with your Oracle database software installation (I know after reading this example you will say its weird but believe me thats how understood it initially , ORACLE_HOME can be called as ORA_TOP , network directory you can say TNS_TOP )
Under ( ORA_TOP ) you will see diretcory related to oracle home , there are two oracle HOME’s in Application Tier 8.0.6 for Forms & Reports , iAS for 9iAS acting as web server)
COMN_TOP will contain files & directories which will be used commonly by all components ( Isn’t this simple to understand )
similarly
IAS_TOP is top files/directory under ORA_TOP/iAS I hope it might be clear to you now if not donot worry it will be more clear once you start working as Apps DBA.
I am attaching few screenshot of other mount points ( Courtsey oracle 11i concepts guide , below is location if you want to read .
http://download-uk.oracle.com/
docs/cd/B25516_08/current/
acrobat/11iconcepts.pdf ( Add these three lines before putting in to browser , I have not put it in single line as it breaks my page layout )
So In this guide you will find few more screenshot of different TOP’s , Go through Chapter 2 , Just 13 Pages ( 13 unlucky number for someone but if understand this chapter , it can be very lucky for you in your Apps DBA Career.

So here I conclude my TOP’s Section , Please don’t forget to leave feedback & what you want hear next.

You can find some comanies on right side or top of this page who might be looking for Apps DBA , visit them by clicking & go to Career section to look for Apps DBA opportunity.

1Z0-312 OAS 10g Administrator OCP

Oracle University has recently announced Oracle Certified Professional (1Z0-312) track for 10g Application Server Administrator, you can check details at 10g Application Certification Track . This exam is in Beta phase right now (1Z1-312)

For Oracle Certified Associate (1Z0-311) 10g Application Server Administrator track which is prereq. for OCP click here . My previous post with references to books related to 1Z0-311 can be found at http://becomeappsdba.blogspot.com/2006/12/oracle-certification-oca-1z0-311.html

Exam topic for 1Z0-312, Oracle Certified Professional for 10g Application Server Administrator track are (I will be covering one exam topic per post in my coming posts)

Managing Customized Oracle Application Server Topologies
Cloning and Staging Oracle Application Server
–Distributing Oracle Application Server Infrastructure Components
–Oracle Application Server High Availability Solutions
–Configuring and Managing OracleAS Cluster (Web Cache)
–Configuring and Managing OracleAS Cluster (OC4J)
–Configuring OracleAS Cold Failover Cluster (Middle-Tier)
–Configuring OracleAS Cold Failover Cluster (Infrastructure)
–Administering OracleBI Discoverer in Oracle Application Server
–Administering Oracle Reports in Oracle Application Server
–Administering Forms Applications in Oracle Application Server
–Monitoring Oracle Application Server
–Tuning the Oracle Application Server Middle Tier
–Reconfiguring Middle-Tier Instances
–Installing and Configuring OracleAS Cluster (Identity Management)
–Oracle Application Server Disaster Recovery

1Z0-312 Managing Customized Oracle Application Server Topologies

As promised, I’ll cover one topic per post for Oracle Certified Professional Certification track for Oracle Application Server 10g Administrator. Today’s post cover first topic which is Managing Customized Oracle Application Server Topologies.

New features for customized deployment topology
——————————————————————-
1. Install only IM type and use it with existing MR in different oracle_home or on different machine
2. Install only MR without registering with IM/OID
3. Rack mounted directory server configuration (Multiple IM/OID pointing to same MR)

Role of OPMN in customized topology
—————————————————-
Role of OPMN is extended in OAS 10g
1. It start/stops all components of OAS
2. Scope of OPMN is extended, it can start specified instance or all instance in farm and OAS cluster
3. opmn.xml can be edited as per your need both manually or from iasConsole

Managing ports in customized topology
————————————————-
1. use static ports initialization file to customize port list , staticports.ini during installation (except database listener port)
2. use chgiphost.sh to change hostname or IP address
3. You can change port numbers later depending on your requirement

Various topology for Oracle Application Server
——————————————————————–
Each oracle application server deployment has unique characterstic and vary as per their requirements. Oracle Application server topologies are broadly classified into three categories
1. Development topology
2. Deployment Topology
3. Special topology for HA (High Availability)
4. Enterprise Data center topology

Each of these broad classification has further sub classification based on type of installation, usages…. explained below

1. Development topology used by
—1.1 Java developers (standalone OC4J or J2EE and webcache installation type). This is single computer install with no infrastructure tier install.
You have to install two components
a) J2EE and WebCache
b) Oracle JDeveloper

Key considerations — These two products should be installed in separate oracle_homes. Order of installation of these two products doesn’t matter

—1.2 Portal & wireless developers (Portal and Wireless installation type)
This type of installation needs two components of oracle application server, Infrastructure tier (IM+MR) and Middle Tier.
Key considerations — These two components of OAS, Infra tier and middle tier should be on separate oracle_home and can be on same machine or different machines.Order of install should be first Infrastructure tier and then middle tier. PDK (Portal Development kit) and Wireless SDK (Software development kit) shipped with Portal and wireless type install type is used for development.

—1.3 Forms & reports developers (BI and forms installation type)in this topology, developers use Forms & Report builder to build application and BI & Forms type installation to test their application (forms,report, BI)This will be installed in three oracle_homes (one for infra tier, second for middle tier of type forms & BI and third for Forms & Report developer)Order of installation is First infra tier, then middle tier and then forms & report developer.

—1.4 Integration architect and modelers topology (OAS install with ProcessConnect and infrastructure tier )This type of topology includes J2EE and webcache type installation with Infrastructure tier and third home for OracleAS ProcessConnect. Order of installation is first infra tier , then J2ee and webcache type middle tier installation using infra tier and finally ProcessConnect. This topology type will have two oracle_homes one for Infra tier and second for j2ee & webcache and processConnect (they will share same oracle_home)

2. deployment topology
—2.1 Hosting topology (in model where OAS is hosted environments)
—2.2 department topology (Where each depptt host their application)
—2.3 Data center topology (multiple deptt. share same data center)

3. Development life cycle (Dev to Test to Stage to Production)similarly application moves from developer topology to departmental topology to enterprise data center topology

4. special topology for HA

—4.1 Cold failover cluster (CFC)Here infrastructure is active only on one node at a time and can be activated on another node if existing Infra tier fails, similarly for middle tier.CFC is Supported with Sun Clusters, HP Service Guard and Veritas. Oracle_homes and OAS configuration files are placed on shared file system. It uses virtual hostname and virtual IPs

—4.2 Active failover cluster (AFC)Only difference between AFC and CFC is that in AFC, infrastructure is active at same time in all infra nodes. —3.3 IM replication (This uses database replication or LDAP replication technology )

Thumb rule as per oracle documentation
—————————————————–
1. All development topology to be installed on single machine
2. All deployment topology need at least four machines

1Z0-312 Cloning and Staging Oracle Application Server

This post is in continuation of Oracle 10g Application Server administration (OCP) track 1Z0-312. This post covers second topic of certification track i.e. Cloning and Staging Oracle Application Server .

Cloning process mentioned here are w.r.t. Oracle Application Server 10g and not at all related to Oracle Applications 11i/R12 (Financials/HRMS)

This topic covers following points as per certification track explained under A, B, C…
A) Clone Oracle Application Server installations
=========================================

i) Cloning is process of creating replica of existing installation to differnt location while preserving its configurations.
ii) You can create a clone using command line cloning scripts or OEM 10g Grid control

iii)

You can clone J2EE and Web Cache middle tier which is not connected to Infrastructure,

Similarly in Portal and Wireless only middle tier can be cloned (You can’t clone infrastructure tier) both source and target instances share same infrastructure database (as described in fig)

iv) During cloning source ORACLE_HOME is copied to destination ORACLE_HOME , then a set of scripts is used to update information in key configuration files of oracle application server middle tier (like hostname).

Key points in OAS cloning ?
—————————————
–You can clone middle tier installation of (J2EE & Webcache, Portal & Wireless and BI & Forms)
–You CANNOT clone
—–i)Infrastructure Tier (MR & IM)
—–ii)OAS Integration, BPEL Process Anaytics or BPEL process manager
—–iii) Developer kit and SDK
—–iv) Installation that includes workflow
–Cloned instance must have different name than source instance.
– You can clone MT (Middle Tier) that is member of OracleAS Cluster or Farm but you must remove instance from OracleAS Cluster and Farm before beginning cloning operation.
– Cloning process does not configure Load Balancer Router, If you use one, you have to configure it manually including invalidation port
– If in source webcache instance is member of cache cluster, then target webcahe should be manually added in to cache cluster (or delete other cache cluster member info manually if you don’t wish to target cloned instance as cache cluster)
– If source webcache instance is configured to forward requests to more than one origin server on same host as source web cache instance, then cloning will fail.
Cloning Process in Oracle Application Server
———————————————————-
i) On source instance run prepare_colne.pl (in $OH/clone/bin) (parses files, create archives using DCM, backs up required files, and run wireless clone assistant if wireless is enabled)
ii) Copy ORACLE_HOME to destination location
iii) ON target instance run clone.pl (invokes OUI which repeats all actions done during source instance installation time)
iv) post clone phase , clone.pl also does following post clone steps to make target cloned instance to a working state. These are
—-a) setting new ORACLE_HOME in DCM
—-b) update configuration file
—-c) calls chgiphost command to change hostname and IP address in cloned instance
—-d) If source instance was connected to OID (Portal/BI) then add information about clone in OID
—-e) After cloning start services on target instance on unix you have to run root.sh after cloning (from root)

B) Customize the cloning process
=============================
You can customize various aspects of cloning like specify custom port during cloning or preserve custom settings

i) Customizing ports during cloning
As mentioned above, cloning oracle application server in turn calls Oracle Universal Installer (OUI), Though you don’t see OUI calls; still OUI calls can be customized by configuration file cs.properties in $ORACLE_HOME/clone/ias/config
For example - To configure custom ports (to target instance) during cloning
clone_command_line = oracle.iappserver.iapptop:szl_PortListSelect=”{\”YES\”,
\”/location_of_port_list/portlist.ini\”}”

When you update this line in cs.properties while cloning , OUI will pick staticportlist.ini file and assign ports based on above file to target instance.

ii) Updating custom data
You can update custom data (custom files) that is not updated by default during cloning.
You can change/customize following data in target cloned instance
Change hostname in a file -> Add full path name of file in which hostname needs to be cahnged to
$ORACLE_HOME/chgip/config/hostname.lst
Update occurance of ORACLE_HOME in a file from old value to new OH value -> Use replace tag in fixup_script.xml.tmpl under
$ORACLE_HOME/clone/ias/config
Extract value from file1 and use it to replace value in file2 -> Use alter tag in fixup_script.xml.tmpl under
$ORACLE_HOME/clone/ias/config

C) Use cloning to expand an OracleAS Cluster
==================================
The most common example of cloning Oracle Application Server is expanding a Oracle AS cluster. For example you have a cluster of J2EE and Webcache Middle tier with identical configuration and wish to add another J2EE and webcache node with identical configuration and deployemt. Assume source Oracle Application Server is connected to file based repository and member of farm and OracleAS Cluster following are cloning steps to expand this OracleAS Cluster
i) Remove Source isnatnce from Farm and Cluster (Use dcmctl or iasConsole); dcmctl leaveFarm and dcmctl leaveCluster
ii) Run preclone on source Instance (”perl prepare_clone.pl”)
iii) Copy oracle_home and associated files from source to target instance
iv) Run clone on target instance “perl clone.pl”
v) Add source isntance to Farm & Cluster (”dcmctl joinFarm” & “dcmctl joinCluster”)
vi) Add target instance to Farm & Cluster using same command mentioned above

Few points related to using cloning to expand OracleAS Cluster
–Cloning Oracle AS Clusters, If source cloned instance is member of Cluster/Farm as mentioned in past remove it from cluster add it back to cluster after cloning.
–If source instance (clustered) is connected to file based repository in separate instance (it is not host of file based repository), cloned instance will be member of same farm as source instance
–If source instance (clustered) is connected to file based repository in same instance (it is host of file based repository), cloned instance will be host of new file based repository.

D) Move J2EE applications from a test middle tier to a new production environment.
==========================================
Their are various ways/options (depending on your requirement)
in which you can move J2EE application from Test to Production Instance

i) You already have J2EE and Webcache type test & production inastance–> Use “dcmctl redeployApplication” or iAS console “Deploy EAR File” method.
ii) You already have J2EE and Webcache (without IM) Test Instance but no prod instance –> Use middle tier clone method (mentioned in previous post) or Install J2EE and Webcache type middle tier on production and deploy J2EE application (using dcmctl or iASConsole)
iii) You already have J2EE and WebCache (with IM & MR) Test Instance but no prod instance –> Install Infrasturure tier on prod instance, install J2EE and Webcache type middle tier and deploy J2EE application by method mentioned above in point ii)

E) Move OracleAS Portal metadata from test to production
==========================================


As figure shown here is self explanatory that we have an existing test & prod Oracle AS environment(Portal type) with Portal
Metadata repository on separate database. Now if you wish to move Portal MR from test to production use export/import feature
to move content from test to prod.
Please note here that export/import mentioned here is portal import/export and not database imp/exp (though portal import/export in background with some additional steps uses database exp/imp only)
i) Create transport set and extract content to transport tables (using portal exp/imp feature from GUI)
ii) Move transport set from source to target (using portal exp/imp command line tool)
iii) copy dump file and script file from source to target instance
iv) Run command line script to import data from dump file to transport tables on target instance
v) Import objects from transport tables to portal repository via GUI using Transport Set Manager Portlet

F) Move applications from a test middle tier with Identity Management and a product Metadata Repository to an existing production environment with Identity Management
========================================

As shown in figure, this migration from test to production assume that ; You have an existing production Instance which already had Middle tier, Identity Management and metadata repository.

Remaining steps on how to migrate them coming soon ….

If you have any doubts in above topic or any other topic, leave a comment and I’ll get back to you.

1Z0-233 Dump: Install Patch and Maintain Applications : AD

Here is list of few exam questions which you can encounter in 1Z0-233 Install, Patch and Maintain Oracle Applications specific to AD Utility. Question mentioned here are to test your knowledge w.r.t. Oracle Applications. These certification questions are developed by me to get better understanding of Oracle Applications and to focus on key points of apps which we miss while reading.

This post cover question on two AD Utility License Manager & Splicer so test your Skills

Q: Whats is use of license manager ?
Note* In Oracle Application 1Z0-233 there is no descriptive type questions, this is to make you familiarize with various ad utilities as We want you to understand Apps with Certification

Q: License manager can be used to change base language you use for business transaction ?
a)
True b) False

Q: What information you can get from License Manager Reports ?
a)
Licensed/Shared Products b) Country-Specific Functionalities c) Languages d) All of above

Q: Once a product or component has been registered, you can use License Manager to de-register it
a) True b) False

Q: What is AD Splicer and how it is different from License Manager ?

Q: You can use AD Splicer to add custom products ?
a)
True b) False

Q: Which of these are AD Splicer control file ? (Choose Two answer)
a) Product Registration File b) Product Definition File c) Product Configuration File d) Product ID File

Q: You must run AD Splicer for each APPL_TOP and database combination in multinode Installation ?
a) True b) False

This is just a sample of huge Inventory of Oracle Apps DBA Certification Question we have for 1Z0-233 track. If you like to see more questions in future about Oracle Apps DBA certification Question (1Z0-233 dump) kindly leave your comment at end of this post.

Some/All/Major of the blog content is not mine and i'm not the writer of it, all rights reserved to the authors.