Re: Need two databases same name, same cluster, different versions

In some cases, they might mean the SID, used during connect, is embedded. Which *might* be resolved using an appropriate service.

Other than that, I'm not sure where any non-DBA application might reference the database name itself.

/Hans

On 09/03/2016 2:30 PM, Sandra Becker wrote:
> _*What they want
> *_
> (Servers are Linux)
> Current database: ver. 11.2.0.4, 2-node RAC, dbname=DEVDB, hosts
> production application
> New database: ver. 12.1.0.2, 2-node RAC (same two nodes as the
> 11.2.0.4 DB), dbname=DEVDB, will host production application
>
> _*Background on the request and suggested strategy
>
> *_I was doing the prep work for upgrading four development RAC
> (GRID/ASM) databases to 12c when I ran into a lot of serious issues
> with one of them that we determined were too numerous to consider
> fixing before upgrading. I suggested just creating a new database
> with a different name, expdp/impdp the critical schemas and create
> developer schemas as needed. I was told we couldn't do that because
> the current database actually hosts a /production/ application and the
> database name is hardcoded in the app. So now I have a poorly designed
> production app on a really messed up development database.
>
> The decision was made not to upgrade this particular database, but
> rather create a new 12c RAC (GRID/ASM) database with the same name on
> the same cluster. I'm not that experienced with GRID/ASM or RAC, so
> I'm not sure this is possible. Am I mistaken in my belief that
> GRID/ASM wouldn't like two databases with the same name even if they
> were different versions? If it is possible, can someone point me to a
> white paper/website to help me work through the process?
>
> My team lead made the suggestion to create a RAC OneNode database on
> one of the nodes in the cluster with the same dbname, do the necessary
> expdp/impdp, and simply shutdown the 11g database. Then convert the
> OneNode to a Cluster database. I can do that, but wouldn't that
> affect the installation option I need to upgrade the other three RAC
> databases? What about installing Cluster software in one OracaleHome
> and OneNode in a different OracleHome? I'm thinking that would solve
> the issue of OneNode vs. Cluster installation, but I'm not positive.
> And how would that affect converting it to a Cluster database later on?
>
> I'm sure I've left out details/information. I'm just not sure how to
> proceed with this request. I have to upgrade GRID and the other three
> databases this week. The "messed up" one can wait a week or two.
> Comments and suggestions are welcome and thank you.
>
> --
> Sandy B.
>

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