We are in the midst of upgrading our system to Q4 2016 CU 1 and as part of the process wanted to move our database to 12c pluggable. We were successful in doing this in our DEV environment starting with Q2 2016 but when I tried to upgrade to Q4, I got an error message saying we could not use pluggables. We are using SERVICE_NAME instead of SID as that is what our DBAs told us to do. We are reaching out to the community to see if anyone else has experience with 12c pluggables or multi-tenet and Q4 or Q2 and have successfully upgraded using the installer. If you have and are willing to share, we would love the support. Blackboard has indicated this is not supported and is not on the road map to support although 12c is fully supported.
We are running Redhat 6, Java 1.8. Any help is much appreciated!
Thanks,
Jon Messer
Blackboard System Administrator
University of Richmond, VA
Hey Jon,
I don't have a solution necessarily, but thought I would throw this in. We were looking at going 12c pluggable with our upgrade last Summer to Q4 2015. We were connecting with SERVICE_NAME and things seemed to be OK. I forget the exact details, but I think things derailed in our testing when we went to use bbpatch or another utility that didn't play too nicely using service name against a PDB. The below Oracle listener parameter helped us get around that and reconfigure Blackboard back to SID. We ended up not going with pluggable once we heard from Blackboard that it wasn't a supported solution. I think it is a little unclear when you "support 12c" but not its core paradigm shift that will become the norm moving forward. Hopefully we'll see support in a future release.
This year we're looking to move to Q4 2016 but are still sticking with 12.1 single instance rather than CDB/PDB. I'll be curious to see your outcome. Good luck!
Have you messed with this in listener.ora?
USE_SID_AS_SERVICE_listener=on
Current Env: RHEL 6 x64, Oracle 12.1.0.2 Standard, Java 7
Upgrade Env: RHEL 6 x64, Oracle 12.1.0.2 Enterprise, Java 8
Regards,
Chris Moore
Database Administrator
Western Kentucky University