To reiterate what Mark has stated, it would not be wise to run this process
for the first time in production.
A useful testing method is to create a similar environment with virtual
machines, and proceed with testing and documentation.
Maybe you have not experienced this, but upgrade scripts sometimes have
bugs.
It would be a shame if that were to happen in production when testing could
have been done, but was not.
Jared
On Tue, Nov 8, 2016 at 3:12 AM amonte <ax.mount@xxxxxxxxx> wrote:
Hi Mark
Ma main question is to know if the pre-upgrade script can be run in a
production database several times.
Installing RHEL 5 in the new server doesnt seem a choice bacause the new
server will become production once a database is upgraded (so I cannot
reuse the server fort other tests). Also the RHEL 5 must be 32 bit and I
dont think it can be upgraded to RHEL 7 46 bit.
Thanks
2016-11-08 11:54 GMT+01:00 Mark W. Farnham <mwf@xxxxxxxx>:
Your data is unique compared to anyone who has tested.
You need to find a way to set up Red Hat 5 some place else, clone, and
test.
I don’t know whether you can flat line the new server, do that, and then
revert to Red Hat 7 (or re-install). The degree of difficulty probably
varies if you have a lot more than just Red Hat 5 on the existing server or
if you have a lot of vendor installed extras in the destination Red Hat 7.
But my point is that when different data is involved you can at most
abstract from someone else’s experience that “It hasn’t not worked yet.”
mwf
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *amonte
*Sent:* Tuesday, November 08, 2016 5:01 AM
*To:* Oracle-L Group
*Subject:* 12c running Pre-Upgrade script
Hello
I have to upgrade a couple of databases in Oracle 11.1.0.7 Linux 32 bit to
12.1.0.2 Linux 64 bit, the source runs in Red Hat 5 and target will be
running in Red Hat 7. Source is a server and the target is another server.
One of the first steps is run the pre-upgrade script from 12c in the
source Oracle Home, the 11.1.0.7 Home. This means that I have to run the
preupgrade in the production 11.1.0.7 database. Does anyone know if this
can cause any undesired effect in the production database? Also how many
times we can run the preupgrade script in the same database?
The reason is that i cannot install 11.1.0.7 32 bit in the new RHEL 7
server because it is not supported so i cannot test the pre-upgrade step in
the new server.
Thanks
Alex
