Paradyne SLM 5.5 manual Rebuilding Oracle Database Indexes

Page 60

7. OpenLane Maintenance

Rebuilding Oracle Database Indexes

As records are added to and deleted from the database, indexes may become fragmented and index trees may increase in height, slowing access to the database.

The ol_rbldidx.sql script rebuilds indexes to maintain performance.

Indexes should be rebuilt weekly, or, if less frequently, as often as practicable.

Procedure

To rebuild the indexes of the database named OpenLane every Sunday morning starting at 12:15 am on a Solaris system:

1.Move /opt/pdn/OpenLane/data/sql/scripts/Oracle/ Maintenance/ol_rbldidx.sql to the $ORACLE_HOME directory.

2.Create a shell script:

ORACLE_HOME=/opt/oracle; export ORACLE_HOME;

ORACLE_SID=OLDB; export ORACLE_SID; /opt/oracle/product/8.1.6/bin/sqlplus

my_username/my_password @ol_rbldidx

For this example, presume the script is saved as:

/OL_Scripts/rebuild_ix

3.Create or a modify a crontab file with the entry:

15 0 * * sunday “/OL_Scripts/rebuild_ix“

For this example, presume the script is saved as:

/OL_Scripts/my_cronfile

4.Submit the crontab file to cron:

crontab /OL_Scripts/my_cronfile

7-8

January 2002

7800-A2-GB32-00

Image 60
Contents OpenLane SLM Copyright 2002 Paradyne Corporation All rights reserved Contents Installing OpenLane on Windows Configuring Distributed ComponentsApache User Access Authentication OpenLane Maintenance Building and Using a Firmware LibraryAdding Devices and Customer Profiles Using XML to Produce Reports OLCmd ReferenceIndex About This Guide Document Purpose and Intended AudienceDocument Summary Product-Related Documents Library → Technical ManualsEasy Installation Introduction to OpenLane SLMOpenLane SLM Network MonitoringOpenLane Features Installing OpenLane on Solaris Planning the InstallationAbout These Instructions Installation Requirements Minimum Hardware RequirementsSoftware Requirements Procedure Checking the Java Runtime Environment VersionUninstalling DCE Manager Uninstalling Performance WizardDCEinstall Cd /opt/OV/pdn/PerfWiz UnInstallToOVOpenLane Installation Program Opt/apacheOpt/pdn/OpenLane Obtaining a License Key Installing from Paradyne’s Web Site Setup.shUser = nobody Group = nobody Installing from CD-ROM Installing from FTP FilesInstalling Remotely Using Installing the Permanent License KeyExport DISPLAY=localhostname0.0 Setenv Display localhostname0.0Locating the License Key On an Installed System Migration to Current Release for OracleDisplaying the License Key Expiration Date OLCmd keyStarting OpenLane Web and Database Services Stopping OpenLane Web and Database ServicesConfiguring Apache to Use a Different Port Installing OpenLane on Solaris January Installing OpenLane on Windows MHz Processor Web Client Software Requirements Cd \opt\OV\pdn\PerfWiz uninstalltoov \Program Files\Apache Group\Apache \opt\apache\opt\pdn\OpenLane Procedure Cd \opt\pdn\OpenLane Migration to Current Release for Oracle Starting OpenLane Web and Database Services Stopping OpenLane Web and Database Services Http//olserver.com8080/openlane Installing OpenLane on Windows January Configuring Distributed Components OpenLane Distributed ComponentsSetting Up Web Server Distribution OpenLane in /opt/pdn/OpenLaneSolaris Operational Notes Http//172.20.1.10/OpenLaneSetting Up the Distributed Poller and Reader Distributed Poller/Reader Management Server SetupCd /opt/pdn/OpenLane OLControl stop Cd /opt/pdn/OpenLane/uhpoller mkdir pollerpoller1OLCmd Dbconfig ‘-m 172.20.1.10’ OLCmd Dbconfig ‘-m 172.20.1.101521’Cd /opt/pdn/OpenLane OLControl start OLCmd logsvcDistributed Poller/Reader Poller/Reader Setup DOMAIN=defaultREADERDOMAIN=default OLControl stop Apache User Access Authentication User Access AuthenticationConfiguring Http Challenge/Response Cd /opt/apache Solaris cd \opt\apache WindowsChange to the /opt/apache/bin Solaris or c\opt\apache\bin Removing a User’s Access \opt\pdn\OpenLane WindowsOLCmd confauth on OLCmd confauth offApache User Access Authentication January Accessing the OpenLane Web Applications Adding Devices and Customer ProfilesAdmin Adding a DeviceNew Device Field Names Field Description Adding a Customer Profile 7800-A2-GB32-00 January Adding Devices and Customer Profiles OpenLane Maintenance Task Importance Ideal FrequencyBacking Up OpenLane Files Oracle DatabaseGzip -d /backupdir/backup.tar.gz tar xvf backup.tar Backing Up OpenLane Under SolarisRestoring OpenLane Under Solaris Opt/pdn/OpenLane/dataBacking Up OpenLane Under Windows Restoring OpenLane Under WindowsDeleting Older Records from the Database FrequencyUsing Cron Under Solaris to Automate Reports Generating Scheduled ReportsAutomating the Generation of Scheduled Reports Cd /opt/pdn/OpenLane OLCmd processreportsUsing AT under Windows to Automate Reports Cd \opt\pdn\OpenLane OLCmd processreportsRebuilding Oracle Database Indexes Monitoring Log Files Apache Log FilesSQL Database Log File OLCmd clean logs .log Archiving and Deleting Log FilesLegacy Logger Log Files Uploading Configurations Click on Click here to schedule the tasksOpenLane Maintenance January Building and Using a Firmware Library Building a Firmware LibraryVersion=filename 01.02.01=R010201.ocdNew Device Models Not Supported by OpenLane Model=directory9880=fw9880 Model=devicetype DbmDslaan DslasnDownloading and Activating Firmware Building and Using a Firmware Library Building and Using a Firmware Library January OLCmd Reference OLCmd Helps Cd \opt\pdn\openlane olcmd confauth onOlcmd viewlog -h OLCmd addcust OLCmd addcust -a realtime -c ExactCorporation Rent-a-Phone.com Rent-a-PhoneGmbH Rent-a-PhoneUSAOLCmd assigndev OLCmd assigndev -c ExactCorporation -aOLCmd assigndev -c ExactCorporation -l exactdevices.txt OLCmd chgrawfileext OLCmd chgrawfileext -o raw -e ftpOLCmd chgrawfileext -d dallas -o bad -e raw OLCmd clean OLCmd clean \opt\apache\logs .log 21 adminOLCmd confauth OLCmd confauth on offOLCmd dbage OLCmd dbconfig OLCmd dbconfig -d c o -a instance -l -hUrl OLCmd dbcopy OLCmd dbcopy d OracleStatsDBOLCmd dbip OLCmd dbip addressOLCmd dbip OLCmd dbroll DatabaseinstanceIpaddress OLCmd dbroll -e 20010101000000 -rOLCmd delcust OLCmd delcust -ccustomer -lcustomer-listOLCmd delcust -l ex-customers.txt OLCmd deldev OLCmd deldev ipaddressOLCmd deldev OLCmd dumpldap OLCmd dumpldap hostOLCmd importldif OLCmd importldif -h host ldiffileLdiffile OLCmd key OLCmd key licensekeyOLCmd key WZBCK-AAM6E-U898Q-MX5HK OLCmd ldapmodify -D c=US -w admin -a -c data/new.ldif OLCmd ldapmodifyOLCmd OLCmd ldapsearch -n-D bindDN -w password -h host -p port OLCmd ldapsearchDebuglevel OLCmd logsvc OLCmd logsvc ipaddressOLCmd processreports Date dateEnddate enddate OLCmd processreports -date 05/13/2001 -customer ExactCorpOLCmd snmpget OLCmd snmpget communityname ipaddress objectidObjectid OLCmd snmpget 135.26.10.37Ipaddress Is the address of the device to be accessed OLCmd snmptestOLCmd snmptest ipaddress communityname OLCmd snmptest 135.26.10.37 nmswriteOLCmd sync OLCmd sync OLCmd uhread -ccommand -npoller-name CommandOLCmd uhread Poller-nameOLCmd unassigndev OLCmd unassigndev -c ExactCorporation -aOLCmd unassigndev -c ExactCorporation -l exactdevices.txt OLCmd viewlog Firmware/Configuration/Feature Maintenance UHLister Poller ControllerUHReader Database Reader OLCmd viewlog -f fi -sd 05/07/2000 -ed 05/13/2000 UHReaderOLCmd xmlreport XmlrequestfileXmloutputfile XsltransformfileOLCmd Reference January Using XML to Produce Reports Command Line Interface OLCmd xmlreportXML Reports Servlet Interface SlvXmlServlet Writing an Interface to the ServletOpt/pdn/OpenLane/OLServlets/pdn.webcgi.SlvXmlServlet Opt/pdn/OpenLane/samples/xml/reports/xmlentry.html. You canXML and XSL Examples Additional ResourcesOpt/pdn/OpenLane/samples/xml/reports/DeviceReports/Requests Opt/pdn/OpenLane/samples/xml/reports/DeviceReports/ReportsUsing XML to Produce Reports January Index IN-1IN-2 IN-3 IN-4