Cisco Systems 78-17023-01 manual Verifying the Oracle Configuration

Page 66

Appendix A 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” procedure on page A-10to 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-7to 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.

 

Installation Guide for Cisco Network Planning Solution

A-10

78-17023-01

Image 66
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 DistributionCisco.com PrefaceObtaining Documentation Documentation DVDDocumentation Feedback Cisco Product Security OverviewOrdering Documentation Reporting Security Problems in Cisco Products Obtaining Technical AssistanceCisco Technical Support Website Submitting a Service Request Definitions of Service Request SeverityObtaining Additional Publications and Information XiiiXiv Planning Your Installation Installation WorkflowA P T E R Registering Your Cisco Solution Product Upgrading LicensesRegistration Information Determining Installation Options Product LicensingRestricted and Unrestricted Licenses Floating Mode Selecting the License TypeRestriction Type Installed Program Installed License How Licensing Types and Modes Affect Who Can Use a LicenseLicensing Requirements Host Name Installed Program Installed Licenses Licensing Scenarios ExamplesLicenseserver = DA1 License mode = Floating/Remote Page Supported Platforms System Requirements for Cisco Network Planning SolutionDesign and Analysis System Requirements Vendor ProcessorSystem Configuration Required System PatchesOther Requirements External Software CompatibilityProduct Version Supported Data Type Virtual Network Data Server System Requirements Vendor1Series Windows System Configuration Free Disk SpaceMinimum Software Platform Supported Version Character Set WE8MSWIN1252Installing Design and Analysis Installing Design and Analysis on WindowsInstalling 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 LicensesAdding a License Workflow Description Obtaining a Username and PasswordLicense Names Cisco Program License NameObtaining an Upgrade Authorization from Cisco Systems, Inc Upgrading a License Workflow DescriptionLicense Operations Adding a License Express MethodAdding 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 Design and Analysis from Windows Standard Uninstalling Cisco Network Planning SolutionUninstalling Design and Analysis Windows Uninstalling Design and Analysis from Windows AdvancedRemove the following registry key Uninstalling Virtual Network Data Server Uninstalling Virtual Network Data Server StandardUninstalling Virtual Network Data Server Advanced Removing Virtual Network Data Server Database Contents Removing All Virtual Network Data Server Elements Entry name is Oracle Installation and Setup Procedures Installing the Oracle 9i DatabaseInstalling 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 Oracle TopLink Installing 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 ConfigurationLocating a Database Net Service Name in tnsnames.ora Additional Oracle NotesTNSNAMES.ORA Example File 78-17023-01 D E IN-2