FOOD PREPARATION TIPS AND USEFUL INFORMATION: Oracle applications interview questions and answer

As a career aspirant people are always looking for career advice. Here we will provide interesting articles on career and education options one can choose from. Today we will be presenting interesting details on what a database administrator aka DBA does in a firm?As a next step we need to see how an oracle DBA can become Oracle Apps DBA All business is built upon information. As the saying goes, information is wealth. Information had always been source of knowledge. So, to store, secure, maintain, manage and retrieve information properly a personnel should be responsible for the business data. It is none other than DBA.DBA can transition from DBA to Oracle Apps DBA to take control of applications in addition to database So, what does it take to be a DBA? DBA is a seperate domain in itself. To be a successful DBA one can 1) Self-study 2) Attend training from premium database vendors like Oracle, microsoft, IBM etc What are the roles and responsibilities of a DBA? DBA in an organization is the person who takes care of 1) Securing data access 2) Performing backup and recovery 3) Performance tuning 4) Use management 5) High availability solution implementation. This ensures business continuity Oracle DBA, the database administrator as it is popularly called is a great profession with best career prospects. They deal with every aspect of data in the enterprise and hence can find position to the level of CIO the Information office in the organization. Information is the wealth and key to success of any organization With changing trends and emerging technologies Oracle DBA wold like to take a good career path change. They look out for plenty of options including data analyst, business analyst, project managers, RAC DBA, Shell Scripting oracle DBA, Oracle Apps DBA, ERP Support personnel to name a few Simple question is can an Oracle DBA emerge as an Apps DBA? Lets take a quick look at difference in job duties and responsibilities of an apps DBA 1) Maintain Data layer which is an oracle database - Integral part of ORacle DBA 2) Maintain App Tier/middleware 3) Maintain front-end As Oracle Apps are stacked on Java, Oracle knowledge with UNIX experience comes handy while choosing ERP career which is Oracle Apps DBA Hence, knowledge of oracle database administration is more than sufficient to takeup job of Oracle Apps DBA What is relationship between rapid clone and autoconfig? Cloning a critical task that an Oracle applications DBA performs on a regular basis, is the process of creating replicas of source instance. It is a need to create replica of production instance along with data for the testing team to test some modifications before the changes become live. In such cases cloning is the process used to create replica of production instance. Autoconfig had been used in earlier releases of 11i to perform cloning. Rapid clone is an automated cloning technique which uses Autoconfig internally to perform cloning. Give details on FNDCPASS, FND Functionality is a functionality in Oracle 11i and R12 :- FND functionality is use to change the passwords of application user, product schema password, APPS password. The executable used for performing this task is FNDCPASS. Directory Location : $FND_TOP/bin Usage of FNDCPASS and options available can be obtained by typing FNDCPASS in command prompt. $FNDCPASS Report Review Agent -- FNDFS is a text viewer used by Oracle applications for viewing the log and output files of Concurrent Manager requests.FNDFS executable uses the Report Review Agent Listener in the 8.0.6 Oracle Home installed on the application tier. The report review agent uses two major configuration files : 1) listener.ora 2) tnsnames.ora Location of these files -- $ORACLE_HOME/network/admin FNDFS listener is automatically configured by the system.When a user makes a request to view a report, FNDFS program is launched.FNDFS connectivity can be configured by configuring the tnsnames.ora file. Location of tnsnames.ora file -- $TNS_ADMIN/tnsnames.ora An alias is created for FNDFS_nodename.The tnsnames.ora file defines connections to the FNDFS listener adn it contains the address list of all the services that we can connect to from the client. FNDFS_nodename= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP) (HOST=hostname) (PORT=portnumber)) (CONNECT_DATA=(SID=FNDFS)) ) What are different oracle applications database objects? Different kinds of objects can be stored in the oracle applications database (oracle e-business suite R12). It can be : 1) Materialized view objects - These are hybrid objects. They are used to store and process data 2) Database objects - These objects store data. It includes tables, index, sequence, IOT (Index-organized tables) 3) Code objects - These are program codes. It includes PL/SQL objects such as PL/SQL package, java-stored procedure, synonym, triggers What is significance of opmn process manager notification server? Oracle Process Manager And Notification Server (OPMN) is a new feature added in Oracle Applications R12 (release 12) tech stack.OPMN has the primary function of managing oracle application server 10g components including Oracle HTTP Server, OC4J (Oracle For Java) etc.. OPMN is composed mainly of the following three components : 1) Oracle Process Manager 2) Oracle Notification Server 3) Process Manager(PM) Modules The script to manage OPMN is - adopmnctl.sh Parameters that can be used with this script - start, stop, status This script creates the logfile - adopmnctl.txt Location of logfile - central location of all the logs Logfile is created when we supply parameters start, stop, status with the adopmnctl.sh script How to start apps middletier? Whenever we want to start Oracle middle tier the first step is to start the listener. We can make use of Oracle supplied scripts to start the middle tier listener.. The script adalnctl.sh can be used to start/stop listener to manage the middle tier.The name of middle tier listener is of format APPS_ adalnctl.sh can be used with 3 parameters - start, stop, status Give details on Oracle application territory support :- Territory selected sets the defaults for day and week numbering (In USA Sunday is day 1, In Germany and many european countries Monday is Day 1) It sets defaults for credit and debit symbols, date format, decimal and group numeric seperators, currency symbols This has profound effect on the way in which application software behaves How to create schema independent users in oracle OID? Shared Schemas / Schema Independent Users are the users that are registered and maintaned in a LDAP repository. LDAP - Lightweight directory access protocol - is the standard that is used by Oracle to implement directory service likInternet Directory(also called as Oracle Internet Directory(OID)). There is one common schema.Users are saved in directory service.OID has details on user roles assigned at the time of login.Centralized user mangement is achieved using OID. Give details on oracle e-business proxy authentication:- Oracle e-business suite and several applications make use of tiered architecture.Database layer is the backend wherein data is stored.Middle-tier is the application tier which is usually made of Web Servers. When a user tries to access the database data connection has to pass through the application layer/middle tier. Proxy authorization comes into picture . SQL>alter user user-name grant connect through application-user authenticated using password; The statement mentioned above demands password.For a user to be authenticated at the middle tier use: SQL>alter user username grant connect through application-user; What are credit or debit memos? Credit or debit memos are used to record the credit for goods/services purchased. They are netted with invoices at payment time. What is use of Oracle management service in middle tier? The Oracle Management Service(OMS) is the middle tier. Before we can start using the grid control interface, we must firsmake sure that the middle tier OMS is running.At the end of the Grid Control software installation, the OMS should be automatically started by the installer.We can use the following command to check whether the OMS is running: $ emctl status oms If server is up we get the message as "Oracle Management Server is up" If the OMS isn't running start it up this way: $ emctl start oms The server starts with the message "Oracle Management Server is Up" Give details on oracle coherence datagrid solution: Oracle coherence 3.6 is the in-memory datagrid solution that has become a component of Oracle Fusion Middleware 11g. Oracle coherence 3.6 is used to address scaling challenges that are common in complex, mission-critical applications in a cost-effective fashion. 1) Oracle coherence provides support for distributed transactions 2) Oracle coherence quorum helps in capacity management, resource management in the grid and cloud frameworks 3) Security is enhanced through the Secure Socket Layer (SSL) connectivity 4) Coherence SQL language CohQL is used to improve efficiency and productivity in development How to create JMS Resources Create JMS Queue in Oracle SOA? We can create a JMS resource by using a Weblogic Server console.We create resources in the following order : JMS queue and connection factory -> connection pool for that connection factory Follow the steps for creating JMS resources : 1) Ensure that Weblogic server is started. If the Weblogic Server is not opened, open http://localhost:7001/console to start the WEblogic Server Console(WSLS Console). Login using weblogic/welcome1. Note : Hostname, ports, username, password can be supplied according to your configuration. 2) In the Weblogic Server Console, on the left navigation bar, expand Services/Messaging. Click on JMS Modules 3) A new table popsup. The table is the summary of resources. This table is titled "Customize this table". On this Summary of resources table, click on New tab. 4) Select the resource type : Queue. Click Next 5) Enter the Name as "ABCDYourValueQueue" and JNDI name as jms/ABCDYourValueQueue, Template : None 6) Click on Next 7) From the subdeployment list, select the SOASubDeployment 8) Under Targets section, from the JMS Servers list, select SOAJMSServer 9) Click on Finish tab. Give details on Oracle bounda amount types financials:- The combinations of amount types and boundaries that the system supports are as follows: If the amount type is PTD, boundary can be Period. If the amount type is QTD, boundary can be Period or Quarter. If the amount type is YTD, boundary can be Period, Quarter or Year. If the amount type is PJTD, boundary can be Period, Quarter, Year, or Project. Oracle fusion middleware configuration wizard:- I wanted to install and configure oracle fusion middleware 11g in my laptop. I've windows 7 installed in it. I started with downloading and installing Oracle database 10g Express Edition. Next I downloaded the repository creation utility and installed the sample schemas. I installed Oracle Weblogic Server and created middleware home at C:OracleMiddleware. Within the Middleware home Oracle weblogic server is installed. Now weblogic server home usually referred to as WL_HOME is inside the Oracle Fusion Middleware home C:OracleMiddleware. I have my weblogic server binary wlserver_10.3 installed in C:OracleMiddlewarewlserver_10.3. I invoked Quick Start From Start->All Programs->Oracle Weblogic and I've included the middleware configuration wizard step by step screenshot. We start with creating a simple domain, creating an administration server, starting domain in development mode, finally deploying application. Finally we start the weblogic server and access the GUI at http://localhost:7001/ Concurrent Requests programs managers oracle applications:- Oracle applications - Concurrent Requests, Concurrent Programs, Concurrent Processes, Concurrent Managers will be discussed here.Concurrent manager is an important term that an Oracle Applications DBA encounters frequently.Managing and maintaining concurrent manager is an essential role/function of a DBA. What is concurrent processing? Concurrent processing is the process of executing programs in background simultaneously with the online operations (i.e executing foregroun abd background operations simultaneously. In LINUX/UNIX, we can get list of foreground operations using the command fg, background operations using the command bg). Concurrent processing facility is available in Oracle applications.Most of the background operations are report generation programs.A person with the system administrator responsibility has the privilege to control the number of OS processes associated with running a program. What is a concurrent request? When a program is scheduled to be run as a background job, the program to generate the report/program to be run is the concurrent request.Lets say a shell script report.sh is to be run shell# ./report.sh - concurrent request - this invokes process and can be looked at by issuing : shell#ps -ef|grep report.sh - This outputs a process lisitng. It is concurrent request. What is a concurrent program? The script report.sh is the concurrent program. What is a concurrent manager? To start a concurrent program we need a concurrent manager. whenever there is a request to start a concurrent program, the request is inserted into a database table. The request is uniquely identified by a request ID. These requests from tables are read by the concurrent manager. Concurrent managers definition has information on how many operating system (OS)processes are to be dedicated to run the concurrent requests. These processes are referred to as target processes Give details on Printing events sequence in oracle applications Oracle applications has two broad categories of printing solution. Pasta utility allows us to define own printer drivers and print styles. The format UTF-8 is supported by pasta utility. Here is the sequence of printing events that happen in Oracle applications 1) User makes use of RunReports form to submit a request to run a report 2) REquests table adds an entry to run reports 3) The concurrent manager reads the request from requests table 4) Oracle reports is called by concurrent manager and SRW(SQL* Report Writer) drivername is passed. This is used by printer. Print style information is also passed by concurrent manager 5) Oracle reports runs the report Oracle Applications R12 Sequence Of Printing Events: Oracle applications is used to manage the printer.When a request to print is submitted to the printer managed by oracle applications the following sequence of events happens. 1) User submits a request to run a report from Run Reports form. 2) A request to run the reports is added to the requests table. 3) Concurrent manager reads the request. 4) Concurrent manager calls the Oracle report to run the report,passes SRW(SQL*Report Writer) driver name. 5) If Report Copies = 0 and printer field is blank printer style's SRW driver is used. 6) If Report Copies>0 printer is required.Printer drivers SRW is used. 7) Concurrent Manager passes print style information rows and columns to Oracle reports. 8) Report is created using Oracle reports 9) Concurrent Manager attaches printer driver information to the file.Initialization string is appended,reset string is appended. 10) Concurrent manager issues OS print command with arguments destination printer,filename including path,number of copies to print and filenamefor the title on the banner page. Where are log files for Oracle Identity Manager located? Oracle Identity Manager (OID) Log File Locations have been discussed here. 1) Installation logs - Global oraInventory/logs/oraInstallYYYY-MM-DD_HH-MM-SSPM.out 2) OID/Idm Configuration Logs - $ORACLE_HOME/cfgtoollogs/cfgfw/CfmLogger_YYYY-MM-DD_HH-MM-SSPM.log 3) Oracle Internet Directory logs - $ORACLE_INSTANCE/diagnostics/logs/OID//oid*.log 4) OID Monitor Logs - $ORACLE_INSTANCE/diagnostics/logs/OID//oidmon-XXXX.log 5) OPMN (Oracle Process Monitor) logs - $ORACLE_INSTANCE/diagnostics/logs/OPMN/opmn/ Installation and Post-Installation Steps of oracle applications : Oracle Application System - Installation and Post-Installation Steps are the various steps/activities needed to operate the applications features appropriately. Some of the important steps carried out in Oracle Applications Setup are as follows1) Run Rapid Install. Rapid install is a tool from Oracle Corporation. IT is used in installation of Oracle Applications. 2) Test Web listener virtual directories 3) Test Oracle HTTP (OHTTP) Server configuration. Oracle HTTP Server is powerd by Apache Webserver. Oracle HTTP Server provides communication services within the Oracle Application Server. HTML-based applications can be deployed with the help of Oracle HTTP Server. 4) Create DBC Files 5) Test Java Servlet setup 6) Set web server profile options Oracle E-Business Suite Supported On Oracle RAC(Real Application Cluster): Oracle E-Business Suite is Supported On Oracle RAC(Real Application Cluster). For this support follow the steps mentioned below : 1) Install the correct version Oracle Clusterware, Oracle clusterware is a clustering solution from Oracle Corporation. It is used to support Oracle RAC databases. 2) Install correct version database software. Note that certain database versions are supported only on specified clusterware version. Care must be ecised while choosing the version compatability. 3) Create database instances - It can be normal instance or an ASM (Automatic Storage Manager) Instance If the current database is supported by single instance version, it is possible to migrate to RAC(Real Application Cluster). Follow the steps to convert single instance database to RAC. 1) Modify the sample xml file - ConvertToRAC.xml to meet the requirements of our system 2) Run the Oracle supplied utility rconfig against the sample xml file - ConvertToRAC.xml which has been customized 3) rconfig Must be run in Verify Only mode. This test run will validate the parameter settings. It reports issues that needs to be resolved before performing actual conversion. Oracle AD Utilities (Applications DBA Utilities): Oracle AD Utilities also called application dba ad utilities are set of Oracle supplied utilities that are used to administer Oracle Applications.A brief listing of utilities and their usage is given below: 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 - Relinks Oracle Applications executable programs with the Oracle server product libraries. adsplice - Adds off-cycle products. adtimrpt.sql - Reports a summary of the timing for jobs run by parallel workers. adpatch - Applies patches and other system updates. admsi.pl - Generates customized installation instructions for a patch. rapidwiz - Provides a wizard for entering parameters that are specific to a new installation or an upgrade of an Oracle Applications system How to fix Oracle 11i installation error RW-50010: Error: script has returned an error:126? RW-50010: Error: - script has returned an error:126, Oracle 11i (11.5.10.2) Installation Error is the most common error encountered while installing Oracle 11i (11.5.10.2) in Linux Servers. For installing Oracle applications (11i), we use rapidwiz utility.This error occurs due to possible permission violation problems. Some solutions include : 1) Change the permissions for the files adrunias.sh, adrunat.sh to 755. As it is a Linux server use command chmod # chmod -R 755 adrunias.sh # chmod -R 755 adrunat.sh 2) Restart the rapidwiz Give details on Oracle Single Signon schema password :- Finding orasso (Oracle Single Signon) Schema Password has been explained in this post. orasso password is randomly generated and stored in OID (Oracle Internet Directory). OID (Oracle Internet Directory) is a LDAP (Lightweight directory access protocol) compliant server from Oracle Corporation. OID is a part of identity Management stack from fusion Middleware.orasso password can be found by executing the following commands. $ORACLE_HOME/bin/ldapsearch -h $OIDHOST -p $OIDPORT -D "cn=orcladmin" -w “$OrcladminPASSWORD” -b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” -s sub “orclResourceName=$DBUSERNAME” orclpasswordattribute How will you install using Fusion Middleware using Configuration Wizard? Started with downloading and installing Oracle database Next download the repository creation utility and installed the sample schemas Install Oracle Weblogic Server and create middleware home at C:\Oracle\Middleware in case of windows Within the Middleware home Oracle weblogic server is installed. Now weblogic server home usually referred to as WL_HOME is inside the Oracle Fusion Middleware home C:\Oracle\Middleware. Weblogic server binary wlserver_xx.x is installed in C:\Oracle\Middleware\wlserver_xx.x Invoke Quick Start From Start->All Programs->Oracle Weblogic and include the middleware configuration wizard We start with creating a simple domain, creating an administration server, starting domain in development mode, finally deploying application Finally we start the weblogic server and access the GUI at http://localhost:7001/ What is FOSS from Oracle? FOSS Free And Opensource Projects is a collection of many different open source projects from oracle corporation. It includes a wide range of open source projects starting from Oracle Linux, Oracle unbreakable Linux, Oracle VM, Eclipse Projects, Oracle and PHP, Oracle Berkeley DB, Oracle ROR (Ruby On Rails), Oracle+Python,XQilla XQuery Engine,Oracle JDeveloper, Oracle And Project Glass fish (Glass fish is a web server from Sun Microsystems), Oracle Database 10g Express Edition (Same as SQL Server 2008 Express Edition) FOSS From Oracle What is Oracle browser look and feel guidelines BLAF? Oracle BLAF (Browser Look And Feel) Guidelines is the user interface guidelines website for BLAF applications. BLAF guidelines are set of specifications regarding the UI components, templates, flows, heuristics. As per Oracle Corporation "These specifications should be used to develop html-based Oracle products to provide a consistent user experience regarding look and feel of applications, flow of applications, layout of pages, and interaction of components. Using the guidelines to design your application will also ensure a consistent suite of applications and tight product intergration." The specifications are arranged in levels or layers, the outer most layer being high level interaction model, to the inner most level of a specific component How will you generate customer Specific file manifest in oracle applications? Follow the steps to generate customer-specific file manifest in Oracle applications 1) Log into system as APPLMGR user 2) Execute the following command to generate the customer specific file manifest : perl $AD_TOP/bin/adgenpsf.pl 3) Above command produces adgenpsf.txt file. This is the customer-specific manifest file Usage of customer specific manifest file 1) Used in platform migration of oracle applications 2) Very much needed during split tier architecture migrations in which applications tier and database tier reside on different platform Give details on Oracle Applications Tablespace Model (OATM) :- Migration is done using a PERL script.There are several steps in the process of migration using OATM.There are three major phases during which several steps are performed 1) Preparatory Phase 1.1Report on tablespace sizing 1.2Create new tablespaces 1.3Generate migration commands 2) Migration Phase 2.1Executemigration commands 2.2Run Migration reports 3)Post Migration Phase 3.1Run post migration steps Optional steps: 1)Run customization steps 2)Batch mode execution of migration Give details on Oracle Fusion Middleware Overview :- Oracle Fusion Middleware 11g has been out on July 1st, 2009.Oracle Fusion Middleware 11g is composed of the following main components 1) Oracle Weblogic Server (J2EE Application Server) 2) Oracle Webcenter (Composer, WC Framework, WC Services, WC Spaces) 3) Oracle SOA(Service Oriented Atchitecture) Suite (Composed of adapters, service bus, business rules, B2B,BPEL (Business Process And Extraction Language, BAM (Business Activity Monitoring) 4) Oracle Identity Management (OID,DIP,federation,OVD,role manager,oaam,entitlements, directory services manager) 5) Oracle Business Intelligence(BI) (Discoverer,Portal,Reports,Forms) 6) Oracle Application Component ( DEV tools, HTTP Server, Web cache, Web Services, DAS) 7) Oracle Metadata repository Oracle Fusion Middleware 11g can be downloaed from the link given below : http://www.oracle.com/technology/software/products/middleware/htdocs/111110_fmw.html Oracle Fusion Middleware Software Download Page : Oracle has made it possible to download and install all the Oracle Fusion Middleware 11gR1 popularly called as FMW products from its single download page. This page acts as a hub and it is possible to download all the components relevant to FMW suite of products. Some popular products include Oracle weblogic server, Repository creation utility, Oracle SOA to name a few. http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html Oracle Fusion Middleware 11g Repository Creation Utility (RCU) : Installation of Oracle Fusion Middleware 11g using Repository Creation Utility (rcu) is a 7 step process. 1) Download repository creation utility (rcu) 2) Extract rcuHome from this archive 3) Navigate to rcuHomeBinrcu.bat. Click on rcu.bat 4) Welcome screen of repository creation utility (rcu) pops up. Click Next 5) First step is the "Create Repository". There are two options in this screen : Create - Which allows us to create and load component schemas into database Drop - Removes component schemas from database. It is useful while installing Oracle SOA (Service Oriented Architecture) suite of products. For now click Create. Click Next 6) Database Connection Details screen appears. It is composed of the following fields: Database type - Specify if it is an Oracle database or a Microsoft SQL Server Hostname - Specify the hostname where database is created. In case of RAC environment specify the VIP name or one of the hostnames in which RAC instance runs Port - Specify the port used for connectivity. Default portnumber of Oracle database is 1521 Service name - Specify the service name Also specify connectivity username (user like SYS who has SYS or SYSDBA privilege should be specified). Specify a valid password. Specify the role of the user. Possible values are Normal and SYSDBA. Some components need SYSDBA prvilege. So, specify the SYSDBA role.Specify the values and click Next. Oracle Access Manager Fusion Middleware 11g : Oracle Access Manager is the single-sign on solution from Oracle corporation. Its sophisticated identity management and access control features which are state-of-art features make it the best choice from Oracle Fusion middleware 11g. Oracle Access Manager 10.1.4.3.0 is the single-sign on solution that comes as a part of Oracle Fusion Middleware 11g. Until Fusion Middleware 10g Oracle Single Sign-on (OSSO) used to be the single-sign on solution. It is no longer recommended in Oracle Fusion Middleware 11g. Though OSSO is still supported in FMW 11g, it will not be ported to Weblogic Application Server. Weblogic is the application server in OFM 11g and hence OSSO is not recommended. Oracle FMW RCU Components Installation: While we try creating a repository using repository creation following list of components gets installed automatically as a part of this installation process. 1) Metadata Services 2) Audit Services 3) Enterprise Scheduler Service 4) Oracle Internet Directory (OID) 5) Oracle Identity Federation 6) Oracle Information Rights Management 7) Oracle Content Server 11g-Complete 8) Oracle Content Server 11g - Search Only 9) Oracle Universal Records Management 11g 10) Oracle Imaging And Process Management 11) Master and work repository 12) Portlet producers 13) Oracle content server 10g 14) Discussions 15) Wiki and Blogs 16) Discoverer 17) Registry 18) Oracle Access Manager (OAM) 19) Oracle Adaptive Access Manager (OAAAM) 20) OAAM Partition Support 21) Authorization policy manager 22) Business Intelligence platform 23) User messaging service 24) Webcenter spaces 25) Discussions crawler 26) Portal 27) SOA Infrastructure 28) Business Activity Monitoring - BAM 29) Oracle Identity Manager 30) Presence 31) SIP infrastructure subscriber data service 32) SIP infrastructure location service Oracle FMW Repository Creation Tablespaces : While creating teh repository using repository creation utility, rcu binary a number of tablespaces, schemas, schema owners gets created automatically. Here is a sample overview of the default tablespaces that gets created during this installation. Tablespaces are created in the corresponding repository database. It is the database chosen while starting install. It can be Oracle Database Express 10g Edition and later versions. In my case I make use of Oracle database 11g Release 2(Latest Oracle database version).This is the progress bar that checks the prerequisites for creating tablespaces and creates teh tablespaces in the repository database. On an average it took 6 minutes for creating all the tablespaces in the repository database. SOA - Service Oriented Architecture - An architectural approach for integrating business processes. This architecture is business centric. Application processes are designed in form of services and provides a means of integrating loosly coupled services. Oracle Fusion applications are based on SOA. BPEL - (Business Process Execution Language) - A language used to orchestrate and streamline business processes. It is a part of Oracle Fusion Middleware suite of products SOA - Simple Object Access Protocol - A protocol used for communication among the web services. SOAP is a part of the Oracle Fusion middleware suite of products. It is XML Based. XML - Exentisble Markup Language - An language used to share information between applications AIA - Application Integration Architecture - An methodology and a product from ORacle corporation used to integrate business processes. WSDL - Web Service Definition Language - A language used for communicating what each web service can do. This is used to define what a web service can do and what a web service needs to do it PIP - Process Integration Pack - It is an industry-specific best practice flow that have been packaged by Oracle . It is built on an AIA framework What is SOA(Service Oriented Architecture)? SOA, a term popular among the software community these days is actually neither a technology nor a product.Just as the TCP/IP protocol laid foundation for networking, SOA is a design approach or a design methodology upon which applications are designed.Different functionalities/processes of an application are viewed and implemented as atomic entities called as services. This make them inependent of each other and is easy to reuse them.Different services are integrated and orchestrated using BPEL(Business Process Execution Language). This is the basic concept behing SOA.SOA can be best implemented using many object-oriented technologies including J2EE, .NET, PL/SQL.SOA is the architecture approach used for Oracle fusion middleware. Oracle SOA Suite Components: Oracle SOA(Service Oriented Architecture) is a multi-tier architecture.It encompasses application functionality into services.Services are grouped to form Web Services.Oracle HTTP is the standard protocol to utilize the web services.It is also based on open standard AML protocols like SOAP,WSDL.Oracle SOA Suite consist of the following components : 1) BPEL - Business Process Execution Language 2) ESB - Enterprise Service Bus 3) OWSM - Oracle Web Services Manager 4) BAM - Business Activity Monitoring BPEL (Business Process Execution Language) : The Business Process Execution Language (BPEL) is an XML-based language for enabling task-sharing across multiple enterprises using a combination of Web services. BPEL is based on the XML schema, Simple Object Access Protocol (SOAP), and Web Services Description Language (WSDL). Using BPEL, we can design a business process that integrates a series of discrete services into an end-to-end process flow. Oracle BPEL Process Manager : A component of Oracle Application Server.It includes the BPEL Server, the BPEL Console, the BPEL Worklist application for human-centric workflows, and the BPEL Designer.We can use the BPEL Designer, an Oracle JDeveloper-based design tool, to graphically create custom workflows for use in Oracle Content DB.Oracle BPEL Process Manager provides a framework to design, deploy, monitor, and administer processes based on BPEL standards. We can define custom BPEL workflows in Oracle BPEL Process Manager, and then register them for use in Oracle Content DB.Custom workflows are only available to the default Site in Oracle Content DB; additional Sites cannot use the custom workflows. Oracle BPEL (Business Process Execution Language) Admin Console : This is a part of Oracle Middleware Components (Oracle SOA Suite). Upon successful installation of Oracle SOA suite, BPEL admin console can be accessed at : http://hostname.domainname:port/BPELAdmin BPEL admin console is implemented as a thin client and hence can be accessed via browser How to create users and define responsibility in oracle applications? Oracle applications technology layer is the layer between oracle applications technology stack and oracle applications product-specific modules. Products in oracle applications layer are 1) Oracle Applications DBA – AD – Used to administer database and filesystem. These are set of tools to install, upgrade, maintain and patch database 2) Oracle applications object library – FND 3) Oracle applications utilities – AU 4) Oracle common modules – AK 5) Oracle workflow – wf 6) Oracle alert – ALR 7) Oracle applications framework – fwk 8) Oracle xml publisher – XDO Oracle Applications has a set of subcomponents that constitute its application tier. It includes : 1) HTTP Server/Web Server 2) Jserv replaced by OC4J (mod_oc4j) 3) Forms Version 6i replaced in R12 4) Reports Version 6i 5) JDBC 6) modplsql or mod_pls 7) Java processes that use JDK/JRE Security plays a major role in all systems. Oracle applications being an ERP requires highest level of security as minor security flaw could lead to the crash of the entire system. We can create users and assign them proper responsibility. Responsibility determines the access level. Users can be created in oracle applications as follows : 1) Navigation -> Security -> User -> Define 2) Enter username, password, description, password expiration (very important as per SOX (Sarbanes Oxley) compliance) and many such details in the form 3) Define responsibility and assign responsibility to users In scenario does Value of Custom Variable Supervisor Password is less than minimum length of 6 characters. Value should be between 6 and 12 characters error occur and how to fix it? I tried creating a repository using repository creation utility. I supplied Master Repository ID, Work Repository ID. In addition to this value of Master Repository password called as Supervisor password, work repository password specified should meet certain password criteria. If the password doesn't meet the criteria, we'll get the following error : Value of Custom Variable Supervisor Password is less than minimum length of 6 characters. Value should be between 6 and 12 characters. Solution : Specify the passwords as per the rules specified in the error and the issue gets fixed. How will you create JMS Resources Hook up connection pool to connection factory Oracle SOA? We can create a JMS resource by using a Weblogic Server console. We create resources in the following order : JMS queue and connection factory -> connection pool for that connection factory Next step is adding connection pool. The connection pool is configured in the JMSAdapter application an uses a Deployment Plan.Deployment Plan is contained in a directory. First, create a directory to contain the deployment plan. 1) Create a directory in this location : C:OracleMiddlewarehome_11gR1Oracle_SOADEMOsoaJMSPlan - Depends on installation path 2) In the left Navigation bar of the Weblogic Server Console(WLS), click on Deployments 3) Click on JMSAdapter (Click on the name, not the checkbox) 4) Click the configuration tab; Click the Outbound Connection Pools tab 5) Click on New 6) Select the radio button : oracle.tip.adapter.jms.IJmsConnectionFactory factory 7) Click on Next 8) Enter eis/Queue/demo. click Finish. 9) At this point we'll be asked to specify the deployment plan location. Click on the directory path we created earlier and enter NewPlan.xml for plan name 10) Click ok. Verify the plan name is set to NewPlan.xml in the JMSPlan directory. Oracle SOA(Service Oriented Architecture) 11gR1 - Creating JMS Resources - Hook up connection pool to connection factory Now go back to the new connection pool to hook up the connection factory : 1) Click the Configuration tab 2) Expand the group : oracle.tip.adapter.jms.IJmsConnectionFactory 3) Click on eis/Queue/demo 4) To change a propoerty value, we must enter the value and then press the Enter key and click on save button. Note : Avoid tab key. 4.1) Select the cell on the far right for the property ConnectionFactoryLocation 4.2) An edit box appears. Type in the value jms/mydemoCF and press Enter key 4.3) We must use teh Enter key for the value to be entered in the field 5) Click on save. We must use the Save button to save the value 6) Redeploy the adapter. Click on Deployments in the left navigation bar 7) Select the checkbox next to JMSAdapter 8) Click on Update at the top of the Deployment table 9) Verify that the correct deployment plan is selected 10) Click on Next. Click on Finish tab How to check Forms Server in oracle applications? Forms server runs as an executable in port 9000. HEre is the simple method to check the status of forms server in an Oracle Apps R12 environment netstat -a|grep 9000 In R12 forms server is started in servlet mode by default. It is possible to start it in socket mode using adformsrvctl.sh script In 11i forms server starts in servlet or socket mode using f60ctl Give details on startup and shutdown sequence in oracle applications:- Oracle Apps E-business suite R12 startup and shutdown sequence is same as in Oracle Apps 11i. Startup Sequence : 1) Startup database listener - addlnctl.sh 2) Startup database - addbctl.sh 3) Startup Middletier/Application services - adstrtal.sh Stop Sequence : 1) Stop Application/Middletier services - adstpall.sh 2) Stop database - addbctl.sh 3) Stop database listener - lsnrctl stop listener_name What is use of adminappserver utility? AdminAppServer Utility is used to create .dbc files that is used to secure the Oracle applications. Adminappserver a javascript generates serverID in application server layer and sent to database server.On authenticating serverid database server provides the necessary access.This security mechanism is not activated by default. Give details on Concurrent Manager Administration :- There are certain Application operations that consumes a great deal of OS resources and needs to be run in background(OS background) without interacting with active processes. Such processes are scheduled to run in background and are referred to as concurrent programs. Oracle Application architecture has the concurrent manager that governs the task of scheduling,running,closing concurrent programs. If concurrent programs are configured to run in more than one node,internal concurrent manager is the master process that starts the service manager in other nodes.Service manager acts as the agent and spawns processes in other nodes. Defining Work Shifts has been presented below : 1) Log into Oracle Applications 2) Select the System Administrator responsibility 3) Navigate : Concurrent -> Manager -> Workshifts 4) From the menu select : File -> New As an alternate, we can also click New Icon in the toolbar 5) Create a new work shift, supplying the following fields : Name : Name of work shift From : Time To : Time From : Day To : Day Description : Some details on work shift 6) Save the work 7) Close the form Give details on patching oracle applications :- Oracle application patching is an essential duty of oracle applications dba. Patching is used to fix the issues in current release, include enhancements to the current release, upgrade to an upper version. There are different kinds of patches. Following are the list of major category of patches. 1) Individual patches 2) Mini Packs 3) Maintenance Packs 4) Family rollups 5) Family consolidated upgrade patches What is the File system structure in oracle applications R12? db/apps_st/data - directory is located on the database node machine, and contains the system tablespaces, redo log files, data tablespaces, index tablespaces, and database files db/tech_st/10.2.0 - directory is located on the database node machine, and contains the ORACLE_HOME for the Oracle10g database apps/apps_st/appl (APPL_TOP) - directory contains the product directories and files for Oracle Applications apps/apps_st/comn (COMMON_TOP) - directory contains Java classes, HTML pages, and other files and directories used by multiple products apps/tech_st/10.1.2 - directory contains the ORACLE_HOME used for the Applications technology stack tools components apps/tech_st/10.1.3 - directory contains the ORACLE_HOME used for the Applications technology stack Java components What is an oracle AIA? AIA,Oracle AIA, Application Integration Architecture is a proposal from Oracle corporation that has come out on May 2007.It is the Oracles way of implementing Service Oriented Architecture (SOA). As per Oracle Corporation, AIA (Application Integration Architecture) provides customers, partners with the capability to more easily integrate and orchestrate information and support transactions within a business process across multiple systems.It helps us look at the holistic picture of our business processes.This creates interoperability across applications What is the use of cloning? Cloning is used to create copies of production Oracle Applications. This is used for development and testing purpose. This process is referred to as cloning of oracle application instances. What are the toolkits/ scripts used with Oracle applications/e-business suite? 1) Oracle application component startup and shutdown script 2) Changing application passwords - Oracle, Applications, APPLSYS/APPS 3) Relinking application executables 4) Regenerating forms, libraries and menus 5) Recompiling JSP pages What is the location of oracle application component startup and shutdown script? $APPLCOMN/admin/scripts/$CONTEXT_NAME What is a concurrent program? Concurrent program is a program registered with AOL. While registering with AOL, certain information like program name, execution method, argument needs to be given What is an Oracle Applications document sequence? A document sequence uniquely numbers documents generated by an Oracle Applications product.A document sequence generates an audit trail that identifies the application that created the transaction.Document sequences can provide proof of completeness.Document sequences generate audit data, so even if documents are deleted, their audit records remain. Give details on oracle applications SID.xml file:- Oracle Applications - SID.xml File is the context file.Oracle applications use this context file and it contains the following information about the APPL_TOP 1) Name of application system 2) Information about various servers 3) Technology stack version 4) Guest user name password 5) DB host and port details 6) port number of all the components in the middle tier 7) Product top directories of all the installed products In general xml file is organized based on xml namespace structure which is easy to parse. So .xml formats are used as context files. Give details on oracle applications context file:- Oracle applications DBA - Application context file is a global configuration file for storing all the configuration information of all components in the E-business suite. Location - $APPL_TOP/admin directory Application context file is a XML file named $CONTEXT_NAME.xml What is an application context file in oracle e-business suite/ oracle applications? The nodes that comprise teh oracle applications have numerous configuration files. Administering these What is Oracle TCG? Oracle TCG stands for Oracle Transaction Controls Governor What is the use of oracle TCG? Oracle TCG helps to ensure that individual transactions are safe. How does oracle TCG achieve transaction security? Models can be defined. Models specify the circumstances under which transactions pose risk. How are the models defined? Models are defined on an individual transaction basis Oracle applications many different layers: Oracle Applications is an ERP solution from Oracle corporation. It is composed of the following three layers: 1) Database layer 2) Application layer Application tier is the set of software used to provide business logic and code processing, database and client desktop interaction. These software components are popularly referred to as servers(application servers). The components that constitute application servers are as follows: 1) Oracle HTTP Server (Apache) 2) Forms Server 3) Reports Server (deprecated in R12. Available only in 11i) 4) Admin Server 5) Concurrent processing server 6) Discoverer server GUI tool used for adhoc querying of Oracle Applications data is the discoverer server.It is an additional/secondary service component.Parameters in context file pertaining to discoverer server are : 1) s_disco_standalone - determines whether the application is configured to use a standalone discoverer server 2) s_disco_machine - location of machine running discoverer services 3) s_disco_port - port configured to listen for discoverer requests 4) s_disco_ver_comma - comma-delimited version of discoverer 5) s_disco_eul_prefix - discoverer end user layer (eul) prefix When we are performing an upgrade to discoverer/e-business suite, ensure that existing configuration remains valid. 3) Desktop layer Each layer is also called by name tier. Desktop tier is the presentation layer that presents the data to user in a formatted fashion. Application layer is the layer formed of application services also called as application servers like Oracle HTTP Server, Forms server, reports server, discoverer server, concurrent server. Database layer is used to store the application data. It constitutes Oracle databases. Databases can be single instance database or can be clustered to provide scalability and high availability What is OBIEE? OBIEE stands for Oracle Business Intelligence Enerprise Edition.It is Oracle’s set of business intelligence tools.OBIEE as it is popularly called is the BI solution from Oracle corporation. It is flaming hot in market and if you have basic knowledge on PL/SQL it is pretty easy to fit in OBIEE developer domain. OBIEE administration is easy and straight forward. After installation obiee can be accessed at http://servername:9704/ We can click on Launch AS Console at Right corner and log onto Oracle Enterprise Manager 10g Application Server Console. Login using default admin user oc4jadmin and password created in installation steps What does OBIEE comprise of? OBIEE comprises of suite of tools from Siebel Analytics What is OBIEEPlus? OBIEE Plus = OBIEE + Hyperion tool suite. Give details on NQSConfig.INI File:- Oracle BI(Business Intelligence) EE (Enterprise edition) (OBIEE) - NQSConfig.INI File is the configuration file in Oracle BI EE(OBIEE).It is used for configuring the clustering of BI server and configuring cluster controller.Location of NQSconfig.ini file - ORACLEBI/server/config/directory While creating OBIEE cluster, we need to install BI server on dedicated servers and configure each and every node to join the cluster.Primary cluster control is one node among the nodes participating in clustering. Primary cluster control receives connection requests and forwards it to one of the nodes in the cluster.This acts as the master.Secondary cluster controller acts as backup for primary cluster controller NQSConfig.INI File Configuration Parameters are as follows: 1) CLUSTER_PARTICIPANT - This tells BI server to look into NQSConfig.INI file for further information on how to connect into cluster. Values : YES|NO 2) REPOSITORY_PUBLISHING_DIRECTORY - Common directory where nodes in cluster can look into for any modification. Value : Directory Path 3) REQUIRE_PUBLISHING_DIRECTORY - Tells BI server to start or not to start if publishing directory is not found. Values : YES|NO 4) ENABLE_CONTROLLER - YES|NO 5) PRIMARY_CONTROLLER - Primary node name 6) SECONDARY_CONTROLLER - Secondary node name 7) SERVERS - participating servers; comma seperated 8) MASTER_SERVER - master server name ORA-00600: internal error code arguments: [733] [538986556] [pga heap] in OBIEE env:- While we try to bring up a database using startup command, building a cube in OBIEE env the ORA-600 error can likely occur. It has been found that the root cause of this issue happens to be pga_aggregate_target value is too small and needs to be fixed The new parameter in Oracle 12c pga_aggregate_limit can be set to appropriate value to fix this issue. In versions prior to 12c , value of pga_aggregate_target can be set appropriately In OBIEE env in versions prior to 12c, fix is to partition the dimension as this will help us build cubes in parallel Oracle BI (Business Intelligence) (OBI) is formed of the following components : 1) Oracle BI spread sheet add-in 2) Oracle BI discoverer 3) Oracle BI beans 4) Oracle BI reports 5) Oracle BI warehouse builder 6) Oracle Data Mining 7) OLAP (Online Analytical Processing) option to the Oracle database 10g 8) Oracle Database 10g Oracle Database 11g BI (Business Intelligence) and Datawarehousing features :- Oracle database 11g has a rich set of Business Intelligence(BI) and datawarehousing features.Some of the major salient features include : 1) Partitioning feature - Interval partitioning, extended composite partitioning, reference partitioning, system partitioning, system-managed domain indexes 2) Virtual columns feature related to statistics collection 3) Improved Oracle Data Pump features 4) Improved Materialized views features 5) Pivot clause 6) Unpivot clause 7) Table compression Oracle BI (Business Intelligence) Administration Tool :- 1) Oracle BI Administration Tool is a windows application. 2) Oracle BI administrator can create and edit repositories using oracle BI administration tool. 3) Oracle BI administration tool has a number of wizards and utilities. They can be used to perform various tasks replacing column,table,generating and deploying metadata dictionary, removing unused physical objects,calculations etc Oracle Business Intelligence (OBI) Infrastructure Components :- Oracle Business Intelligence (OBI) Infrastructure Components are as follows : 1) Business intelligence server 2) Business intelligence presentation services 3) Business intelligence presentation services plug-in 4) Busiess intelligence scheduler 5) Business intelligence administration tools 6) Business intelligence cluster controller 7) Business intelligence client 8) Business intelligence ODBC driver 9) Business intelligence JDBC driver 10) Business intelligence system management 11) Business intelligence catalog manager 12) Business intelligence job manager 13) Business intelligence publisher 14) Business intelligence disconnected client 15) Business intelligence publisher desktop 16) Business intelligence open intelligence interface 17) Business intelligence office plug-in 18) Business intelligence briefing book reader Oracle Datawarehouse Application Console A Quick Look :- Oracle data warehouse application console also called DAC is an application from Oracle corporation that helps us create and schedule ETL taskflows for informatica server. All data warehousing processes including scheduling, loading of eTL, configuring subject areas as loaded using DAC Oracle management agent collects all the metrics from target and is visible in all metrics page Metrica are broadly classified as 1) ETL Performance Metrics - completed tasks, failed tasks, queued tasks, runnabel tasks, running tasks, total tasks 2) ETL Run metircs - completed steps, etl definition, failed steps, running steps, status, total steps, end time, start time 3) Failed ETL run metrics 4) Response metrics 5) ETL run logic metrics oracle general ledger budget hierarchy an overview:- In a budget hierarchy, each budget is either classified as a master budget or a detail budget. Depending on the level in the hierarchy, a budget can be either a master budget, a detail budget, or act as both. A budget that acts as both a master and a detail budget is a detail budget that also has detail budgets of its own. For example in a corporation,there are three levels say,the Corporate level, the Division level and the Region/Department Level.At the Corporate level is the Corporate Budget. This budget is a master budget and is at the top of the hierarchy. The Division level is the second tier in the budget hierarchy and is tied to the Corporate Budget. At this level are two budgets, the Sales Division budget and the Marketing Division budget. The budgets at this level are detail budgets. The third level of the hierarchy has six budgets, three connected to the Sales Division budget and three connected to the Marketing Division budget Starting Stopping Restarting Oracle HTTP Server : Oracle HTTP Server is managed by Oracle Process Manager and Notification Server (OPMN).We use the opmnctl utility to start, stop and restart Oracle HTTP Server.The configuration management infrastructure cannot detect or communicate with the Oracle HTTP Server processes, and problems may occur if we don't use the opmnctl utility.To start Oracle HTTP Server, use the startproc command: UNIX: ORACLE_HOME/opmn/bin> opmnctl [verbose] startproc ias-component=HTTP_Server Windows: ORACLE_HOMEopmnbin> opmnctl [verbose] startproc ias-component=HTTP_Server To stop Oracle HTTP Server, use the stopproc command: UNIX: ORACLE_HOME/opmn/bin> opmnctl [verbose] stopproc ias-component=HTTP_Server Windows: ORACLE_HOMEopmnbin> opmnctl [verbose] stopproc ias-component=HTTP_Server To restart Oracle HTTP Server, use the restartproc command: UNIX: ORACLE_HOME/opmn/bin> opmnctl [verbose] restartproc ias-component=HTTP_Server Windows: ORACLE_HOMEopmnbin> opmnctl [verbose] restartproc ias-component=HTTP_Server To determine the status of Oracle HTTP Server, use the following command: opmnctl status SVMGRL Start an Oracle HTTP Server: We can make use of SVMGRL to start an oracle HTTP server. Follow these steps : $svmgrl svmgr> connect internal svmgr> startup Oracle Applications Layer: Oracle Applications is an ERP solution from Oracle corporation. It is composed of the following three layers: 1) Database layer 2) Application layer 3) Desktop layer Each layer is also called by name tier.Desktop tier is the presentation layer that presents the data to user in a formatted fashion.Application layer is the layer formed of application services also called as application servers like Oracle HTTP Server, Forms server, reports server, discoverer server, concurrent server. Database layer is used to store the application data. It constitutes Oracle databases.Databases can be single instance database or can be clustered to provide scalability and high availability What is the use of identity.obj file in oracle applications? The identity.obj file is saved in the admin node. Admin node has the configuration files and other important files such as application's environment file, identity.obj file, DBC (database connectivity) file.The identity.obj file is located in the $HOME directory of the application owner. The identity.obj file is the identity database file that holds trusted digital certificates.Problems to identity.obj file may cause the failure of the jar applications that are regenerated after patching. The error that occurs after patching that may require the identity.obj file to be recreated is the : Error Message : ERROR: Javakey subcommand exited with status 1 If this error occurs recreate the identity.obj file and use adctrl to restart the failed workers. A yellow bar will appear at the bottom of the application screens. We can re-create identity.obj file using the command "adjkey" $ adjkey -initialize This command will prompt for an entity name and an organization name. What is BPEL (Business Process Execution Language)? 1) BPEL expands to Business Process Execution Language 2) This standard emerged in 2003 3) BPEL was developed to enable orchestration of web services using an executab;e XML-based language 4) BPEL allows us to seperate out the definition of our process from the implementation of the services that it orchestrates 5) BPEL provides process flow operators such as conditional branching, parallel flow(split/join), looping etc 6) BPEL process can be exposed as a web service,hence can be included in other business processes TCF socket in oracle applications usage: TCF socket is a secondary service component/additional service component. TCF stands for - Thin Client Framework TCF is a server process that uses JDBC thin drivers to manage connections for hierarchy editor applications. Some good examples of hierarchy editor applications are object navigator. Profile options used by TCF are : TCF:host TCF:port A list of parameters in context file pertaining to TCF are given below : 1) s_tcfport - Port used by TCF 2) s_tcfname - Name of TCF process 3) s_tcflog - Location of log file for TCF process 4) s_tcftimeout - Timeout setting for TCF process 5) s_tcfctrl - Location of the control script for TCF process We can validate the TCF configuration using the following URL : http://[hostname]:[port]/oa_servlets/oracle.apps.fnd.tcf.SocketServer Use the following GUI navigation : System Administration - > Diagnostics - > TCF Status Application Menu Oracle timbo internationalization : Timbo is an open source project undertaken by Oracle Corporation.It supports internationalization. Timbo is a message catalog library. It is a simple hashed database of message indexes.The message sources are XML specified by timbo.dtd. Timbo Tools : mktimbo - creates a library from XML source. mktimbolate - creates and merges language-specific sources from the main source file. timboget - queries message libraries from the command line. po2timbodoes - a simple translation of the English source to the initial englishTimbo file. The tools have dependancies on Glib 2 and libxml 2. po2timbo depends onPerl. If we only wish to build the library, specify --disable-toolsas an argument to configure em2go oracle mobile architecture: Oracle Enterprise Manager EM2Go is a mobile architecture that enables the management of application from the mobile devices like PDA(personal digital assistant). EM2Go can be installed as a part of Oracle Enterprise Manager(OEM). EM2Go offers mobile security as its architecture is based on https and security model of administrator and roles. EM2Go can be used by DBA and sysadmins to get details on various resources like host,database via PDA.So resources can be controlled from a remote location. EM2Go access the targets via URL which is OEM GUI.Username and password prompt appears when we loginto the system. After logging in we are provided with a inituitive interface similar to a Grid console. From the console we can check the availability and health of the Oracle environment. EM2Go home page has the following sections. 1) Alert and availability helps to investigate the problem that generated the alert 2) Target section displays metrics on targets. Targets managed are host and database. Following are the advantages of using EM2Go 1) The performance of targets can be monitored.We can monitor the health of host,availability and performance metrics of Oracle Application Server. 2) We can schedule notifications to be sent via email to the PDA. 3) EM2Go provides a console to enter and execute SQL and OS commands.For example we can use os commands like top,uptime to get details on host. What is OWB? Oracle Warehouse Builder (OWB) is an information integration tool that leverages the Oracle Database to transform data into high-quality information. The Oracle Database is a central component in the Warehouse Builder architecture because the Database hosts the Warehouse Builder repository and the code generated by Warehouse Builder. What are the major components of warehouse builder? Oracle Warehouse Builder(OWB) is composed of Design centre,Control center manager,target schema,Warehouse builder repository,Repository browser,control center service. What is OMB Plus? OMB plus is a flexible, high-level command line metadata access tool for Oracle Warehouse Builder. We use OMB Plus to create, modify, delete, and retrieve object metadata in Warehouse Builder design and runtime repositories. What is the Scriping language used to manipulate OWB? OMB Plus is a scripting language used to manipulate object and runtime repositories of OWB.OMB Plus is an extension TCL Programming language and hence has variable constructs,looping and control structures. Where are the SQL scripts located in OWB? OWB scripts are installed at owbrtpsql and are used for managing deployment jobs,execution jobs,control centers from SQL*PLUS. How do you launch OMBPlus at Unix Prompt? We can alunch OMB plus at the unix prompt using OWB_HOME/owb/bin/unix/OMBPlus.sh How do you connect to a OWB repository from OMB Plus? From OMB Plus console enter the following : OMBCONNECT repos/password@host:port:service_name USE WORKSPACE wokspace_name Oracle warehouse builder components schema deployment knowhow: OWB is a datawarehousing solution from oracle that has features for designing,implementing,managing data warehouses.It is made up of the following components: 1) Design centre - It is a browser based user interface used to design the ETL processes. 2) Repository - The database used to store the metadata about OWB.It can be hosted in Oracle Database10gR2(standard edition,enterprise edition),Oracle Database 11g(standard edition,enterprise edition).Personal and express editions are not supported.Repository assistant can be used to create workspaces in Repository that is used to isolate development,test,production environments.It has mappings to target schema which is the table that stores the OWB data after mapping and process flows. 3) Repository Browser - It is a user interface used to browse metadata,monitor and view metadata in the repository. 4) Control centre manager - It is a part of design center which manages communication between repository and design centre. 5) Control centre service - It is a server side component that manages the target schema operations Oracle Workflow (2.6.4 and higher versions) are an integral part of latest OWB release. In previous versions it is imperative to download and install them separately.Oracle workflow is used for process flows. Oracle warehouse builder has components to design and deploy database objects.Design centre is used to design the database schema.Various objects are created in design centre and it is logical database design.Physical implementation of this logical design is done using control center manager. Logical design happens in design centre workspace.Target schema is created using control centre manager. Few objects deployed in target have ETL logic embedded in them. For example a PL/SQL program with mapping logic for extracting source data,transform and load data into target table could have been a part of design. In such cases execution step comes to play.It is mandatory for user to have COMPILE privilege for execution to happen.In such cases mapping logic is executed and ata is loaded into target schema. For more details see: http://download.oracle.com/docs/cd/B28359_01/owb.111/b31278/concept_deploy.htm#sthref984 Schema Password Repository Creation oracle fusion middleware: Just as we choose same password for all the default database accounts say SYS,SYSTEM,SYSMAN,DBSNMP, we can choose same password for all the schemas or different passwords while creating a repository using repository creation utility. 1) We can specify same schema passwords for all the schemas 2) We can make use of main schema password for auxillary schema 3) We can make use of different schema passwords for different schemas Value of Custom Variable Master Repository ID(001) is invalid. Value should be a number: I tried installing and creating a repository using repository creation utility. I specified the value of Master Repository ID as a alphabetic name. I got the following error : Value of Custom Variable Master Repository ID(001) is invalid. Value should be a number. solution : I changed it to number and the issue got fixed. It is to be noted that even the work repository ID should be a valid numeral.