Cisco Systems 78-17023-01 manual Sqlplus system/magic@o92avnes

Page 64

Appendix A Oracle Installation and Setup Procedures

Configuring the Oracle Database

cd <install path>\VNEServer\3.0.1_X

For example, you might enter: cd C:\Cisco\CiscoNPS1.0\VNEServer\3.0.1_880

Stay in the command window on the host system for Virtual Network Data Server and continue with Step 2.

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

sqlplus system/<system password>@<DB TNS Service Name>

For example, if the Database TNS Service Name is o92avnes and the account password is magic, type:

sqlplus system/magic@o92avnes

Stay in the command window on the database host and continue with Step 2.

Step 2 Type sqlplus system/<system password> in the command window.

Step 3 At the sqlplus prompt, type @setup_accounts.sql

A message banner appears that states how much free disk space is required on the disk that hosts the database.

Note If you do not have sufficient disk space available to run this script, free sufficient disk space before proceeding. If you wish to cancel the script, press Ctrl-C or close the command window.

Step 4 Click Enter to continue.

A message banner appears with a list of database parameters, parameter settings, and whether the parameters meet recommended settings.

Note If all parameters meet recommended settings, no further action is required. If one or more parameters do not meet recommended settings, running the dbparamchg.sql script after this procedure is recommended. Running the script will improve data import performance with large networks and increase Oracle memory requirements. For more information, see the “Modifying Database Parameters” procedure on page A-9.

Step 5 Click Enter to continue.

Step 6 Note the correct database instance name for use in the next step.

The setup_accounts script prompts you for the database instance name.

Step 7 Enter the database instance name obtained in Step 6.

Note If more than one database name appeared when you ran the previous step, check with your Database Administrator to determine the correct database.

Note If the database is located on a Solaris system, the case (uppercase, lowercase) of the characters in the database instance name must match the case of the name of the database directory. This directory is located under the oradata directory on the Solaris database host.

The setup_accounts script prompts you for the user password.

Step 8 Enter the same database user account password that was entered during Virtual Network Data Server installation and written down in Table A-1 on page A-6.

Installation Guide for Cisco Network Planning Solution

 

A-8

78-17023-01

 

 

 

Image 64
Contents Installation Guide for Cisco Network Planning Solution Corporate HeadquartersPage N T E N T S Required System Patches Oracle Installation and Setup Procedures A-1 Page Supplemental License Agreement Additional License RestrictionsInstallation and Use Reproduction and DistributionPreface Obtaining DocumentationCisco.com Documentation DVDCisco Product Security Overview Documentation FeedbackOrdering Documentation Obtaining Technical Assistance Reporting Security Problems in Cisco ProductsCisco Technical Support Website Submitting a Service Request Definitions of Service Request SeverityObtaining Additional Publications and Information XiiiXiv Installation Workflow Planning Your InstallationA P T E R Upgrading Licenses Registering Your Cisco Solution ProductRegistration Information Product Licensing Determining Installation OptionsRestricted and Unrestricted Licenses Floating Mode Selecting the License TypeHow Licensing Types and Modes Affect Who Can Use a License Restriction Type Installed Program Installed LicenseLicensing Requirements Host Name Installed Program Installed Licenses Licensing Scenarios ExamplesLicenseserver = DA1 License mode = Floating/Remote Page System Requirements for Cisco Network Planning Solution Design and Analysis System RequirementsSupported Platforms Vendor ProcessorSystem Configuration Required System PatchesExternal Software Compatibility Other RequirementsProduct Version Supported Data Type Vendor1 Virtual Network Data Server System RequirementsSeries Free Disk Space Windows System ConfigurationMinimum Software Platform Supported Version Character Set WE8MSWIN1252Installing Design and Analysis on Windows Installing Design and AnalysisInstalling Design and Analysis on Windows Installing Design and Analysis on Solaris Installing Design and Analysis on SolarisInstalling Design and Analysis on Solaris procedure on Preparing User AccountsPage Installing Virtual Network Data Server System RequirementsWorkflow 1 Initial Installation Local Oracle Database Workflow 2 Initial Installation Remote Oracle DatabaseInstalling Virtual Network Data Server Workflow 3 Initial Installation Oracle Already InstalledInstalling Virtual Network Data Server Scenario Oracle Installation Instructions Network Data Server procedure onInstalling Virtual Network Data Server Click Next Verifying the Virtual Network Data Server Installation Verifying the Virtual Network Data Server Installation Page Using the License Manager Adding and Upgrading LicensesObtaining a Username and Password License NamesAdding a License Workflow Description Cisco Program License NameObtaining an Upgrade Authorization from Cisco Systems, Inc Upgrading a License Workflow DescriptionAdding a License Express Method License OperationsAdding a Component License Express Method Adding a License Browser Method Adding a Component License Browser MethodDeregistering a License Express Method Deregistering a Component License Express MethodDeregistering a License Browser Method Deregistering a Component License Browser MethodTechnical Support for Licensing Operations Uninstalling Cisco Network Planning Solution Uninstalling Design and Analysis WindowsUninstalling Design and Analysis from Windows Standard Uninstalling Design and Analysis from Windows AdvancedRemove the following registry key Uninstalling Virtual Network Data Server Standard Uninstalling Virtual Network Data ServerUninstalling Virtual Network Data Server Advanced Removing Virtual Network Data Server Database Contents Removing All Virtual Network Data Server Elements Entry name is Installing the Oracle 9i Database Oracle Installation and Setup ProceduresInstalling the Oracle 9i Database Click Next or OK to proceed through these panels Installing the Oracle 9i Client Installing the Oracle 9i Client Click Next at the Configuration Tools panelCollecting Oracle Database Access Information Configuration Complete panel appearsInstalling Toplink Installing Oracle TopLinkAccess Item Value Description Configuring the Oracle Database Configuring the Oracle DatabaseSqlplus system/magic@o92avnes Modifying Database Parameters Modifying Database ParametersVerifying the Oracle Configuration Verifying the Oracle ConfigurationAdditional Oracle Notes Locating a Database Net Service Name in tnsnames.oraTNSNAMES.ORA Example File 78-17023-01 D E IN-2