Re: Upgrading Oracle 12.1 to Oracle 19 on Win-x64
Date: Wed, 9 Sep 2020 19:30:06 -0400
Message-ID: <CAF+xsmRORQwR-8e3u5S72a8KzqpLSz31BKg+3afBR12WdR6Oiw_at_mail.gmail.com>
For what it's worth,
Cheers
On Wed, Sep 9, 2020 at 4:46 PM Steve Wales (AddOns) <
steve.wales_at_addonsinc.com> wrote:
> Greetings to all,
I had installed oracle software 19c using a domain user and patched it to
19.7 on a windows uat environment and didn't have any issue .
My account was part of the usual ora_* groups through a domain group (when
I run: whoami /groups).
Client wanted to move few refreshed DBs from 12.1.0.2 to the new 19c CDB.
I used Autoupgrade last week as moving 600GB of data and 50K objects was
just not the fun I was ready for.
I don't know why you had the error but I just realized that the new home is
owned by my domain account while the old homes were ownd by the local admin
and it still worked.
Kosseila
>
> I have been given a server that has about 18 databases on it, a
> combination of Production and Test and Dev, all on the same server.
>
> I didn’t build it and have inherited it and now have to upgrade it.
>
> The Oracle 12.1 install and all the Oracle services on the server are
> owned by a Windows Domain account called MYDOMAIN\ora.service.
>
> I went and unzipped the Oracle 19 install and went to run the setup.
> First thing it told me was that the ora.service account has administrator
> privileges and can’t be used to install the Oracle software.
>
> So then I was going to just perform the install in a different ORACLE_BASE
> using one of the recommended account options when it hit me.
>
> When I go to run DBUA to upgrade the databases, if the services are owned
> by different accounts, it probably won’t work. The database upgrade
> documentation confirm this. Database upgrade is supported when the same
> Windows user account is used as the Oracle Home user in both the source and
> the destination Oracle Homes.
>
> I have an SR open with Oracle Support but they are not being super
> responsive at the moment. This has been dragging on for over a week and I
> need to get the initial dev/test upgraded done to meet project deadlines.
>
> The advice I’ve received so far is “Install in a different home with a
> different user, then export and import or restore and upgrade”.
>
> Neither of those are particularly appealing to me, let along running into
> the problems of having to create new database names since I’d be building
> new databases on the existing server and having to reconfigure all the
> application connect strings.
>
> Is there a way to get around this? What happens if I have the system
> administrator remove the Administrative privileges from the ora.service
> domain account ? Will this affect the running Oracle 12.1 production
> databases in any way? Nearly all the databases I regularly look after are
> on Linux so I don’t run into these Windows security setting problems and
> I’m just not familiar enough with the intricacies of Windows and Oracle to
> make an informed decision and I don’t want to go play with things blindly
> since there are production instances at stake here.
>
> Once the service is started as Admin does it do things to the database
> binaries and data files where removal of Admin would break things ?
>
> Appreciate any information or anecdotes around this situation.
>
> Thanks
> Steve
>
> Disclaimer
>
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and may
> be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
> automatically archived.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 10 2020 - 01:30:06 CEST