Tag Info

New answers tagged

0

The only real difference between the two is that "Upgrade a Database" will install the new version in a new Oracle Home and then launch DBUA (DataBase Upgrade Assistant) after. Personally, I would suggest doing the two steps separately. An important note: you say you don't want to affect the other SIDs (database instances), this may not be possible, ...


2

Choose Install database software only, then later you can upgrade your databases one by one with DBUA (Database Upgrade Assistant) from the new Oracle Home, or by performing a manual upgrade.


2

There are two workarounds: Delete one record from table ServerUpgradeHistory USE [name_of_you_SSRS_database] DELETE FROM ServerUpgradeHistory WHERE ServerVersion = 163 Install Cumulative Update 1 for SQL Server 2014 Service Pack 1. Before updating your SQL Server 2014 SP1 with Cumulative Update 1 - test it hard in your lab. BE AWARE - Pay ...


1

What we ended up doing is grepping out queries from the slow.log based on table name into database-specific (raw) log files. Then we specified --type rawlog and --database with pt-upgrade.


1

I have a similar problem. I have missing tables and missing USE statments as well. Sometimes the USE statement is present but with the wrong database. I use a quite simple workaround. (Prelude) My first issue : my slow.log is 60Go long so I split it with split with option -l set to 20 millions (that gives me roughly 1Go per file) make sure you do not have ...


0

Maybe a compatibility level will help you. You can define it in the options of your database under compatibility level. Change it to a version earlier of your current sql server at home. This way I'm sure it will be correctly used in your school.


1

The nice clean solution is to: install Oracle 11.2.0.3 on a new machine with the same machine name depending on your network putting the new one a different sub-net or in a fire walled zone could prevent network issues create an instance with the same name set the parameters and table spaces to be the same as the original import the data test, test, test ...


2

Does it still fail to work if you omit --sample? (from manual) Also note that pt-query-digest may fail to report the database for queries when parsing tcpdump output. The database is discovered only in the initial connect events for a new client or when is executed. If the tcpdump output contains neither of these, then pt-query-digest cannot ...


1

I found interesting this link: http://thomaslarock.com/2011/12/7-mistakes-you-cant-afford-to-make-when-upgrading-to-sql-2012/ In my case I upgraded from sql 2000 to 2014 (with a 2008 bridge) detaching and moving files, but considerations are still good. My db whas about 1.3 terabytes. I run DBCC CHECKDB WITH DATA_PURITY; But this is critical just ...



Top 50 recent answers are included