Re: EXT :Oddity with upgrades on Windows

Thanks Peter! This looks like a smart recipe, I'll discuss it with the client.

Regards

On 04/03/2018 02:06 PM, Schauss, Peter [US] (ES) wrote:
> Mladen,
>
> I did something like this under Windows 2008r2 Standard so it may be a bit different on 2012.
>
> - I had our sysadmins create a service account for the Oracle 12c processes to run under and added it to the sysadmin group on the server.
>
> - When I installed the 12c software I specified that account and password when the installer asked for it.
>
> - I used regedit to find the SID for the above service account by looking in HKEY_LOCAL_MACHINE\software\Microsoft\WindowsNT\CurrentVersion\ProfileList.
>
> The items in ProfileList have a format which looks like:
> S- followed by some hyphenated groups of numbers.
>
> I looked at the values associated with each one until you find one where the associated ProfileImagePath = c:\Users\<service account name>
>
> The S-<numbers> value is the SID of the service account.
>
> - In HKEY_USERS\<SID>\Environment I added a field called ORACLE_HOME and set its value to the path to the ORACLE_HOME for 12c.
>
> - I set the properties of the 12c listener service to run under this service account with the result that it used the appropriate ORACLE_HOME for 12c.
>
> Hope this helps and is not too confusing.
>
> Peter Schauss
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
> Sent: Saturday, March 31, 2018 3:19 PM
> To: oracle-l <oracle-l_at_freelists.org>
> Subject: EXT :Oddity with upgrades on Windows
>
> The scenario is like this: the client is using 64 bit Windows 2012R2, with several 11G databases running from the same 11.2.0.4 home. For testing purposes, the client wants to upgrade just one of the databases to Oracle 12.1.0.2. I noticed that it is not possible to move the listener to the new Oracle home. No matter what I do, the listener being used is always the listener from the 11G home. That prevents me from using DBUA and I have to use catctl.pl, which is a lot more of manual labour. Has anyone solved that problem? Explicit setting of TNS_ADMIN doesn't help.  I am at a loss.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l