iSelfSchooling.com - Since 1999  References  |  Job Openings
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

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

BASICS

SQL | PL/SQL

DEVELOPERS

FORMS 2 | REPORTS | Other TOOLS

DBAs

FUNDAMENTALS 2 | PERFORMANCE | OEM

ADVANCE

APPLICATION SERVER | GRID CONTROL | ARTICLES 2 3 4

Advanced - Application Server

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 | Lesson 30 | Lesson 31 | Lesson 32 | Lesson 33 | Lesson 34 | Lesson 35 |

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

 

 

 
 
Google
 
Web web site