Re: EXT :Oddity with upgrades on Windows

Brilliant!

+1 !!

On Tue, Apr 3, 2018 at 2:06 PM, Schauss, Peter [US] (ES) < peter.schauss_at_ngc.com> 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
>
>
>

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