Second instance on a database server, how to configure
We have an Oracle 12c Standard Edition install on our single database server. We are planning to upgrade to 12c Enterprise Edition and want to install a test environment to do a test upgrade and backup/restore test.
How should I best install a second instance (SID) on my server?
Should I install it using the same Oracle Home and Oracle user or should I create a new user and do a complete new install of 12c Standard?
Again, the thing I want to do is first do a complete cold backup via RMAN, then do a restore, then once I know it's a good backup I want to do the in-place upgrade to EE.