Cisco Systems 78-17023-01 Verifying the Oracle Configuration

A-10

Installation Guide for CiscoNetwo rk Planning Solution

78-17023-01

AppendixA Oracle Installation and Setup Procedures

Verifying the Oracle Configuration

When the script finishes, a list of the changed parameters and their new settings appears with a reminder

to restart the Oracle DB service for the changes to take effect.

Step 5 Type Quit to exit sqlplus.

Step 6 Use the Windows Service Manager to stop and restart the Oracle database service.

a. From the desktop, select Start > Settings > Control Panel > Administrative Tools > Services to

open the Windows Service Manager.

b. Select the service named OracleService<DB SID>.

c. Right-click on the service and select Stop from the menu.

d. After the Service Control progress dialog completes, right-click on the service and select Start from

the menu to restart the service.

Step 7 If the Oracle database service fails to restart, restore the original spfile for the database and repeat Step 6

to recover.

Perform the“Verifying the Oracle Configuration” proced ure on pageA-10 to verify that you can connect

to the database through the Virtual Network Data Server account.

Verifying the Oracle Configuration

Perform this procedure on the database host to verify that you can connect to the database through the

Virtual Network Data Server account.

Verifying the Oracle Configuration

Step 1 Type sqlplus <user name>/<password> in a command window on the database host system. Use the

user name and password from Table A-1 on page A-6.

Warning

Do not use SYS or SYSTEM as the user name.

Note If the Oracle database is not on the same host system as Virtual Network Data Server, use the

same methods described in Step 1 of “Configuring the Oracle Database” procedure on page A-7

to connect to the remote database.

a. If Oracle configuration is successful, an Oracle banner and a Connected To: message appears.

Type quit at the SQL> prompt to exit.

b. If Oracle configuration fails, error messages inform you that login has been denied.

Reconfigure the Oracle database and verify again. If configuration problems persist, contact Cisco

Technical Support.

Virtual Network Data Server installation and database configuration are now complete. Proceed to the

next section to verify the Virtual Network Data Server installation.

Contents

Main Installation Guide for Cisco Network Planning Solution Page CONTENTS Page Page Page Supplemental License Agreement ADDITIONAL LICENSE RESTRICTIONS Page Preface Obtaining Documentation Cisco.com Documentation DVD Ordering Documentation Documentation Feedback Cisco Product Security Overview Reporting Security Problems in Cisco Products Obtaining Technical Assistance Cisco Technical Support Website Submitting a Service Request Definitions of Service Request Severity Obtaining Additional Publications and Information Page Planning Your Installation Installation Workflow Upgrading Licenses Registering Your Cisco Solution Product Registration Information Determining Installation Options Product Licensing Restricted and Unrestricted Licenses Selecting the License Type Floating Mode How Licensing Types and Modes Affect Who Can Use a License Licensing Requirements Licensing Scenarios: Examples Page Page System Requirements for Cisco Network Planning Solution Design and Analysis: System Requirements Supported Platforms Required System Patches Obtaining the Solaris 8 Patch Cluster System Configuration Other Requirements External Software Compatibility Import of Network Topology Import of Network Traffic Virtual Network Data Server: System Requirements Supported Platforms Required System Patches Windows System Configuration Other Requirements Installing Design and Analysis Installing Design and Analysis on Windows Installing Design and Analysis on Windows Installing Design and Analysis on Solaris Installing Design and Analysis on Solaris Preparing User Accounts Page Installing Virtual Network Data Server System Requirements Installation Workflow Workflow 1: Initial Installation (Local Oracle Database) Installing Virtual Network Data Server (with Oracle Database on Local Host)Workflow Description Workflow 2: Initial Installation (Remote Oracle Database) Installing Virtual Network Data Server (with Oracle Database on Remote Host)Workflow Description Workflow 3: Initial Installation (Oracle Already Installed) Installing Virtual Network Data Server Installing Virtual Network Data Server Page Page Page Verifying the Virtual Network Data Server Installation Verifying the Virtual Network Data Server Installation Page Adding and Upgrading Licenses Using the License Manager License Names Adding a License: Workflow Description Obtaining a Username and Password Upgrading a License: Workflow Description Obtaining an Upgrade Authorization from Cisco Systems, Inc. License Operations Adding a License (Express Method) Adding a Component License (Express Method) Adding a License (Browser Method) Adding a Component License (Browser Method) Deregistering a License (Express Method) Deregistering a Component License (Express Method) Deregistering a License (Browser Method) Deregistering a Component License (Browser Method) Technical Support for Licensing Operations Uninstalling Cisco Network Planning Solution Uninstalling Design and Analysis (Windows) Uninstalling Design and Analysis from Windows (Standard) Uninstalling Design and Analysis from Windows (Advanced) Page Uninstalling Virtual Network Data Server Uninstalling Virtual Network Data Server (Standard) Uninstalling Virtual Network Data Server (Advanced) Removing Virtual Network Data Server Database Contents (Optional) Removing Virtual Network Data Server Database Contents Removing the Virtual Network Data Server Installation (Complete Uninstall) Removing All Virtual Network Data Server Elements Page APPENDIX A Oracle Installation and Setup Procedures Installing the Oracle 9i Database Installing the Oracle 9i Database Page Installing the Oracle 9i Client Installing the Oracle 9i Client Collecting Oracle Database Access Information Installing Oracle TopLink Installing Toplink 9.0.3.5 Configuring the Oracle Database Configuring the Oracle Database Page Modifying Database Parameters Modifying Database Parameters Verifying the Oracle Configuration Verifying the Oracle Configuration Additional Oracle Notes Locating a Database Net Service Name in tnsnames.ora TNSNAMES.ORA Example File Page INDEX D E F I L W