1
7800-A2-GZ43-00 March 2000
OpenLane
t
5.1 Oracle 8i Integration
Quick Start Instructions
Document Number 7800-A2-GZ43-00
March 2000
Oracle Integration
OpenLanet 5.1 supports a distributed architecture with an Oracle 8i SQL database. The following Oracle 8i integration procedure includes the necessary steps to configure OpenLane 5.1 to support an Oracle 8i (Standard or Enterprise) database for the storage of performance data.
Assumptions:
H Oracle 8i Standard or Enterprise is installed, and
H An Oracle 8i DBA (Database Administrator) is available to create the necessary table space and schema.
Product Documentation on the World Wide Web
We provide complete product documentation online. This lets you search the documentation for specific topics and print only what you need, reducing the waste of surplus printing. It also helps us maintain competitive prices for our products.
Complete documentation for this product is available at www.paradyne.com. Select Library → Technical Manuals → Network Management Solutions. Document Number Document Title
7800-A2-GZ41 OpenLane 5.1 Service Level Management for UNIX Quick Start Installation Instructions
7800-A2-GZ42 OpenLane 5.1 Service Level Management for Windows NT Quick Start Installation Instructions
7800-A2-GZ44 OpenLane 5.1 Web Server Distribution Quick Start Instructions
7800-A2-GZ45 OpenLane 5.1 Distributed Poller Quick Start Instructions
To order a paper copy of a Paradyne document:
H Within the U.S.A., call 1-800-PARADYNE (1-800-727-2396)
Installing the Oracle Database
The Oracle database can be installed on the OpenLane Management server or loaded on a remote database server. If the Oracle database is installed on a remote server, make sure that you can reach this server over the network from the OpenLane Management server. After installing Oracle, proceed with these steps:
"
Procedure1. Install OpenLane 5.1 on the OpenLane Management server. 2. Locate the file oracleSchema.dat. This file is located in:
— UNIX: /opt/OV/pdn/OpenLane/data/sql/schema
— Windows NT: /opt/OV/pdn/OpenLane/data/sql/schema
3. Transfer the oracleSchema.dat file to the system that is running the Oracle database. This file will allow the Oracle DBA to create the OpenLane 5.1 schema.
Oracle Tablespace Worksheet
After the Oracle DBA has created a Tablespace with the OpenLane 5.1 schema, fill out the following information. You will need this information to set up the OpenLane Management server.
Tablespace Fields Tablespace Field Values
Oracle Server IP Address or Name Oracle Listener TCP Port
Oracle SID Database Login Database Password
3
7800-A2-GZ43-00 March 2000
Disable the Cloudscape Database
To disable the existing Cloudscape database:
"
Procedure1. If running, stop OpenLane: OlControl stop. Access OLControlConfig. 2. Change the entry DATABASE=1 to DATABASE=0 as shown below.
Example of the OLControlConfig file:
OL_HOME=/opt/OV/pdn/OpenLane APACHE=/opt/apache/bin JRE_HOME=/bin/../java/bin/../bin SLEEP=10 DOMAIN=default PARAMS= RMI=1099 DATABASE=1 ← Change to 0 WEBSERVER=1 MGMTSVCS=1 UHLISTER=1 UHPOLLER=1 UHREADER=1 SNMPPOLLER=0 SCHEDRPTS=0
3. To configure OpenLane 5.1 to use the Oracle database, you will need to run the command DbConfig. For this example, the following values are used.
Tablespace Fields Tablespace Field Values Example
Oracle Server IP Address or Name merlin.paradyne.com Oracle Listener TCP Port 1521
Oracle SID OLDB
Database Login pdyn Database Password pdyn
4. Run OLControl start to start the OpenLane 5.1 system. Run the command DbConfig to configure the OpenLane 5.1 system to use the Oracle database. The DbConfig file is located in:
— UNIX: /opt/OV/pdn/OpenLane
— Windows NT: \pdn\OpenLane DbConfig options:
Command Option
-d Database type (c=Cloudscape; o=Oracle)
-m Machine running the Oracle database plus port number
-n Oracle SID
-u Database user login name
-p Database user password
— UNIX DbConfig input:
’–d o –m merlin.paradyne.com:1521 –n OLDB –u pdyn –p pdyn’
— Windows NT DbConfig input:
”–d o –m merlin.paradyne.com:1521 –n OLDB –u pdyn –p pdyn”
NOTE:
DbConfig input:
— UNIX: use single quotes.
— Windows NT: use double quotes.
5
7800-A2-GZ43-00 March 2000
Paradyne.ldif File Example
Following is an example paradyne.ldif file after DbConfig is run and the file has been updated by the directory services process. The entries in this example reflect the Oracle information used in the example in Step 4 on page 4.
You can refer to this example to modify the paradyne.ldif file manually for Oracle support. Make sure you edit the entries under the DefaultStatsDB
area. dn: DefaultStatsDB,Core,Applications,ou=Paradyne OpenLane,o=Paradyne Corporation,c=US raw_sql: oracleRawSql rn: DefaultStatsDB feed_class: pdn.uhpoller.feed.UHSqlStatsFeed age_class: pdn.uhpoller.age.UHSqlStatsAge uri: jdbc:oracle:thin:@$host$:$dbName$ dup_err_code: 1 objectclass: pdn_database driver: oracle.jdbc.driver.OracleDriver password: pdyn host: merlin.paradyne.com:1521 cn: DefaultStatsDB db_class: DatabaseAdapter dbname: OLDB calc_map: defaultCalcMap sn: DefaultStatsDB oid_map: defaultOidMap user: pdyn stats_map: defaultStatMap
Oracle Tablespace Reference Table
Tablespace Fields Tablespace Field Values
Oracle Server IP Address or Name Oracle Listener TCP Port
Oracle SID Tablespace Name Tablespace Size Data Base File Name
Temporary Tablespace Name Temporary Tablespace Size Temporary File Name Database Login Database Password
Warranty, Sales, Service, and Training Information
Contact your local sales representative, service representative, or distributor directly for any help needed. For additional information concerning warranty, sales, service, repair, installation, documentation, training, distributor locations, or Paradyne worldwide office locations, use one of the following methods:
H Internet: Visit the Paradyne World Wide Web site at www.paradyne.com.
(Be sure to register your warranty at www.paradyne.com/warranty.)
H Telephone: Call our automated system to receive current information by fax
or to speak with a company representative. — Within the U.S.A., call 1-800-870-2221 — Outside the U.S.A., call 1-727-530-2340
Document Feedback
We welcome your comments and suggestions about this document. Please mail them to Technical Publications, Paradyne Corporation, 8545 126th Ave. N., Largo, FL 33773, or send e-mail to userdoc@paradyne.com. Include the number and title of this document in your correspondence. Please include your name and phone number if you are willing to provide additional clarification.
Trademarks
OpenLane is a trademark of Paradyne Corporation. All other products and services mentioned herein are the trademarks, service marks, registered trademarks, or registered service marks of their respective owners.