Oracle Openworld Directory Index

Today’s Agenda
Oracle iPortal Overview
What can I use it for?
Installation
Portlets
URL Services
Deployment
Portals, The New e-business Desktop



Portal - A single sign-on window into a users work-environment,
a Web-Top. Accessible by Internet Browser or even by wireless
connectivity.

Portals are personalized and enable users to create and publish
web pages without the need of IT staff.

Portals are great for content management.

Portals are a quick and easy tool for developing new and
exciting Web Apps (portlets).

“With a portal built on Oracle9i, you won't need an army of programmers and administrators to deploy and manage your mission-critical web sites.
”

Application Integration
Portlets can bring disparate systems together into one user Interface. Portal utilizes a Single Sign-On architecture to enable a single point of access to all applications.
Application Development
Develop simple database applications very quickly and easily utilizing Portal Wizards
Application Deployment
Quickly deploy applications to the Web via Portal Portlets

Install Oracle software - different Oracle Homes
Oracle 8i Database Server - do not install HTTP Server
Oracle 9i Application Server
Create Oracle 8i Database
Verify SQL*Net connectivity
Check HTTP Server running correctly
Create Tablespaces to support Oracle Portal
Default, DOC, LOG and TEMP
Configuration Assistant or Manual install

Shared Pool - at least 50MB
Open Cursors - recommend at least 100 based on activity - more users, increase open_cursors
DB Block Buffers - should be adjusted as necessary for better performance.
System Tablespace - 2-3 times available
Shared Pool Reserved Size - 1/2 of SHARED_POOL
Java Pool - at least 20MB

Will install Portal and Login Server, 1 1/2 to 3 hour execution time
Check the server name in HTTPD.CONF on NT, should be in lower case
Access Portal via http://myserver/pls/portal30
After using the configuration assistant, if you receive error referencing no configuration information (WWC-41439), run ssodatan manually and be careful with the URL’s

Copy 8.1.7 tnsnames to 9ias
HTTPD.CONF changes
Scripts
$ORACLE_HOME/portal30/admin/plsql
onetime - installs OWA packages
winstall - installs Oracle Portal
ssodatan - associates a Login Server with a Portal installation
$ORACLE_HOME/portal30/admin/plsql/wwu
contimp - installs Oracle Portal Help

Installs OWA Packages

-p sys_password The Oracle Database password for the Oracle SYS user
-l logfile Log file name of this script
-c connect_string Optional string to connect to a remote database


onetime -p change_on_install -l onetime.log -c oow1




Creates the Portal Node on an existing DB instance
-s iportal_schema Oracle Database schema for iPortal database objects
-p sys_password The Oracle Database password for the Oracle SYS user
-u default_tablespace Install iPortal objects in this tablespace
-t temporary_tablespace User this tablespace for temporary objects
-d document_tablespace Install iPortal document table in this tablespace
-l logging_tablespace Install iPortal logging tables in this tablespace
-o sso_schema Oracle Database schema for Login Server objects
-c connect_string Optional string to connect to a remote database

winstall -s portal30 -p change_on_install -u appserver -t appserver_tmp -d appserver_doc -l appserver_log -o portal30_sso -c oow1

Access Portal via http://myserver/pls/portal30

Associates a Portal Node to a Login Server - all URL’s must include an ending slash

-w portal_url URL that points to the Portal product host and DAD.
-l login_server_url URL that points to the Login Server host and DAD.
-s portal_schema Oracle Database schema for Portal database objects.
-p portal_password Oracle Database password for Portal schema.
-o sso_schema Oracle Database schema for Login Server objects.
-d sso_password Oracle Database password for Login Server schema.
-c portal_connect_string Optional connect string to a remote Portal database.

ssodatan -w http://mymachine/pls/portal30/ -l http://mymachine/pls/portal30_sso/ -s portal30 -p portal30 -o portal30_sso -d portal30_sso -c oow1

Creates content area for Portal Help system

-s portal_schema Database account for Portal user
-p portal_password Database password for Portal user
-o from_portal_schema Database account for Portal user from where the Content Area was exported
-m merge_mode Mode used for merging imported data
reuse - which reuses existing objects instead of importing
new - which creates new objects if one exists already
-d dump_file_name Dump Filename for Oracle Export Utility
-c connect_string Optional connect string for remote database connection

contimp -s portal30 -p portal30 -o portal_help -m new -u database_user -d ../../../doc/site/hlp30ca.dmp -c oow1

Overview
Types
Database
Java
URL Services
Portal Development Kits
PL/SQL
Java


A portlet is a window into an application, which is displayed on a Portal Page. Enables a user to interface with other applications. Applications can be either Internal, External or Web Based.

Each portal page consists of content presented through one or more portlets.

Based on data stored within database
Implemented using Stored Procedures (Java or PL/SQL)
PL/SQL Portal Development Kit (PPDK)
Created using Portal API (PPDK) or Portal Wizards

Implemented using Java Technologies (JSP or Servlets)
Java Portal Development Kit (PDK)
Constructed using any Web -Capable Technology (CGI, Perl, C and yes even ASP) utilizing the PDK


URL Services allow developers to take any application written in any language and easily create integrated portlets.
Can be easily created using the PDK-URL Services.

Managing DAD’s (Database Access Description) can be done via the URL http://myserver.com/pls/admin_/gateway.htm
Enter username/password and alias for DB connection
No other modifications should be necessary
Use additional DAD’s as Portal Site entry point
DAD’s can also be manually administered via the file wdbsvr.app located at $ORACLE_HOME/Apache/modplsql/cfg

Current Database Versions - Portal Nodes
8.1.6.2.0 EE - Oracle Portal makes extensive use of 8.1.6 specific features (I.e. Native Dynamic SQL, Autonomous Transactions, nested tables, etc..)
8.1.7 EE & SE - is required if using interMedia Text option, which is required to support full text searches.
Connectivity from Oracle Node to remote Oracle Databases
All Database versions supporting SQL*Net 2.0 +