OpenLane
™
5.3 Distributed Database Configuration
Quick Start Instructions
Document Number 7800-A2-GZ43-30
September 2000
Distributed Databases
OpenLane™ 5.3 supports a distributed architecture with either an Oracle 8i SQL database or a Sybase database. Refer to:
Oracle Integration on page 2.
Sybase Integration on page 6.
Refer to OpenLane 5.3 Distributed Components Configuration Quick Start Instructions, Document No. 7800-A2-GZ44, for Web server and Distributed Poller/Reader information.
Product Documentation Online
Complete documentation for this product is available at www.paradyne.com. Select Library → Technical Manuals → OpenLane Network Management
Solutions.
Document Number Document Title
7800-A2-GZ41 OpenLane 5.3 Service Level Management for UNIX Quick Start Installation Instructions
7800-A2-GZ42 OpenLane 5.3 Service Level Management for Windows Quick Start Installation Instructions
7800-A2-GZ44 OpenLane 5.3 Distributed Components Configuration Quick Start Instructions
7800-A2-GZ46 OpenLane SLM Oracle Database Administration Reference
Oracle Integration
OpenLane 5.3 supports a distributed architecture with an Oracle 8i SQL database. The following Oracle 8i integration procedure includes the necessary steps to configure OpenLane 5.3 to support an Oracle 8i (Standard or Enterprise) database for the storage of performance data.
Assumptions:
Oracle 8i Standard or Enterprise is installed, and
An Oracle 8i DBA (Database Administrator) is available to create the necessary table space and schema.
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:
Procedure
1. Install OpenLane 5.3 on the OpenLane Management server. 2. Locate the file oracleSchema.dat. This file is located in:
— UNIX: /opt/pdn/OpenLane/data/sql/schema
— Windows: \opt\pd\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.3 schema.
After the Oracle DBA has created a Tablespace with the OpenLane 5.3 schema, fill out the following information. You will need this information to run the dbconfig function of OLCmd.
Tablespace Fields Tablespace Field Values Oracle Server IP Address or Name
For this procedure example, the following values are used. When running the
dbconfig function of OLCmd, substitute your real information from the previous worksheet.
4. To disable the existing Cloudscape database, stop OpenLane if it is running:
OlControl stop. Edit the appropriate OLControlConfig file in the OpenLane home directory:
— UNIX: /opt/pdn/OpenLane/OLControlConfig
— Windows: \opt\pdn\OpenLane\OLControlConfig.bat
5. Change the entry DATABASE=1 to DATABASE=0 as shown below. Example of the OLControlConfig file (UNIX):
OL_HOME=/opt/pdn/OpenLane APACHE=/opt/apache/bin JRE_HOME=/bin/../java/bin/../bin SLEEP=10 DOMAIN=default READER_DOMAIN=default PARAMS= RMI=2099 LDAP=3890 DATABASE=1 ← Change to 0 WEBSERVER=1 MGMTSVCS=1 UHPOLLER=1 UHREADER=1 SNMPPOLLER=0 SCMPOLLER=1 SCHEDRPTS=0 DIRSVCS=1
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
6. To configure OpenLane 5.3 to use the Oracle database, you will need to run the dbconfig function of OLCmd.
Run OLControl start to start the OpenLane 5.3 system.
Run the dbconfig function of OLCmd to configure the OpenLane 5.3 system to use the Oracle database. The OLCmd (UNIX) or OLCmd.bat (Windows) file is located in:
— UNIX: /opt/pdn/OpenLane
— Windows: \opt\pdn\OpenLane
OLCmd dbconfig options:
NOTE:
OLCmd dbconfig input: — UNIX: use single quotes. — Windows: use double quotes.
— UNIX OLCmd dbconfig command example:
OLCmd dbconfig ’-d o -m merlin.paradyne.com:1521 -n OLDB -u pdyn -p pdyn’
— Windows OLCmd dbconfig command example:
OLCmd dbconfig ”-d o -m merlin.paradyne.com:1521 -n OLDB -u pdyn -p pdyn”
Command Option
–d Database type (c=Cloudscape; o=Oracle; s=Sybase) –m Host running the Oracle database plus port number –n Oracle SID
–u Database user login name –p Database user password
7. Run the dbconfig function of OLCmd with the ’–l’ list option (UNIX) or
“–l” list option (Windows) option to verify your entries. The following is an
example of the output 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 3.
The DefaultStatsDB instance entry should resemble:
Database Instance: DefaultStatsDB
rawUrl: jdbc:oracle:thin:@$host$:$dbName$ host: merlin.paradyne.com:1521 dbname: OLDB user: pdyn password: pdyn driver: oracle.jdbc.driver.OracleDriver dupKeyErrorCode: 1 statMapName: defaultStatMap calcMapName: defaultCalcMap rawSqlName: oracleRawSql oidMapName: defaultOidMap statsFeedClass: pdn.uhpoller.feed.UHSqlStatsFeed statsAgeClass: pdn.uhpoller.age.UHSqlStatsAge
Sybase Integration
OpenLane 5.3 supports a distributed architecture with a Sybase SQL database on Sun Solaris, version 2.6 or later. The following Sybase integration procedure includes the necessary steps to configure OpenLane 5.3 to support a Sybase database for the storage of performance data.
Assumptions:
Sybase Adaptive Server Enterprise Version 11.9.2 or 12.0 is installed, and
A Sybase DBA is available to create the necessary schema.
The Sybase database can be installed on the OpenLane Management server or loaded on a remote database server. If the Sybase 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 Sybase, proceed with the following steps to create all the metadata tables required for JDBC classes.
Procedure
After installing OpenLane 5.3 on the OpenLane Management Solaris server: 1. Edit the OLControlConfig file. Change the entry DATABASE=1 to
DATABASE=0 as shown below.
Example of the OLControlConfig file:
OL_HOME=/opt/pdn/OpenLane APACHE=/opt/apache/bin JRE_HOME=/bin/../java/bin/../bin SLEEP=10 DOMAIN=default READER_DOMAIN=default PARAMS= RMI=2099 LDAP=3890 DATABASE=1 ← Change to 0 WEBSERVER=1 MGMTSVCS=1 UHPOLLER=1 UHREADER=1 SNMPPOLLER=0 SCMPOLLER=1
3. Run OLControl start to start the OpenLane 5.3 system. Run the
dbconfig function of OLCmd to configure the OpenLane 5.3 system to use the Sybase database. The OLCmd file is located in:
/opt/pdn/OpenLane
OLCmd dbconfig options:
Command example (use single quotes):
OLCmd dbconfig ’-d s -m merlin.paradyne.com:4100 -u pdyn -p pdyn’
4. Run the dbconfig function of OLCmd with the ’–l’ list option to verify your entries. The DefaultStatsDB instance entry should resemble:
Database Instance: DefaultStatsDB rawUrl: jdbc:sybase:Tds:$host$ host: merlin.paradyne.com:4100 dbname: Name_of_the_database user: pdyn password: pdyn driver: com.sybase.jdbc2.jdbc.SybDriver dupKeyErrorCode: 2601 statMapName: defaultStatMap calcMapName: defaultCalcMap rawSqlName: sybaseRawSql oidMapName: defaultOidMap statsFeedClass: pdn.uhpoller.feed.UHSqlStatsFeed statsAgeClass: pdn.uhpoller.age.UHSqlStatsAge
NOTE:
Sybase default listening port is 4100. Specify the port number configured during Sybase server installation.
5. Edit $APACHE/conf/jserv.properties. Search for
wrapper.classpath=. Add the following line:
wrapper.classpath=$OL_HOME/classes/jconn2.jar
6. In /opt/pdn/OpenLane, locate the command olCreateSybTables. Copy this file and sybaseSchema.dat file to the Sybase machine. To create the Sybase tables on the Sybase machine, run the command:
Command Option
–d Database type (c=Cloudscape; o=Oracle; s=Sybase)
–m Host running the Sybase database plus port number
–u Database user login name
7. On the client machine (same as the server machine if this is a standalone installation), download the Sybase JDBC. Go to: http://www.sybase.com, locate the Downloads section, and find the link for jConnect. Download the jConnect 5.2 zip file. After downloading the file:
— Unzip the jConnect file to: /opt/sybase/jdbc
— Change to directory /opt/sybase/jdbc/sp and enter:
JDBC_HOME=/opt/sybase/jdbc Export JDBC_HOME
CLASSPATH=$CLASSPATH:$JDBC_HOME/classes:$DB_DRIVER Export CLASSPATH
8. Check the Sybase server version:
dataserver -v
If the version is Sybase Adaptive Server Enterprise (ADE)12.0, run:
java IsqlApp –U<sa> –P<password> –S<jdbc:sysbase:Tds:[hostname]:[port]> –I<$JDBC_HOME/sp/sql_server12.sql> –cgo
If the version is not Sybase ADE12.0, run:
java IsqlApp –U<sa> –P<password> –S<jdbc:sysbase:Tds:[hostname]:[port]>
–I<$JDBC_HOME/sp/sql_server.sql> –cgo
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:
Internet: Visit the Paradyne World Wide Web site at www.paradyne.com. (Be sure to register your warranty at www.paradyne.com/warranty.)
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 [email protected]. 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.