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.
Linux x86-64
Hi Mike
Lifetime Support doc on oracle.com has not changed to reflect 12.2 ; is that deliberate or has no-one got round to it yet ?
Ta
Chris.
It did get changed over the weekend – see my blog post tomorrow morning please 🙂
Cheers
Mike
Hi Mike,
Do you have any information when this version is to be released also for Windows platform?
Thanks in advance,
Ilia
Please see MOS Note 742060.1 for proposed release dates (includes Win as well).
Cheers
Mike
Q2CY2017
Thanks a lot,
Ilia
Could you plz point to the docs which talks about the Net difference for the below?
1. Oracle DB 12.2 On-premise release Vs Oracle DBCS 12.2 which includes the Features differences between them and if there are any features that are enabled by Default
2. Oracle DBCS 12.1 Vs Oracle DBCS 12.2
This is the license documentation. There you’ll find now a separation between on-premises and the cloud.
https://docs.oracle.com/database/122/DBLIC/toc.htm
Cheers
Mike
Hallo Mike,
der Kunde plant, seine gesamte DB Landschaft von HP-UX Itanium nach Linux x86 zu migrieren.
Auf Linux soll dann mit 12.2 und single tenant begonnen werden.
Für die ersten “Gehversuche” haben wir folgenden Plan:
Cross Platform Migration via TTS der 12.1 DB.
Upgrade auf 12.2
Umstellung auf PDB (single tenant).
Jedoch haben wir schon ein Problem nach der Platform Migration.
Das insert in ein CLOB verursacht einen ORA-00600 [25027] …
Das war unter 11.2.0.4 nicht der Fall.
Der SR 3-14469428971 wurde von uns dazu eröffnet.
Falls Du hierzu noch Tipps hast, nehmen wir die gerne entgegen.
Wenn wir denn mal auf Linux sind, werden wir vorgehen, wie von Dir beschrieben.
Viele Grüße,
Bernd
Hallo Bernd,
entschuldige die spaete Rueckmeldung. Dein Kommentar ist mir irgendwo zwischen dem Raster durchgerutscht.
Ich haette vermutet, dass Ihr in einen Bug lauft.
Du musst auch nicht den Zwischenweg ueber 12.1 gehen – und kannst in diesem Fall auch das Plugin vermeinden, indem Du eine neue PDB in 12.2 anlegst und direkt rein migrierst. Schau Dir mal bitte das Video von Roy in unserer VIDEO Seite an: https://mikedietrichde.com/videos/
Da siehst Du, wie Du mit Full Transportable Export/Import direkt in die PDB kommst. Im Video Linux/Linux, im Echtleben aber natuerlich in alle Richtungen.
Ganz ehrlich wuerde ich aber wenigstens das April Bundle Patch fuer 12.2 abwarten. Da werden sehr wichtige Fixes drin sein.
Viele Gruesse
Mike
Hello Mike,
I have some questions about gathering statistics before and after our upgrade. We are working and testing our upgrade from 11.2.0.4 to 12c.
There is one Oracle Support note (Doc ID 465787.1) with statistics recommendations. Would it be ok to save statistics the way this document suggests?
While doing the upgrade in place tests, the output recommends to create stats on fixed objects two weeks
after the upgrade. Would you recommend to wait two weeks, or can they be created right after the upgrade?
The MOS note also includes steps to create fresh baselines of data dictionary, fixed objects and system statistics.
Is this something you would suggests right after the upgrade?
Thank you,
Nidia Pichardo
Nidia,
ignore the two weeks and transform it into:
– once directly after upgrade if you plan to recompile a high number of invalid objects
– again a bit (maybe 24-48 hours) as by then the X$ structures should have been filled now.
For instance X$BH (Buffer Cache) may be more or less empty directly after the upgrade. But it will not once you kicked off production.
Furthermore, since 12.1.0.2 fixed objects stats gathering is part of the Automatic Stats Gathering job – so you may ignore the above hints anyways.
Cheers
Mike