Manuals / Sybase / Computer Equipment / Server

Sybase 15.0.2 manual Recovering from a failed upgrade

Models: 15.0.2

1 160

Download 160 pages 32.42 Kb

Page 104

Recovering from a failed upgrade

90	Adaptive Server Enterprise

Image 104

Sybase 15.0.2 manual Recovering from a failed upgrade

Contents

Adaptive Server Enterprise Document ID Contents Connecting to Adaptive Server via Sybase Central Post-Installation TasksInstalling Sybase PC-Client Products Upgrading Adaptive ServerContents 101119 123124 126131 135How to use this book AudienceViii Related documentsAbout This Book Adaptive Server Enterprise Other sources of information Xii Finding the latest information on component certificationsConventions XiiiAccessibility features If you need help XivSQL syntax conventions Key DefinitionOverview TopicProduct licensing with SySAM Product licensing with SySAMOverview Product componentsAdaptive Server Enterprise Backup Server Product componentsStored procedures Adaptive Server editionsClient DataAdaptive Server editions Enterprise EditionSmall Business Edition Adaptive Server specifications Adaptive Server specifications for HP-UX 64-bit PA RiscAdaptive Server specifications on Windows Developer EditionProduct descriptions and directory layout Product descriptions and directory layoutProduct description Product DescriptionSDK Sybase support for ADO.NET, OLE DB, and Odbc Interactive SQLPC-Client product descriptions and directory layout Products and platformsSeparately installable PC-Client products PC-Client product descriptions and directory layoutA P T E R 2 Installing Adaptive Server OverviewSystem requirements System requirementsPre-installation tasks for SySAM Installing Adaptive ServerDisk space requirements for Windows platforms Product Disk space requirementsAccessing Spdc Pre-installation tasks for SySAMGetting your host ID EnterGenerating licenses at Spdc Generating a served license Generating an unserved license Installing a new license server SYBASE%\%SYBASESYSAM%\bin Pre-installation tasks for Adaptive Server Pre-installation tasks for Adaptive Server Adjust shared memory segments Pre-installation tasks for Adaptive Server Installing components with the Installer in GUI mode Installing server componentsInstallation methods Installing server components Installing Sybase Central and Adaptive Server plugin in? Installing server components Small Business Edition Developers Edition Express Edition Installing server components Installing Adaptive Server Installing server components Monitor Server User’s Guide Determining Adaptive Server version Backing up Adaptive ServerInstalling the Adaptive Server version 15.0.2 binary overlay XML Services in Adaptive Server version A P T E R 3 Post-Installation Tasks Post installation instructionsVerifying that servers are running Verifying that servers are runningPost-Installation Tasks Verifying that you can connect to serversConnecting to Adaptive Server via Sybase Central Setting the System Administrator passwordSAMreport Installing sample databases Default devices for sample databasesInstalling sample databases Sample database scriptsRunning the database scripts Installing the interpubs database Interpubs databaseInstalling the jpubs database Jpubs databaseMaintaining the sample databases Installing Sybase PC-Client Products Before you install the PC-Client products Before you install the PC-Client productsInstalling PC-Client products Installing Sybase PC-Client Products Operating system Service pack levelInstalling PC-Client Components on Windows PC-Client system requirementsInstalling PC-Client products Installing PowerDesigner, PowerTransfer, and InfoMaker Configuring network connections for client products Configuring libtcl.cfg for LdapFor example Adding a server to the interfaces file Machinename Testing the Sybase Central installation A P T E R 5 Upgrading Adaptive Server Overview of the upgrade process Overview of the upgrade processSystem catalog changes during upgrade Upgrading Adaptive ServerPre-upgrade tasks Pre-upgrade tasksChecking system and upgrade requirements Reserved words Procedure text is required for upgradeNoting server and device names and locations Running a reserved word check Addressing reserved words conflictsUsing quoted identifiers Increasing default database sizesCreate a sybsystemdb database If you have a sybsystemdb databaseUpgrading to Adaptive Server If you do not have a sybsystemdb databaseUpgrading the server Testing the Adaptive Server upgrade Post-upgrade tasks Run the instmsgs.ebf scriptPost-upgrade tasks Restoring functionality in Adaptive ServerSpconfigure configuration file, 0, verify, fullpathtofile Reenabling Replication Server Removing old log recordsReenabling replication Restoring replication after upgrade Spaudit execprocedure, all, spaddlogin, on Reenabling auditingUpgrading Backup Server, Monitor Server, and XP Server Upgrading Backup Server, Monitor Server, and XP ServerUpgrading Backup and Monitor Servers Shutting down SySAM serversUpgrading Job Scheduler Upgrading Job SchedulerUpgrading Job Scheduler templates Upgrading Job SchedulerUpgrading Job Scheduler templates JstdumplogSybDeleteStatsTemplate.xml Template Modified file Change description From this template Upgrading high availability Upgrading high availabilityConsole output on primary server is similar to the following Migrating from 32-bit to 64-bit versions Migrating from 32-bit to 64-bit versionsMethod #2 BCP data out Method #3 Replacing the binary Recovering from a failed upgrade Recovering from a failed upgradeIsql alter database dbname on devicename = 2m Recovering from a failed upgrade A P T E R 6 Troubleshooting SySAM Issues Calling Sybase technical support for SySAM-related issuesWhere to look for SySAM-related errors Where to look for SySAM-related errorsTroubleshooting SySAM Troubleshooting SySAM IssuesTroubleshooting SySAM Description What to doTroubleshooting SySAM Or use a different port number for the license server Software Asset Management User’s Guide Matches these settings SySAM grace mode SySAM grace modeSySAM grace period Enabling and changing e-mail notificationsEnabling and changing e-mail notifications 100A P T E R 7 Troubleshooting 102 Troubleshooting guidelines for WindowsProblem Possible cause and solution Error log locations TroubleshootingError log locations for installation utilities for Windows Utility Error log locationSolutions to common installation problems Installer fails to startAdaptive Server fails to start Stopping Adaptive Server after a failure105 Recovering from a failed installationIf installation fails after files are created If Adaptive Server fails the pre-upgrade eligibility test Recovering from a failed upgradeRestoring from backup 106Re-running the upgrade 107If the cause of the failure is known 108109 Upgrading compiled objects with dbcc upgradeobjectIf the cause of the failure is unknown 110 Finding compiled object errors before productionUpgrading compiled objects with dbcc upgradeobject Reserved word errors Quoted identifier errorsMissing, truncated, or corrupted source text 111112 Select * potential problem areasTemporary table references Using dbcc upgradeobject 113View upgrades all views 114Increasing the log segment size 115Using database dumps in upgrades Error reportingUpgrading using dump and load Upgrading compiled objects in database dumpsDetermining whether a compiled object has been upgraded 117118 Uninstalling Adaptive Server Heading120 Removing an old serverRemoving an old server Removing Adaptive Server 121122 P E N D I X a Alternative Installation Methods Installation on consoles non-GUI mode124 Silent installationSilent installation Appendix a Alternative Installation Methods 125Configuration using resource files Configuring from a resource fileConfiguration using resource files Editing a sample resource file127 Resource file variables 128Variable, PUT-THE Description Running the sybatch utility129 130 Introduction 131Suspending transaction processing and replication activities 132133 Draining the transaction logs for primary databasesAppendix B Upgrading Servers with Replicated Databases Draining the transaction logs for primary databases 134Draining the Rssd transaction log 135136 Disabling the secondary truncation pointDisabling the secondary truncation point P E N D I X C Using sybsystemprocs 137Increasing the size of the sybsystemprocs database Increasing the size of the sybsystemprocs database138 Enlarging the sybsystemprocs database139 Appendix C Using sybsystemprocsCreating a larger system procedures device sysprocsdev 140 141 142 Index 143Index 144145 146