iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

Advanced - Application Server

 

 

 

 

 

 

 

 

Lesson 04

"Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world."

-Albert Einstein (1879-1955)

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:

A website-based application for purchasing products.

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 

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