iSelfSchooling.com - Copyright © 1999-2009 iSelfSchooling.com ||  References  |  Job Openings
    Home  | Search more...  |  FREE Online VIDEO Oracle Training 

    Oracle Syntax  | Suggestions  | Private Tutoring

  Copyright & User Agreement

Email2aFriend  | Homepage us! |  Bookmark

Services

 Vision/Mission

 Services

 Biography

 Contact Us

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 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