We use cookies to optimize our website and our service.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Mike, thank you, now I’m not scared to migrate 🙂
Great Workshop!!! Very useful! good show!
Thanks a lot!
Mike, it was a great event,
a lot of things began to seem much easier,
look forward to see you next time!
P.S. Thanks for T-shirt!
Moscow
Danke schön, Mike!
That was one of the best workshops for me for the previous 10 yrs. Just like that good old university lectures. Btw, German style beats the American one easily ;o)
Thanks so much, i’m sure i’ll refer to the presentation may times, and i’ll take any opportunity to visit your workshops.
Guten tag, Mike, 🙂
Very useful and clever presentation!
Much thanks for sharing your experience for us !
Welcome to Moscow many-many times !
Thanks!
Thanks for your feedback, Yuri 🙂 And I’ll come back – really enjoyed the workshop with you all and the great city!!!
Vasily, thanks a lot – and thanks for your feedback 🙂 Highly appreciated – next time I have to learn some Russian 🙂 CU
Hi Timur,
was great to have you there, too!! Really enjoyed the workshop!! Have successful upgrades!
Kind regards
Mike
Thanks for your feedback – highly appreciated 🙂
Yury, glad to hear that :-))) Have successful upgrades! Thanks and kind regards
Mike
Thanks!
So more information.
Hi Mike,
For those like us whom are not able to use flash can you also print screen for www://supporthtml.oracle.com Version.
Thanks Regards François.
Mike can you add note for cross platform migration with native database!
Thanks François.
Speed up your upgrade performance by:
• Truncating the auditing table SYS.AUD$
This table can have been migrated to the system owner by catlbacs.sql.
François.
BROKEN LINKS!!!!!
Note: Document TitleComplete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1)
Check the spool file and examine the output of the upgrade information tool.
The sections which follow, describe the output of the Upgrade Information Tool.
For Sample output, Click here
http://st-doc.us.oracle.com/11/112/server.112/e10819/upgrade.htm#CACHIDJD
https://webiv.oraclecorp.com/cgi-bin/webiv/do.pl/awiz.pl#appA Appendix A: “Deprecated Initialization Parameters” for a list of initialization parameters that are deprecated in Oracle Database 11g release 2 (11.2).
https://supporthtml.oracle.com/ep/faces/secure/km/%20https://webiv.oraclecorp.com/cgi-bin/webiv/do.pl/awiz.pl#appB
Appendix B: “Obsolete Initialization Parameters” for a list of initialization parameters that are obsolete in Oracle Database 11g release 2 (11.2)
Comment out obsoleted parameters( Appendix A ) and change all deprecated parameters( Appendix B ).
https://supporthtml.oracle.com/ep/faces/secure/km/%20https://webiv.oraclecorp.com/cgi-bin/webiv/do.pl/awiz.pl#appB
Note Document TitleScript to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)
Scripts appear as a bmp file!!!
François.
Thanks for this information – the script can be found in $ORACLE_HOME/rdbms/admin and it’s a subset of script: @$ORACLE_HOME/rdbms/admin/catols.sql for Label Security.
Francois,
I would – but I can’t login to the html portal as it is fully for customers and not for Oracle people.
Kind regards
Mike
Hi Mike,
Thanx a lot for the presentation! It will be very helpful to use your great migration guide when upgrading databases! 🙂
Best regards,
Sergey Kushnarev from Saint-Petersburg.