• No results found

Product Documentation on the World Wide Web

N/A
N/A
Protected

Academic year: 2021

Share "Product Documentation on the World Wide Web"

Copied!
6
0
0

Loading.... (view fulltext now)

Full text

(1)

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)

(2)

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.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)

3

7800-A2-GZ43-00 March 2000

Disable the Cloudscape Database

To disable the existing Cloudscape database:

"

Procedure

1. 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)

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)

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

(6)

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.

*7800-A2-GZ43-00*

References

Related documents

Guided tissue regeneration in intrabony periodontal defects following treatment with two bioabsorbable membranes in combination with bovine bone mineral graft. The

• Attach image or text file documentation to procedures • Optional electronic signing of work order records • Email notifications for newly created and completed WOs • In or

Therefore a focus group enable us to answer the research questions regarding potential reverse mortgage borrowers’ perceptions and fulfill the purpose of getting

The university also offers an interdisciplinary doctoral degree program through the Center for Interdisciplinary Research and Graduate Education (CIRE).. This initiative offers

We show for the first time that aerosol particles generated from both subsurface and microlayer seawater from the highly productive Eastern Tropical North Pacific Ocean

Oracle 8i & 9i Clients v7, v8, v9 Oracle Clients (ldap.ora ) (sqlnet.ora) Oracle Database Oracle Internet Directory Server Oracle 9i Names Server Proxy LDAP LDAP SQL NET SQL

was, were, be, been, being ) is used before the Third Form of the main Verb according to the Number and Person of the Subject and Tense of the Verb.. The different forms of the Verb

Install and Configure Oracle Database Create and manage storage structures Administer the Oracle Database.. Backup