How many different development topologies you may have?

1.        Java developer topology

2.        Departmental Topology

3.        Development life-cycle support topology

 

When do you use the development topology?

We use the development topology for the following scenario:

1. A website-based application for purchasing products.

2. A website-based application for any online processes.

How to install Distributing OracleAS Infrastructure components using an existing database?

Set up the Oracle variables environment

   # export ORACLE_SID=your-instance-name

   # export ORACLE_HOME=your-oracle-home-directory

   # export PATH=$PATH:$ORACLE_HOME/bin

Start the database listener and the database if there not up.

   # lsnrctl start

   # sqlplus “sys/your-password@your-service-name as sysdba”

   SQL> startup

Check database version

   # sqlplus “sys/your-password@your-service-name as sysdba”

   SQL> select version from product_component_version

         Where product like ‘Oracle%’

         /

Check initialization parameters

   # sqlplus “sys/your-password@your-service-name as sysdba”

   SQL> select name, value from v$parameter;

Parameter	Required Value
aq_tm_processes    db_block_size    db_cache_size    java_pool_size    job_queue_processes    large_pool_size    max_commit_propagation_delay      open_cursors    pga_aggregate_target    query_rewrite_enabled    squery_rewrite_integrity    sessions    shared_pool_size	1 or greater 8k or greater 150meg or more 67k or more 1 or more 0 Less 100 300 or more 96meg or more TRUE trusted or enforced 400 or more 100meg or more

Check required database option

   SQL> select * from v$option; BIT-map indexes, Materialized view rewrite,

      Materialized view warehouse refresh, OLAP Window Functions,

      Parallel execution, Parallel Load, and Partitioning.

   SQL> select count(*) from dba_objects   

      Where object_type like ‘JAVA%’ and owner = ‘SYS’ and status = ‘VALID’; -- result > 0 for java

   SQL> select count (name) from sys.props$

      Where name = ‘EXPORT_VIEWS_VERSION’;  -- result > 0 for Intermedia

Check required PL/SQL packages

   SQL> select count(object_name) from all_objects

      Where object_name like ‘blow-package’ and status = ‘VALID’; -- result > 0 for following

      DBMS_AQADM, DBMS_DDL, DBMS_LDAP, DBMS_LOCK,

      DBMS_OBFUSCATION_TOOLKIT, DBMS_OUTPUT, DBMS_REPUTIL,

      DBMS_SHARED_POOL, DBMS_SQL, DBMS_STATS, DBMS_UTILITY,

      DBMS_FILE, DBMS_RAW

Check registration with Oracle Internet Directory

   Note that the existing database is not already registered with any Oracle Internet Directory (OID).

   If it is, then you may get unexpected problem during runtime.

   To find if a database is already register, do the following:

   # cd $ORACLE_HOME/bin

   # ./dbca

   If the database configuration assistant displays the directory service screen, which

   enables you to de-register the database, then the database is already registered.

   Make sure to de-register it.

Run OracleAS “RepCA” to install the Metadata Repository in an existing database

   To run the Oracle Application Server Repository Creation Assistant (RepCA):

   # runRepca –OH $ORACLE_HOME –LOGDIR $ORACLE_HOME/assistants/repca/log

Install OracleAS Infrastructure using the above existing metadata repository

   # ./location-of-your-cd-rom/runInstaller   -- after inserting the OracleAS

   Define a new location and select infrastructure with Identity Management.

   Select Oracle Internet Directory, OracleAS Single Sign-On,

        Oracle Delegated Administration Services, Oracle Directory Integration and Provisioning.

   Answers all the questions:

   Note that the Oracle port assignments are in $ORACLE_HOME/<sid>/install/portlist.ini

 

How do you establish high availability concepts in the Oracle Application Server?

   High availability is defined by the percentage of time that your server works normally.

   You can use hardware cluster for failover to build High availability.

   Hardware cluster is a collection of loosely coupled computers where a load balancer

      provides a single view of services.

   Failover is a process to relocate an application from failed node to a standby node.

   You can install as many redundant infrastructures in many servers.

   You can install as many J2EE and Web Cache Middle-Tier instance.

  

How can you create a J2EE and Web Cache Cluster?

   Assuming you have two J2EE and web caches installed.

   $ORACLE_HOME/webcache1

   $ORACLE_HOME/webcache2

   Their port assignments are in the

   $ORACLE_HOME/webcache(1 or 2)/install/portlist.ini files.

   Go to webcache1 to create cluster:

   http://hostname1:4000     -- log on as the “administrator” userid.

   Click Clustering under Properties. In the new page, select the cluster member and

   click Edit Selected, enter a new name, submit and restart web cache.

   Go to webcache2 to add the web cache to cluster.

   Click Clustering under Properties and then click “Add.” Enter information and submit.

   In Cache operations, select the new cache cluster and then click Propagate. Then

   select all cache and click Restart.

 

How do you find the DCM user password?

   Go to the oidadmin tool, log as “orcladmin”

   cn = OracleContext

      cn = Products

         cn = IAS

         IAS Infrastructure Databases

         orclReferenceName=<database-name>

         OrclResourceName=DCM

 

How do you deploy an application to OC4J?

First you should create an OC4J instance. In the OC4J control page, click on the Application tab. In this page, you can deploy EAR or WAR files. In the deploy application page, type the J2EE application location, application name, and select “default” as Parent Application. Click the Finish bottom after you entered the URL mapping for your Web Modules for example /myapplication. To point your browser to your application just type: http://<host-name>:<HTTP listener port>/myapplication.

 

How do you administer OracleAS business intelligence components?

In this section, you will learn how to access business intelligence home pages, identify the different components running, start, stop and restart instances.

# $ORACLE_HOME/bin/emctl stop iasconsole   -- to stop or start enterprise manager

# $ORACLE_HOME/bin/opmn/bin/opmnctl stopall  -- to stop or start all bi components.

To run a report using url:

http://<hostname>:<httpServerPort>/reports/paramform.jsp?userid=.../...@databasname

To run a form using url:

http://<hostname>:<httpServerPort>/forms90/f90servlet?form=your-form-name

To compile the forms:

# f90genm.sh your-form-name.fmb userid=username/password@your-database