I've just installed Oracle 12c. I did not select any of the fancy new options, I just wanted an Oracle instance. I'm fairly new to Oracle but I was used to 11.2.0.4.
Every command I try now fails and it's always something like "Cannot do [x] on pluggable database", etc.
I just want a normal oracle instance and I want to be able to create users and import my database but every turn I take has some frustrating error having to do with pluggable databases. I don't care at all about them, and I specifically tried to avoid any install option that looked like it would make a "pluggable" database but apparently it still did.
Is there any way I can just keep life the same in 12c or am I stuck with this entirely clumsy pluggable paradigm? Thanks very much.
-
Who moved my cheese?Andrew Brennan– Andrew Brennan2016年08月23日 15:41:19 +00:00Commented Aug 23, 2016 at 15:41
2 Answers 2
Yes it is possible to use single tenant.. here you go --> Single Tenant Configuration
-
1
Yes, it is. Just create a Non-CDB (the old architecture) database, but keep in mind this architecture will be deprecated in the future.
-
This doesn't offer any more information than Tesla & Patrick's Answer/Comment.LowlyDBA - John M– LowlyDBA - John M2016年06月08日 15:20:02 +00:00Commented Jun 8, 2016 at 15:20
-
@JohnM comments may be deleted at any time, without notice. I know almost nothing about Oracle's pluggable databases, or single-tenant architecture or non-CDB databases but it seems this answer has some value. The other answer is also just a link. Is this answer really worth a -3 while the other a +2?ypercubeᵀᴹ– ypercubeᵀᴹ2016年06月08日 19:53:52 +00:00Commented Jun 8, 2016 at 19:53
-
Information that is useful for the question should be in answer, not comments. Whether the specific fact about the deprecation is good enough for a separate answer or it should be an edit to the other answer, I won't judge but the answer shouldn't be downvoted just because the info is in a comment - that some readers may just miss reading. The down or up vote should be on whether the answer adds something to the question asked.ypercubeᵀᴹ– ypercubeᵀᴹ2016年06月08日 19:59:36 +00:00Commented Jun 8, 2016 at 19:59
-
@ypercubeTM Fair point. I'd un-vote if I could at this point, but it is locked.LowlyDBA - John M– LowlyDBA - John M2016年06月08日 20:29:55 +00:00Commented Jun 8, 2016 at 20:29