experience
ORACLE
for Streams
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Oracle Streams Commander
Stefan Menschel Master Principal Sales Consultant BU Server Technology Germany
DB / Grid Control versus OSC
Feature Installation Repository Number of Targets Oracle Streams Configuration Single Source Replication Config Multiple Source Replication Config Hub & Spoke Configuration Downstream Capture Config Browser Requirements Database Authentication Authentication of Admin Functions Component based on
DB Control (Grid Control) Database Installation (Separate) In each Database (Repository DB) One Database (All Databases) Two Databases Yes No No No MS IE 5.5 + Multiple Times No Java
Oracle Streams Commander Separate Installation Source Database All Oracle Streams Databases Up to four Databases Yes Yes Yes Yes Any (Firefox recommended) One Time at HTTP-Server Start Yes PL/SQL
Oracle Streams Commander
Architektur
OSC – Web Frontend Oracle HTTP-Server
OSC-Repository im „Streams“ Schema
DB-Link
OSC Objekte im „Streams“ Schema
repliziertes Schema
Database A
Database B
Oracle Streams Commander (OSC)
Oracle Streams Commander is a browser-based administration Tool to monitor and manage an Oracle Streams Environment. OSC is written in PL/SQL. Before you can use the OSC you must install the OSC Repository in the Oracle Source Database. Oracle Streams Commander required a HTTP-Server to make the HTML pages visible to the Oracle Streams (Database) Administrator. If you don‘t have one please install it. Configure your HTTP-Server like Oracle Streams Commander needs. You can use any Browser to interact with the Oracle Streams Commander but Oracle recommended “Firefox”.
Oracle Streams Setup
1. Download Oracle Streams Commander: http://www.oracle.com/global/de/community/platform/index.html 2. Choose the Kind of Data Replication (e.g.: Multimaster or Hub & Spoke) 3. Configure the „00_define.sql“ Script 4. Run the appropriate Oracle Streams Setup SQL-Scripts
OSC needs a HTTP-Server
Oracle Streams Commander is a tool written in PL/SQL Web PL/SQL functions require a HTTP-Server If you dont have an HTTP-Server please install one first You can install in one of your existing nodes or in another node In case of another node, this node must have the same tnsnames.ora file how your replication system. You can use an Apache HTTP-Server or an Oracle HTTP-Server:
e.g.: Oracle HTTP-Server 10.1.3.3.0 (Windows 32-Bit) from: http://www.oracle.com/technology/software/products/database/oracle11g/111060_win32soft.html http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxsoft.html
OSC – HTTP-Server Installation
HTTP-Server Installation and Configuration
Installation (1)
HTTP_HOME
D:/oracle D:/oracle/ora111
$ORACLE_BASE $ORACLE_HOME
D:/oracle/http111
HTTP_HOME
Choose OSC-File locations
Recommendation: Create a new subdirectory „osc“ in $ORACLE_HOME or HTTP_HOME
Documentation
D:/oracle/osc/ /home/oracle/osc
Icons
D:/oracle/osc/icons /home/oracle/osc/icons
Installation (2)
Choose OSC-File locations
Recommendation: Create a new subdirectory „osc“ in $ORACLE_HOME or HTTP_HOME
Documentation
D:/oracle/osc/ /home/oracle/osc
Icons
Copy OSC Structure from Stick
D:/oracle/osc/icons /home/oracle/osc/icons d:/oracle/osc /home/oracle/osc
Copy OSC-images files:
d:/oracle/osc/02 INSTALLATION OSC/OSC-SOURCE/icons /home/oracle/osc/02 INSTALLATION OSC/OSC-SOURCE/icons
d:/oracle/osc/icons /home/oracle/osc/icons
Configuration (1)
Modify „httpd.conf“ and „dads.conf“ Apache HTTP-Server: HTTP_HOME/Apache/Apache/conf/httpd.conf HTTP_HOME/Apache/modeplsql/conf/dads.conf Oracle HTTP-Server (10.1.3.3.0): d:/oracle/http111/ohs/conf/httpd.conf d:/oracle/http111/ohs/modplsql/dads.conf
Add the following lines to „httpd.conf“: Windows: Alias /osc_docu/ Alias /osc/ Alias /osc_docu/ Alias /osc/ „d:\oracle\osc\DOCUMENTATION/" „d:\oracle\osc\icons/" "/home/osc/DOCUMENTATION/" "/home/osc/icons/"
UNIX / Linux:
Configuration (2)
Add the following DAD to „dads.conf“: SetHandler pls_handler Order deny,allow Allow from all AllowOverride None PlsqlDatabaseUsername strmadmin PlsqlDatabasePassword strmadmin PlsqlDatabaseConnectString hostname:port:sid PlsqlDefaultPage inhalt PlsqlErrorStyle DebugStyle Restart the HTTP-Server !!!
Start All Programs HTTP_HOME Oracle Process Manager
Please adapt this to your requirements!
Oracle Process Manager Stop Oracle Process Manager Start
HTTP-Server Test
Connect with SQLPlus
sqlplus strmadmin/strmadmin@"hubdb„
SQL> CREATE PROCEDURE testosc is BEGIN HTP.P('hello world'); END; /
Open your browser and enter the following link:
http://yournodename:7777/pls/osc/testosc
(Test procedure)
If your HTTP-Server listening on another port then change the 7777 port. If you dont get the message "hello world", check your settings in tnsnames.ora and the settings for proxy in your browser.
http://yournodename:7777/osc/oracle.gif
(Test image)
If you dont get the oracle image, check your settings for the „osc“ alias in „httpd.conf“
http://yournodename:7777/osc_docu/start.htm
(Test documentation)
If you dont get the documentation, check your settings for the „osc_docu“ alias in „httpd.conf“
New OSC Version – What is do to?
Only three steps:
1. Replace the Docu- and the Icon-Files 2. Update entries in „00_define.sql“ 3. Run the OSC installation scripts
Restart the HTTP-Server !!!
experience
ORACLE
for SAP